3658l1.orig100664 777 330 1532 7062317216 12144 0ustar ljeditorljedit3658l1 Listing 1. getnamenum.php3 "; // simple echo of string echo "What is your name?

"; echo "

"; echo "First Name:
"; //note quotes within quotes are escaped with a //backslash echo "Last Name:
"; echo "Enter two numbers to add: "; echo "
"; echo ""; echo "
"; ?> @fig:respond.php3 @cx: "; // echo of // cgi vars passed in $z=$x+$y; i // perform calculation echo "$x + $y = $z !"; ?> 3658l2.orig100664 777 330 1041 7062317244 12141 0ustar ljeditorljedit3658l2 Listing 2. Numbered Checklist Check off the numbers you want to include:

"; for($i=0;$i<20;$i++) { echo " $i"; echo "

\n"; } echo ""; #note quotes are escaped with backslash inside a #quoted string /* note that this is also a comment and the \n above makes the HTML more readable. It doesn't affect the user as browser sees it as white space */ ?> 3658l3.orig100664 777 330 352 7062317407 12127 0ustar ljeditorljedit3658l3 Listing 3. respond2.php3 You selected:

"; } ?> 3658l4.orig100664 777 330 2505 7062317501 12145 0ustar ljeditorljedit3658l4 Listing 4. Connecting to MySQL mysql> CREATE TABLE parts ( partno int(11) DEFAULT '0' NOT NULL, parentpartno int(11), description char(255), price decimal(8,2), shipweight decimal(10,4), PRIMARY KEY (partno) ); -----------php code------------ $connection = mysql_connect("127.0.0.1","root","tiger"); $db="stores"; $query=mysql_db_query($db,"SELECT partno,parentpartno,description,price FROM parts ",$connection); $rowno=mysql_num_rows($query); if ($rowno) { echo "

"; echo ""; echo ""; echo ""; while($rowno-){ $row=mysql_fetch_array($query); echo "\n"; for($i=0;$i<4;$i++) { $value=$row[$i]; echo " "; } echo "\n"; // want to use partnumber as param to checkout // script,that is field 0 of query } echo "

Parts List

Part # Parent Part # Description Price Include in Cart
$value
"; } echo ""; 3658l5.orig100664 777 330 1150 7062317561 12147 0ustar ljeditorljedit3658l5 Listing 5. Creating Selected Items Table mysql> CREATE TABLE saleitems ( saleid int(11) DEFAULT '0' NOT NULL, partno int(11) DEFAULT '0' NOT NULL, quantity int(11) DEFAULT '0' NOT NULL ); --------php code--------- //would need database connection as above //also need a mechanism for defining saleid.... while (list($mine,$junk)=each($HTTP_GET_VARS)){ //retrieve the cgi variable names and values as a //pair from the //associative array $HTTP_GET_VARS--one pair at a //time $queryins=mysql_db_query($db,"INSERT INTO saleitems (saleid,partno,quantity) VALUES ($thesaleid,$mine,$junk)",$connection); }