close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Let's start a discussion about PHP versions

Thread began 10/12/2023 3:44 pm by Patrice | Last modified 12/18/2024 2:23 am by Patrice | 9232 views | 92 replies

Peterson Design Studio - jefferis

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 &amp; 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">&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 &amp; 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 &amp; Rings</h1>
<p>&nbsp;</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>&nbsp;</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>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...