C R U D les requêtes mysqli sont-elles correctes.
Les codes suivant sont ils corrrect.
Crud
Code:
1 2 3 4
| mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $db);
$sql = "INSERT INTO orders (conducteur, lieudepart, lieuarrive, participation, datedepart, datearrive)
VALUES (".$conducteur.",".$lieudepart.",".$lieuarrive.",".$participation.",".$datedepart.",".$datearrive.")"; |
cRud
Code:
1 2
| $query = "SELECT * FROM orders WHERE datedepart BETWEEN '".$_POST["datedepart"]."' AND '".$_POST["datearrive"]."'ORDER BY order_number desc ";
$result = mysqli_query($con, $query); |
crUd
Code:
1 2
| $req = "UPDATE orders SET conducteur = ".$conducteur." , lieudepart = ".$lieudepart.", lieuarrive = ".$lieuarrive.", participation = ".participation.", datedepart = ".$datedepart.", datearrive = ".datearrive." WHERE order_number = ".$order_number."";
$mysqli = new mysqli('127.0.0.1', $dbuser, $dbpass, $db); |
cruD
Code:
1 2
| $req = "DELETE FROM `orders` WHERE `orders`.`order_number` = '$order_number'";
$mysqli = new mysqli('127.0.0.1', 'root', 'root', 'local'); |
Merci pour votre aide.