statement ???

npereira

Hello all,

If you have a bunch of IF() statement that get activated by pressing a button.
Example code:

if($addNow == 'ADD')
{
$query = "insert into membres (prenom, nom, adresse, 
telephone, fréquence, email)values
('$addFirstName', '$addLastName', '$addAddress', '$addTelephon
e', '$addFrequency', '$addEmail')";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Terminé l'opération ajoue</h1>";
}
if($add == 'ADD')
{
	print("<table border=\"0\" width=\"900\">");
					echo "<form action=\"$PHP_SELF\" method=\"post\">";
					printf("<td valign=\"top\"><h1>Ajouter:</h1></td><td valign=\"top\" 
align=\"left\">Prénom: <input type=\"text\" 
name=\"addFirstName\"><br>Nom: <input type=\"text\" 
name=\"addLastName\"><br>Adresse: <input type=\"text\" 
name=\"addAddress\"><br>Téléphone: <input type=\"text\" 
name=\"addTelephone\"><br>Fréquence: <input type=\"text\" 
name=\"addFrequency\"><br>Email: <input type=\"text\" 
name=\"addEmail\">");
					print("</td>");
					echo "<input type=\"submit\" name=\"addNow\" value=\"ADD\">";
					echo "</form>";
	echo "</table>";
}

How do you make it so that if no buttons are pressed, to do a specific task?
Example code;


IF NOTHING IS DONE, DO THIS !

