One page is blank on remote server
hi
i developing site wife, dw cs5.5. in live view , testing server quite well. on remote server single page (product.php) blank. have checked structure, folders, files , databases of local , remote site. same.
the site www.dolls.com.sg. following code of product.php page.
tks in advance
helmut
<?php require_once('connections/conndolls.php'); ?>
<?php
if (!function_exists("getsqlvaluestring")) {
function getsqlvaluestring($thevalue, $thetype, $thedefinedvalue = "", $thenotdefinedvalue = "")
{
if (php_version < 6) {
$thevalue = get_magic_quotes_gpc() ? stripslashes($thevalue) : $thevalue;
}
$thevalue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($thevalue) : mysql_escape_string($thevalue);
switch ($thetype) {
case "text":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "long":
case "int":
$thevalue = ($thevalue != "") ? intval($thevalue) : "null";
break;
case "double":
$thevalue = ($thevalue != "") ? doubleval($thevalue) : "null";
break;
case "date":
$thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null";
break;
case "defined":
$thevalue = ($thevalue != "") ? $thedefinedvalue : $thenotdefinedvalue;
break;
}
return $thevalue;
}
}
$currentpage = $_server["php_self"];
$maxrows_rsproducts = 10;
$pagenum_rsproducts = 0;
if (isset($_get['pagenum_rsproducts'])) {
$pagenum_rsproducts = $_get['pagenum_rsproducts'];
}
$startrow_rsproducts = $pagenum_rsproducts * $maxrows_rsproducts;
mysql_select_db($database_conndolls, $conndolls);
$query_rsproducts = "select products.productid, products.productname, products.description_short, products.image1, category.categoryname products, category products.categoryid=category.categoryid";
$query_limit_rsproducts = sprintf("%s limit %d, %d", $query_rsproducts, $startrow_rsproducts, $maxrows_rsproducts);
$rsproducts = mysql_query($query_limit_rsproducts, $conndolls) or die(mysql_error());
$row_rsproducts = mysql_fetch_assoc($rsproducts);
if (isset($_get['totalrows_rsproducts'])) {
$totalrows_rsproducts = $_get['totalrows_rsproducts'];
} else {
$all_rsproducts = mysql_query($query_rsproducts);
$totalrows_rsproducts = mysql_num_rows($all_rsproducts);
}
$totalpages_rsproducts = ceil($totalrows_rsproducts/$maxrows_rsproducts)-1;$maxrows_rsproducts = 10;
$pagenum_rsproducts = 0;
if (isset($_get['pagenum_rsproducts'])) {
$pagenum_rsproducts = $_get['pagenum_rsproducts'];
}
$startrow_rsproducts = $pagenum_rsproducts * $maxrows_rsproducts;
mysql_select_db($database_conndolls, $conndolls);
$query_rscategories = "select * category order categoryname asc";
$rscategories = mysql_query($query_rscategories, $conndolls) or die(mysql_error());
$row_rscategories = mysql_fetch_assoc($rscategories);
$totalrows_rscategories = mysql_num_rows($rscategories);
$querystring_rsproducts = "";
if (!empty($_server['query_string'])) {
$params = explode("&", $_server['query_string']);
$newparams = array();
foreach ($params $param) {
if (stristr($param, "pagenum_rsproducts") == false &&
stristr($param, "totalrows_rsproducts") == false) {
array_push($newparams, $param);
}
}
if (count($newparams) != 0) {
$querystring_rsproducts = "&" . htmlentities(implode("&", $newparams));
}
}
$querystring_rsproducts = sprintf("&totalrows_rsproducts=%d%s", $totalrows_rsproducts, $querystring_rsproducts);
?>
<?php include('./includes/title.inc.php'); ?>
<!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"><!-- instancebegin template="/templates/cute.dwt.php" codeoutsidehtmlislocked="false" -->
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<!-- instancebegineditable name="title" -->
<title>cute & cosy<?php echo "—{$title}"; ?></title>
<link href="css/products.css" rel="stylesheet" type="text/css" />
<!-- instanceendeditable -->
<style type="text/css"></style>
<link href="css/cute_dwt.css" rel="stylesheet" type="text/css" />
<link href="spryassets/sprymenubarhorizontal.css" rel="stylesheet" type="text/css" />
<link href="css/oawidget.css" rel="stylesheet" type="text/css" />
<link href="yui/2.8.2r1/build/calendar/assets/skins/sam/calendar.css" rel="stylesheet" type="text/css" />
<script src="yui/2.8.2r1/build/yahoo-dom-event/yahoo-dom-event.js" type="text/javascript"></script>
<script src="yui/2.8.2r1/build/calendar/calendar-min.js" type="text/javascript"></script>
<script src="spryassets/sprymenubar.js" type="text/javascript"></script>
<script type="text/xml">
<!--
<oa:widgets>
<oa:widget wid="2443523" binding="#oawidget" />
</oa:widgets>
-->
</script>
</head>
<body>
<div id="container">
<div id="header">
<div id="banner"><img name="" src="images/general/banner.png" " alt="" /></div>
<div class="cute">cute & cosy</div>
<div class="dolls">dolls & more</div>
<div id="head"><img name="" src="images/general/bavarians.jpg" " alt="" /></div>
<!--end #header--></div>
<div class="sidebar1">
<div class="events">
<p><strong>events</strong></p><hr />
2012 sep 29/30, path market, vivocity
<hr />
2012 aug 25/26, path market, vivocity
<hr />
2012 jul 28/29, path market, vivocity
<hr />
2012 jun 30/jul 01, path market, vivocity
<hr />
2012 jun 02/03, path market, vivocity
<hr />
2012 apr 28/29, path market, vivocity
<hr />
2012 mar 31/apr 01, path market, vivocity
<hr />
2012 feb 04/05, path market, vivocity
<hr />
2011 dec 17 - 24, path market, vivocity
<hr />
2011 dec 10/11, path market, vivocity
<hr />
2011 dec 03/04, un women, "buy save" suntec city
<hr />
2011 nov 26/27, path market, vivocity
<hr />
2011 nov 21, holiday fair, embassy
<hr />
2011 nov 16 - 18, sip bazaar & exhibition
<hr />
2011 oct 29/30, path market, vivocity
<hr />
2011 jun 11/12, traffic jam project, orchard central mall
<hr />
2011 mar 06, love-in 2011 music festival, hong lim park
<hr />
2010 dec 18/19, heart, mind & body festival, suntec city
<hr />
2010 dec 11/12, unifem "buy save", m hotel, anson road
<hr />
2010 mar 20, flee market, unifem office, nassim road
<hr />
2010 mar 12/13, british club, bukit tinggi road
<hr />
<!--end .events--></div>
<div id="oawidget"></div>
<script type="text/javascript">
// beginoawidget_instance_2443523: #oawidget
document.body.classname += " yui-skin-sam";
yahoo.namespace("widget.calendar");
yahoo.init_oawidget = function() {
var ocalendar_oawidget = new yahoo.widget.calendar("ocalendar_oawidget","oawidget",
{selected: "",
mindate: null,
maxdate: null,
title: "",
close: false,
iframe: true,
multi_select: false,
navigator: false,
show_weekdays: true,
locale_weekdays: "short",
start_weekday: 0,
show_week_header: false,
show_week_footer: false,
hide_blank_weeks: false }
);
ocalendar_oawidget.render();
}
yahoo.util.event.ondomready(yahoo.init_oawidget);
// endoawidget_instance_2443523
</script>
<!-- end .sidebar --></div>
<?php $currentpage = basename($_server['script_filename']); ?>
<ul id="menubar1" class="menubarhorizontal">
<li><a href="index.php" <?php if ($currentpage == 'index.php') {echo 'id="here"';} ?>>home</a></li>
<li><a href="products.php" <?php if ($currentpage == 'products.php') {echo 'id="here"';} ?>>products</a></li>
<li><a href="about.php" <?php if ($currentpage == 'about.php') {echo 'id="here"';} ?>>about us</a></li>
<li><a href="contact.php" <?php if ($currentpage == 'contact.php') {echo 'id="here"';} ?>>contact</a></li>
<li><a href="" <?php if ($currentpage == '') {echo 'id="here"';} ?>>open</a></li>
</ul>
<!-- instancebegineditable name="content" -->
<div id="products">
<p class="records">dolls <?php echo ($startrow_rsproducts + 1) ?> <?php echo min($startrow_rsproducts + $maxrows_rsproducts, $totalrows_rsproducts) ?> of <?php echo $totalrows_rsproducts ?></p>
<p class="records"> </p>
<table width="740px" border="0" cellpadding="0" cellspacing="0" class="products">
<tr>
<th width="24%" align="left" scope="col">name</th>
<th width="35%" scope="col">description</th>
<th width="15%" scope="col">category</th>
<th width="15%" scope="col">image</th>
<th width="9%" scope="col"></th>
</tr>
<?php { ?>
<tr>
<td><?php echo $row_rsproducts['productname']; ?></td>
<td><?php echo $row_rsproducts['description_short']; ?></td>
<td><?php echo $row_rsproducts['categoryname']; ?></td>
<td><img src="images/products/<?php echo $row_rsproducts['image1']; ?>" width="100" height="100" /></td>
<td><a href="details.php?productid=<?php echo $row_rsproducts['productid']; ?>">details</a></td>
</tr>
<?php } while ($row_rsproducts = mysql_fetch_assoc($rsproducts)); ?>
</table>
<div class="next">
<table border="0">
<tr>
<td><?php if ($pagenum_rsproducts > 0) { // show if not first page ?>
<a href="<?php printf("%s?pagenum_rsproducts=%d%s", $currentpage, 0, $querystring_rsproducts); ?>">first</a>
<?php } // show if not first page ?></td>
<td><?php if ($pagenum_rsproducts > 0) { // show if not first page ?>
<a href="<?php printf("%s?pagenum_rsproducts=%d%s", $currentpage, max(0, $pagenum_rsproducts - 1), $querystring_rsproducts); ?>">previous</a>
<?php } // show if not first page ?></td>
<td><?php if ($pagenum_rsproducts < $totalpages_rsproducts) { // show if not last page ?>
<a href="<?php printf("%s?pagenum_rsproducts=%d%s", $currentpage, min($totalpages_rsproducts, $pagenum_rsproducts + 1), $querystring_rsproducts); ?>">next</a>
<?php } // show if not last page ?></td>
<td><?php if ($pagenum_rsproducts < $totalpages_rsproducts) { // show if not last page ?>
<a href="<?php printf("%s?pagenum_rsproducts=%d%s", $currentpage, $totalpages_rsproducts, $querystring_rsproducts); ?>">last</a>
<?php } // show if not last page ?></td>
</tr>
</table>
</div>
<div id="selectcat">
<select name="categories">
<?php
do {
?>
<option value="<?php echo $row_rscategories['categoryname']?>"<?php if (!(strcmp($row_rscategories['categoryname'], $row_rscategories['categoryname']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rscategories['categoryname']?></option>
<?php
} while ($row_rscategories = mysql_fetch_assoc($rscategories));
$rows = mysql_num_rows($rscategories);
if($rows > 0) {
mysql_data_seek($rscategories, 0);
$row_rscategories = mysql_fetch_assoc($rscategories);
}
?>
</select>
</div>
</div>
<!-- instanceendeditable -->
<div class="footer">
<p><a href="#">terms & conditions</a> • <a href="#">privacy policy</a> • <a href="#">site map</a></p>
<p>©
<?php
$startyear = 2011;
$thisyear = date('y');
if ($startyear == $thisyear) {
echo $startyear;
} else {
echo "{$startyear}–{$thisyear}";
}
?>
<span>cute & <a href="login.php">cosy</a></span></p>
</p>
<!-- end .footer --></div>
<!--end #container--></div>
</body>
<!-- instanceend --></html>
<?php
mysql_free_result($rsproducts);
mysql_free_result($rscategories);
?>
change -
<?php require_once('connections/conndolls.php'); ?>
<?php
to -
<?php ini_set('display_errors', 1); ?>
<?php require_once('connections/conndolls.php'); ?>
<?php
and upload page. when browse page now, error message see?
More discussions in Dreamweaver support forum
adobe
Comments
Post a Comment