[SOLVED] Insert Multiple Rows Using a Textarea With Linebreaks

[iwpg]

Hi guys, I have been pulling my hair out trying to find a good example on this.  ??? I know that arrays play the main theme in the function, and I am an array flunkie. 

 

I have a textarea, where I am inserting 1 item per line and I am trying to get it to upload to my mysql database. This is kind of like the Google Adwords "add keywords" function.

 

I also need to be able to remove selected values once they're in the db using a checkbox.

 

I just have no way of handling the submitted data, and inserting it. Any help is GREATLY appreciated.

 

Thanks, Mike

 

 

[discomatt]

Try this:

 

<?php

//Split data
$data = preg_split('/\r\n|\n/', $_POST['textarea'], -1, PREG_SPLIT_NO_EMPTY);

//Iterate through array
foreach ($data as $val) {
   echo $val . '<br>';
}

?>

[iwpg]

Thanks for the much needed help. The insert new records function is working perfectly. Many thanks...

 

Now, I am having trouble removing multiple records by using a checkbox. This is what I have:

 

  $id = array();

  $id = $_POST['kwcb'];

 

  if (count($id) > 0)

  {

    foreach ($id as $removeid)

    {

      mysql_query("delete from table where kw='$removeid'");

    }

  }

 

 

Thanks again. Mike

[iwpg]

Sorry, I fogot to mention that the above outputs:

Invalid argument supplied for foreach()

 

Thanks again - mike

[Fadion]

foreach() needs an array as the first argument and yours is a string. If u want to pass all or at least one post value to your array:

 

<?php
$id[] = $_POST['kwcb'];
?>

 

or

 

<?php
foreach($_POST as $val){
   $id[] = $val;
}
?>

[iwpg]

Thanks, I got rid of the error, but only 1 result of the multiple checkboxes will delete. It doesn't loop through the rest of them.

 

This is my code:

 

	elseif ($action=='postdelete'){
	  $id = array();
	  $id[] = $_POST['kwcb'];

	  if (count($id) > 0)
	  {
	     foreach ($id as $removeid)
	     {
	      mysql_query("delete from table where kw='$removeid'");
	     }
	  }
}

[Fadion]

If i get this right, u need to see which checkbox is checked and delete the related data. Then u need to have checkboxes with names like:

 

<input type="checkbox" name="checkbox[]" value="1" />

<input type="checkbox" name="checkbox[]" value="2" />

 

Note the square paranthesis in the checkbox name, which makes them an array. To get the values:

 

<?php
$id = array();
$id = $_POST['checkbox']; //u pass all the array data of the checkboxes to $id
foreach($id as $removeid){
    $mysql_query("DELETE FROM table WHERE kw='$removeid'");
}
?>

 

Hope its what u need.

[iwpg]

Just what I needed. I really do appreciate you helping me out on this.

 

Many thanks.

 

Mike