//我根据$id来查询某条记录的详细信息
<?php
// error_reporting(0);
$db=mysql_connect("localhost","root");
mysql_select_db("wuyc",$db);
if($id)
{
$result=mysql_query("Select * from employees where id=$id",$db);
$myrow=mysql_fetch_array($result);
echo "<p><table border=1 align=center><caption>id为 $id 的详细情况</caption>";
echo "<tr bgcolor=#c0c0c0><td>id</td><td>First name</td><td>Last Name</td><td>Address</td><td>Position</td></tr>";
echo "<tr>";
printf("<td>%d</td>",$myrow[0]);
printf("<td>%s</td>",$myrow[1]);
printf("<td>%s</td>",$myrow[2]);
printf("<td>%s</td>",$myrow[3]);
printf("<td>%s</td>",$myrow[4]);
printf("</tr></table>");
}
else
{
$result=mysql_query("Select * from employees",$db);
echo "<p><table border=1 align=center><caption>Employees 详细记录</caption>";
echo "<tr><td>id</td><td>First name</td><td>Last Name</td><td>Address</td><td>Position</td></tr>";
while($myrow=mysql_fetch_array($result)){
echo "<tr>";
printf("<td><a href=\"%s?id=%d\">%d</a></td>",$PATHINFO,$myrow[0],$myrow[0]);
printf("<td>%s</td>",$myrow[1]);
printf("<td>%s</td>",$myrow[2]);
printf("<td>%s</td>",$myrow[3]);
printf("<td>%s</td>",$myrow[4]);
printf("</tr>");
}
echo "</table>";
}
?>
<?php
// error_reporting(0);
$db=mysql_connect("localhost","root");
mysql_select_db("wuyc",$db);
if($id)
{
$result=mysql_query("Select * from employees where id=$id",$db);
$myrow=mysql_fetch_array($result);
echo "<p><table border=1 align=center><caption>id为 $id 的详细情况</caption>";
echo "<tr bgcolor=#c0c0c0><td>id</td><td>First name</td><td>Last Name</td><td>Address</td><td>Position</td></tr>";
echo "<tr>";
printf("<td>%d</td>",$myrow[0]);
printf("<td>%s</td>",$myrow[1]);
printf("<td>%s</td>",$myrow[2]);
printf("<td>%s</td>",$myrow[3]);
printf("<td>%s</td>",$myrow[4]);
printf("</tr></table>");
}
else
{
$result=mysql_query("Select * from employees",$db);
echo "<p><table border=1 align=center><caption>Employees 详细记录</caption>";
echo "<tr><td>id</td><td>First name</td><td>Last Name</td><td>Address</td><td>Position</td></tr>";
while($myrow=mysql_fetch_array($result)){
echo "<tr>";
printf("<td><a href=\"%s?id=%d\">%d</a></td>",$PATHINFO,$myrow[0],$myrow[0]);
printf("<td>%s</td>",$myrow[1]);
printf("<td>%s</td>",$myrow[2]);
printf("<td>%s</td>",$myrow[3]);
printf("<td>%s</td>",$myrow[4]);
printf("</tr>");
}
echo "</table>";
}
?>
解决方案 »
- linux下怎么编辑shell脚本啊。
- 数据导入的算法问题,搞了大半天了,请教大家
- 有PHP后台,请问怎么在前台调用呢
- 繁体操作系统导数据库数据为乱码?
- 一个关于php数组的基础问题。
- 咨询一个smarty与fckeditor相互结合的问题
- 如何去掉客户端js输入的逗号
- 表单的method为post,提交成功后,会在$_REQUEST与$_POST中看到相同的值.
- 如何对从数据库读取的文本进行分页
- mysqli_connect_error 乱码
- 求救求救,有人知道PHPED怎样使用吗?
- 我在win2000下安装php4+apache_1_3_12,怎么调试的时候显示php源代码啊?如何让它正常显示呢?急用!!!
Warning: Undefined variable: PATH_INFO in c:/foxserv/www/myphp/db.php on line 28这是为什么呢?