faqts : Computers : Programming : Languages : PHP : Not Quite PHP : HTML

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

14 of 22 people (64%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

How do I achieve the effect of presenting a Please wait page, while waiting for a large database table to be loaded up?

Apr 4th, 2000 09:28
Allan Taylor, Joe Cheong,


I acheived this using the following code. Hopefully it is self 
explanatory
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function doSubmit($var1)
 {
location.href = "filename.phtml?var2=$var1"; 
 }
//-->
</script>
</head>
<body 
<?
IF (ISSET($ITEM))  /* If there has NOT been given a value for selected 
product */
{ // begin IF ISSET
	echo "<center><table BORDER=2 CELLSPACING=3 CELLPADDING=3 
WIDTH='98%' BGCOLOR='black'>"
	."<tr ALIGN=CENTER><td><font color=yellow 
size=+4><blink>Searching 
Database</blink></font></td></tr></table></center>";
	echo "<SCRIPT LANGUAGE=\"JavaScript\">";
	{
	echo "doSubmit($var1)";// calls javascript function to load new 
page
	}
	echo "</script>";
} //  end ISSET set 
else
{ // begin if NOT ISSET
?>
<center><table BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="98%" >
<tr ALIGN=CENTER>
<td ALIGN=CENTER><form action="<? ECHO $PHP_SELF ?>" method=POST>
<table BORDER=2 >
<tr>
<th><font size=+1>Product:</font></th>
<td><select NAME=ITEM SIZE="10"><option SELECTED VALUE="">------Items 
For Sale -------
<?
$Dbname = "nameofyourdatabase"; // name of data base
$Tbname_3 = "tablename1"; // name of table1
$Tbname_4 = "tablename2"; // name of table2
$Tbname_5 = "tablename..."; // name of table ditto
msql_connect(); // connects to the msql-server on Localhost
$variablename = MSQL($Dbname,"SELECT * FROM $Tbname_3");
WHILE($row = msql_fetch_row($variablename)) // loop until all products 
in table for selecting
{  //begin WHILE loop1
       echo "<option>".($row[0])." ".($row[2])." ".($row[3])."\n"; 
	/* finds fields item_num, category and description*/
} // end WHILE loop1
msql_free_result($products);
/* To release the memory occupied by the product */
?></select></td></tr>
<tr><td><BR></td>
 <TD><input type="submit" value="SUBMIT">
</TD></tr></table>
</td></tr></table></center>
</form>
<?
	echo "<center><h3><font color=\"red\">PLEASE select an 
Item</font></h3></center>";
} // end if NOT ISSET
?>
</body>
</html>