whats wrong in this simple mysqli query?

Asked Mar 17 '17 at 17:40

Active Mar 17 '17 at 17:40

Viewed 21 times

This simple query works on localhost perfectly, but not in my hosting:

if (!$mysqli->query("INSERT INTO orders (userid,cid,tipou,cantidad,factura,producto,lote,notas,cprod,pbase,cenvio,fecha,status,cobro,ip)

VALUES ('".$sessid."','".$cid."','".$tipou."','".$cantidad."','".$factura."','".$producto."','".$numlot."','".$notas."','".$cprod."','".$pbase."','".$cenvio."','".$fecha."','".$status."','".$cobro."','".$ip."')")) {
    echo "Falló la Insersión de Datos: (" . $mysqli->errno . ") " . $mysqli->error;
} else {echo"Datos Insertados";}

asked Mar 17 '17 at 17:40

Guillermo Esquivel

Use prepared statements with parameter binding. There could be a quoting issue coming from your variables. You also didn't provide anything from your error, so it makes it really hard to tell. – aynber Mar 17 '17 at 17:44
can you please give me an example? – Guillermo Esquivel Mar 17 '17 at 17:46
The [documentation](http://php.net/manual/en/mysqli.quickstart.prepared-statements.php) is a good place to start. – aynber Mar 17 '17 at 17:47
The query simply dont insert anything into the table, and also dont return any error. – Guillermo Esquivel Mar 17 '17 at 17:47
Im working with php.net documentation, and that query works on localhost (my pc) but when I upload the file to my hosting, dont work. – Guillermo Esquivel Mar 17 '17 at 17:48
1

Try echoing your query and running it directly in the database. – aynber Mar 17 '17 at 17:55

whats wrong in this simple mysqli query?

0 Answers0