Wow, Okay I opened the server behaviors on this page and found that the connection to the database was NOT in the server behavior although it was on the page ! I reconnected it and it updated to Mysqli And I am getting better results. HOWEVER, I am seeing two errors now, but thankfully NOT connection issues. I invite you to check this page.
https://ringsbychristianbauer.com/weddingrings.php It shows a ring but also another issue.
Fatal error: Uncaught Error: Call to undefined function mysql_fetch_assoc() in /usr/www/users/jodenii/cbauer/weddingrings.php:295 Stack trace: #0 {main} thrown in /usr/www/users/jodenii/cbauer/weddingrings.php on line 295
But if you click on the ring for an enlargement, it works and so does the contact page, after I updated them. What is missing is the ability to scroll through rings on this first wedding page.
The following is the updated code from the entire page. BTW, I tried to find that server behavior for these 2 items and those lines are NOT selected.
<?php require_once('Connections/WedingRings.php'); ?>
<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php
function curPageURL() {
$pageURL = 'plugins/http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
?>
<?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"];
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;
}
}
?>
<?php
$WeddingRings = new WA_MySQLi_RS("WeddingRings",$WedingRings,8);
$WeddingRings->setQuery("SELECT * FROM CKBauer");
$WeddingRings->execute();
?>
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$WedingRings,1);
$Recordset1->setQuery("SELECT * FROM CKBauer");
$Recordset1->execute();
?>
<?php
$queryString_WeddingRings = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WeddingRings") == false &&
stristr($param, "totalRows_WeddingRings") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WeddingRings = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_WeddingRings = sprintf("&totalRows_WeddingRings=%d%s", $WeddingRings->TotalRows, $queryString_WeddingRings);
?>
<!doctype html>
<html><!-- InstanceBegin template="/Templates/CKBAUER.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<meta name="viewport" content="width=device-width">
<!-- InstanceBeginEditable name="doctitle" -->
<title>Catalog of Christian Bauer Wedding Bands & Rings </title>
<!-- InstanceEndEditable -->
<script type="text/javascript" src="p7ehc/p7EHCscripts.js"></script>
<link href="p7csspbm2/p7csspbm2_06.css" rel="stylesheet" type="text/css">
<link href="p7csspbm2/p7csspbm2_print.css" rel="stylesheet" type="text/css" media="print">
<!--[if lte IE 7]>
<style>
.menutop li {display: inline;}
div, .menuside a {zoom: 1;}
.masthead .banner, .masthead .banner img {width: 100%;}
</style>
<![endif]-->
<!-- InstanceBeginEditable name="head" --><meta name="description" content="Catalog of Christian Bauer Wedding Bands and Rings, with diamonds set in Gold, Platinum and Palladium. Tricolor rings, hand made and premium quality. From Germany" /><meta name="keywords" content="catalog, Christian Bauer Wedding Bands, Rings" />
<!-- InstanceEditableHeadTag -->
<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[i])&&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[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
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[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].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[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<script language="JavaScript1.2" type="text/javascript">
<!--
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[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
/* Functions that swaps images. */
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[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
/* Functions that handle preload. */
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[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function P7_LH(){ //1.5 by PVII
MM_preloadImages('plugins/images/videobut_r1_c1_f2.gif','plugins/images/videobut_r1_c3_f2.gif','plugins/images/videobut_r1_c5_f2.gif','plugins/images/videobut_r1_c7_f2.gif');;
}
function P7_LoadHandler(a){ //1.5 by PVII
if(a==1||a==3){onload=P7_LH;}if(a>1){onresize=P7_RH;}
}
P7_LoadHandler(1);
//-->
</script>
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
#apDiv1 {
position:absolute;
left:232px;
top:86px;
width:408px;
height:21px;
z-index:1;
color: #FFF;
font-family: "Palatino Linotype", Palatino, "Book Antiqua", serif;
letter-spacing: 0.5em;
}
-->
</style>
<link href="includes/CSSPanels/folder/lightblue.css" rel="stylesheet" type="text/css" />
<link href="includes/CSSPanels/CSSPanel3.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="includes/CSSPanels/CSSPanels.js"></script>
<link href="includes/CSSPanels/CSSPanel4.css" rel="stylesheet" type="text/css" />
<link href="includes/CSSPanels/CSSPanel5.css" rel="stylesheet" type="text/css" />
<meta name="keywords" content="Christian Bauer, Wedding Rings, Wedding Bands, Hand Made" />
<link href="p7pm3/p7PM3-12.css" rel="stylesheet" type="text/css" media="all">
<script type="text/javascript" src="p7pm3/p7PM3scripts.js"></script>
</head>
<body onLoad="MM_preloadImages('plugins/images/videobut_r1_c1_f2.gif','plugins/images/videobut_r1_c3_f2.gif','plugins/images/videobut_r1_c5_f2.gif','plugins/images/videobut_r1_c7_f2.gif')">
<div class="content-wrapper">
<div class="masthead">
<div class="logo">
<h1><a href="/index.php"><img src="/images/logo.jpg" width="679" height="104" alt="Rings By Christian Bauer"></a></h1>
</div>
</div>
<div id="p7PM3_1" class="p7PM3-12 p7PM3 p7PM3noscript horiz responsive menu-centered rounded shadows auto-subs sub-left">
<div id="p7PM3tb_1" class="pmm3-toolbar closed"><a href="#" title="Hide/Show Menu">≡</a></div>
<ul class="closed">
<li><a href="/quality.php">Quality</a>
<ul>
<li><a href="/quality.php">Hand Made</a></li>
<li><a href="/movie.php">Movie</a></li>
<li><a href="/authentic.php">Maker's Mark</a></li>
</ul>
</li>
<li><a href="/weddingrings.php">Wedding Rings</a></li>
<li><a href="/contact.php">Contact Info</a></li>
<li><a href="/aboutus.php">About us</a>
<ul>
<li><a href="/aboutus.php">About Our Store</a></li>
<li><a href="/testimonials.php">Testimonials</a></li>
<li><a href="/news.php">In the News</a></li>
<li><a href="/location.php">Map & Location</a></li>
</ul>
</li>
<li><a href="/index.php">Home</a></li>
</ul>
<script type="text/javascript">P7_PM3op('p7PM3_1',1,8,-5,-5,0,1,0,1,0,1,1,1,0,900,1,0,0)</script>
</div>
<div class="columns-wrapper">
<div class="main-content">
<div class="content p7ehc-1">
<!-- InstanceBeginEditable name="mainColumn" -->
<h1>Catalog of Christian Bauer Wedding Bands & Rings</h1>
<p> </p>
<div class="repeatable" align="center">
<?php
$wa_startindex = 0;
while(!$WeddingRings->atEnd()) {
$wa_startindex = $WeddingRings->Index;
?>
<table border="0" cellpadding="0" cellspacing="0" >
<tr>
<?php
do { // horizontal looper version 3
?>
<td width="146" align="center" ><form action="form.php" method="post" enctype="multipart/form-data" target="_self" />
<input name="image" type="image" value="value" src="/thumbs/<?php echo $WeddingRings->getColumnVal('Images'); ?>" alt="<?php echo $WeddingRings->getColumnVal('Left_or_Top_Description'); ?>" width="150" height="150" border="0" id="WeddingRings" /><br />No: <?php echo $WeddingRings->getColumnVal('Left_Number'); ?>
<input name="img" type="hidden" value="<?php echo $WeddingRings->getColumnVal('Images'); ?>" />
<input name="Leftno" type="hidden" value="<?php echo $WeddingRings->getColumnVal('Left_Number'); ?>" />
<input name="Leftdesc" type="hidden" value="<?php echo $WeddingRings->getColumnVal('Left_or_Top_Description'); ?>" />
<input name="Leftdim" type="hidden" value="<?php echo $WeddingRings->getColumnVal('L_Dimensions'); ?>" />
<input name="Rightno" type="hidden" value="<?php echo $WeddingRings->getColumnVal('Right_Number'); ?>" />
<input name="Rightdesc" type="hidden" value="<?php echo $WeddingRings->getColumnVal('Right_or_Bottom_Description'); ?>" />
<input name="Rightdim" type="hidden" value="<?php echo $WeddingRings->getColumnVal('R_Dimensions'); ?>" />
<input name="Ourname" type="hidden" value="<?php echo $WeddingRings->getColumnVal('OurName'); ?>" />
<input name="CurPage" type="hidden" value="<?php echo curPageURL(); ?>" />
</form></td>
<?php
$row_WeddingRings = mysql_fetch_assoc($WeddingRings);
if (!isset($nested_WeddingRings)) {
$nested_WeddingRings= 1;
}
if (isset($row_WeddingRings) && is_array($row_WeddingRings) && $nested_WeddingRings++ % 3==0) {
echo "</tr><tr>";
}
} while ($row_WeddingRings); //end horizontal looper version 3
?>
</tr>
</table>
<?php
$WeddingRings->moveNext();
}
$WeddingRings->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?></div>
<div align="center"><table border="0" align="center" cellpadding="0" cellspacing="0" id="repeatnav">
<tr>
<td colspan="5" align="center"><img src="/images/images/spacer.gif" width="250" height="1" alt="spacer" /></td>
</tr>
<tr>
<td align="center"><?php if ($WeddingRings->PageNum > 0) { // Show if mysqli not first page ?>
<a href="<?php echo $WeddingRings->getFirstPageLink(); ?>" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('videobut_r1_c1','','plugins/images/videobut_r1_c1_f2.gif',1);"><img name="videobut_r1_c1" src="images/videobut_r1_c1.gif" width="42" height="13" border="0" id="videobut_r1_c1" alt="First" /></a>
<?php } // Show if mysqli not first page ?>
<?php if ($WeddingRings->PageNum == 0) { // Show if mysqli first page ?>
<img src="/images/videobut_r1_c1_f2.gif" width="42" height="13" alt="spacer" />
<?php } // Show if mysqli first page ?></td>
<td><?php if ($WeddingRings->PageNum > 0) { // Show if mysqli not first page ?>
<a href="<?php echo $WeddingRings->getPrevPageLink(); ?>" onmouseover="MM_swapImage('videobut_r1_c3','','plugins/images/videobut_r1_c3_f2.gif',1)" onmouseout="MM_swapImgRestore()"><img name="videobut_r1_c3" src="/images/videobut_r1_c3.gif" width="41" height="13" border="0" id="videobut_r1_c3" alt="Previous" /></a>
<?php } // Show if mysqli not first page ?><?php if ($WeddingRings->PageNum == 0) { // Show if mysqli first page ?>
<img src="/images/videobut_r1_c3_f2.gif" width="41" height="13" alt="spacer" />
<?php } // Show if mysqli first page ?></td>
<td align="center"><?php if ($WeddingRings->PageNum < $WeddingRings->TotalPages) { // Show if mysqli not last page ?>
<a href="<?php echo $WeddingRings->getNextPageLink(); ?>" onmouseover="MM_swapImage('videobut_r1_c5','','plugins/images/videobut_r1_c5_f2.gif',1)" onmouseout="MM_swapImgRestore()"><img name="videobut_r1_c5" src="/images/videobut_r1_c5.gif" width="35" height="13" border="0" id="videobut_r1_c5" alt="Next" /></a>
<?php } // Show if mysqli not last page ?>
<?php if ($WeddingRings->PageNum >= $WeddingRings->TotalPages) { // Show if mysqli last page ?>
<img src="/images/videobut_r1_c5_f2.gif" width="35" height="13" alt="spacer" />
<?php } // Show if mysqli last page ?></td>
<td align="center">
<a href="<?php echo $WeddingRings->getLastPageLink(); ?>" onmouseover="MM_swapImage('videobut_r1_c7','','plugins/images/videobut_r1_c7_f2.gif',1)" onmouseout="MM_swapImgRestore()">
<?php if ($WeddingRings->PageNum < $WeddingRings->TotalPages) { // Show if mysqli not last page ?>
<img name="videobut_r1_c7" src="/images/videobut_r1_c7.gif" width="37" height="13" border="0" id="videobut_r1_c7" alt="Last" />
<?php } // Show if mysqli not last page ?>
</a>
<?php if ($WeddingRings->PageNum >= $WeddingRings->TotalPages) { // Show if mysqli last page ?>
<img src="/images/videobut_r1_c7_f2.gif" width="37" height="13" alt="spacer" />
<?php } // Show if mysqli last page ?></td>
<td> </td>
</tr>
</table>
</div>
<p>Platinum is the purest, rarest and most enduring precious metal on our planet. Whilst it melts the hearts of lovers all over the world, it takes 1772°c to melt platinum itself. This noble metal is extremely kind to the skin (hypoallergenic) complimented by a unique silky texture. It has a weight and presence that exudes rarity and status. The pure white lustre of platinum shines like the moon. And if you look very carefully, you can see moon-dust in every Christian Bauer platinum ring!</p>
<p>For more than 4000 years gold has been the traditional choice for precious jewellery, portable wealth and payment across countries and continents. It has fascinated man from the very beginnings of civilisation. Its unique colour, weight and malleability have given it a special place in the hearts of mankind. Today Christian Bauer takes this amazing metal and forges it into the most fabulous wedding rings in the world.</p>
<p>With the Christian Bauer ‘system collection’ you can design your own ring. Which profile should you choose? Would you prefer platinum of gold? Which width would look best and which finish, polished or satin? Perhaps a diamond would add something special or maybe more than one. Finally, a special message laser-engraved inside would add a really personal touch, especially in your partners own handwriting
!</p>
<!-- InstanceEndEditable -->
</div>
</div>
<div class="sidebar">
<div class="content p7ehc-1">
<!-- InstanceBeginEditable name="RightCol" -->
<p>Wedding ring film<br />
Get to know Christian Bauer wedding rings and see how a high value wedding ring is produced.<br />
<a href="/movie.php">More on this…</a></p>
<!-- InstanceEndEditable -->
</div>
</div>
</div>
<div class="footer">
<p class="copyright">We are an authorized
jeweler for Christian Bauer. ©2016 for Joden World Resources by <a href="http://www.petersonsales.net" target="_blank">Peterson Design Studio</a> <br />
<div align="center"><a target="_blank"
href="https://www.bbb.org/online/consumer/cks.aspx?id=1091026142955"><br />
<img
src="/images/bbbsealh1US.gif" alt="Click to verify BBB accreditation and to see a BBB
report." width="135" height="51" border=0
title="Click to verify BBB accreditation and to see a BBB report." /></a></p>
</div>
</div></div>
</body>
<!-- InstanceEnd --></html>