Jump to content

preg_match


daled

Recommended Posts

I'm trying to code something that searches a mysql database for matches to an input.  The input is a get variable.

 

here's my code:

 

<?php
$query_Search = sprintf("SELECT * FROM search");
$Search = mysql_query($query_Search, $search) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);

preg_match_all('/$_GET["searchfield"]/', $row_Search['bandname'], $match);
print_r($match);
?>

I believe the problem is the search patter, but i have no idea what to do with it.

Thanks for anyones help.

Link to comment
https://forums.phpfreaks.com/topic/59883-preg_match/
Share on other sites

to get the preg_match_all working use

 

preg_match_all("/{$_GET['searchfield']}/", $row_Search['bandname'], $match);

 

 

but thats not the problem.. i think you want something like..

 

 

$query_Search = "SELECT * FROM search WHERE theField='{$_GET['searchfield']}'";
$Search = mysql_query($query_Search, $search) or die(mysql_error());

 

of course change theField to the field your searching

 

also $search and $Search are NOT the same and $search should be the connection string

Link to comment
https://forums.phpfreaks.com/topic/59883-preg_match/#findComment-297775
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.