php - how to do search in the same page? -

php - how to do search in the same page? -

1) search form

search.html :

<form action="process.php" method="post"> <input type="text" name="query" /> <input type="hidden" name="searching"> <input type="submit" value="search" /> </form>

2) of search process handled , shown on process.php.

process.php :

<?php $connection = mysql_connect("*****","*****","*****"); if (!connection) { die ("please reload page. database connection failed: " . mysql_error()); } // select databse utilize $db_select = mysql_select_db("*****",$connection); if (!$db_select) { die("please reload page. database selection failed: " . mysql_error()); } if (isset($_post["searching"])) { /*call search process*/ dosearch(); } function dosearch(){ $keyword = $_post("query"); $search = "select * tbl_name name '%$keyword%'"; $result = mysql_query($search) or die('query did not work'); while($result_arr = mysql_fetch_array( $result )) { echo $result_arr['name']; echo " "; echo "<br>"; echo "<br>"; } } ?>

3)how show search result @ page "search.html" , how combine 1 same page?

you have create search.php instead of search.html.

you may seek using php sessions. helpful.

you can save whatever variable want transfer "process.php" "search.php" in $_session array , utilize them in search.php. illustration :

in process.php

<?php session_start(); $_session['a']=$result_arr['name']; ?>

then in search.php

<?php session_start(); echo $_session['a']; ?>

php mysql