Petit nouveau ! |
2 Messages
29 mai 2022, 09:10
J'ai indiquer mais j'ai eu le même le problème. Je ne sais quoi indiquer dans la colonne 19.
Fatal error: Uncaught mysqli_sql_exception: Table 'formulaire.account' doesn't exist in C:\xampp\htdocs\www\jeu\inscription.php:19 Stack trace: #0 C:\xampp\htdocs\www\jeu\inscription.php(19): mysqli->query('INSERT INTO acc...') #1 {main} thrown in C:\xampp\htdocs\www\jeu\inscription.php on line 19
Voici mon code
<?php
$prenom = filter_input(INPUT_POST, 'prenom');
$age = filter_input(INPUT_POST, 'age');
if (!empty($prenom)){
if (!empty($age)){
$host = "localhost";
$dbprenom = "root";
$dbage = "";
$dbname = "formulaire";
// Create connection
$conn = new mysqli ($host, $dbprenom, $dbage, $dbname);
if (mysqli_connect_error()){
die('Connect Error ('. mysqli_connect_errno() .') '
. mysqli_connect_error());
}
else{
$sql = "INSERT INTO account (prenom, age)
values ('$prenom','$age')";
if ($conn->query($sql)){
echo "New record is inserted sucessfully";
}
else{
echo "Error: ". $sql ."
". $conn->error;
}
$conn->close();
}
}
else{
echo "Password should not be empty";
die();
}
}
else{
echo "Username should not be empty";
die();
}
?>