//我根据$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>";
}
?>
解决方案 »
- 时间问题
- xp下php中mysql远程登录后无法登录本机mysql
- xajax 例题出错.the xml response......
- 关于登录跳转问题
- 为什么有的人无法注册?
- PHP Startup: Unable to load dynamic library ,不知道为啥在FC9出这样的问题。
- 文件上传的问题..........
- 急!!!php画图的问题
- 如何对phpnuke等新闻文章管理软件迅速上手
- 如何用php保存整个用户登录过程的信息?最后23分了。
- 求救求救,有人知道PHPED怎样使用吗?
- 我在win2000下安装php4+apache_1_3_12,怎么调试的时候显示php源代码啊?如何让它正常显示呢?急用!!!
Warning: Undefined variable: PATH_INFO in c:/foxserv/www/myphp/db.php on line 28这是为什么呢?