Data to render page missing

abdulrahmed · 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">

<head>

</head>

<body>

<?php include_once("template_header.php");?>

<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>

<br />

<?php echo "£".$shippingprice; ?> <br />

<br />

<?php echo $details; ?>

<br />

</p>

</form>

</td>

</tr>

</table>

</div>

<?php include_once("template_footer.php");?>

</div>

</body>

</html>

mofm · April 15, 2012

Edit you post and use the

 tags provided plz

abdulrahmed · April 15, 2012

Mofm

Please explain

Sign In

Data to render page missing

Recommended Posts

abdulrahmed

Link to comment

Share on other sites

mofm

Link to comment

Share on other sites

abdulrahmed

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information