怎么简单做一个php查询数据库包含的并列举表的内容
展开全部
这个简单啊！首页做个前台输入姓名和会员卡信息的页面，我做个简单的页面给你看
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>会员查询系统</title></head> <body><form id="form1" name="form1" method="post" action="test.php"> <p> <label for="name"></label> <input type="text" name="name" id="name" /> </p> <p> <label for="vipid"></label> <input type="text" name="vipid" id="vipid" /> </p> <p> <input type="submit" name="button" id="button" value="查询" /> </p></form></body></html>然后我给你一个test.php的文件代码：<?php$name = trim($_POST['name']);$vipid = trim($_POST['vipid']);$con = mysql_connect("127.0.0.1","数据库用户名","数据库密码");if (!$con) { die('Could not connect: ' . mysql_error()); }$a = mysql_select_db("数据库名字", $con);$sql = "select * from kh_customer where name = '$name' and vipid = '$vipid'";$result = mysql_query($sql);while($row = mysql_fetch_array($result)) { echo $row['name'] . " " . $row['data']; echo "<br />"; }mysql_close($con);?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<html xmlns="<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>会员查询系统</title></head> <body><form id="form1" name="form1" method="post" action="test.php"> <p> <label for="name"></label> <input type="text" name="name" id="name" /> </p> <p> <label for="vipid"></label> <input type="text" name="vipid" id="vipid" /> </p> <p> <input type="submit" name="button" id="button" value="查询" /> </p></form></body></html>然后我给你一个test.php的文件代码：<?php$name = trim($_POST['name']);$vipid = trim($_POST['vipid']);$con = mysql_connect("127.0.0.1","数据库用户名","数据库密码");if (!$con) { die('Could not connect: ' . mysql_error()); }$a = mysql_select_db("数据库名字", $con);$sql = "select * from kh_customer where name = '$name' and vipid = '$vipid'";$result = mysql_query($sql);while($row = mysql_fetch_array($result)) { echo $row['name'] . " " . $row['data']; echo "<br />"; }mysql_close($con);?>
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
