| Server IP : 109.234.164.53 / Your IP : 216.73.216.136 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/home/computer3/litsolide.com/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
if (isset($_GET['cat'])) {
///////////////////////////
$cat= $_GET['cat'];
$insert= $_GET['insert'];
if ($insert =='0'){
$cppp= 0;$cpppa= 0;
$requete2 = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['products_categories'] . "
WHERE id_category = " . $cat ." ORDER BY id_product ASC");
while ($pro = $requete2->fetch()) {
$idd = $pro['id_product'];
$cppp= $cppp +1;
$requete = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['lot_list'] . " WHERE id_produit = " . $idd);
$product = $requete->fetch();
$existe = $product['nombre'];
echo 'Produit id : ' . $idd . '';
if ($existe >0) { echo' ------- > Attention EXISTE !!'; $cpppa=$cpppa +1; }
echo '<br />';
}
echo'
<br/><b>TOTAL ART : '. $cppp.'</b>';
}
if ($insert =='1'){
$cpppa= 0;
$cppp= 0;
$requete21 = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['products_categories'] . "
WHERE id_category = " . $cat ." ORDER BY id_product ASC");
while ($pro1 = $requete21->fetch()) {
$idddd = $pro1['id_product'];
$requete1 = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['lot_list'] . " WHERE id_produit = " . $idddd);
$product1 = $requete1->fetch();
$existe1 = $product1['nombre'];
if ($existe1 =='') {
// Modifie ici
/**************/
/*
$qid = $bdd->prepare("UPDATE " . $GLOBALS['db_table']['products'] . "
SET price = :price WHERE id = :id");
$qid->execute(array( 'price' => '23.90','id' => $idddd));
////////////
$sql = "INSERT INTO ".$GLOBALS['db_table']['lot_list']." (id_produit, nombre, prix) VALUES (:id, :nombre, :prix)";
$req = $bdd->prepare($sql);
$req->execute(array( 'nombre' => '2',
'prix' => '22.90',
'id' => $idddd));
$sql = "INSERT INTO ".$GLOBALS['db_table']['lot_list']." (id_produit, nombre, prix) VALUES (:id, :nombre, :prix)";
$req = $bdd->prepare($sql);
$req->execute(array( 'nombre' => '5',
'prix' => '4.20',
'id' => $idddd));
$sql = "INSERT INTO ".$GLOBALS['db_table']['lot_list']." (id_produit, nombre, prix) VALUES (:id, :nombre, :prix)";
$req = $bdd->prepare($sql);
$req->execute(array( 'nombre' => '10',
'prix' => '12.90',
'id' => $idddd));
$sql = "INSERT INTO ".$GLOBALS['db_table']['lot_list']." (id_produit, nombre, prix) VALUES (:id, :nombre, :prix)";
$req = $bdd->prepare($sql);
$req->execute(array( 'nombre' => '12',
'prix' => '3.70',
'id' => $idddd));
*/
/***********************************/
echo' <b>modifié !!!!</b> ';
echo 'Produit id : ' . $idddd . '';
if ($existe >0) { echo' --------- Attention EXISTE !!'; $cpppa=$cpppa; } else { echo' --------- OK'; $cpppa=$cpppa+1;}
echo '<br />';
}
}
echo'
<br/> <b>TOTAL MODIFIE : '. $cpppa.' ARTICLES</b>';
}
?>
<div class="container">
<form class="form-horizontal" method="GET" action="#" enctype="multipart/form-data">
<?php
echo '<br />';
echo '<br />';
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="reference">Reinitialiser :</label>';
echo '<div class="controls">';
?>
<button type="submit" name="edit" class="btn btn-success"><i class="icon-ok"></i> OK</button>
<?php
echo '</div>';
echo '</div>';
echo '</form>';
echo '</div>';
$insert = "INSERT INTO `lot_list` " ;
?>
<div class="container">
<form class="form-horizontal" method="GET" action="#" enctype="multipart/form-data">
<?php
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="reference"></label>';
echo '<div class="controls">';
echo $insert .' ';
echo '<input name="cat" type="hidden" required value="'.$cat.'">';
echo '<input name="insert" type="hidden" required value="1">';
if ($cpppa < 1){
?>
<button type="submit" name="edit" class="btn btn-success"><i class="icon-ok"></i> Envoyer</button>
<?php
}
echo '</div>';
echo '</div>';
echo '<br />';
echo '</form>';
echo '</div>';
}
?>
<?php
if (!isset($_GET['cat'])) {
?>
<div class="container">
<form class="form-horizontal" method="GET" action="#" enctype="multipart/form-data">
<?php
echo '<br />';
echo '<br />';
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="reference">Id Categorie :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="cat" type="text" required value="">';
echo '<input name="insert" type="hidden" required value="0">';
?>
<button type="submit" name="edit" class="btn btn-success"><i class="icon-ok"></i> Envoyer</button>
<?php
echo '</div>';
echo '</div>';
echo '<br />';
echo '</form>';
echo '</div>';
}
include_once('includes/footer.php');
?>