Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to do a foreach insert query for a field?
- $person = mysql_real_escape_string($_POST['person']);
- foreach($person_array as $value)
- {
- $insert = "INSERT INTO people (Person)
- VALUES ('".$value."')";
- $query = mysql_query($insert) or die ("Error: ".mysql_error());
- }
- $person = explode(',', $_POST['person']);
- foreach($_POST['person'] as $value)
- {
- $value = mysql_real_escape_string($value);
- //your query here
- }
- $person = $POST['person'];
- foreach($person as $value) {
- $value = mysql_real_escape_string($value);
- $insert = "INSERT INTO people (Person) VALUES ('$value')";
- $query = mysql_query($insert) or die("Error: ".mysql_error());
- }
- $person = mysql_real_escape_string($POST['person']);
- $person = mysql_real_escape_string($_POST['person']);
- $person = $POST['person'];
- foreach($person as $value) {
- $value = mysql_real_escape_string($value);
- $insert = "INSERT INTO people (Person) VALUES ('$value')";
- $query = mysql_query($insert) or die("Error: ".mysql_error());
- }
Add Comment
Please, Sign In to add comment