PHP/MySQL Search SQL

Forum|Forum|18 years ago
March 14, 2007
3 replies
483 views

I am trying to build a search page on my site. I am wanting it to search by "name". I have it wokring is someone types in the whole name exactly.

mysql_select_db($database_siteText, $siteText);
$query_Recordset1 = sprintf("SELECT * FROM reviews WHERE review_name = %s", GetSQLValueString($colname_Recordset1, "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $siteText) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

When I click test in DW and it give me the box to type in, if I put the whole name it works fine. However I would like it find part of the name too. Is there a wildcard I should use.

Ex. Complete name in database "John Doe"

If I type exactly that it works fine but I would like it where a user can just type "john" and get a list of ever name that includes john.

Thanks

Server side applications

This topic has been closed for replies.

N

Newsgroup_User

Inspiring

newhorizonhosting.com wrote:
> Below is the code I made in dreamweaver. Where/how should I modify it to ad the
> %.
>
> I want them at the front and back of the search term.

Steve is right in saying that % is the SQL wildcard, but you don't need
to add it directly into the code.

In the Recordset dialog box, set Filter to review_name, the drop-down
menu alongside to "contains", and the other two drop-downs to URL
parameter and searchterm. Dreamweaver then creates the correct code for you.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

N

newhorizonhosting.comAuthor

Participating Frequently

David -

I am not really understanging what you are saying.

If you look at my search page below and try searching for "chipotle" it works find as long as you use the who word. But if tyou search for "chipotl" it does not return any results.

http://dfwfoodguide.com/search.php

An I can see from this example that it works if I add the wildcard myself in the url

http://dfwfoodguide.com/search_results.php?searchterm=chipotl%
http://dfwfoodguide.com/search_results.php?searchterm=%hipotl%

So I gues my questions is what do I need to do, to get the wild card add to my string

Thanks
C

N

newhorizonhosting.comAuthor

Participating Frequently

I think I understand. I dod not see that because was not in the simple dialog box. I now see it.

N

newhorizonhosting.comAuthor

Participating Frequently

Below is the code I made in dreamweaver. Where/how should I modify it to ad the %.

I want them at the front and back of the search term.

$colname_Recordset1 = "-1";
if (isset($_GET['searchterm'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['searchterm'] : addslashes($_GET['searchterm']);
}
mysql_select_db($database_siteText, $siteText);
$query_Recordset1 = sprintf("SELECT * FROM reviews WHERE review_name LIKE %s", GetSQLValueString($colname_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $siteText) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

N

Newsgroup_User

Inspiring

On Wed, 14 Mar 2007 05:54:19 +0000 (UTC), "newhorizonhosting.com"
<charles@dieselinteractive.com> wrote:

> If I type exactly that it works fine but I would like it where a user can just
>type "john" and get a list of ever name that includes john.

You'll need to use a SQL query like this:

SELECT * FROM reviews WHERE review_name LIKE "%$searchterm%"

If you use "%$searchterm%" it looks for your search term with anything
at either end, or you can just use a single % in which case it looks
for anything either before or after your search word (delending where
you put the %).
--
Steve Fleischer
steve at flyingtigerwebdesign dot com
Hong Kong

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded