putting items into an array after a post

irishgirl2004

hi,
I am using the following code

<?php
mysql_connect(localhost,"mark","****");
@mysql_select_db("phardddsd") or die( "Unable to select database");
$query = "Select * from tempcart where userid = $_SESSION[userid]";
$result1 = mysql_query($query);
if (mysql_num_rows($result1) > 0)
{

echo ("<table width=\"100%\"  border=\"0\">
  <tr bgcolor=\"#999999\">
    <td width=\"26%\" bgcolor=\"#99CCFF\"><div align=\"center\">Date Job Added </div></td>
    <td width=\"34%\" bgcolor=\"#99CCFF\"><div align=\"center\">Job Title </div></td>
    <td width=\"33%\" bgcolor=\"#99CCFF\"><div align=\"center\">Location</div></td>
    <td width=\"7%\" bgcolor=\"#99CCFF\">Delete</td>
  </tr>");
 }

while ($myrow = mysql_fetch_array($result1))
{

$query2 = "Select * from jobs where id = $myrow[2]";
$result2 = mysql_query($query2);
$myrow1 = mysql_fetch_array($result2);
$tmpdate =      strftime ("%d/%m/%Y", strtotime($myrow[11]));
echo ("  <tr bgcolor=\"#E9E9E9\">
    <td>$tmpdate </td>
    <td>$myrow1[2]</td>
    <td>$myrow1[10]</td>
    <td>
     <input type=\"checkbox\" name=\"checkbox$myrow[0]\" value=\"$myrow[0]\">
    </td>
  </tr>");



}


[code=php]

i want to read all the ID's into an array that are selected, is this possible?


thanks

scoppc

I'm not sure what u r trying to achieve, but ... sure you can store all ID into an array and only read those IDs user has selected.

<input type="checkbox" name="id[]" value="<?php print $id; ?>">

irishgirl2004

hi,
i'm posting the form to a php file, just using a submit button, so i want to have all the the values ( which are a table id ) in an array in the php file....

make sense?

thanks

scoppc

You can have your checkbox written this way

<input type="checkbox" name="id[]" value="<?php print $id; ?>">

Note: u dont need to include any index within the [].

and later on your PHP file, just get the data the normal way

$selectedid=$_POST['id']; //if u use POST as the form method

the variable $selectedid will be array.

irishgirl2004

ok, so that will put each item selected into the array?

how can i read from the array ? ( sorry , this is prob simple? )

scoppc

well, u can loop through the array using foreach()

$selectedid=$_POST['id'];
print "below is the ID u have selected<br />";
foreach ($selectedid as $tableid){
   //u can do anything to $tableid here... 
   //not limited to printing it out... u can store to tables, etc
    print $tableid . "<br />";
}

just try it out first and let us know the result.

irishgirl2004

cool, thank you..... is it possible to keep this in memory to access it from another script?

irishgirl2004

	 	$selectedid=$_POST['id'];
			print "below is the ID u have selected<br />";
			foreach ($selectedid as $tableid) {
   			//u can do anything to $tableid here...
   			//not limited to printing it out... u can store to tables, etc
    			print $tableid . "<br />";
				}  

[code=php]

i get the following error?


[code=php]
below is the ID u have selected

Warning: Invalid argument supplied for foreach() in /home/httpd/vhosts/pharmacyone.ie/httpdocs/test/deletefromcart.php3 on line 16

[code=php]

scoppc

it is because your $selectedid is empty or NOT an array. foreach() requires array as its argument to work.
Please check whether u have successfully get the ID from your form?
Make sure u do select some or one checkbox before hitting the "submit" button.

scoppc

u have few options to keep data...
if u want it to be accessible from other page... u can..

pass it using GET method... (not suitable for large data)
Keep it in cookies
Store in inside SESSION variable.
for permanent storage, consider using file or table within your database...

irishgirl2004

yes, items are being passed....

here's the code on the original form

while ($myrow = mysql_fetch_array($result1)) 
{

$query2 = "Select * from jobs where id = $myrow[2]";
$result2 = mysql_query($query2);
$myrow1 = mysql_fetch_array($result2);
$tmpdate = 	strftime ("%d/%m/%Y", strtotime($myrow[11]));
echo ("  <tr bgcolor=\"#E9E9E9\">
    <td>$tmpdate </td>
    <td>$myrow1[2]</td>
    <td>$myrow1[10]</td>
    <td>
	<input type=\"checkbox\" name=\"checkbox\" value=\"$myrow1[0]\">
    </td>
  </tr>");




}
[code=php]

and on the php script that is called, 

[code=php]
 $selectedid=$_POST['checkbox'];
print "below is the ID u have selected<br />";
foreach ($selectedid as $tableid){
   //u can do anything to $tableid here...
   //not limited to printing it out... u can store to tables, etc
    print $tableid . "<br />";
}  

[code=php]

have i been stupid?

thanks

scoppc

thx for posting your code here... at least I can try to analyze it. 🙂

while ($myrow = mysql_fetch_array($result1))
{

$query2 = "Select * from jobs where id = $myrow[2]";
$result2 = mysql_query($query2);
$myrow1 = mysql_fetch_array($result2);
$tmpdate = strftime ("%d/%m/%Y", strtotime($myrow[11]));
echo (" <tr bgcolor=\"#E9E9E9\">
<td>$tmpdate </td>
<td>$myrow1[2]</td>
<td>$myrow1[10]</td>
<td>
<input type=\"checkbox\" name=\"checkbox[]\" value=\"$myrow1[0]\">
</td>
</tr>");
}

The name of your checkbox must be corrected. Please take a closer look at the code above... you miss the [] for name="checkbox"

irishgirl2004

ok, i am getting a bit confused. I am going to need to call each checkox a different name, and then put the value from the checkbox into an array ( if it is clicked ) can this be done?

scoppc

umm... sorry to confuse u...

u dont need to call each checkbox a different name. Just call them using a name, for instance "checkbox". So, several checkboxes within your table will be having the same name. It is just that u need to give [] after the name to make all your checkboxes belongs to one object with several values (dats the concept of array).

When u select, let say, 3 out of 10 checkboxes... these 3 values will be sent to your PHP page only in one single variable, that is the $_POST['checkbox']
This variable has 3 values... in this case, 3 selected IDs.

If u named each of ur checkbox a different name, then u have to get the data one by one.

$id1=$_POST['$check1'];
$id2=$_POST['$check2'];
//and so on...