Exploded Data - Insert into DB

[3raser]

Is there a way to send exploded data into a database without using multiple loops just to do so? My current code, but it only inserts the name value in the database as Array.

 

	$chicken_names = mysql_real_escape_string($_POST['names']);
	$chicken_names_exp = explode(' ', $_POST['names']);

	foreach($chicken_names_exp as $value)
	{
		mysql_query("INSERT INTO names VALUES (null, '$chicken_names_exp"', '". $_POST['type'] ."')");
	}

	echo "Success! You have successfully sent in your chicken names! <a href='index.php'>Home</a>";

[Jnerocorp]

shouldnt:

 

mysql_query("INSERT INTO names VALUES (null, '$chicken_names_exp"', '". $_POST['type'] ."')");

 

be:

 

mysql_query("INSERT INTO names VALUES (null, '$value"', '". $_POST['type'] ."')");

[3raser]

shouldnt:

 

mysql_query("INSERT INTO names VALUES (null, '$chicken_names_exp"', '". $_POST['type'] ."')");

 

be:

 

mysql_query("INSERT INTO names VALUES (null, '$value"', '". $_POST['type'] ."')");

 

Heh, yeah! Thanks.

[Jnerocorp]

No problem gotta love those simple little mistakes (I hate when i make spelling errors in odd places that are hard to find lol)

[3raser]

No problem gotta love those simple little mistakes (I hate when i make spelling errors in odd places that are hard to find lol)

 

I always mess up mysql_query somehow. Usually I accidentally type mysql_insert, or mysql_qery.

[Jnerocorp]

I had a tendancy to do the same stuff for a long time I always had to visit tizag.com for a reference on making sure my syntax was all correct. it just takes a long time of practice and the more you try the more it just sticks.

[Pikachu2000]

You can avoid running the query in the loop as below. I've added some comments in the code to explain.

 

$_POST['names'] = preg_replace('~[\s]{2,}~', ' ', $_POST['names']); // Replace multiple spaces with one space to avoid empty records
$chicken_names = mysql_real_escape_string($_POST['names']);
$chicken_names_exp = explode(' ', $chicken_names);
$query = "INSERT INTO names VALUES "; // Start building query string
$records = array(); //initialize an empty array to hold the records

foreach($chicken_names_exp as $value) {
$records[] = "(null, '$value', '{$_POST['type']}')"; // build an array of values to insert
}

$query .= implode( ', ', $records ); // implode the array of values with a comma, and concatenate to query string

if( $result = mysql_query($query) ) {
echo "Success! You have successfully sent in " . mysql_affected_rows() . " chicken names! <a href='index.php'>Home</a>";
}