index.php
<?php
require_once("header.php");//连接数据库
?> <!doctype html>
<html>
<head>
<meta charset="utf-8">
<script src="http://libs.baidu.com/jquery/1.7.0/jquery.min.js"></script>
</head>
<body><div id="container">
<?php
$q3="select * from qiangad2 where adyz='0' order by adtime desc,adid Limit 0,8";//$ags[adgsdp3]
$r3=$obj_db->simplequery($q3);
while ($a3=$obj_db->fetchrow($r3,DB_FETCHMODE_ASSOC)){
?>
<div class="single_item">
<div class="element_head">
<div class="date"><?php echo $a3[adjifen];?></div>
<div class="author"><?php echo $a3[adjiage];?></div>
</div>
<div class="content"><b><?php echo $a3[adid];?></b></div>
</div>
<?php } ?>
</div>
<script language='javascript'>
$(function(){
var winH = $(window).height(); //页面可视区域高度
var i = 1; //设置当前页数
$(window).scroll(function () {
var pageH = $(document.body).height();
var scrollT = $(window).scrollTop(); //滚动条top
var aa = (pageH-winH-scrollT)/winH;
if(aa<0.02){
$.getJSON("result.php",{page:i},function(json){
if(json){
var str = "";
$.each(json,function(index,array){
var str = "<div class=\"single_item\"><div class=\"element_head\">";
var str += "<div class=\"date\">"+array['date']+"</div>";
var str += "<div class=\"author\">"+array['author']+"</div>";
var str += "</div><div class=\"content\">"+array['content']+"</div></div>";
$("#container").append(str);
});
i++;
}else{
$(".nodata").show().html("别滚动了,已经到底了");
return false;
}
});
}
});
});
</script>
<div class="nodata"></div>result.php
<?php
require_once("header.php");$page = intval($_GET['page']); //获取请求的页数
$start = $page*8; $q3="select * from qiangad2 where adyz='0' order by adtime desc,adid Limit $start,8";//$ags[adgsdp3]
$r3=$obj_db->simplequery($q3);
while ($a3=$obj_db->fetchrow($r3,DB_FETCHMODE_ASSOC)){
$arr[] = array(
'content'=>$a3[adjifen],
'author'=>$a3[adjiage],
'date'=>$a3[adid]
);
}
echo json_encode($arr);//转换为json数据输出
?>或者谁有现成的 php+mysql 下拉加载源码的,请无私分享一份给我,谢谢!
<?php
require_once("header.php");//连接数据库
?> <!doctype html>
<html>
<head>
<meta charset="utf-8">
<script src="http://libs.baidu.com/jquery/1.7.0/jquery.min.js"></script>
</head>
<body><div id="container">
<?php
$q3="select * from qiangad2 where adyz='0' order by adtime desc,adid Limit 0,8";//$ags[adgsdp3]
$r3=$obj_db->simplequery($q3);
while ($a3=$obj_db->fetchrow($r3,DB_FETCHMODE_ASSOC)){
?>
<div class="single_item">
<div class="element_head">
<div class="date"><?php echo $a3[adjifen];?></div>
<div class="author"><?php echo $a3[adjiage];?></div>
</div>
<div class="content"><b><?php echo $a3[adid];?></b></div>
</div>
<?php } ?>
</div>
<script language='javascript'>
$(function(){
var winH = $(window).height(); //页面可视区域高度
var i = 1; //设置当前页数
$(window).scroll(function () {
var pageH = $(document.body).height();
var scrollT = $(window).scrollTop(); //滚动条top
var aa = (pageH-winH-scrollT)/winH;
if(aa<0.02){
$.getJSON("result.php",{page:i},function(json){
if(json){
var str = "";
$.each(json,function(index,array){
var str = "<div class=\"single_item\"><div class=\"element_head\">";
var str += "<div class=\"date\">"+array['date']+"</div>";
var str += "<div class=\"author\">"+array['author']+"</div>";
var str += "</div><div class=\"content\">"+array['content']+"</div></div>";
$("#container").append(str);
});
i++;
}else{
$(".nodata").show().html("别滚动了,已经到底了");
return false;
}
});
}
});
});
</script>
<div class="nodata"></div>result.php
<?php
require_once("header.php");$page = intval($_GET['page']); //获取请求的页数
$start = $page*8; $q3="select * from qiangad2 where adyz='0' order by adtime desc,adid Limit $start,8";//$ags[adgsdp3]
$r3=$obj_db->simplequery($q3);
while ($a3=$obj_db->fetchrow($r3,DB_FETCHMODE_ASSOC)){
$arr[] = array(
'content'=>$a3[adjifen],
'author'=>$a3[adjiage],
'date'=>$a3[adid]
);
}
echo json_encode($arr);//转换为json数据输出
?>或者谁有现成的 php+mysql 下拉加载源码的,请无私分享一份给我,谢谢!
解决方案 »
- mysql 触发器怎么写 5.0.6
- zend stuio 7.2 如何高亮显示所有PHP关键字?
- php中是否自带这样的方法
- flashfxp上传至网络时出现Discuz! Database Error,求原因
- 能用thinkphp做php类cms的二次开发么?
- eval函数的用法???
- 请教cms问题
- linux svn 检出更新时报错svn: Can't convert string from 'UTF-8' to native encoding:
- ubuntu下Smarty3 配置后 页面空白
- php写支付宝提现,支付宝提现能提现成功就是调不到异步地址
- TP3.2怎么引入百度云的SDK
- oa自动化办公系统
header.php只是读取数据,和这个没关系
<script language='javascript'>
$(function(){
var winH = $(window).height(); //页面可视区域高度
var i = 1; //设置当前页数
$(window).scroll(function () {
var pageH = $(document.body).height();
var scrollT = $(window).scrollTop(); //滚动条top
var aa = (pageH-winH-scrollT)/winH;
if(aa<0.02){
$.getJSON("result.php",{page:i},function(json){
if(json){
var str = "";
$.each(json,function(index,array){
var str = "<div class=\"single_item\"><div class=\"element_head\">";
var str += "<div class=\"date\">"+array['date']+"</div>";
var str += "<div class=\"author\">"+array['author']+"</div>";
var str += "</div><div class=\"content\">"+array['content']+"</div></div>";
$("#container").append(str);
});
i++;
}else{
$(".nodata").show().html("别滚动了,已经到底了");
return false;
}
});
}
});
});
</script>抛开header.php
直接用这个 ,拉到最下面,也不触发啊