插入多个_POST值从php web表单发送到sql表

Question

How could I essentially add multiple _POST values to my below statement.

$sql = "INSERT INTO emails (emailaddress) // starting action
VALUES ('".$_POST['email']."')"; // I would like to add more values to send here

Answer 1

1. You HAVE to escape your variable. Read about SQL-injections here
2. You can make a foreach statement. Example:
   foreach($_POST as $emailaddress){ $sql = "INSERT INTO emails (emailaddress) VALUES (" . $emailaddress . ")"; // Execute query here. }
   This codesnippet is just for demonstrational purposes, so do not use it directly. Escape the emailaddress first.