[wama_mms]

i am trying to insert an array into database when i use checkbox the id for each row that has a checkbox refers to it need to insert it in the database how can i do it ?? when i write array('1','2') it inserted well

<?php
include('db.php');

@$id = $_POST['id'];
if(isset($_POST['delete']))
{
	if(empty($id) || $id == 0)
	{
			echo '<script type="text/javascript">alert("اختر صف")</script>';
	}
	else
	{
		$array_data = array($id);

		echo print_r($array_data);
		
		for($i = 0; $i < count($array_data); $i++)
		{
		  mysql_query("INSERT INTO names (`mail`) VALUES ('$array_data[$i]')");
		}
		if(isset($delete))
		{
			echo '<script type="text/javascript">alert("تم المسح")</script>';
		}
	}
}
?>

This post has been edited by Dormilich: 02 February 2013 - 02:51 PM
Reason for edit:: please use [CODE] [/CODE] tags when posting code

[Dormilich]

well, it depends how you set up your checkboxes.

[wama_mms]

Dormilich, on 02 February 2013 - 02:53 PM, said:

well, it depends how you set up your checkboxes.

there is the code of each checkbox

 <?php echo '<td><input type="checkbox" name="id[]" value='.$row['id'].'></td>' ?> 

[andrewsw]

I don't know about the rest of the code, but you need curly brackets when quoting an array element:

mysql_query("INSERT INTO names (`mail`) VALUES ('{$array_data[$i]}')");

The mysql library is deprecated - use mysqli or PDO instead.
Use prepared statements.

[Dormilich]

$id is already an array and putting that into an array (line #13) you don’t loop over your array data, but the original array (which returns the string "Array" when dumped into a string).

[wama_mms]

andrewsw, on 02 February 2013 - 02:55 PM, said:

I don't know about the rest of the code, but you need curly brackets when quoting an array element:

mysql_query("INSERT INTO names (`mail`) VALUES ('{$array_data[$i]}')");

The mysql library is deprecated - use mysqli or PDO instead.
Use prepared statements.

same problem and the inserted value in the is Array no the actual value

[Dormilich]

wama_mms, on 02 February 2013 - 10:58 PM, said:

same problem and the inserted value in the is Array no the actual value

see explanation above.

[wama_mms]

Dormilich, on 02 February 2013 - 02:57 PM, said:

$id is already an array and putting that into an array (line #13) you don’t loop over your array data, but the original array (which returns the string "Array" when dumped into a string).

thanks i solved it by using the $id instead of putting into array