prefix."dporders` WHERE datecommande LIKE '".$date1."%' ";
//echo $query_Lignecommande;
}
else{
$date1 = date('Y-m-d');
$query_Lignecommande = "SELECT * FROM `". $wpdb->prefix."dporders` WHERE printed=0 AND datecommande LIKE '".$date1."%' ";
// echo $query_Lignecommande;
}
if ($_GET["test"]==1){
$query_Lignecommande = "SELECT * FROM `". $wpdb->prefix."dporders` ORDER BY id DESC LIMIT 1";
// echo "test";
}
$date = date('Y-m-d');
//$date= "2020-11-05";
//echo $date;
//echo "largeur :".$largeur."
";
global $wpdb;
//echo $wpdb->prefix;
$host = DB_HOST;
$mabase = DB_NAME;
$user = DB_USER;
$passwd = DB_PASSWORD;
$conn = mysqli_connect($host, $user, $passwd, $mabase);
$conn->set_charset("utf8");
$afficheprix=1;
//$query_Lignecommande = "SELECT * FROM `". $wpdb->prefix."dporders` WHERE printed=0 AND datecommande LIKE '".$date1."%' ";
//echo $query_Lignecommande;
//$query_Recordset1 = "SELECT * FROM tablecoord WHERE ".$marequete;
$RecordsetLignecommande = $conn->query($query_Lignecommande);
$num_rows2 = mysqli_num_rows($RecordsetLignecommande);
//echo $num_rows2."
";
$i=1;
while($ligne = mysqli_fetch_array($RecordsetLignecommande)){
$query_printed = "UPDATE `". $wpdb->prefix."dporders` SET printed=1 WHERE id=".$ligne["id"];;
// marque les commandes comme imprimé
$Recordsetprinted = $conn->query($query_printed);
// echo $query_printed;
$idorder = $ligne["idorder"];
//echo $idorder."
";
$date=$ligne["datecommande"];
$heureretrait=$ligne["heureretrait"];
setlocale(LC_TIME, "fr_FR");
$date = strftime("%d/%m/%Y %H:%M", strtotime($date));
//echo $date."
";
//$ligne=str_replace("\line", "*line", $ligne["commande"]);
//$ligne=str_replace(" \\r\\n", "", $ligne["commande"]);
//$ligne=stripslashes($ligne);
//$ligne=addslashes($ligne["commande"]);
$ligne=$ligne["commande"];
//$ligne=stripslashes($ligne["commande"]);
//echo $ligne."
";
//$var = array ( "email"=>$email ,"id" => $id , "ligne" => $ticket, "etat" => $etat ,"selectE" => $selectE,"telephone" => $commande["Tel"] ,"nomprenom" => $nomprenom,"C" => $C,"heureretrait" => $heureretrait );
//$var = array ( "ligne" => $ligne["commande"] ,"heureretrait" => $heureretrait );
$var = array ( "id" => $idorder , "ligne" => $ligne, "etat" => "1" );
array_push($mescommandes ,$var);
}
//echo stripslashes(json_encode($mescommandes));
echo json_encode($mescommandes);
mysqli_free_result($RecordsetLignecommande);
?>