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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
|
<?php
$idRef ="";
$idPres ="";
$idProd ="";
$idSit = $_POST["idSite"];
if (is_numeric($idSit)) {
include('../Connections/connect_admin.php');
$reqres=mysql_query("SELECT * FROM lien_pack_referencement WHERE idPack='".$idSit."'");
$nbenr=mysql_num_rows($reqres);
if ($nbenr==0){
//On est mode ajout
foreach( $_POST as $key => $value ) {
if (substr($key,0,3) == "ref"){
$idRef = $value;
}
if (substr($key,0,4) == "pres") {
$idPres = $value;
}
if (is_numeric($idRef) && is_numeric($idPres)) {
$reqres=mysql_query("INSERT INTO lien_pack_referencement VALUES ('".mysql_real_escape_string($idSit)."','".mysql_real_escape_string($idRef)."','".mysql_real_escape_string($idPres)."')");
$idRef ="";
$idPres ="";
}
}
} else {
//On est en mode modification
foreach( $_POST as $key => $value ) {
if (substr($key,0,3) == "ref"){
$idRef = $value;
}
if (substr($key,0,4) == "pres") {
$idPres = $value;
}
if (is_numeric($idRef) && is_numeric($idPres)) {
$reqres=mysql_query("UPDATE lien_pack_referencement SET idPresence='".mysql_real_escape_string($idPres)."' WHERE idPack='".$idSit."' AND idRef ='".$idRef."'");
$idRef ="";
$idPres ="";
}
}
}
$reqres=mysql_query("SELECT * FROM lien_pack_produit WHERE idPack='".$idSit."'");
$nbenr=mysql_num_rows($reqres);
if ($nbenr==0){
//On est mode ajout
foreach( $_POST as $key => $value ) {
if (substr($key,0,4) == "prod"){
$idProd = $value;
}
if (substr($key,0,5) == "pProd") {
$idPres = $value;
}
if (is_numeric($idProd) && is_numeric($idPres)) {
$reqres=mysql_query("INSERT INTO lien_pack_produit VALUES ('".mysql_real_escape_string($idSit)."','".mysql_real_escape_string($idProd)."','".mysql_real_escape_string($idPres)."')");
$idProd ="";
$idPres ="";
}
}
} else {
//On est en mode modification
foreach( $_POST as $key => $value ) {
if (substr($key,0,4) == "prod"){
$idProd = $value;
}
if (substr($key,0,5) == "pProd") {
$idPres = $value;
}
if (is_numeric($idProd) && is_numeric($idPres)) {
$reqres=mysql_query("UPDATE lien_pack_produit SET idPresence='".mysql_real_escape_string($idPres)."' WHERE idPack='".$idSit."' AND idProd ='".$idProd."'");
$idProd ="";
$idPres ="";
}
}
}
mysql_close($connect_admin);
}
?> |
Partager