Inspiring

解決済み

Search / Results Page not showing results

Forum|Forum|13 years ago
December 14, 2012
返信数 1.
1040 ビュー

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

このトピックへの返信は締め切られました。

解決に役立った回答 Sara_Reese

dont worry - i've figured it out.

Sara_Reese作成者

Inspiring

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>

<meta name="description" content="Eterna Lighting are market leading importers and distributors of utility lighting products and electrical accessories, to electrical wholesale and OEM customers." />

</head>

<div class="maincontainer">

<div class="header">

<table width="850" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="587" height="20"> </td>

<td width="263"> </td>

</tr>

<tr>

<td> </td>

<td><form action="search_results.php" method="post" name="form1" target="_self" id="form1">

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

<input type="text" name="search_box" id="search_box" />

<input type="submit" name="search_submit" id="search_submit" value="GO" />

</form></td>

</tr>

<tr>

<td> </td>

</tr>

</table>

</div>

<div class="advert"><img src="images/advert.gif" width="850" height="100" alt="advert" /></div>

<div class="leftnav">

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

</tr>

<tr>

</tr>

<tr>

<td><img src="images/leftnavbtn_ebritehead.jpg" width="179" height="27" alt="Ebrite" /></td>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><img src="images/leftnavbtn_lightingHEAD.jpg" width="179" height="27" alt="Lighting Range" /></td>

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

<td><img src="images/leftnavbtn_NONlightingHEAD.jpg" width="179" height="27" alt="Non Lighting Range" /></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

<div class="productarea">

<table width="613" height="138">

<tr>

<td>code</td>

<td>description</td>

<td>link</td>

</tr>

<?php do { ?>

<tr>

<td><?php echo strtoupper($row_Recordset1['code']); ?></td>

<td><?php echo strtoupper($row_Recordset1['description']); ?></td>

<td><?php echo $row_Recordset1['link']; ?></td>

</tr>

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

</table>

</div>

<div class="footer"><img src="images/footer.jpg" width="850" height="50" alt="footer - copyright at Eterna Lighting Ltd - Registered in UK No. 410716" /></div>

</div>

</body>

</html>

<?php

mysql_free_result($Recordset1);

Sara_Reese作成者解決！

Inspiring
Forum|Forum|13 years ago
December 14, 2012

dont worry - i've figured it out.

Powered by Gainsight
契約条件 Accessibility statement

サインアップ

すでにアカウントをお持ちですか？ログイン

ソーシャルログイン
oauthでログイン

コミュニティへログイン

ソーシャルログイン
oauthでログイン

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

メールアドレスをこちらに入力します

概要に戻る

ファイルをウイルススキャンする。

申し訳ございません。このファイルは、ダウンロードしても安全かどうか、内容を確認中です。数分後にもう一度お試しください。
OK

このファイルはダウンロードできません

申し訳ございませんが、当社のウイルススキャナは、このファイルをダウンロードすることは安全ではないと検出しました。
OK

Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information AdChoices