1 / 13

A Simple Online Store

A Simple Online Store. By: Lisa Schwartz ECE 3553 – Multifarious Systems Dr. Këpuska – Fall 2006. Problem Statement:. The goal of this project is to create an online store from which the user can create an account, log-in, input his/her address and credit card

hoshi
Download Presentation

A Simple Online Store

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Simple Online Store By: Lisa Schwartz ECE 3553 – Multifarious Systems Dr. Këpuska – Fall 2006

  2. Problem Statement: The goal of this project is to create an online store from which the user can create an account, log-in, input his/her address and credit card information, and “purchase” items.

  3. A Few Details and Features: All user inputs will be verified for validity of type and length using regular expressions and if statements. • if ( !ereg("^[A-Za-z0-9 ]{1,12}$", $password)) • { • passwordTooLong(); • die(); • } • if ( !$street || !$city || !$state || !$zip_code ) • { • fieldsBlank(); • die(); • }

  4. The project uses a session to know which user is logged-in at the time and store other variables. • <?php session_start(); ?> • $_SESSION['total'] = $total; • $tot = $_SESSION['total']; • session_destroy();

  5. White pages are “stationary” pages, while yellow pages will be redirected after a timer expires. • print( "You are being redirected to a page to enter your new address" ); • print( "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"3; • URL=http://my.fit.edu/~schwartz/fp5.html\">" ); • print( "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; • URL=http://my.fit.edu/~schwartz/fp3.php\">" ); • <p><a href = "http://my.fit.edu/~schwartz/fp11.php">Logout</a></p>

  6. Queries are used to insert, delete, update, and select to/from the database. • $query = "SELECT Account_Number, Street, City, State, Zip_Code FROM • Addresses WHERE Account_Number = " . $_SESSION['acc_num'] . ""; • $query2 = "INSERT INTO Shopping_Cart ( Account_Number, Item_ID ) • VALUES ( " . $_SESSION['acc_num'] . ", '$item')"; • $query = "UPDATE Addresses SET Street = '$street', City = '$city', • State = '$state', Zip_Code = '$zip_code' WHERE • Account_Number = " . $_SESSION['acc_num'] . ""; • $query = "DELETE FROM Shopping_Cart WHERE • Account_Number = " . $_SESSION['acc_num'];

  7. PHP functions are defined to inform the user of any invalid entries. • function passwordTooLong() • { • print( "<title>Access Denied</title></head><body style = \"font-family: • arial; font-size: 1em; color: red\"><strong>Please make sure your • password is 12 characters or less.<br /></strong>" ); • } • function noItems() • { • print( "<title>Access Denied</title></head><body style = \"font-family: • arial; font-size: 1em; color: red\"><strong>You have no items in • your cart!<br /></strong>" ); • }

  8. Tables were used to organize the forms. • print( "<table border = \"0\" cellpadding = \"2\" cellspacing = \"0\" • width = \"45%\">" ); • print( "<tr><td>Type of Card:</td><td><select name = \"type\">" ); • print( "<option value = \"Discover\" selected = \"selected\" > • Discover</option>" ); • print( "<option value = \"Mastercard\">Mastercard</option>" ); • print( "<option value = \"Visa\">Visa</option>" ); • print("<option value = \"AmericanExpress\">American • Express</option></td></tr></select>"); • print( "<tr><td>Number:</td><td><input type = \"text\" • name = \"number\" /></td></tr>" );

  9. Continued… • print( "<tr><td>Expiration Year:</td><td><select name = \"year\">" ); • print( "<option value = \"2006\" selected = \"selected\">2006</option>" ); • print( "<option value = \"2007\">2007</option>" ); • print( "<option value = \"2008\">2008</option>" ); • print( "<option value = \"2009\">2009</option>" ); • print( "<option value = \"2010\">2010</option>" ); • print( "<option value = \"2011\">2011</option>" ); • print( "<option value = \"2012\">2012</option></td></tr></select>" ); • print( "</table>" );

  10. Tables were also used in the display of the Shopping Cart. • print( "<table border = \"1\" cellpadding = \"2\" cellspacing = \"0\" • width = \"85%\">" ); • print( "<tr><th>SHOPPING CART</th><th>Item Id</th> • <th>Item Name</th><th>Quantity</th><th>Unit Price</th></tr>" ); • for ($counter2 = 0; $row2 = mysql_fetch_row($result2); $counter2++) • { • $row21 = $row2[1]; • if(!isset($myItems[$row21])) • $myItems[ $row21 ] = 1; • else • $myItems[ $row21 ] ++; • }

  11. Continued… • for ($counter = 0; $row = mysql_fetch_row($result); $counter++) • { • foreach($myItems as $key => $value ) • { • if ( $key == $row[0] ) • { • print( "<tr><td></td><td>" . $key . "</td><td>" . $row[2] . • "</td><td>" . $value . "</td><td>$" . $row[1] . "</td></tr>" ); • $subtotal += $value*$row[1]; • $totalNumberOfItems += $value; • } • } • }

  12. Continued… • if ( ereg("^[1-9]+.[0-9]{1}$", $subtotal)) • print( "<tr><td>Subtotal</td><td></td><td></td><td>" . • $totalNumberOfItems . "</td><td>$" . $subtotal . "0</td></tr>" ); • elseif ( ereg("^[1-9]+$", $subtotal)) • print( "<tr><td>Subtotal</td><td></td><td></td><td>" . • $totalNumberOfItems . "</td><td>$" . $subtotal . ".00</td></tr>" ); • else • print( "<tr><td>Subtotal</td><td></td><td></td><td>" . • $totalNumberOfItems . "</td><td>$" . $subtotal . "</td></tr>" );

  13. Acknowledgements • Thanks to everyone that helped me test my code and a big thanks to Tudor that assisted me whenever I got stuck on something!

More Related