Question

PHP查询功能如何实现

就是输入读者编号，按确定，然后该读者的姓名，性别什么的就显示出来

<?php
include("conn/conn.php");
$barcode=$_POST[barcode];
//$sql=mysql_query("select r.*,t.name as typename,t.number from tb_reader r left join tb_readerType t on r.typeid=t.id where r.barcode='$barcode'");
$sql=mysql_query("select r.*,t.name as typename,t.number,book.bookname,book.price,borr.borrowTime,borr.backTime,pub.pubname,bc.name as bookcase from tb_reader r left join tb_readerType t on r.typeid=t.id join tb_borrow as borr on borr.readerid=r.id join tb_bookinfo as book on book.id=borr.bookid join tb_publishing as pub on book.ISBN=pub.ISBN join tb_bookcase as bc on book.bookcase=bc.id where r.barcode='$barcode'");
$info=mysql_fetch_array($sql);?>
<form name="form1" method="post" action="">
<tr>
<td height="72" align="center" valign="top" background="Images/main_booksort_1.gif" bgcolor="#F8BF73"><br>
<table width="96%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#9ECFEE" class="tableBorder_grey"><tr>
<td height="33" valign="top" background="Images/bookborr.gif">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"><tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr>
<td height="33" background="Images/bookborr.gif"> </td></tr></table>
<table width="100%" height="21" border="0" cellpadding="0" cellspacing="0"><tr>
<td width="24%" height="18" style="padding-left:7px;padding-top:7px;"><img src="Images/bg_line.gif" width="132" height="20"></td>
<td width="76%" style="padding-top:7px;">读者编号：
<input name="barcode" type="text" id="barcode" size="24" value="<?php echo $info[barcode] ?>"> <input name="Button" type="button" class="btn_grey" value="确定" onClick="checkreader(form1)"></td></tr></table></td></tr>
<?php
if($_post[Button])
{$sql=mysql_query("select * FROM db_library.tb_reader as tb_readertype");
$info=mysql_fetch_array($sql);} ?><tr>
<td height="13" align="left" style="padding-left:7px;"><hr width="90%" size="1"></td>
</tr><tr><td align="center"><table width="96%" border="0" cellpadding="0" cellspacing="0"><tr><td height="27">姓    名：
<input name="readername" type="text" id="readername" value="<?php
echo $info[name];?>">
<input name="readerid" type="hidden" id="readerid" value="<?php echo $info[id];?>"></td>
<td>性    别：
<input name="sex" type="text" id="sex" value="<?php echo $info[sex];?>"></td>
<td>读者类型：
<input name="readerType" type="text" id="readerType" value="<?php echo $info[vocation];?>"></td></tr><tr><td height="27">证件类型：
<input name="paperType" type="text" id="paperType" value="<?php echo $info[paperType];?>"></td><td>证件号码：<input name="paperNo" type="text" id="paperNo" value="<?php echo $info[paperNO];?>"></td><td>可借数量：<input name="number" type="text" id="number" value="<?phpecho $info[number];?>" size="17">册

Answer 1

//获得连接
$db = mysql_connect("localhost", "root", "root") or die(mysql_error());
//echo "Connected to MySQL<br/>";
//连接数据库
mysql_select_db("test") or die(mysql_error());
//echo "Connected to Database";
 
$result = mysql_query("select * from books",$db);
//循环遍历                                                          
while ($myrow = mysql_fetch_row($result)){ 
    print_r($myrow) ; 
}

Answer 2

读者编号表单名称nid

提交表单，获取nid
<?php
include("conn/conn.php");
$nid = $_POST['nid'];
$sql = mysql_query("select * from tb_reader where id=$nid");
$row = mysql_fetch_row($sql);
if(mysql_num_rows($sql)>0)
{
//你可以在这赋值，比如：
$username = $row['username'];
}
else
{
//未找到相关用户信息...
}
mysql_free_result($sql);
mysql_close($conn);
//下面是显示用户信息
?>

用户名：<?php echo $username; ?>
....

Answer 3

这么行，还有人看啊，NB

Answer 4

就是用select 语句查询数据库读啊，你问的问题太笼统了

Answer 5

这样?