Go4Expert - php help please

Go4Expert (http://www.go4expert.com/)

- PHP (http://www.go4expert.com/forumdisplay.php?f=26)

- - php help please (http://www.go4expert.com/showthread.php?t=25525)

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

Re: php help please

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 :D

Re: php help please

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.