abdulrahmed Posted April 15, 2012 Share Posted April 15, 2012 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> Quote Link to comment Share on other sites More sharing options...
mofm Posted April 15, 2012 Share Posted April 15, 2012 Edit you post and use the tags provided plz Quote Link to comment Share on other sites More sharing options...
abdulrahmed Posted April 15, 2012 Author Share Posted April 15, 2012 Mofm Please explain Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.