mysql-php INSERT INTO不起作用 [英] mysql-php INSERT INTO not working

问题描述

我正在尝试插入表格并获取新行的ID.

i am trying to insert to a table and get the ID of the new row.

$mysqli = new mysqli("localhost", "dbuser", "dbpass", "dbname");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "INSERT INTO table (tbl1,tbl2,tbl3,tbl4,tbl5) VALUES ('".$tbll."','".$tbl2."','".$tbl3."','0.00','".$tbl5."'"; 
$mysqli->query($query);
$id_log = $mysqli->insert_id;

• id_log在日志中的任何地方返回0都没有错误
• 在同一文件上，我正在执行SELECT&更新，一切正常运行

推荐答案

您在此处错过了括号...

You missed a parenthesis here...

$query = "INSERT INTO table (tbl1,tbl2,tbl3,tbl4,tbl5) VALUES ('".$tbll."','".$tbl2."','".$tbl3."','0.00','".$tbl5."')";
                                                           ----------------------------------------------------------^

这篇关于mysql-php INSERT INTO不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！