1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
<?php
$employer_id=$_GET['employer_id'];
$sales=$_GET['sales'];
$retention= $_GET['retention'];
$oneDeposit= $_GET['oneDeposit'];
$recapPnl= $_GET['recapPnl'];
$enLigne= $_GET['enLigne'];
$papier= $_GET['papier'];
$recapSales= $_GET['recapSales'];
$recapRet= $_GET['recapRet'];
$recapOneDepo= $_GET['recapOneDepo'];
$allCalendar= $_GET['allCalendar'];
$statFiche= $_GET['statFiche'];
$Withdraw= $_GET['Withdraw'];
$payeEmploye= $_GET['payeEmploye'];
$calendar= $_GET['calendar'];
$changePwd= $_GET['changePwd'];
$accounting= $_GET['accounting'];
$pnl= $_GET['pnl'];
$statistique= $_GET['statistique'];
$convertionNew= $_GET['convertionNew'];
$recapEmp= $_GET['recapEmp'];
$addSignaux= $_GET['addSignaux'];
$demoInf= $_GET['demoInf'];
$selectMail= $_GET['selectMail'];
$affiliateBonus= $_GET['affiliateBonus'];
$mail= $_GET['mail'];
$turnover= $_GET['turnover'];
$turnover_forex= $_GET['turnover_forex'];
$forex= $_GET['forex'];
$sql ="INSERT INTO permission(
empId, sales, retention, oneDeposit, recapPnl, enLigne, papier, recapSales, recapRet, recapOneDepo, allCalendar, statFiche, Withdraw, payeEmploye, calendar, changePwd, accounting, pnl, statistique, convertionNew, recapEmp, addSignaux, demoInf, selectMail, affiliateBonus, mail, turnover, turnover_forex, forex)
VALUES ($employer_id, $sales, $retention, $oneDeposit, $recapPnl, $enLigne, $papier, $recapSales, $recapRet, $recapOneDepo, $allCalendar, $statFiche, $Withdraw, $payeEmploye, $calendar, $changePwd, $accounting, $pnl, $statistique, $convertionNew, $recapEmp, $addSignaux, $demoInf, $selectMail, $affiliateBonus, $mail, $turnover, $turnover_forex, $forex)
ON DUPLICATE KEY UPDATE empId=$employer_id, sales=$sales, retention=$retention, oneDeposit=$oneDeposit, recapPnl=$recapPnl, enLigne=$enLigne, papier=$papier, recapSales=$recapSales, recapRet=$recapRet, recapOneDepo=$recapOneDepo, allCalendar=$allCalendar, statFiche=$statFiche, Withdraw=$Withdraw, payeEmploye=$payeEmploye, calendar=$calendar, changePwd=$changePwd, accounting=$accounting, pnl=$pnl, statistique=$statistique, convertionNew=$convertionNew, recapEmp=$recapEmp, addSignaux=$addSignaux, demoInf=$demoInf, selectMail=$selectMail, affiliateBonus=$affiliateBonus, mail=$mail, turnover=$turnover, turnover_forex=$turnover_forex, forex=$forex;";
$prep = $db2->prepare($sql);
$prep->execute();
header('Location:index.php');
?> |
Partager