MySQL查询不插入数据（php）

Question

Sorry, probably a stupid code error, but my website is failing to insert the data into the database. From submit.php:

$questionID = 2;
$connection = mysqli_connect("localhost", "root", "password", "db_name");
mysqli_query($connection, "INSERT INTO data ('questionID') VALUES ('$questionID')");

My table is called 'data' and the first field is named 'questionID' and is of type int.

Answer 1

Using bind values is a better approach to doing this insert:

$questionID = 2;
$dbh = mysqli_connect("localhost", "root", "password", "db_name");
$insert = $dbh->prepare("insert into data (questionID) values (?)");
$insert->bind_param("i", $questionID);
$insert->execute();

More reading

There are a number of reasons to use bind values, predominant arguments being protection against injection and preventing hard parses.