Ad:

PHP Discussion Thread
Unsolved
Views: 186

Sep 2nd, 2010

Multiple search fields results

Expand Post »

hello,
i have something like this
search:_______ search1:___________ submit btn

how can i search for something from the same table in the database considering both search fields?

I've tried this code nut it doesn't work.
thanks

php Syntax (Toggle Plain Text)
	if($search == '')
	{
		$smarty->assign('Error','Please enter any string!');
		$z=1;
	}
	elseif($type == 'like')
	{
		$sql = 'SELECT * FROM topic WHERE Title LIKE '."'$search%'".' AND Title1 LIKE '."'$search1%'";
	}
	elseif($type == 'exact')
	{
		$sql = 'SELECT * FROM topic WHERE MATCH (Title) AGAINST ("'.$search.'") AND (Title1) AGAINST ("'.$search1.'")';
	if($search == '')
	{
		$smarty->assign('Error','Please enter any string!');
		$z=1;
	}
	elseif($type == 'like')
	{
		$sql = 'SELECT * FROM topic WHERE Title LIKE '."'$search%'".' AND Title1 LIKE '."'$search1%'";
	}
	elseif($type == 'exact')
	{
		$sql = 'SELECT * FROM topic WHERE MATCH (Title) AGAINST ("'.$search.'") AND (Title1) AGAINST ("'.$search1.'")';

Last edited by patrioticcow; Sep 2nd, 2010 at 4:01 am.

Similar Threads

php code to search and show results on same page in PHP
Multiple search fields php - Please Help! in PHP
PHP MYSQL Search with multiple AND search terms in PHP
Multiple Search Options using radio buttons? in PHP
Using ASP.NET to create multiple search engine in ASP.NET

patrioticcow

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Sep 2010

Permalink

Sep 2nd, 2010

Re: Multiple search fields results

You used double quotes, instead of single.

PHP Syntax (Toggle Plain Text)
if($search == '')
{
  $smarty->assign('Error','Please enter any string!');
  $z=1;
}
elseif($type == 'like')
{
  $sql = "SELECT * FROM topic WHERE Title LIKE '$search%' AND Title1 LIKE '$search1%'";
}
elseif($type == 'exact')
{
  $sql = "SELECT * FROM topic WHERE MATCH (Title) AGAINST ('$search') AND (Title1) AGAINST ('$search1')";
}
if($search == '')
{
  $smarty->assign('Error','Please enter any string!');
  $z=1;
}
elseif($type == 'like')
{
  $sql = "SELECT * FROM topic WHERE Title LIKE '$search%' AND Title1 LIKE '$search1%'";
}
elseif($type == 'exact')
{
  $sql = "SELECT * FROM topic WHERE MATCH (Title) AGAINST ('$search') AND (Title1) AGAINST ('$search1')";
}

Last edited by pritaeas; Sep 2nd, 2010 at 10:15 am.

pritaeas

Sponsor

Featured Poster

Reputation Points: 546

Solved Threads: 717

Bite my shiny metal ass!

Offline

4,143 posts
since Jul 2006

Permalink

Sep 2nd, 2010

Re: Multiple search fields results

What doesn't work exactly? You get a PHP or Sql error code or you get no results when you should be?

Edit: ok, you got a solution now :] Ignore this message :]

Last edited by Daiva; Sep 2nd, 2010 at 10:20 am.

Daiva

Reputation Points: 14

Solved Threads: 9

Light Poster

Offline

37 posts
since May 2009

Permalink

Sep 2nd, 2010

Re: Multiple search fields results

Click to Expand / Collapse Quote originally posted by Daiva ...

What doesn't work exactly? You get a PHP or Sql error code or you get no results when you should be?

Edit: ok, you got a solution now :] Ignore this message :]

thanks for the reply

the single quotes improved the search, but.
it looks like the each search field finds results independent from each other. I want them to work together and the result to contain what is search in both fields

and i get no errors php or sql errors.

Last edited by patrioticcow; Sep 2nd, 2010 at 10:39 am.

patrioticcow

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Sep 2010

Permalink

Sep 2nd, 2010

Re: Multiple search fields results

hello.
i believe i fix it.
ill explin my results on the code

php Syntax (Toggle Plain Text)
//this is the first search field
if($search == '')
	{
		$smarty->assign('Error','Please enter an departure location!');
		$z=1;
	}
//this is the second search field
	elseif($search1 == '')
	{
		$smarty->assign('Error','Please enter any destination!');
		$z=1;
	}
//both search fields are selecting and matching the search words from the table "topic" with the fields "Title1" and "Title2"
	elseif($type == 'like')
	{
		$sql = "SELECT * FROM topic WHERE Title LIKE '$search%' AND Title1 LIKE '$search1%'";
	}
	elseif($type == 'exact')
	{
		$sql = "SELECT * FROM topic WHERE MATCH (Title) AGAINST ('$search') AND (Title1) AGAINST ('$search1')";
		//$sql .= ' UNION ';
	}
//this is what solved my problem. i replace the $search with $search1.
	if($tag == 'tag' && $z!= 1)
	{
		$sql .= ' OR Tag LIKE "%'.$search1.'%"';
	}
//and off course the double quotes thing by pritaeas:)
//this is the first search field
if($search == '')
	{
		$smarty->assign('Error','Please enter an departure location!');
		$z=1;
	}
//this is the second search field
	elseif($search1 == '')
	{
		$smarty->assign('Error','Please enter any destination!');
		$z=1;
	}
//both search fields are selecting and matching the search words from the table "topic" with the fields "Title1" and "Title2"
	elseif($type == 'like')
	{
		$sql = "SELECT * FROM topic WHERE Title LIKE '$search%' AND Title1 LIKE '$search1%'";
	}
	elseif($type == 'exact')
	{
		$sql = "SELECT * FROM topic WHERE MATCH (Title) AGAINST ('$search') AND (Title1) AGAINST ('$search1')";
		//$sql .= ' UNION ';
	}
//this is what solved my problem. i replace the $search with $search1.
	if($tag == 'tag' && $z!= 1)
	{
		$sql .= ' OR Tag LIKE "%'.$search1.'%"';
	}
//and off course the double quotes thing by pritaeas:)

ill keep u all posted if any problem occurs in the nearest future
thanks

patrioticcow

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Sep 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: combo box's problem

Next Thread in PHP Forum Timeline: passing variables

DaniWeb Message

Cancel Changes

User Name
Password