php分页刷新问题 php分页数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?php $con =@mysql_connect("localhost","root",""); mysql_select_db("message",$con); $url = $_SERVER['REQUEST_URI']; $url = parse_url($url); $url = $url[path]; //echo $url; $result = mysql_query("select * from infor"); $count = mysql_num_rows($result); $pagesize = 10; $maxpage = ceil($count/$pagesize); if(empty($_GET['page'])||$_GET['page']<0){ $page = 1; }else{ $page = $_GET['page']; } $nowpage = $pagesize*($page-1); $results = mysql_query("select * from infor limit $nowpage,$pagesize"); while($row = mysql_fetch_array($results)) { ?><table cellpaddign="1" cellspacing="1" border="1" width="500px" align="center"> <tr> <td width="200px">ID:<?php echo $row[0]?></td> <td>姓名:<?php echo $row[1]?></td> </tr> <tr> <td colspan="2">标题:<?php echo $row[2]?></td> </tr> <tr> <td colspan="2">内容:<?php echo $row[3]?></td> </tr></table><?php }?><?phpecho "共"."$count"."条";?><a href="login.php">添加留言信息</a><br><a href="<?php echo $url;?>?page=<?php echo $page-1;?>">上一页</a><?php for($i =1;$i<maxpage;$i++){?><a href="<?php echo $url;?>?page=<?php echo $i;?>"><?php echo $i;?></a><?php }if($page<$maxpage){?><a href="<?php echo $url;?>?page=<?php echo $page+1?>">下一页</a><?php }?></body></html> 你的代码给全了吗?并没有看到 insert既然没有 insert 指令被执行,怎么会产生空记录呢? <html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>留言板</title><style type="text/css">a{text-decoration:none;}body h1{text-align:center;}</style></head><body><h1 style="color:green;">留言内容</h1><?php $con = @ mysql_connect("localhost","root","") or die("Could not connect:".mysql_error()); mysql_select_db("message",$con); $sql="insert into infor (name,title,content) values ('$_GET[name]','$_GET[title]','$_GET[content]')"; mysql_query($sql); mysql_close($con); ?><?php $con =@mysql_connect("localhost","root",""); mysql_select_db("message",$con); $url = $_SERVER['REQUEST_URI']; $url = parse_url($url); $url = $url[path]; //echo $url; $result = mysql_query("select * from infor"); $count = mysql_num_rows($result); $pagesize = 10; $maxpage = ceil($count/$pagesize); if(empty($_GET['page'])||$_GET['page']<0){ $page = 1; }else{ $page = $_GET['page']; } $nowpage = $pagesize*($page-1); $results = mysql_query("select * from infor limit $nowpage,$pagesize"); while($row = mysql_fetch_array($results)) { ?><table cellpaddign="1" cellspacing="1" border="1" width="500px" align="center"> <tr> <td width="200px">ID:<?php echo $row[0]?></td> <td>姓名:<?php echo $row[1]?></td> </tr> <tr> <td colspan="2">标题:<?php echo $row[2]?></td> </tr> <tr> <td colspan="2">内容:<?php echo $row[3]?></td> </tr></table><?php }?><?phpecho "共"."$count"."条";?><a href="login.php">添加留言信息</a><br><a href="<?php echo $url;?>?page=<?php echo $page-1;?>">上一页</a><?php for($i =1;$i<maxpage;$i++){?><a href="<?php echo $url;?>?page=<?php echo $i;?>"><?php echo $i;?></a><?php }if($page<$maxpage){?><a href="<?php echo $url;?>?page=<?php echo $page+1?>">下一页</a><?php }?></body></html> <?php $con = @ mysql_connect("localhost","root","") or die("Could not connect:".mysql_error());mysql_select_db("message",$con);$sql="insert into infor (name,title,content) values ('$_GET[name]','$_GET[title]','$_GET[content]')";mysql_query($sql);mysql_close($con);?>这里面的$sql语句每次请求页面都会执行一次,向数据库插入一条记录,由于参数name, title,content没有赋值所以插入的是空记录 我把表单填写之后,点击submit不就是给name,title,content赋值了吗、 for($i =1;$i<maxpage;$i++){ 这边还少了$ .. 如何采集http://www.haha.mx/的首页 Apache中的httpd.conf配置? 循环问题,来看看 老板给个东西我们要在三天之内搞懂,我看不明白!请大家帮忙! php 如何根据当月的天数,取得下个月(或者说如何表示下个月) 编码!!!急!高人请进 Linux下 apache 集成 php 出现的问题 关于 php 发送送邮件检验的问题 有关apache服务器问题 mail函数中如何发送html邮件,在线等待. 关于函数 __call 的一个疑问 求ecshop,ecmall,thinkphp三者的详细解释,以及在实际项目中的优缺点
$con =@mysql_connect("localhost","root","");
mysql_select_db("message",$con);
$url = $_SERVER['REQUEST_URI'];
$url = parse_url($url);
$url = $url[path];
//echo $url;
$result = mysql_query("select * from infor");
$count = mysql_num_rows($result);
$pagesize = 10;
$maxpage = ceil($count/$pagesize);
if(empty($_GET['page'])||$_GET['page']<0){
$page = 1;
}else{
$page = $_GET['page'];
}
$nowpage = $pagesize*($page-1);
$results = mysql_query("select * from infor limit $nowpage,$pagesize"); while($row = mysql_fetch_array($results))
{
?>
<table cellpaddign="1" cellspacing="1" border="1" width="500px" align="center">
<tr>
<td width="200px">ID:<?php echo $row[0]?></td>
<td>姓名:<?php echo $row[1]?></td>
</tr>
<tr>
<td colspan="2">标题:<?php echo $row[2]?></td>
</tr>
<tr>
<td colspan="2">内容:<?php echo $row[3]?></td>
</tr>
</table>
<?php }?>
<?php
echo "共"."$count"."条";
?>
<a href="login.php">添加留言信息</a><br>
<a href="<?php echo $url;?>?page=<?php echo $page-1;?>">上一页</a>
<?php
for($i =1;$i<maxpage;$i++){
?>
<a href="<?php echo $url;?>?page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }
if($page<$maxpage){
?>
<a href="<?php echo $url;?>?page=<?php echo $page+1?>">下一页</a>
<?php }?>
</body>
</html>
既然没有 insert 指令被执行,怎么会产生空记录呢?
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>留言板</title>
<style type="text/css">
a{text-decoration:none;}
body h1{text-align:center;}
</style>
</head>
<body>
<h1 style="color:green;">留言内容</h1>
<?php
$con = @ mysql_connect("localhost","root","") or die("Could not connect:".mysql_error());
mysql_select_db("message",$con);
$sql="insert into infor (name,title,content) values ('$_GET[name]','$_GET[title]','$_GET[content]')";
mysql_query($sql);
mysql_close($con);
?>
<?php
$con =@mysql_connect("localhost","root","");
mysql_select_db("message",$con);
$url = $_SERVER['REQUEST_URI'];
$url = parse_url($url);
$url = $url[path];
//echo $url;
$result = mysql_query("select * from infor");
$count = mysql_num_rows($result);
$pagesize = 10;
$maxpage = ceil($count/$pagesize);
if(empty($_GET['page'])||$_GET['page']<0){
$page = 1;
}else{
$page = $_GET['page'];
}
$nowpage = $pagesize*($page-1);
$results = mysql_query("select * from infor limit $nowpage,$pagesize"); while($row = mysql_fetch_array($results))
{
?>
<table cellpaddign="1" cellspacing="1" border="1" width="500px" align="center">
<tr>
<td width="200px">ID:<?php echo $row[0]?></td>
<td>姓名:<?php echo $row[1]?></td>
</tr>
<tr>
<td colspan="2">标题:<?php echo $row[2]?></td>
</tr>
<tr>
<td colspan="2">内容:<?php echo $row[3]?></td>
</tr>
</table>
<?php }?>
<?php
echo "共"."$count"."条";
?>
<a href="login.php">添加留言信息</a><br>
<a href="<?php echo $url;?>?page=<?php echo $page-1;?>">上一页</a>
<?php
for($i =1;$i<maxpage;$i++){
?>
<a href="<?php echo $url;?>?page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }
if($page<$maxpage){
?>
<a href="<?php echo $url;?>?page=<?php echo $page+1?>">下一页</a>
<?php }?>
</body>
</html>
$con = @ mysql_connect("localhost","root","") or die("Could not connect:".mysql_error());
mysql_select_db("message",$con);
$sql="insert into infor (name,title,content) values ('$_GET[name]','$_GET[title]','$_GET[content]')";
mysql_query($sql);
mysql_close($con);
?>
这里面的$sql语句每次请求页面都会执行一次,向数据库插入一条记录,由于参数name, title,content没有赋值所以插入的是空记录
我把表单填写之后,点击submit不就是给name,title,content赋值了吗、