Comment afficher les erreurs (php, mysqli) ?
Bonsoir
J'ai un souci avec ma requête qui n'enregistre que l'ID, ma question est moins de savoir ou est mon erreur, que de savoir comment insérer des traces dans une requête PHP
Code:
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
| <?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$mysqli = new mysqli("localhost", "root", "root", "bdd_prod");
// Check connection
if($mysqli === false){
die("ERROR: Could not connect. " . $mysqli->connect_error);
}
// Escape user inputs for security
$name = $mysqli->real_escape_string($_REQUEST['nom']);
$prenom = $mysqli->real_escape_string($_REQUEST['prenom']);
$email = $mysqli->real_escape_string($_REQUEST['email']);
// attempt insert query execution
$sql = "INSERT INTO USERS (user_nom, user_prenom, user_email) VALUES ('$name', '$prenom', '$email')";
if($mysqli->query($sql) === true){
echo "Records inserted successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . $mysqli->error;
}
// Close connection
$mysqli->close();
?> |
Merci pour votre aide
Bonne soirée
