mysql-php INSERT INTO not working

Question

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 is returning 0 no error anywhere in logs
on same file i am doing SELECT & UPDATE and all work perfectly

As a side note, you're using mysqli, but not prepared statements. As a result, you are still open to SQL injection because you insert php variables directly. Granted, you could be doing things in code you haven't included, but if this is all your MySQL code, you should start using prepared statements and parametrized queries. — jpodwys
– jpodwys, Commented Dec 8, 2013 at 18:33
LOL! i wasted so much time on it..but i learned many new things on the way :D — user1741397
– user1741397, Commented Dec 8, 2013 at 18:42

Shankar Narayana Damodaran · Accepted Answer · 2013-12-08 18:32:14Z

3

You missed a parenthesis here...

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

answered Dec 8, 2013 at 18:32

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql-php INSERT INTO not working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related