php help please

elina's Avatar, Join Date: Apr 2011
Newbie Member
im very new to php. can anyone please help. im trying to create a search feature for my application which im using php and mysql. can you please give me the code for a simple search feature.

thank you
0
ManzZup's Avatar, Join Date: May 2009
Skilled contributor
can you descripbe the search features
if you clearly know the app, you can base your search on the DB itself, and dynamically generate the required links
ex: you search for "best article"
you have a page named best artcle in your DB
you make link with the article ID
hope you got it
0
transparent's Avatar, Join Date: May 2011
Go4Expert Member
You need first to create a HTML form for the search

HTML Code:
<form action="search.php">
  <input type="text" name="s" />
  <input type="submit" value="Search" />
</form>
Now inside your search.php:
PHP Code:
<?php
// connect to the database
$con mysql_connect('localhost','username','password');
mysql_select_db('database_name',$con);


//create a search query
$find $_REQUEST['s'];
$q "SELECT * FROM `table_to_do_search` WHERE `field1` LIKE '%$find%' or `field2` LIKE '%$find%'";

$result mysql_query($q);

if(
mysql_num_rows($result) > 0)
{
  echo 
'<h1>Results:</h1>';
  echo 
'<ol>';
  while(
$row mysql_fetch_assoc($result))
  {
     echo 
'<li>'.$row['fieldname'].'</li>';
  }
  echo 
'</ol>';

}
else
  echo 
'No results found';

?>
This is just a concept on how it should work.