INSERT查询在mysqli中不起作用

Question

I have a table named user_data which contains 5 rows-id(primary key),name,address,phone,sex.When I try to insert values into the table via this query

mysqli_query($con,"INSERT INTO user_data  VALUES ('Peter_malik', 'Griffin door',35897,'male')");

it doesnt work.But When I tried this one,it works.

mysqli_query($con,"INSERT INTO user_data (name,address,phone,sex) VALUES ('Peter_Gregory', 'Griffin door',35897,'male')");

I didnt understand what is the real issue behind this.I am using PHP 5.4.7 and XAMPP 1.8.1.

Answer 1

instead of this:

mysqli_query($con,"INSERT INTO user_data  VALUES ('Peter_malik', 'Griffin door',35897,'male')");

Use this when the field is set as NOT NULL

mysqli_query($con,"INSERT INTO user_data  VALUES (NULL, 'Peter_malik', 'Griffin door',35897,'male')");

Or use this when the field is set as NULL

mysqli_query($con,"INSERT INTO user_data  VALUES (0, 'Peter_malik', 'Griffin door',35897,'male')")

See the mysql manual: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html