Search / Results Page not showing results

Report · Dec 14, 2012

Hello, I am designing a "catalog" website for my work, which requires a "search products" element.

I have read that I need to do this "dynamically" in PHP and MySQL and so have been learning how to do this, and so far I have managed to:

1) set up WAMP

2) create "4 products (will eventually be 300 when I know it works)" sample database and have it "talk" to Dreamweaver (CS6)

3) Set up the "search form button"

4) create a search_results.php page with the dynamic table to hold the data / recordset

5) Get the correct results when I "test" the recordset as shown below: (i.e using "black" as the search test word which does correctly shows the one product out of the 4 that has black in the description column)

click on pic below to view:

6) it looks like it added it to the table correctly in design view in dreamweaver:

7) but when I preview it in the browser and type in "black" into the search box I dont get any results? I only get the titles of the columns? (image below of the results I get in the browser):

I've been looking on the internet / adobe help and have the "dummies" books and lynda.com dvds, but i've yet to find clear step by step instructions on how to do this properly - every source tends to miss out important steps and offers no solutions - according to lynda.com training dvd, it should now just work!. Does anyone know what I should be doing - I appear to be going around in circles with this one? thanks.

PS I am a designer, and not a coder, and doing a dynamic site for the first time with no code knowledge, so please be gentle

Report · Dec 14, 2012

code below incase this helps:

<?php require_once('Connections/eternatest.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;

}

$maxRows_Recordset1 = 10;

$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {

$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "-1";

if (isset($_GET['description'])) {

$colname_Recordset1 = $_GET['description'];

}

mysql_select_db($database_eternatest, $eternatest);

$query_Recordset1 = sprintf("SELECT * FROM productslist WHERE `description` LIKE %s ORDER BY code ASC", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"));

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $eternatest) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {

$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

$all_Recordset1 = mysql_query($query_Recordset1);

$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

?>

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

<head>

<title>Eterna Lighting Ltd</title>

.maincontainer {

width: 850px;

margin-right: auto;

margin-left: auto;

}

.header {

background-color: #333;

height: 70px;

width: 850px;

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

color: #FFF;

background-image: url(images/header_eterna.jpg);

}

.topnav {

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

text-transform: uppercase;

color: #FFF;

background-color: #000;

text-align: right;

height: 20px;

width: 850px;

padding-top: 4px;

}

.leftnav {

width: 180px;

list-style-type: none;

float: left;

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

color: #000;

background-color: #FFF;

padding-top: 5px;

padding-bottom: 5px;

}

.advert {

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

height: 100px;

width: 850px;

margin-top: 5px;

}

.productarea {

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

width: 660px;

float: left;

height: 800px;

padding-left: 5px;

padding-top: 5px;

overflow: scroll;

margin-top: 5px;

margin-bottom: 5px;

margin-left: 5px;

}

.footer {

position: relative;

clear: both;

height: 50px;

width: 850px;

font-family: Arial, Helvetica, sans-serif;

font-size: 14px;

padding: 0px;

}

a:link {

color: #333;

}

a:visited {

color: #333;

}

a:hover {

color: #999;

}

a:active {

color: #999;

}

.maincontainer .topnav a:link {

color: #FFF;

text-decoration: underline;

}

.maincontainer .topnav a:visited {

color: #FFF;

text-decoration: underline;

}

.maincontainer .topnav a:hover {

color: #999;

text-decoration: underline;

}

.maincontainer .topnav a:active {

color: #999;

text-decoration: underline;

}

a img {

border:none;

}

</style>

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=new Image; d.MM_p[j++].src=a;}}

}

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_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)&&d.all) x=d.all; for (i=0;!x&&i<d.forms.length;i++) x=d.forms;

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>

<tr>

</tr>

<tr>

<label for="search_box">Search</label>

</form></td>

</tr>

<tr>

</tr>

</table>

</div>

<tr>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

<tr>

<td>description</td>

</tr>

<?php do { ?>

<tr>

</tr>

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

</table>

</div>

</div>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

Report · Dec 14, 2012

dont worry - i've figured it out.

Search / Results Page not showing results

1 Correct answer