文章详情页
一个用mysql_odbc和php写的serach数据库程序
浏览：4日期：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
上一条：利用PHP动态生成VRML网页下一条：PHP4实际应用经验篇(1)
排行榜
网公网安备