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
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
You need first to create a HTML form for the search HTML: <form action="search.php"> <input type="text" name="s" /> <input type="submit" value="Search" /> </form> Now inside your search.php: PHP: <?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.
