Passing multiple variable's

[coolphpdude]

At the minute i have a message service on my uni site. Similar to most email sites there is a tick box after the message where you can selet 1 or multiple messages then click a delete button to delete them all.

 

At present my code looks similar to this...

 

echo "<td><input class='blank' name='checkbox[]' type='checkbox' id='checkbox[]' value='".$memo['memo']." '></td>\n";

 

what i want to know is could the 'value' contain more than one field/variable? At present it only holds the memo_id, would it be possible to hold memo subject '$memo['memo_s']' as well?? If so how do you do it??

[samshel]

value attribute holds a string...it can be one field from your database...or multiple fields seperated by comma or something else...as far as it is a string, it will work

[coolphpdude]

so would sumthing like this work...

 

echo "<td><input class='blank' name='checkbox[]' type='checkbox' id='checkbox[]' value='".$memo['memo'].$memo['memo_s']." '></td>\n";

 

 

[samshel]

yes it will work unless your field dont have single or double quotes..but if you dont put a seperator in between 2 fields..how will you seperate them on next page, or you dont need to do that?

[coolphpdude]

I basically have this within the same page and the 'delete' button takes you to this section of code and refreshes the page so the memo's you have deleted disapear.

 

// delete message loop
switch(@$_GET["action"]) 
{
Case "delete":
if(is_array($_POST['checkbox']))
{
  foreach($_POST['checkbox'] as $memo)
  {
  echo "memo subject: $memo_s has been deleted.";
	mysql_query("DELETE FROM memo WHERE memo_id='$memo'") or die(mysql_error());
  }
}
//echo 'records deleted';

default:

 

so i need to get not just the memo_id but the memo subject as well. any ideas??

[samshel]

in form

echo "<td><input class='blank' name='checkbox[]' type='checkbox' id='checkbox[]' value='".$memo['memo_id'].";;".$memo['memo_s']." '></td>\n";

 

 

in code

// delete message loop
switch(@$_GET["action"]) 
{
Case "delete":
if(is_array($_POST['checkbox']))
{
  foreach($_POST['checkbox'] as $memo)
  {
            $arr = explode(";;", $memo);
                         echo "memo subject: ".$arr[1]." has been deleted.";
	mysql_query("DELETE FROM memo WHERE memo_id='".$arr[0]."'") or die(mysql_error());
  }
}
//echo 'records deleted';

default:

 

OR you can pass just id from check box and fetch subject again from database for showing subject after deletion..

[coolphpdude]

hmm that didn't work... any other ideas??

[coolphpdude]

echo "<td><input class='blank' name='checkbox[]' type='checkbox' id='checkbox[]' value='".$memo['memo"].";;".$memo['memo_s']." '></td>\n";

 

is echoing... 16;;hand in date

 

so im guessing its taking it all in as one string under $memo instead of 2 seperate variables.

 

I could do another select from the database but with high ammount of users it would be another search query which i could do without if it is possible to pass the two variables. if its not then i will have to do another select query.

[samshel]

is it showing some error ?

 

try echoing $memo in for loop

 

foreach($_POST['checkbox'] as $memo)
{
    echo $memo."<br/>";

[coolphpdude]

yeah thats what i echoed and its echooing the ID and the subject but within the same variable.

[samshel]

what does the line below that echo? also try to echo the query..

the explode function should seperate the 2 fields...

foreach($_POST['checkbox'] as $memo)
  {
            $arr = explode(";;", $memo);
                         echo "memo subject: ".$arr[1]." has been deleted.<br/>";
                         echo "DELETE FROM memo WHERE memo_id='".$arr[0]."'<br/>";
	mysql_query("DELETE FROM memo WHERE memo_id='".$arr[0]."'") or die(mysql_error());
  }

[coolphpdude]

erm i give up, i'll just do another select query to get the info i need! Cheers for your help mate