[RESOLVED] Insert with array

Fernashes

Hey all,

I need to put an array into my mysql database. I've already figured out that you can't actually insert an array into the database and that it needs to be broken up somehow. The question is, how?

This is the checkbox which is repeated for the number of articles there are in the selection:

<input type="checkbox" name="artikelid[]" value="<?php echo $row_all_records['artikelid']; ?>" />

It's passed to the next page, where the following code works with it:

$artikelid=$_POST['artikelid'];
$count=count($artikelid);

for ($i=0; $i<$count; $i++) {
    echo $artikelid[i];
}

When I try and do the following, it goes wrong. I've got it so far that it's only giving me an SQL error:

<?php 

if (isset($_POST['orderid'])) { 

$orderid=$_POST['orderid'];
$artikelid[]=$_POST['artikelid'];
$count=count($artikelid);
mysql_select_db($database_DB_tests, $DB_tests);	

for ($i=0; $i<$count; $i++) {
     $insertSQL = 'INSERT INTO ink_order_artikel (orderid, artikelid) VALUES       
     ($orderid, $artikelid[i])';
     Result = mysql_query($insertSQL, $DB_tests) or die(mysql_error());
 } //end for

 header("Location: index.php");

} //end if

else { echo "No orderid, this can't be happening!"; } 

?>

The SQL error is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[i])' at line 1

The thing is, with the code shown above, I'm not trying to insert an array - I'm trying to insert the element of an array which is really just an int.

I don't really want to use the serialize function because I want each element of the array to be a separate row in the table so I can treat it as a separate entity.

I have a feeling that the answer is right in front of my nose and I just can't quite figure it out. So any help that any one can offer would be much appreciated. 🙂

Thanks!

cahva

Change:

$insertSQL = 'INSERT INTO ink_order_artikel (orderid, artikelid) VALUES       

         ($orderid, $artikelid[i])';

..to:

$insertSQL = "INSERT INTO ink_order_artikel (orderid, artikelid) VALUES       

         ($orderid, $artikelid[i])";

If you have a variable inside single quotes, php wont parse it. With double quotes it will.
To demonstrate:

$t = 'test';

$single = '$t';
$double = "$t";

echo $single.'<br>'.$double;

Fernashes

Hi Cahva,

Thanks, I'd forgotten about that. 🙂

Problem is, I just end up with another error which doesn't make much sense to me:

Notice: Undefined index: i in C:\Web\tstadm\adm\inkoop\artikelen\test.php on line 23
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Line 23 is the line with the actual query. Since you don't have to define the variables in PHP, like "int i;"'- I'm not sure what's going on here.

Any ideas?

Thanks once again!

jernhenrik

$varname

should be

$varname[$i]

Fernashes

Ahh, you'd think I'd forgotten C and C++ by now, but nooooo, they just have to come back and haunt me! 🙂 Thanks a bunch for that tip.

I now have a different error:

Unknown column 'Array' in 'field list'

As I'm pretty sure I'm not even trying to insert an array into the db, what does that error mean?

I thought that maybe I should change this line:

$artikelid[]=$_POST['artikelid'];

to this...

$artikelid[]=$_POST['artikelid[]';

But that just give me another error:

Notice: Undefined index: artikelid[] in C:\Web\tstadm\adm\inkoop\artikelen\test.php on line 17

... and the standard MySQL error. 🙂

Thanks for all the help until now! Does anyone else have another idea?

jernhenrik

Yes, well there might be some problems with the way you get hold of your variables.

When grabbing the article id, you could use a foreach loop to catch which article id's that has been selected.

ex:

<?php



if(isset($_POST['submit']))
{
	$orderid = $_POST['orderid'];
	if(isset($_POST['artid']) )
	{ //we have selected at least one checkbox
		foreach($_POST['artid'] as $value)
		{
			$qry = "INSERT INTO ink_order_artikel (orderid, artikelid) VALUES ($orderid, $value)";
			//execute your query
			echo $qry."<br/>";

	}
}
else
{//no artid selected

	showstuff();
	echo '<br/>No values selected';
}




}
else
{
	showstuff();

}


function showstuff()
{
	//stuff from database
	$artid[]=1;
	$artid[]=2;
	$artid[]=3;
	$orderid = 12;



echo '<form method="POST" action="./phpbuilder.php">';
foreach ($artid as $value)
{
	echo 'Artid:#'.$value.' - <input type="checkbox" name="artid[]" value="'.$value.'"><br/>';
}

echo '
<input type="hidden" name="orderid" value="'.$orderid.'">
<input type="submit" name="submit" value="submit">
<form>
';

}



?>

Fernashes

Jernhenrik, thank you very much! 🙂

Works like a charm!

The actual solution to the problem lies in the following bit of code:

$orderid = $_POST['orderid']; 
if(isset($_POST['artikelid']) ) 
    { //we have selected at least one checkbox 
        foreach($_POST['artikelid'] as $value) 
        { 
            $qry = "INSERT INTO ink_order_artikel (orderid, artikelid) VALUES ($orderid, $value)"; 
            //execute your query 
            echo $qry."<br/>"; 

    } 
} 
else 
{//no artid selected 
    echo '<br/>No values selected'; 
}

Most specifically in the

foreach ($_POST['artikelid'] as $value) 
{ 
    do something with $value;
}