如何使用for循环将数据插入mysql数据库？

Question

My code is:

<?php
include("connect.php");
mysql_select_db("cars",$conec);
array("red","green","blue","yellow"); 
for(i = 0; i < 4; i++){
  echo "$array[i] <br>";
  }
?>

What I want to do is insert each car into a database and this is what I tried to do but I only get the id increasing becuase it is an auto-increment

for($i = 0; $i < 4; $i++){
    $res = mysql_query("insert into auto (car) values ($array[i])")
}

Answer 1

You need to put $ before variable names. And when substituting an expression into a string, you have to put {} around it. And since the values are SQL strings, you need to put quotes around them in the query.

for($i = 0; $i < 4; $i++){
    $res = mysql_query("insert into auto (car) values ('{$array[$i]}')")
}