PHP foreach插入语句与数组的问题

Question

Hey guys, i'm currently learning php and I need to do this

  $connection = mysql_open();
  $likes= array();
  foreach($likes as $like)
  {

  $insert3 = "insert into ProfileInterests " .
    "values ('$id', '$like', null)";
  $result3 = @ mysql_query ($insert3, $connection)
    or showerror();

  }
  mysql_close($connection)
    or showerror();

For some reason this does not work =/ I don't know why. $likes is an array which was a user input. I need it to insert into the table it multiple times until all of the things in the array are in.

EDIT I fixed the issue where I was closing it in my foreach loop. mysql_open is my own function btw.

Any ideas?

Answer 1

For one $likes is an empty array in your example, I am assuming you fix that in the code you run.

The second is you close the MySQL connection the first the time the loop would run, which would prevent subsequent MySQL queries from running.