[RESOLVED] jessie

jessiegao42

hi, can anyone help me with the pseudocode? i don't know how to write the pseudocode for something like

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

switch ($_POST['BtnSearch']) {
        case 'Sale':

thank you very much

Houdini

Do you mean?

switch ($variablename)
{
  case value:
     block of statements;
     break;
  case value:
     block of ststements;
     break;
  default:
     block of statements;
     break;
}

Where the case value is the block of code that is executed depending on the value of the $variablename in the switch statement?

Rodney_H_

You can find more info at the PHP.net site, too: http://www.php.net/switch

bradgrafelman

I believe he wants to know how to turn that code into pseudo-code. In that case, I would say something like...

if 'BtnSearch' was POST'd in a form {

 for possible values of the 'BtnSearch' field {
      if it's 'Sale' then:
           do this
           do this
           stop
      if it's 'Contact' then:
           do this
           do this
           stop
 }
}

jessiegao42

thanks lot

bradgrafelman

So... is that it? If so, don't forget to mark the thread resolved!

jessiegao42

<?php

IF (isset($_POST['AddAnn'])) {

require ('connection.php');
$table ='announcement';

	$AnnDate = $_POST['AnnDate']; 
	$AnnTitle = $_POST['AnnTitle']; 
	$AnnouncementBoard = $_POST['AnnouncementBoard']; 

	$AnnouncementData = mysql_query("SELECT AnnouncementTitle, Announcements FROM $tablename"); 

	$AddNewAnnouncement = "INSERT INTO `$table` (`AnnouncementID`, `AnnouncementDate`, `AnnouncementTitle`, `Announcements`)
	VALUES ('','$AnnDate','$AnnTitle','$AnnouncementBoard')";

	mysql_query($AddNewAnnouncement) or die(mysql_error());

	print "<center> The Announcment been added </center>";

}

bradgrafelman

if ('AddAnn' was submitted by a form) {

 require the file 'connection.php' to be loaded
 $table is 'announcement'

 $AnnDate is the submitted element 'AnnDate'
 $AnnTitle is the submitted element 'AnnTitle'
 $AnnouncementBoard is the submitted element 'AnnouncementBoard'

 $AnnouncementData = MySQL query 'SELECT AnnouncementTitle, Announcements FROM $tabelname'

 $AddNewAnnouncement = MySQL query that inserts the Date, Title, and AnnouncementBoard data into MySQL in a new row

 If AddNewAnnouncement is not successfull, stop execution and output the MySQL error message.

 print "<center> The Announcement been hadded </center>" to the user

}

Though, there are some things wrong with that code...

jessiegao42

thanks for the help, hoho, i was doing our final year project, the codes above is working currently, however i know there are some thing wrong with it, so my group memebers and i were just willing to make the codes working, that's it~..hehe.thanks a lot for your time

jessiegao42

the below is the new question which i have just now, i don't know how to translate it to pseudocode from "$Count=0...." and i also have no idea about how to write pseudocode for html codes....

<?php

// Connection to the Database
require ('connection.php');

$tablename = 'announcement'; //  Assing the Announcment as the table name

// Reterieve from the database
$AnnouncementData = mysql_query("SELECT AnnouncementTitle, Announcements FROM $tablename");

$count = 0;

//Count how many rows
$count = mysql_num_rows($AnnouncementData);


if ($AnnouncementData && $count != 0)
{	
	$i = -1;

	while($data = mysql_fetch_array($AnnouncementData)) 
	{ 

 		$i ++;
  		$AnnouncementTitle[$i] = $data["AnnouncementTitle"];
  		$Announcements[$i] = $data["Announcements"]; 

   } 


	print "<form name=\"DeleteAnnouncement\" method=\"post\" action=\"\">";
	print "<table width=\"572\" border=\"0\" align=\"center\">";
	print "<tr bgcolor=\"#0033FF\">";
	print "<td width=\"29\">&nbsp;</td>";
	print "<td width=\"156\"><div align=\"center\" class=\"style2\">Title </div></td>";
	print "<td width=\"307\"><div align=\"center\" class=\"style2\">Announcement </div></td>";
	print "</tr>";


	for ($x = 0; $x < $count; $x++)
	{
		print "<tr>";
  		print "<td height=\"47\" bgcolor=\"#EEEEEE\"><div align=\"center\">";
	    print "<input name=\"AnnouncementChoice\" type=\"radio\" value=\"$AnnouncementTitle[$i]\">";
 	    print "</div></td>";
 	    print "<td bgcolor=\"#EEEEEE\">$AnnouncementTitle[$x]</td>";
  		print "<td bgcolor=\"#EEEEEE\">$Announcements[$x]</td>";
		print "</tr>";
	}

 print "<tr bgcolor=\"#EEEEEE\">";
 print "<td height=\"23\" colspan=\"3\">";
 print "<div align=\"center\">";
 print "<input name=\"BtnDelete\" type=\"submit\" id=\"BtnDelete\" value=\"Delete\">";
 print "</div></td>";
 print "</tr>";
 print "</table>";
 print "</form>";
}	
elseif ($count == 0)
{
	print "There isn't any announcement in the database.";
}

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


	$DeleteAnnouncement = mysql_query("DELETE FROM $tablename WHERE AnnouncementTitle = '$AnnouncementChoice'"); 
	//AND Announcements = '$Announcements");
	header ('Location: DeleteAnnouncement.php');


}