Kode: Vælg alt
<?php
include_once("php_includes/conf.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Search page in php</title>
</head>
<body>
<form method="post" id="frm" name="frm" action="search.php">
<table width="500" border="0">
<tr>
<td>Search page in php</td>
<td>
<input type="text" name="username" id="username"/> </td>
</tr>
<tr>
<td>
<input type="submit" name="Submit" value="Search" /> </td>
<td> </td>
</tr>
</table>
</form>
<?php
if($_REQUEST["Submit"]=="Search")
{
$sql="select * from employee where username like '%$_REQUEST[user]%' OR address like '%$_REQUEST[user]%' OR city like '%$_REQUEST[user]%' OR state like '%$_REQUEST[user]%' OR id='$_REQUEST[user]'";
$sql_row=mysql_query($sql);
$num=@mysql_num_rows($sql_row);
if($num > 0)
{
?>
<table width="500" border="1">
<tr>
<td>ID</td>
<td>Name</td>
<td>Address</td>
<td>City</td>
<td>State</td>
</tr>
<?php
while($sql_res=@mysql_fetch_assoc($sql_row))
{
?>
<tr>
<td><?php echo $sql_res["id"]; ?></td>
<td><?php echo $sql_res["user"]; ?></td>
<td><?php echo $sql_res["email"]; ?></td>
<td><?php echo $sql_res["gender"]; ?></td>
<td><?php echo $sql_res["country"]; ?></td>
</tr>
<?php
} ?>
</table>
<?php
}
else
{
?>
<p>No Results found</p>
<?php
}
?>
<?php
}
?>
</body>
</html>