<table class="font" border="0" width="330" cellspacing="0" cellpadding="0" align="center">
<form name=b2b_search method="POST" action="./error_log.php" >
<tr>
<td width="50" align="center">关键字:</td>
<td width="150" align="center"><input class="input2" type="text" name="searchword" size="17"></td>
<td width="80" align="center"><select class="input2" size="1" name="field">
<option value="username" selected>帐号</option>
<option value="add_date">时间</option>
</select></td>
<td width="50" align="center"><input onclick=checkfrom(b2b_search) type=button name=btnSubmit value="搜索" name="B1" class="submit2"></td>
</tr>
</form>
</table>where $field like '%$searchword%'
class Mssql
{
var $host;
var $user;
var $dbname;
var $pass;
var $last_insert_id="";
var $link_id = 0;
function mssql($host,$user,$pass,$db)
{
$this->host = $host;
$this->user = $user;
$this->pass = $pass;
$this->dbname = $db;
}
function connect()
{
$this->link_id = mssql_connect($this->host,$this->user,$this->pass);
if(!$this->link_id)
{
$this->halt("连接数据库出错!");
}
else
{
if(!mssql_select_db($this->dbname))
{
$this->halt("选择数据库出错!");
}
}
}
function query($query)
{
$reg = "/INSERT INTO/is";
if(preg_match($reg,$query))
{
$sql = "select @@IDENTITY as id";
$res = mssql_query($sql);
$this->last_insert_id = mssql_result($res,0,"id");
}
return mssql_query($query);
}
function num_rows($result)
{
return mssql_num_rows($result);
}
function fetch_array($result)
{
return mssql_fetch_array($result);
}
function insert_id()
{
return $this->last_insert_id;
}
function halt($message)
{
die($message);
}
}
?>