abdulrahmed
-
Posts
2 -
Joined
-
Last visited
Never
abdulrahmed's Achievements
Newbie (1/5)
0
Reputation
-
Mofm Please explain
-
Beginner to php and need assistance. I have added in the products through an admin section that is create but it doesnot reflect on the page. I get the meassge from the code : "echo "Data to render this page is missing.Get ID variable is not set. Please contact us.";". Please help Code: <?php // Script Error Reporting error_reporting(E_ALL); ini_set('display_errors', '1'); ?> <?php // Check to see the URL variable is set and that it exists in the database if (isset($_GET['?id=1'])) { // Connect to the MySQL database include "..storescripts/connect_to_mysql.php"; $id = preg_replace('#[^0-9]#i', '', $_GET['?id=1']); // Use this var to check to see if this ID exists, if yes then get the product // details, if no then exit this script and give message why $sql = mysql_query("SELECT * FROM products WHERE id='$id' LIMIT 1"); $productsCount = mysql_num_rows($sql); // count the output amount if ($productsCount > 0) { // get all the product details while($row = mysql_fetch_array($sql)){ $product_name = $row["product_name"]; $price = $row["price"]; $shippingprice = $row["shippingprice"]; $details = $row["details"]; $category = $row["category"]; $date_added = strftime("%b %d, %Y", strtotime($row["date_added"])); //product_name, price, shippingprice, details, category, date_added } } else { echo "No product in the system with that ID."; exit(); } } else { echo "Data to render this page is missing.Get ID variable is not set. Please contact us."; exit(); } mysql_close(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title><?php echo $product_name; ?></title> <link rel="stylesheet" href="style/style.css" type="text/css" media="screen" /> </head> <body> <div align="center" id="mainWrapper"> <?php include_once("template_header.php");?> <div id="pageContent"> <table width="100%" border="0" cellspacing="0" cellpadding="15"> <tr> <td width="19%" valign="top"><img src="inventory_images/<?php echo $id; ?>.png" width="142" height="188" alt="<?php echo $product_name; ?>" /><br /> <a href="inventory_images/<?php echo $id; ?>.jpg">View Full Size Image</a></td> <td width="81%" valign="top"><h3><?php echo $product_name; ?></h3> <p><?php echo "£".$price; ?><br /> <br /> <?php echo "£".$shippingprice; ?> <br /> <br /> <?php echo $details; ?> <br /> </p> <form id="form1" name="form1" method="post" action="cart.php"> <input type="hidden" name="pid" id="pid" value="<?php echo $id; ?>" /> <input type="submit" name="button" id="button" value="Add to Shopping Cart" /> </form> </td> </tr> </table> </div> <?php include_once("template_footer.php");?> </div> </body> </html>