{
print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\"><tr>");
print("<form action = \"$PHP_SELF\" method=\"post\">");
print("<input type=\"submit\" name=\"edit\" value=\"EDIT\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"add\" value=\"ADD\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"delete\" value=\"DELETE\">&nbsp;&nbsp;&nbsp;");
print("</td></tr>");
$count		=	1;
$colsprinted	=	0;
$totalcols	=	3;
$totalitems	=	0;
$query 		=	"select * from membres order by nom";
$mysql_result	=	mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
print("</tr><tr>");
$colsprinted	=	0;
}
printf("<td valign=\"top\" style=\"border-bottom: solid 1 #000000
\"><input type=\"checkbox\" name=\"checkbox$count\" 
value=\"%s\" unchecked>%s, %s<br>%s<br><b>Tel.:</b> %s   

<b>Fréq.:</b> %s<br><b>Email:</b> %s</td>", $row[0], $row
[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
print("</td></tr>");
print("</form>");
print("</table>");
}

What STATEMENT is needed to acheive this?

Thanks in advance for your help.

Nelson

asolell

switch ($MessageType)
{

 case "SellMyCar":
 echo "This will do something-1";
 if...  just enter everything you want done under this area.

 break;


 case "BuyMyCar":
 echo "This will do something-2";

 break;

 case "123":
 echo "This will do something-3";
 break;

 default:
 echo "Gush.. you didn't select any of the options!";
 break;

}

HTH

-Alon
js@wsco.com

npereira

What do you mean by

switch ($MessageType)

Do I have to change the "MessageType" to something or what?

thanks

Nelson

asolell

switch is a reserved word that is the function that checks the different cases.

the variableb $MessageType should recieve a value from the submit button (each button would submit a different value).
You can use instead of the submit button,.. radio buttons, or whatever you want that sends the value and is 'picked up' by the variable $MessageType. (MessagType is just the name that
I used in my code.. you can call it whatever you want).

npereira

Ok, i'll try this right now.

npereira

if I use a button, is it the name or the value that the case should reflect?

asolell

Switch (NAME)

case value:

npereira

Something is not right!
This is not working.

here is my script:

<?

include("./dbconnect.php");
print("<body bgcolor=\"#6699CC\">");
///////////////////////////////////////////////////////////////////////

switch ($MessageType)
{
/** BEGIN IF THE EDIT BUTTON IS PRESSED **/
case saveNow:
$query = "update membres set prenom = '$editFirstName', nom = '$editLastName', adresse = '$editAddress', telephone = '$editTelephone', fréquence = '$editFrequency', email = '$editEmail' where id = '$ID'";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Terminé l'opération modifié</h1>";
break;
case addNow:
$query = "insert into membres (prenom, nom, adresse, telephone, fréquence, email)values('$addFirstName', '$addLastName', '$addAddress', '$addTelephone', '$addFrequency', '$addEmail')";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Terminé l'opération ajoue</h1>";
break;
case deleteNow:
$query = "delete from membres where id = '$ID'";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Terminé l'opération éffacer</h1>";
break;

/////////////////////////////////////////////////////////////////////

case edit:
	$countnow		= 0;
	$totalcols1		= 3;
	$colsprinted1 		= 0;
	$totalcolsprinted 	= 0;
	$sumcolsprinted 	= 0;
	print("<table border=\"0\" width=\"900\">");
	while($countnow <= $totalitems)
	{
		$countnow++;
		$item = ${'checkbox'.$countnow};
		if($item != '')
		{
			if($colsprinted1 == $totalcols1)
				{
					print("</tr><tr>");
					$colsprinted1 = 0;
				}
			$query0 	= 	"select * from membres where id = '$item'";
			$mysql_result0	=	mysql_query($query0, $mysql_link);
			while($row0 = mysql_fetch_row($mysql_result0))
				{
					echo "<form action=\"$PHP_SELF\" method=\"post\">";
					printf("<td valign=\"top\"><h1>Editing:</h1></td><td valign=\"top\" align=\"left\"><h1>%s, %s</h1>Prénom: <input type=\"text\" name=\"editFirstName\" value=\"%s\"><br>Nom: <input type=\"text\" name=\"editLastName\" value=\"%s\"><br>Adresse: <input type=\"text\" name=\"editAddress\" value=\"%s\"><br>Téléphone: <input type=\"text\" name=\"editTelephone\" value=\"%s\"><br>Fréquence: <input type=\"text\" name=\"editFrequency\" value=\"%s\"><br>Email: <input type=\"text\" name=\"editEmail\" value=\"%s\">", $row0[2], $row0[1], $row0[1], $row0[2], $row0[3], $row0[4], $row0[5], $row0[6]);
					echo "<input type=\"hidden\" name=\"ID\" value=\"$row0[0]\">";
					echo "<input type=\"submit\" name=\"saveNow\" value=\"saveNow\">";
					print("</td>");
					echo "</form>";
				}
			$colsprinted1++;
			$totalcolsprinted++;
			$sumcolsprinted++;
		}
	}
break;
/** END OF EDIT BUTTON PRESSED **/

/** BEGIN IF THE ADD BUTTON IS PRESSED **/

case add:
	print("<table border=\"0\" width=\"900\">");
					echo "<form action=\"$PHP_SELF\" method=\"post\">";
					printf("<td valign=\"top\"><h1>Ajouter:</h1></td><td valign=\"top\" align=\"left\">Prénom: <input type=\"text\" name=\"addFirstName\"><br>Nom: <input type=\"text\" name=\"addLastName\"><br>Adresse: <input type=\"text\" name=\"addAddress\"><br>Téléphone: <input type=\"text\" name=\"addTelephone\"><br>Fréquence: <input type=\"text\" name=\"addFrequency\"><br>Email: <input type=\"text\" name=\"addEmail\">");
					print("</td>");
					echo "<input type=\"submit\" name=\"addNow\" value=\"addNow\">";
					echo "</form>";
	echo "</table>";
break;
/** END OF ADD BUTTON PRESSED **/

/** BEGIN IF THE DELETE BUTTON IS PRESSED **/

case delete:
	$countnow		= 0;
	$totalcols1		= 3;
	$colsprinted1 		= 0;
	$totalcolsprinted 	= 0;
	$sumcolsprinted 	= 0;
	print("<table border=\"0\" width=\"900\">");
	while($countnow <= $totalitems)
	{
		$countnow++;
		$item = ${'checkbox'.$countnow};
		if($item != '')
		{
			if($colsprinted1 == $totalcols1)
				{
					print("</tr><tr>");
					$colsprinted1 = 0;
				}
			$query0 	= 	"select * from membres where id = '$item'";
			$mysql_result0	=	mysql_query($query0, $mysql_link);
			while($row0 = mysql_fetch_row($mysql_result0))
				{
					echo "<form action=\"$PHP_SELF\" method=\"post\">";
					printf("<td valign=\"top\"><h1>Voulez-vous vraiement éffacer ce/ces membre/es?</h1></td></tr><tr><td valign=\"top\" align=\"left\"><h2><font color=\"#FF0000\">%s, %s</font></h2>", $row0[2], $row0[1]);
					print("</td>");
					echo "<input type=\"hidden\" name=\"ID\" value=\"$row0[0]\">";
					echo "<input type=\"submit\" name=\"deleteNow\" value=\"deleteNow\">";
					echo "</form>";
				}
			$colsprinted1++;
			$totalcolsprinted++;
			$sumcolsprinted++;
		}
	}
break;
/** END OF DELETE BUTTON PRESSED **/



///////////////////////////////////////////////////////////////////////


///////////////////////////////////////////////////////////////////////
default:
print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\"><tr>");
print("<form action = \"$PHP_SELF\" method=\"post\">");
print("<input type=\"submit\" name=\"edit\" value=\"edit\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"add\" value=\"add\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"delete\" value=\"delete\">&nbsp;&nbsp;&nbsp;");
print("</td></tr>");
$count		=	1;
$colsprinted	=	0;
$totalcols	=	3;
$totalitems	=	0;
$query 		=	"select * from membres order by nom";
$mysql_result	=	mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
print("</tr><tr>");
$colsprinted	=	0;
}
printf("<td valign=\"top\" style=\"border-bottom: solid 1 #000000\"><input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked>%s, %s<br>%s<br><b>Tel.:</b> %s   <b>Fréq.:</b> %s<br><b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
print("</td></tr>");
print("</form>");
print("</table>");
break;

////////////////////////////////////////////////////////////////////////
}


?>

asolell

"edit"
"add"
"delete"

You forgot to put quation marks.
It is case sensitive.
Your submit button,..should have the same name for all
three buttons, but the value needs to different.

So that when you click anyone of the buttons,. the name
is "MessageType" .
Then,..when it gets to the recieving page... it will
see.. OH.. I have a $MessagType,.. let me examine it
and see if it's value is matching any of my cases.

npereira

I'll put the quotation marks and change the "name" of each button to be "MessageType"

npereira

Almost there!
take this example;

surf to (the script) memberlist.php
select a record and click "edit",
edit the record and click "saveNow",
I get a blank page that says edit was successful which is actualy
the part

case saveNow:
$query = "update membres set prenom = '$editFirstName', nom 
= '$editLastName', adresse = '$editAddress', telephone 
= '$editTelephone', fréquence = '$editFrequency', email 
= '$editEmail' where id = '$ID'";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Terminé l'opération modifié</h1>";
break;

that executes wich is good. Although, I would like the script to take me back to the "default:" after this.

How can I do this?

npereira

I got it!

I just put a

print("<meta http-equiv=\"refresh\" content=\"2\">");

just before the "break;"

All is good now! YA BABY!

Thanks to all that have helped me.

Nelson