Re: Search MySQL db with PHP
- From: "Chris" <designerNOSPAM@xxxxxxxxxxxxxx>
- Date: Tue, 27 Jun 2006 10:59:15 -0700
Hi,
Thanks Lorenzo...Actually, that part I saw right after I posted and changed
it to keyword throughout as it is supposed to search 3 different columns,
but it still won't pass the value. I assigned a varible to it: $keyword =
$_POST['keyword']; I also separated the 2 pages, 1 for the form, and 1 for
the results because at one point the form was coming up with 2 items listed
below it without even inputting a search keyword.
It still won't work. I thought this would be so easy...
This is what I have now, and it just gives me another error: "You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'LIMIT 0, 25' at line 1". I
have looked at the MySQL manual/site and there is very little reference to
LIMIT, as well as researching PHP and Googling the error. I have some
familiarity with SQL Server, but MySQL has slightly different syntax - such
as not wanting to recognize alias column names in the WHERE clause.
Form page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p>Simple Search Form:</p>
<form id="search" name="search1" method="post" action="dwmxsearch.php">
<label>Keywords:
<input name="keyword" type="text" size="30"/>
</label>
<label>
<input type="submit" name="Submit" value="Submit" />
</label>
<input name="submitted" type="hidden" value="submitted" />
</form>
<p>
</p>
</body>
</html>
Results page (includes page generation code):
<?php include('../Connections/website.php'); ?>
<?php
$currentPage = $_SERVER['PHP_SELF'];
$keyword = $_POST['keyword'];
$maxRows_search = 25;
$pageNum_search = 0;
if (isset($_GET['pageNum_search'])) {
$pageNum_search = $_GET['pageNum_search'];
}
$startRow_search = $pageNum_search * $maxRows_search;
mysql_select_db($database_website, $website);
$query_search = "SELECT DISTINCT docURL as URL, docTitle as Title, docDesc
as Description, projCode as Project FROM docs, proj WHERE docs.projID =
proj.projID AND docURL LIKE "%$keyword%" OR docTitle LIKE "%$keyword%"' OR
docDesc LIKE "%$keyword%"";
$query_limit_search = sprintf("%s LIMIT %d, %d", $query_search,
$startRow_search, $maxRows_search);
$search = mysql_query($query_limit_search, $website) or die(mysql_error());
$row_search = mysql_fetch_assoc($search);
if (isset($_GET['totalRows_search'])) {
$totalRows_search = $_GET['totalRows_search'];
} else {
$all_search = mysql_query($query_search);
$totalRows_search = mysql_num_rows($all_search);
}
$totalPages_search = ceil($totalRows_search/$maxRows_search)-1;
$queryString_search = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_search") == false &&
stristr($param, "totalRows_search") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_search = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_search = sprintf("&totalRows_search=%d%s", $totalRows_search,
$queryString_search);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p>
<?php do { ?>
<a href="<?php echo $row_search['URL']; ?>"><?php echo
$row_search['Title']; ?></a> :<br />
<strong>Description:</strong> <?php echo $row_search['Description'];
?>, <strong>Project:</strong> <?php echo $row_search['Project']; ?><br />
<?php } while ($row_search = mysql_fetch_assoc($search)); ?>
</p>
<p>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"><?php if ($pageNum_search > 0) { // Show
if not first page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage, 0,
$queryString_search); ?>">First</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_search > 0) { // Show
if not first page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage,
max(0, $pageNum_search - 1), $queryString_search); ?>">Previous</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_search <
$totalPages_search) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage,
min($totalPages_search, $pageNum_search + 1), $queryString_search);
?>">Next</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_search <
$totalPages_search) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_search=%d%s", $currentPage,
$totalPages_search, $queryString_search); ?>">Last</a>
<?php } // Show if not last page ?>
</td>
</tr>
</table>
</p>
</body>
</html>
<?php
mysql_free_result($search);
?>
"lorento" <laurente1234@xxxxxxxxx> wrote in message
news:1151406437.726096.182120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Chris wrote:
I have tried assigning a variable to the textbox value, but that doesn'tIts because the keyword didn't pass to action page. Try like this :
work either.
<form id="search" name="search1" method="post" action="search.php">
<label>Keywords:
<input name="docDesc" type="text" size="30"/>
</label>
<label>
<input type="submit" name="Submit" value="Submit" />
</label>
</form>
--
http://blog.deshot.com
http://www.deshot.com
.
- Follow-Ups:
- Re: Search MySQL db with PHP
- From: Chris
- Re: Search MySQL db with PHP
- References:
- Search MySQL db with PHP
- From: Chris
- Re: Search MySQL db with PHP
- From: lorento
- Search MySQL db with PHP
- Prev by Date: Re: Convert $string to gibberish - how?
- Next by Date: Re: Search MySQL db with PHP
- Previous by thread: Re: Search MySQL db with PHP
- Next by thread: Re: Search MySQL db with PHP
- Index(es):
Relevant Pages
|
