INSERT INTO不向数据库发送数据

Question

This is the code to insert into MySQL. However, for some reason, it is not sending data to the database.

$con=mysqli_connect("localhost","esferinf_fpessoa","mypassword","esferinf_factura");
// Check connection
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

mysqli_query("INSERT INTO Entregas (dia, cliente, toalhetes, higienico, bidons)
VALUES ('$dia', '$cliente','$toalhetes', '$higienico', '$bidons')");

I don't understand what's going on, what's missing to me?

Answer 1

You're mainly missing the link in your query

mysqli_query($con, "INSERT INTO Entregas (dia, cliente, toalhetes, higienico, bidons) VALUES ('$dia', '$cliente','$toalhetes', '$higienico', '$bidons')");

Also, if this is user input, make sure you validate and sanitize your variables.

It would be even better if you started using prepared statements