文章詳情頁
一個用mysql_odbc和php寫的serach數(shù)據(jù)庫程序
瀏覽：5日期：2024-01-02 17:25:40
<html>;;<head>;;<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;;<title>查詢條件</title>;;<meta name="GENERATOR" content="Microsoft FrontPage 3.0">;;</head>;;<body bgcolor="#fcf8c2">;;<p>查詢條件 </p>;;<form action="searchyh.php" method="post">;;<table border="1" width="43%" height="34">;;<tr>;;<td width="100%" height="28">用戶名稱: <input type="text" name="name" size="20"></td>;;<td width="100%" height="28">用戶地址: <input type="text" name="add" size="20"></td>;;<td width="100%" height="28">用戶電話: <input type="text" name="tel" size="20"></td>;;</tr>;;</table>;;<p><input type="submit" value="提交查詢"> </p>;;</form>;;</body>;;</html>;;//后臺PHP;;<?php;;echo "<body bgcolor=’#fcf8c2’>";;;echo "查詢結果:";;;echo " ";;;echo " ";;;$conn = odbc_connect("blue", "root", "");;;$name .="%";;;$add .="%";;;$tel .="%";;;$query = "select * ";;;$query .= "from jc_yh where (name like ’$name’ and address like’$add’ and tel like ’$tel’ )";;;odbc_result_all( odbc_do($conn, $query), "border=1 width=50%");;;odbc_close($conn);;;?>;;///表結構;;CREATE TABLE jc_yh (;;id int not null default 0,;;name varchar(80) not null default "blue",;;city varchar(40) not null default "xn",;;tel varchar(14) not null default "00000000000000",;;fax varchar(14) not null default "00000000000000",;;address varchar(60) not null default "xn",;;post varchar(6) not null default "000000"）；;;
標簽：
PHP
排行榜
網(wǎng)公網(wǎng)安備