Cannot get the page to render

zeusthegreat · October 18, 2011

index.php

?php

error_reporting(E_ALL);

ini_set('display_errors', '1');

?>

<?php

// Run a select query to get my latest 6 items

//Connect to the MySQL database

include "storescripts/connect_to_mysql.php";

$dynamicList = "";

$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 6");

$productCount = mysql_num_rows($sql);//count the the output ammount

if ($productCount > 0){

while($row = mysql_fetch_array($sql)){

$id = $row["id"];

$price = $row["price"];

$details = $row["details"];

$product_name = $row["product_name"];

$date_added = strftime("%b %d, %Y", strtotime($row["date_Added"])); // Notice here how we changed it from _added to _Added

$dynamicList .= '<table width="100%" cellpadding="6">

<tr>

<td width="34%" valign="top"><a href="product.php?"><img style="border: #666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="$product_name" width="1//Connect to the MySQL database

include "storescripts/connect_to_mysql.php";20" height="113" border="1" /></a></td>

<td width="66%" valign="top"><p> ' . $product_name . '<br />

£ ' . $price . '<br />

' . $details . '<br />

<a href="product.php?id="inventory_images/' . $id . '.jpg">View product</a></p></td>

</tr>

</table>';

}

}else{

$dynamicList = "We have no products listed in our store Yet";

}

mysql_close();

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'>http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">'>http://www.w3.org/1999/xhtml">

<head>

<title>Store </title>

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

</head>

<body onload="MM_preloadImages('style/home-grey.gif','style/web-design-grey.gif','style/web-development-grey.gif','style/e-commerce-grey.gif','style/pricing-grey.gif')">

<div align="center" id="outerMainWrapper">

<div align="center" id="mainWrapper">

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

<div id="headerNav"><table width="100%">

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

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

</div>

<div align="left" id="pageContent"><table width="98%">

<tr>

<td width="25%" valign="top">Template</td>

<td width="49%" valign="top"><p>Newest Items added to the store</p>

<p><?php echo $dynamicList; ?></p>

<!--<table width="100%" cellpadding="6">

<tr>

<td width="34%" valign="top"><a href="product.php?"><img style="border: #666 1px solid;" src="inventory_images/21.jpg" alt="$dynamicTitle" width="120" height="113" border="1" /></a></td>

<td width="66%" valign="top"><p>product Title<br />

product price<br />

product details<br />

<a href="product.php?">View product</a></p></td>

</tr>

</table> -->

<p> </p>

<!--<table width="92%" height="106" cellpadding="4">

<tr valign="top">

<td width="77%"><p>product title<br />

product price<br />

product details

<br />

<a href="Product.php">View product</a></p></td>

</tr>

</table> -->

<p> </p>

<p> </p></td>

<td width="26%" valign="top">Large templates</td>

</tr>

</table>

</div>

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

</div>

</body>

</html>

this page seems to work ok just wondering if links ok though

product.php

<?php

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'])){

//Connect to the MySQL database

include "storescripts/connect_to_mysql.php";

$id = preg_replace('#[^0-9]#i','', $_GET['id']);

//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");

$productCount = mysql_num_rows($sql);//count the the output ammount

if ($productCount > 0){

//get all the product details

while($row = mysql_fetch_array($sql)){

$product_name = $row["product_name"];

$price = $row["price"];

$details = $row["details"];

$category = $row["category"];

$subcategory = $row["subcategory"];

$date_added = strftime("%b %d, %Y", strtotime($row["date_added"])); // Notice here how we changed it from _added to _Added

//product_name,price,details,category,subcategory,date_Added

}

}else{

echo "That item does not exist";

exit();

}

}else{

echo "Data to render this page is missing";

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

<script type="text/javascript">

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

</head>

<body onload="MM_preloadImages('style/home-grey.gif','style/web-design-grey.gif','style/web-development-grey.gif','style/e-commerce-grey.gif','style/pricing-grey.gif')">

<div align="center" id="outerMainWrapper">

<div align="center" id="mainWrapper">

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

<div id="headerNav"><table width="100%">

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

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

</div>

<div align="left" id="pageContent"><table width="84%">

<tr>

<td valign="top"><table width="100%" cellpadding="6">

<tr>

<td width="33%" valign="top"><p><img src="inventory_images/<?php echo $id; ?>.jpg" alt="<?php echo $product_name; ?>" width="84" height="140" border="1" /></p>

<p><a href="inventory_images/<?php echo $id; ?>.jpg">View full size image</a></p></td>

<td width="67%" valign="top"><?php echo $product_name; ?><br />

<?php echo $price; ?><br />

<?php echo "$subcategory $category"; ?><br />

<?php echo $details; ?><br />

<br />

ADD TO CART</td>

</tr>

</table>

<p> </p>

<!--<table width="100%" cellpadding="6">

<tr>

<td width="34%" valign="top"><a href="product.php?"><img style="border: #666 1px solid;" src="inventory_images/21.jpg" alt="$dynamicTitle" width="120" height="113" border="1" /></a></td>

<td width="66%" valign="top"><p>product Title<br />

product price<br />

product details<br />

<a href="product.php?">View product</a></p></td>

</tr>

</table> -->

<p> </p>

<!--<table width="92%" height="106" cellpadding="4">

<tr valign="top">

<td width="77%"><p>product title<br />

product price<br />

product details

<br />

<a href="Product.php">View product</a></p></td>

</tr>

</table> -->

<p> </p>

<p> </p></td>

</tr>

</table>

</div>

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

</div>

</body>

</html>

i try to open this page through a browser and keep getting this error at top of the page

Data to render this page is missing

then when i try to view it on the indexpage though a link

i get this message

That item does not exist

and when i try to click the link on the picture i get

Data to render this page is missing

it is almost as if $_GET is not working

what really maddens me is at 4 oclock yesterday i had it working perfectly, but i messed up tinkering around with it

please help as i just want to return to yesterdays glory.

daddyalfie · October 19, 2011

I am certainly no PHP expert, but I noticed a missing "angle bracket" (<) in your first call for a php code. You have ?php instead of <?php as I think is proper.

Check that out and see what happens.

Alfie

Sign In

Cannot get the page to render

Recommended Posts

zeusthegreat

Link to comment

Share on other sites

daddyalfie

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Store

Support