Let's start a discussion about PHP versions

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>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<meta name="viewport" content="width=device-width">

<title>Catalog of Christian Bauer Wedding Bands & Rings </title>

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

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

<script type="text/javascript">

</script>
<script language="JavaScript1.2" type="text/javascript">

</script>
<script language="JavaScript" type="text/JavaScript">

</script>

<style type="text/css">

</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">&equiv;</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">


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

</div>
</div>
<div class="sidebar">
<div class="content p7ehc-1">

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

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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

8/01/2024 7:40 pmPeterson Design Studio - jefferis

Build websites with a little help from your friends

Build websites from already-built web applications

Want your website pre-built and hosted?

Everything else!

U.S. 858.201.4911 | International +1.858.201.4911

We've earned your trust.

Connect with us.

Post a question as