Reputation: 23
I'm trying to use search as my retrieve option, this is my simpliest form of searching, what can I do with these codes, No error but not working. Please indicate what is wrong in my code. Give advice, site, solution Thanks.
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
session_start();
ob_start();
//connetion database
$dbhost = '192.168.0.9';
$dbuser = 'dsc';
$dbpass = 'csd';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('ERROR CONNECTING TO MYSQL');
$dbname = 'dbtips';
mysql_select_db($dbname);
$output='';
if(isset($_POST['search']))
{
$searchq = $_POST['search'];
$searchq = preg_replace("#[^0-9a-z]#i","",$searchq);
//query
$query = mysql_query("SELECT * FROM tblnews WHERE udate LIKE '%$searchq%'");
$count = mysql_num_rows($query);
if($count==0)
{
$output = 'There was no search result!';
}
else
{
while($row = mysql_fetch_array($query)){
$udate = $row['udate'];
$mis = $row['mis'];
$status = $row['status'];
$output .= '->'.$udate.'-'.$mis.'-'.$status.'<br>';
}
}
}
?>
//form for searching
<form action="search.php" method="POST">
<center>
<p>
<input type="text" size="90" name="search" style="text-align:center">
<br>
<br>
<input type="button" name="searchbutton" value="Search">
<br>
<br>
</p>
</center>
</form>
Upvotes: 0
Views: 65
Reputation: 2509
change this to
<input type="button" name="searchbutton" value="Search">
To this
<input type="submit" name="searchbutton" value="Search">
Upvotes: 1