[ale] Querying a MySQL database from PHP

[John Wells]

John,

In your LIKE clause, surround your search string with % (wildcard)
characters.  in other words, if I wanted to match my name in a field, it
would be something like:

select * from people where names like '%john%';

To add it to your sprintf, you'll have to escape the % (either with \%
or %%, can't remember which off hand).

Good luck!

John


On Fri, 2002-09-20 at 11:23, John Cole wrote:
> Howdy all!
> 
> I've built a page in Dreamweaver MX that uses PHP for scripting.  I can get
> data out of my mysql database but I need to be able to search for wildcards.
> currently it only matches 100% exact queries.
> Below is the code that is at the beggining of the PHP page.
> -----------
> $varSort_search1 = "%";
> if (isset($HTTP_POST_VARS["Sort"])) {
>   $varSort_search1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS["Sort"] :
> addslashes($HTTP_POST_VARS["Sort"]);
> }
> $varText_search1 = "%";
> if (isset($HTTP_POST_VARS["Text"])) {
>   $varText_search1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS["Text"] :
> addslashes($HTTP_POST_VARS["Text"]);
> }
> mysql_select_db($database_CATCH, $CATCH);
> $query_search1 = sprintf("SELECT * FROM secureworks WHERE %s LIKE  '%s'",
> $varSort_search1,$varText_search1);
> $search1 = mysql_query($query_search1, $CATCH) or die(mysql_error());
> $row_search1 = mysql_fetch_assoc($search1);
> $totalRows_search1 = mysql_num_rows($search1);
> 
> -------------
> 
> Does anyone have any ideas?
> 
> Thanks,
> John Cole, TCISA
> 
> Help Desk Administrator
> Lockheed Georgia Employees' Federal Credit Union
> 430 Commerce Park Drive
> Marietta, GA 30060 
> (770) 424-0060
> (800) 541-8921 
> jcole at lgefcu.org
> Disclaimer: The information contained in this email is proprietary and
> confidential.  It is intended solely for the use of the person identified
> and intended as the recipient. This document is forwarded to you in such a
> form (E-mail) that LGEFCU cannot guarantee the completeness and/or
> correctness of its contents and information. If you have received this
> E-mail message in error, please notify us immediately. Please also delete
> this document from your computer. This document may not be reproduced,
> copied, distributed, published, modified, or furnished to third parties,
> without the prior written consent of LGEFCU. LGEFCU specifically disclaims
> any responsibility or liability for any personal information or opinions of
> the author expressed in this email.
> 
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
> sent to listmaster at ale dot org.
> 



---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.