0

i've Apach2, Mysql and php (also php-mysql); i'm trying to insert from a form (varchar, varchar, password, date, varchar)into the table utenti in my db music: Describe Utenti

I'm using procedural style mysqli: It says me "Insert success" but it doesn't write for real on the Db;

    <?php

$nome = $_POST['nome'];
$cognome = $_POST['cognome'];
$password = $_POST['password'];
$datanascita = $_POST['datanascita'];
$email = $_POST['email'];

$host = "localhost";
$user = "root";
$password = "popolo";
$dbname = "music";

//Connessione

$con = mysqli_connect($host, $user, $password, $dbname);

//verifica eventuali errori
if (mysqli_connect_errno()) {
    echo "Connesione fallita" . mysqli_connect_error();
    exit();
} else {

    echo "Connected \n";
    //Inserting record in table using INSERT query

    $mysqli = "INSERT INTO Utenti (`nome`, `cognome`, `password`, `datanascita`, `email`) 
    VALUES ($nome, $cognome, $password, $datanascita, $email)";

    mysqli_query($conn, $mysqli);

    echo "Insert success";

}
mysqli_close($conn);

?>
Funk Forty Niner
  • 74,450
  • 15
  • 68
  • 141
D.T
  • 11
  • 2

1 Answers1

-1

whatever your query succeeded or not this message echo "Insert success"; will output, you should check if your query succeeded first , you must your varchar in 2 '

$mysqli = "INSERT INTO Utenti (`nome`, `cognome`, `password`, `datanascita`, `email`) 
VALUES ('$nome', '$cognome','$password', '$datanascita', '$email')";

you can check like this:

$result = mysqli_query($conn,$mysqli);
if($result){
echo "Insert success";
} else {
echo "Insert failed, Error: ".$mysqli->error;
}
Gouda Elalfy
  • 6,888
  • 1
  • 26
  • 38