Sid Gifari From Gifari Industries - BD Cyber Security Team
Home
/
home
/
airmobeuag
/
pro
/
commande
/
lib
/
✏️
Editing: commande.lib.php
<?php Class ClassCde{ public function CnxDBaseSQL() { if ($_SERVER['REMOTE_ADDR'] == "127.0.0.1") { $connexion = mysqli_connect("127.0.0.1", "root", "") or die ("could not connect to mysql"); mysqli_select_db($connexion, "airmob") or die ("no database"); } else { $connexion = mysqli_connect("airmobeuagweb.mysql.db", "airmobeuagweb", "5345fhjthk875HJzzs112") or die ("could not connect to mysql"); mysqli_select_db($connexion, "airmobeuagweb") or die ("no database"); } return $connexion; } public function APIStripe( $Array ) { $this->action = $Array['action']; $this->data = $Array['data']; $CodeAPIStripe = "sk_live_jmMEEsrBrru0qcmySOPhViz1"; // AIRMOB // $CodeAPIStripe = "sk_test_wtOLZRJRmrRm5va5cDWUKeNl"; // AIRMOB $ch = curl_init(); curl_setopt_array($ch, [ CURLOPT_URL => "https://api.stripe.com/v1/".$this->action, CURLOPT_RETURNTRANSFER => true, CURLOPT_USERPWD => $CodeAPIStripe, CURLOPT_HTTPAUTH => CURLAUTH_BASIC ]); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($this->data)); $response = json_decode(curl_exec($ch)); return $response; curl_close($ch); } public function EnregCommande( $Msg , $RetourAPI ) { // => $RetourAPI Pour enregistrer le retour API $cnx = $this->CnxDBaseSQL(); // echo "<h1>INS.</h1>"; // Déjà dasn la table ? $Q_IDU = mysqli_query ($cnx,"SELECT * FROM commandes WHERE idunique='".$_SESSION['airmob']['macommande']['idunique']."'"); $IDU = mysqli_fetch_array($Q_IDU); // Liste la commande $Q_INS_CDE['creation'] = "'".date('Y-m-d H:i:s')."'"; if($RetourAPI) { $Q_INS_CDE['paiement'] = "'" . date('Y-m-d H:i:s') . "'"; } $Q_INS_CDE['montant'] = "'" . $_REQUEST['amount'] . "'"; $Q_INS_CDE['msg'] = "'".$Msg."'"; $ColIndiv = ['offre','Rec','Fas']; // Correspond au nom des colonnes individuelles de la tables foreach($_SESSION['airmob']['macommande'] as $Key=>$DetailCmd) { // Infos clients if($Key!="panier"){ $Q_INS_CDE[$Key] = "'".$DetailCmd."'"; } // Infos details else { foreach($DetailCmd as $Produits=>$ProdDtls) { foreach($ProdDtls as $Prod=>$Dtl) { if($Prod=="pack") { $Ligne['produit'] = "'".$Prod."'"; $Ligne['offre'] = "'".$Dtl."'"; $Ligne['rec'] = "''"; $Ligne['fas'] = "''"; $Ligne['detail'] = "''"; } else { /* if($Prod=="abor") { if( !$ProdDtls['routeur']['offre'] || !$Dtl['offre'] ) { unset($ProdDtls['abor']['offre']); unset($ProdDtls['routeur']['offre']); echo "<h1>XX123 ".$ProdDtls['routeur']['offre']."</h1> "; } //echo "$Prod<pre>"; print_r($ProdDtls['routeur']); echo "</pre>"; } */ $detail = []; $Ligne = []; // Liste tout les champs foreach($Dtl as $KeyCol=>$Val) { // Stock le detail <> des champs $ColIndiv if(!in_array($KeyCol,$ColIndiv) ){ $detail[$KeyCol] = $Val; } } // 1/ Si produit n est pas un routeur ou un aboRetour $offreRouteur = $ProdDtls['routeur']['offre']; $Ligne['produit'] = "'" . $Prod . "'"; $Ligne['offre'] = "'" . $Dtl['offre'] . "'"; $Ligne['rec'] = "'" . $Dtl['Rec']['Prix'] . "'"; $Ligne['fas'] = "'" . $Dtl['Fas']['Prix'] . "'"; $Ligne['detail'] = "'" . json_encode($detail) . "'"; if($Prod=="abor" && !$ProdDtls['routeur']['offre']) { $Ligne = []; } if($Prod=="routeur" && !$ProdDtls['routeur']['offre']) { $Ligne = []; } } //echo "<pre>"; print_r($Ligne); echo "</pre>"; //echo $Prod."->". count($Ligne)."<br>"; $Q_INS_DTL[] = $Ligne; } } } } // DEBUG : affichage // echo "<pre>"; print_r($Q_INS_CDE); echo "</pre>"; // INSERT Infos clients $InsChamps = join(',',array_keys ($Q_INS_CDE)); $InsValeurs = join(',',array_values ($Q_INS_CDE)); // UPDATE foreach($Q_INS_CDE as $NomChamp=>$Valeur) { $Q_UPDATE[] = $NomChamp."=".$Valeur; } $Update = join(',', $Q_UPDATE); if(!$IDU) $Q_ = "INSERT INTO commandes ($InsChamps) VALUES ($InsValeurs) "; else $Q_ = "UPDATE commandes SET $Update WHERE id='".$IDU['id']."'"; $QUERY = mysqli_query ($cnx , $Q_); $ID = mysqli_insert_id($cnx); // DELETE detail commande $Q_DEL = mysqli_query ($cnx , "DELETE FROM cde_detail WHERE id_cde='$IDU[id]'"); // INSERT detail Commande foreach($Q_INS_DTL as $Lg=>$Dtl) { $InsChamps = "id_cde,".join(',',array_keys ($Dtl)); $InsValeurs = "'".$IDU['id']."',".join(',',array_values ($Dtl)); $Q_I = "INSERT INTO cde_detail ($InsChamps) VALUES ($InsValeurs)"; $INSERT = mysqli_query ($cnx , $Q_I); } } public function Pictos($ref ) { $Picto = [ 'MOB'=>['mobile1.svg'], 'DUO'=>['mobile1.svg','ligne1.svg'], 'TRIO'=>['mobile1.svg','ligne1.svg','routeur.svg'], ]; $LignePicto = join('|+|',$Picto[$ref]); // mobile.svg|+|ligne.svg|+|routeur.svg $Xplode = explode ('|',$LignePicto); foreach($Xplode as $Obj) { if($Obj!="+") { $Plus[] = "<div style='float:left; '><img src='images/$Obj' height='45px'></div>"; } else { $Plus[] = "<div class='SignePlus' style='float:left;'> + </div>"; } } // return "<div style='float:left; '><img src='images/ligne.svg' height='35px'></div><div style='float:left; '>+</div><div style='float:left; '><img src='images/routeur.svg' height='50px'></div>"; return join(' ',$Plus)."<div style='float:left; '> </div>"; } public function StepMobile() { $NomEtape = $_SESSION['airmob']['etape']['suivi'][$_SESSION['airmob']['etape']['courante']]; list($Nom) = explode ('_',$NomEtape); $NumEtape = ['','offres','mes','infos','offre','']; $NumActive = array_search($Nom,$NumEtape); ${'active'.$NumActive}='is-active' ; ${'bold'.$NumActive}='bold; border-bottom:2px solid #235BA5' ; if(!$bold1 && !$bold2 && !$bold3 && !$bold4) $bold5="bold; color :#000;"; echo " <div id=\"container\" style=\"border:0px;\"> <div id=\"content\" style=\"width:650px\"> <br /><br /> <ul class=\"list-unstyled multi-steps\" > <li class=\"$active1 \">Je choisis<br>mon offre</li> <li class=\"$active2\">Mes informations</li> <li class=\"$active3\">Information sur<br>l'entreprise</li> <li class=\"$active4\">J'affine<br>mon offre</li> <li class=\"$active5\">Je paie et j'ouvre<br>ma ligne</li> </ul> </div> </div> "; } // Declenche la ligne etape public function Step() { $NomEtape = $_SESSION['airmob']['etape']['suivi'][$_SESSION['airmob']['etape']['courante']]; list($Nom) = explode ('_',$NomEtape); $NumEtape = ['','offres','mes','infos','offre','']; $NumActive = array_search($Nom,$NumEtape); ${'active'.$NumActive}='is-active' ; echo " <div lass='container-fluid col-md-12'> <br /><br /> <ul class=\"list-unstyled multi-steps\" > <li class=\"$active1 \">Je choisis<br>mon offre</li> <li class=\"$active2\">Mes informations</li> <li class=\"$active3\">Information sur<br>l'entreprise</li> <li class=\"$active4\">J'affine<br>mon offre</li> <li class=\"$active5\">Je paie et j'ouvre<br>ma ligne</li> </ul> </div>"; } // Gere les actions sur etape public function Etape() { /* * 1/ Etape Choisir Offre * * */ // DEBUG : affichage // echo "<pre style='border:1px solid #00ff00'>aaaaa"; print_r($_REQUEST); echo "</pre>"; // echo "<pre>"; print_r($_SESSION['airmob']); echo "</pre>"; // Initialize ETAPE 1 if ( !@$_SESSION['airmob']['etape'] || $_SESSION['airmob']['etape']['courante']==0) { $_SESSION['airmob']['etape']['courante'] = "1"; $_SESSION['airmob']['etape']['suivi']['1'] = "offres"; unset($_SESSION['airmob']['macommande']); } // Etape courante $MyEtapeNo = @$_SESSION['airmob']['etape']['courante'] ; // Action if($_REQUEST) { // DEBUG : affichage // echo "<pre>"; print_r($_REQUEST); echo "</pre>"; // Bouton RETOUR if ( @$_REQUEST['Retour'] ) { // Etape précédente $EtapePrec = ($_SESSION['airmob']['etape']['courante'] - 1); // Etape N° $MyEtapeCourante = $_SESSION['airmob']['etape']['suivi'][$EtapePrec]; // Include $MyEtapeNo = $EtapePrec; // Nouvelle Etape courante // Reset Etape Suivi $EtapeCourante = $_SESSION['airmob']['etape']['courante']; unset($_SESSION['airmob']['macommande'][$EtapeCourante]); unset($_SESSION['airmob']['etape']['suivi'][$EtapeCourante]); // unset($_SESSION['airmob']['macommande']['panier'][$EtapePrec]); } // offres,mes_infos elseif ( $_REQUEST['CmdPOST'] ){ // Etape en cours... $MyEtapeCourante = $_REQUEST['CmdPOST']; // Include // Enregsitre un ID unique if(!$_SESSION['airmob']['etape']['idunique'] && $_REQUEST['CmdPOST']=="infos_entreprise") { $_SESSION['airmob']['etape']['idunique'] = (md5(date('YmdHis').($_REQUEST['form_nomprenom']).($_REQUEST['form_email']))); $_SESSION['airmob']['macommande']['idunique'] = (md5(date('YmdHis').($_REQUEST['form_nomprenom']).($_REQUEST['form_email']))); } // Si ajouter ou valider $IdOffre = ''; if( $_REQUEST['CmdPOST']=="ajouter" || $_REQUEST['CmdPOST']=="valider" ){ // Si ajouter = voir liste pour quoi ajouter if($_REQUEST['CmdPOST']=="ajouter") { if ($_REQUEST['ajoute_offre']) $MyEtapeCourante = "offre_" . $_REQUEST['ajoute_offre']; } // Ajoute un clé indiv pour chaque produit $IdOffre = $MyEtapeNo; $EtapeCourante = $_SESSION['airmob']['etape']['courante']; $Suivi = $_SESSION['airmob']['etape']['suivi'][$EtapeCourante]; list($O,$T) = explode ('_',$Suivi); } // Télécharge le fichier if ($_FILES['form_file']['error']) { switch ($_FILES['form_file']['error']){ case 1: // UPLOAD_ERR_INI_SIZE echo"Le fichier dépasse la limite autorisée par le serveur (fichier php.ini) !"; break; case 2: // UPLOAD_ERR_FORM_SIZE echo "Le fichier dépasse la limite autorisée dans le formulaire HTML !"; break; case 3: // UPLOAD_ERR_PARTIAL echo "L'envoi du fichier a été interrompu pendant le transfert !"; break; case 4: // UPLOAD_ERR_NO_FILE echo "Le fichier que vous avez envoyé a une taille nulle !"; break; } } else { // $_FILES['nom_du_fichier']['error'] vaut 0 soit UPLOAD_ERR_OK // ce qui signifie qu'il n'y a eu aucune erreur } $legalExtensions = array('bmp','jpeg', 'jpg', 'gif', 'png','pdf'); if ( ($_FILES['form_file']['tmp_name'] )) { $nom = md5($_FILES["form_file"]["name"].date('YmdHis')); $ext = pathinfo($_FILES['form_file']['name'], PATHINFO_EXTENSION); $nomfichier = $nom.".".$ext; if (in_array($ext, $legalExtensions)) { $chemin_destination = './upload/'; move_uploaded_file($_FILES['form_file']['tmp_name'], $chemin_destination.$nomfichier); $_SESSION['airmob']['macommande']['file'] = $nomfichier; } } // Si pas déjà enreg. et pas de clé indiv(autorise les doublons) if( !in_array($MyEtapeCourante,$_SESSION['airmob']['etape']['suivi'] && !$IdOffre ) ) { foreach($_REQUEST as $NomChamp=>$Value) { list($form,$nom,$type) = explode ('_',$NomChamp); if($form=="form") { // Normal if(!$IdOffre) { $_SESSION['airmob']['macommande'][$nom] = $Value; } // Panier else { // Si form_offre_mobile => nouvel clé => type=mobile, ligne if($type) { $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type][$nom] = $Value; $_SESSION['airmob']['macommande']['panier'][$IdOffre]['pack'] = $_SESSION['airmob']['etape']['suivi'][$IdOffre]; // Tarifs if($nom=="offre") { // echo "<h1>--$IdOffre--$type--$Value--$NomChamp--</h1>"; // $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec'] = $_SESSION['airmob']['lesoffres'][$type][$_REQUEST[$NomChamp]]['rec']; $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Ref'] = $Value; $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$_REQUEST[$NomChamp]]['rec']; // Ajoute les FAS if ($_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]) { $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Ref'] = $_SESSION['airmob']['lesoffres']['fas'][$Value]['ref']; $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Prix'] = $_SESSION['airmob']['lesoffres']['fas'][$Value]['fas']; } if($type=="option" || $type=="option") { // Rec $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Ref'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['ref']; $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Rec']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['rec']; // Fas $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Ref'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['ref']; $_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Fas']['Prix'] = $_SESSION['airmob']['lesoffres'][$type][$Value]['fas']; } //if($type=="option") { // echo "<br>--->"; //echo $IdOffre. " ".$type."<br>"; //$_SESSION['airmob']['macommande']['panier'][$IdOffre][$type]['Opt']['Ref'] = $_SESSION['airmob']['lesoffres']['option'][$Value]['ref']; ///$_SESSION['airmob']['macommande']['panier'][$IdOffre][$type][$type.'xxx']['Prix'] = $_SESSION['airmob']['lesoffres']['option'][$Value]['fas']; //} } } // Si form_nomprenom (normal) else $_SESSION['airmob']['macommande']['panier'][$IdOffre][$nom] = $Value; } } } $MyEtapeNo++; } $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante; // Enregsitre à toutes les etapes si nom et renseigné if($_SESSION['airmob']['macommande']['nomprenom'] ) { // Msg indique le nom de l etape précédente $Msg = $_SESSION['airmob']['etape']['suivi'][$_SESSION['airmob']['etape']['courante']]; $this->EnregCommande($Msg, ''); } } /* elseif ( $_REQUEST['SouscrireOffre'] ) { $MyEtapeCourante = "mes_infos"; if( !in_array( $MyEtapeCourante,$_SESSION['airmob']['etape']['suivi']) ) { $_SESSION['airmob']['macommande']['Offre'] = $_REQUEST['SouscrireOffre']; $MyEtapeNo++; } $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante; } elseif ( $_REQUEST['MesInformations'] ) { $MyEtapeCourante = "info_entreprise"; if( !in_array( $MyEtapeCourante,$_SESSION['airmob']['etape']['suivi']) ) { $_SESSION['airmob']['macommande']['MesInfos'] = ""; $MyEtapeNo++; } $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo] = $MyEtapeCourante; } */ elseif( $_REQUEST['CmdEDIT'] ) { // DEBUG : affichage echo "<pre>"; print_r($_REQUEST); echo "</pre>"; $MyEtapeNo =$_REQUEST['CmdEDIT']; } elseif( $_REQUEST['CmdDEL'] ) { //echo "-->".$_REQUEST['CmdDEL']."<br>"; unset($_SESSION['airmob']['macommande']['panier'][$_REQUEST['CmdDEL']]); unset($_SESSION['airmob']['etape']['suivi'][$_REQUEST['CmdDEL']]); foreach($_SESSION['airmob']['etape']['suivi'] as $K=>$Ope) { $i++; list($O, $T) = explode('_', $Ope); if($O=="offre") { //echo " $K ==> $i - $O<br>"; if($K<>$i) { $_SESSION['airmob']['macommande']['panier'][$i] = $_SESSION['airmob']['macommande']['panier'][$K]; $_SESSION['airmob']['etape']['suivi'][$i] = $_SESSION['airmob']['etape']['suivi'][$K]; unset($_SESSION['airmob']['macommande']['panier'][$K]); unset($_SESSION['airmob']['etape']['suivi'][$K]); } } } //echo "Courant ==> ".$i."<br>"; $_SESSION['airmob']['etape']['courante'] = $i; $MyEtapeNo = $i; // Lance à partir de l etape de suppression /* for ($index = $_REQUEST['CmdDEL']; $index < 10; $index++) { list($O, $T) = explode('_', $_SESSION['airmob']['etape']['suivi'][$index]); // Si offre_MOB if ($O == "offre") { // Decale de -1 SUIVI et PANIER si pas = à 4 if( $_REQUEST['CmdDEL'] > 4) { $_SESSION['airmob']['etape']['suivi'][($index - 1)] = $_SESSION['airmob']['etape']['suivi'][($index)]; $_SESSION['airmob']['macommande']['panier'][($index - 1)] = $_SESSION['airmob']['macommande']['panier'][($index)]; } // Supprime la demande unset($_SESSION['airmob']['macommande']['panier'][$index]); unset($_SESSION['airmob']['etape']['suivi'][$index]); } // valider else { // Decale de -1 SUIVI et PANIER si pas = à 4 if( $_REQUEST['CmdDEL'] > 4) { $_SESSION['airmob']['etape']['suivi'][($index - 1)] = $_SESSION['airmob']['etape']['suivi'][($index)]; } } } */ // Recule la valeur dse l etape courante // $EtapeCourant = $_SESSION['airmob']['etape']['courante']; // $_SESSION['airmob']['etape']['courante'] = ($EtapeCourant - 1); // Force l affichage // $MyEtapeNo = ($EtapeCourant - 1); //$MyEtapeNo = ($EtapeCourant - 1); /* $PremCle = array_shift(array_keys($_SESSION['airmob']['macommande']['panier'])); if ($PremCle)$MyEtapeNo = $PremCle; else $MyEtapeNo ="3"; echo "<h1>".$PremCle."</h1>"; */ // Si le retour est sur 4 alors repasse à l etape 3 poru eviter la page blanche // if($MyEtapeNo==4) $MyEtapeNo ="3"; } $_SESSION['airmob']['etape']['suivi'] = array_filter($_SESSION['airmob']['etape']['suivi']);$_SESSION['airmob']['etape']['suivi']; // Trier (ne fonctionne pas) ksort($_SESSION['airmob']['etape']['suivi']); } // Mémorise $_SESSION['airmob']['etape']['courante'] = $MyEtapeNo; // Function à éxecuter $NomCl = 'Affiche_'. $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo]; $this->nomfunction = $NomCl; $this->include = $_SESSION['airmob']['etape']['suivi'][$MyEtapeNo]; return ClassCde::$NomCl([]); } // Affiche Offres public function Affiche_offres( $arr ) { $Return['return']['titre'] = "Choisissez votre ligne sur mesure"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; $Return['return']['result'] = $this->ListeOffres(); return $Return; } public function Affiche_mes_infos( $arr ) { $Return['return']['titre'] = "Mes informations"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_infos_entreprise( $arr ) { $Return['return']['titre'] = "Informations sur l'Entreprise"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_offre_MOB( $arr ) { $Return['return']['titre'] = "J'affine mon offre"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_offre_DUO( $arr ) { $Return['return']['titre'] = "J'affine mon offre"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_offre_TRIO( $arr ) { $Return['return']['titre'] = "J'affine mon offre"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_valider( $arr ) { $Return['return']['titre'] = "Règlement"; $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function Affiche_ajouter( $arr ) { $Return['return']['include'] = $this->include; $Return['return']['function'] = $this->nomfunction; return $Return; } public function ListeOffres() { $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres ORDER BY id ") or die(mysqli_error()); while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) { // Conserve que les offres pack if($Detail['offre']=="pack") $Offres[$Detail['id']] = $Detail; // Stock tous les produits $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['nom'] = $Detail['nom']; $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['ref'] = $Detail['ref']; $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['rec'] = $Detail['rec']; $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['fas'] = $Detail['fas']; $_SESSION['airmob']['lesoffres'][$Detail['offre']][$Detail['ref']]['description'] = $Detail['description']; } return $Offres; } public function OffresLigne() { $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='ligne' ") or die(mysqli_error()); while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) { $OffresLigne[$Detail['id']] = $Detail; } return $OffresLigne; } public function OffresMobile() { $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='mobile' ") or die(mysqli_error()); while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) { $OffresMobile[$Detail['id']] = $Detail; } return $OffresMobile; } public function OffresOption() { $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='routeur' ") or die(mysqli_error()); while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) { $OffresOption[$Detail['id']] = $Detail; } return $OffresOption; } public function OffresAbo() { $Lst = mysqli_query($this->CnxDBaseSQL(), "SELECT * FROM offres WHERE offre='abor' ") or die(mysqli_error()); while ($Detail = mysqli_fetch_array($Lst, MYSQLI_ASSOC)) { $OffresAbo[$Detail['id']] = $Detail; } return $OffresAbo; } } ?>
💾 Save
❌ Cancel