worker_find.php

来自「医院网站系统」· PHP 代码 · 共 37 行

<?
session_start();
?>
<style type="text/css">
<!--
a:link {
	color: #000066;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #000066;
}
a:hover {
	text-decoration: underline;
	color: #0099FF;
	font-style: italic;
	font-size:17px;
}
a:active {
	text-decoration: none;
	color: #000066;
}
.STYLE2 {font-size: 14px}
-->
</style>
<table width="528" border="1" cellpadding="1" cellspacing="0">
  <tr>
    <? require_once 'conn.php';
		$sql="select * from worker where id like '%".$search1."%' or number like '%".$search1."%' or name like '%".$search1."%' or sexy like '%".$search1."%' or age like '%".$search1."%' or do like '%".$search1."%' or idcard like '%".$search1."%' or worktime like '%".$search1."%' or address like '%".$search1."%' or tel like '%".$search1."%' or mail like '%".$search1."%' or qq like '%".$search1."%' or income like '%".$search1."%' or mobile like '%".$search1."%' or bumen like '%".$search1."%' or duty like '%".$search1."%' or note like '%".$search1."%' order by id DESC;";
		echo $sql;
		$result=mysql_db_query("hostipal",$sql,$cn);
		while($arr=mysql_fetch_array($result))
    	echo "<td width=663><a href=worker_view.php?id=$arr[id]>$arr[name]</a></td>";
	?>
  </tr>
</table>