问题描述
- Jquery 瀑布流应用，怎么把它和数据库对接
-
<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>jQuery Wookmark Plug-in Example</title> <meta name="description" content="An very basic example of how to use the Wookmark jQuery plug-in."> <meta name="author" content="Christoph Ono, Sebastian Helzle"> <meta name="viewport" content="width=device-width,initial-scale=1"> <!-- CSS Reset --> <link rel="stylesheet" href="../css/reset.css"> <!-- Global CSS for the page and tiles --> <link rel="stylesheet" href="../css/main.css"> </head> <body> <div id="container"> <header> <h1>jQuery Wookmark Plug-in Example</h1> <p>Scroll down to see the infinite scroll effect.</p> </header> <div id="main" role="main"> <ul id="tiles"> <!-- These are our grid blocks --> <li><img src="../sample-images/image_1.jpg" width="200" height="283"><p>1</p></li> <li><img src="../sample-images/image_2.jpg" width="200" height="300"><p>2</p></li> <li><img src="../sample-images/image_3.jpg" width="200" height="252"><p>3</p></li> <li><img src="../sample-images/image_4.jpg" width="200" height="158"><p>4</p></li> <li><img src="../sample-images/image_5.jpg" width="200" height="300"><p>5</p></li> <li><img src="../sample-images/image_6.jpg" width="200" height="297"><p>6</p></li> <li><img src="../sample-images/image_7.jpg" width="200" height="200"><p>7</p></li> <li><img src="../sample-images/image_8.jpg" width="200" height="200"><p>8</p></li> <li><img src="../sample-images/image_9.jpg" width="200" height="398"><p>9</p></li> <li><img src="../sample-images/image_10.jpg" width="200" height="267"><p>10</p></li> <li><img src="../sample-images/image_1.jpg" width="200" height="283"><p>11</p></li> <li><img src="../sample-images/image_2.jpg" width="200" height="300"><p>12</p></li> <li><img src="../sample-images/image_3.jpg" width="200" height="252"><p>13</p></li> <li><img src="../sample-images/image_4.jpg" width="200" height="158"><p>14</p></li> <li><img src="../sample-images/image_5.jpg" width="200" height="300"><p>15</p></li> <li><img src="../sample-images/image_6.jpg" width="200" height="297"><p>16</p></li> <li><img src="../sample-images/image_7.jpg" width="200" height="200"><p>17</p></li> <li><img src="../sample-images/image_8.jpg" width="200" height="200"><p>18</p></li> <li><img src="../sample-images/image_9.jpg" width="200" height="398"><p>19</p></li> <li><img src="../sample-images/image_10.jpg" width="200" height="267"><p>20</p></li> <li><img src="../sample-images/image_1.jpg" width="200" height="283"><p>21</p></li> <li><img src="../sample-images/image_2.jpg" width="200" height="300"><p>22</p></li> <li><img src="../sample-images/image_3.jpg" width="200" height="252"><p>23</p></li> <li><img src="../sample-images/image_4.jpg" width="200" height="158"><p>24</p></li> <li><img src="../sample-images/image_5.jpg" width="200" height="300"><p>25</p></li> <li><img src="../sample-images/image_6.jpg" width="200" height="297"><p>26</p></li> <li><img src="../sample-images/image_7.jpg" width="200" height="200"><p>27</p></li> <li><img src="../sample-images/image_8.jpg" width="200" height="200"><p>28</p></li> <li><img src="../sample-images/image_9.jpg" width="200" height="398"><p>29</p></li> <li><img src="../sample-images/image_10.jpg" width="200" height="267"><p>30</p></li> <!-- End of grid blocks --> </ul> </div> <footer> </footer> </div> <!-- include jQuery --> <script src="../libs/jquery.min.js"></script> <!-- Include the imagesLoaded plug-in --> <script src="../libs/jquery.imagesloaded.js"></script> <!-- Include the plug-in --> <script src="../jquery.wookmark.js"></script> <!-- Once the page is loaded, initalize the plug-in. --> <script type="text/javascript"> (function ($){ var $tiles = $('#tiles'), $handler = $('li', $tiles), $main = $('#main'), $window = $(window), $document = $(document), options = { autoResize: true, // This will auto-update the layout when the browser window is resized. container: $main, // Optional, used for some extra CSS styling offset: 20, // Optional, the distance between grid items 图片与图片之间的间距 itemWidth: 210 // Optional, the width of a grid item 太小的话图片与图片会叠加 }; /** * Reinitializes the wookmark handler after all images have loaded */ function applyLayout() { $tiles.imagesLoaded(function() { // Destroy the old handler if ($handler.wookmarkInstance) { $handler.wookmarkInstance.clear(); } // Create a new layout handler. $handler = $('li', $tiles); $handler.wookmark(options); }); } /** * When scrolled all the way to the bottom, add more tiles */ function onScroll() { // Check if we're within 100 pixels of the bottom edge of the broser window. var winHeight = window.innerHeight ? window.innerHeight : $window.height(), // iphone fix closeToBottom = ($window.scrollTop() + winHeight > $document.height() - 100); if (closeToBottom) { // Get the first then items from the grid, clone them, and add them to the bottom of the grid var $items = $('li', $tiles), $firstTen = $items.slice(0, 10); $tiles.append($firstTen.clone()); applyLayout(); } }; // Call the layout function for the first time applyLayout(); // Capture scroll event. $window.bind('scroll.wookmark', onScroll); })(jQuery); </script> </body> </html>
我想要的瀑布流是从数据库里读取，但网页进来时不会显示全部图片，往下滑动时才会显示其他图片。而这种它一次就把所有图片读取，滑动到底部也只是重复一遍而已。
解决方案
一般瀑布流插件有配置支持动态从数据库中读取数据的，你认真看下API。
如果确认你的这个不支持动态读取，只能换一个瀑布流插件了，如这个：
(function ($) {
var
//参数
setting = {
column_width: 240, //列宽
column_className: 'waterfall_column', //列的类名
column_space: 10, //列间距
cell_selector: '.cell', //要排列的砖块的选择器，context为整个外部容器
img_selector: 'img', //要加载的图片的选择器
auto_imgHeight: true, //是否需要自动计算图片的高度
fadein: true, //是否渐显载入
fadein_speed: 600, //渐显速率，单位毫秒
insert_type: 1, //单元格插入方式，1为插入最短那列，2为按序轮流插入
getResource: function (index) { } //获取动态资源函数,必须返回一个砖块元素集合,传入参数为加载的次数
},
//
waterfall = $.waterfall = {}, //对外信息对象
$waterfall = null; //容器
waterfall.load_index = 0, //加载次数
$.fn.extend({
waterfall: function (opt) {
opt = opt || {};
setting = $.extend(setting, opt);
$waterfall = waterfall.$waterfall = $(this);
waterfall.$columns = creatColumn();
render($(this).find(setting.cell_selector).detach(), false); //重排已存在元素时强制不渐显
waterfall._scrollTimer2 = null;
$(window).bind('scroll', function () {
clearTimeout(waterfall._scrollTimer2);
waterfall._scrollTimer2 = setTimeout(onScroll, 300);
});
waterfall._scrollTimer3 = null;
$(window).bind('resize', function () {
clearTimeout(waterfall._scrollTimer3);
waterfall._scrollTimer3 = setTimeout(onResize, 300);
});
}
});
function creatColumn() {//创建列
waterfall.column_num = calculateColumns(); //列数
//循环创建列
var html = '';
for (var i = 0; i < waterfall.column_num; i++) {
html += '<div class="' + setting.column_className + '" style="width:' + setting.column_width + 'px; display:inline-block; *display:inline;zoom:1; margin-left:' + setting.column_space / 2 + 'px;margin-right:' + setting.column_space / 2 + 'px; vertical-align:top; overflow:hidden"></div>';
}
$waterfall.prepend(html); //插入列
return $('.' + setting.column_className, $waterfall); //列集合
}
function calculateColumns() {//计算需要的列数
var num = Math.floor(($waterfall.innerWidth()) / (setting.column_width + setting.column_space));
if (num < 1) { num = 1; } //保证至少有一列
return num;
}
function render(elements, fadein) {//渲染元素
if (!$(elements).length) return; //没有元素
var $columns = waterfall.$columns;
$(elements).each(function (i) {
if (!setting.auto_imgHeight || setting.insert_type == 2) {//如果给出了图片高度，或者是按顺序插入，则不必等图片加载完就能计算列的高度了
if (setting.insert_type == 1) {
insert($(elements).eq(i), setting.fadein && fadein); //插入元素
} else if (setting.insert_type == 2) {
insert2($(elements).eq(i), i, setting.fadein && fadein); //插入元素
}
return true; //continue
}
if ($(this)[0].nodeName.toLowerCase() == 'img' || $(this).find(setting.img_selector).length > 0) {//本身是图片或含有图片
var image = new Image;
var src = $(this)[0].nodeName.toLowerCase() == 'img' ? $(this).attr('src') : $(this).find(setting.img_selector).attr('src');
image.onload = function () {//图片加载后才能自动计算出尺寸
image.onreadystatechange = null;
if (setting.insert_type == 1) {
insert($(elements).eq(i), setting.fadein && fadein); //插入元素
} else if (setting.insert_type == 2) {
insert2($(elements).eq(i), i, setting.fadein && fadein); //插入元素
}
image = null;
}
image.onreadystatechange = function () {//处理IE等浏览器的缓存问题：图片缓存后不会再触发onload事件
if (image.readyState == "complete") {
image.onload = null;
if (setting.insert_type == 1) {
insert($(elements).eq(i), setting.fadein && fadein); //插入元素
} else if (setting.insert_type == 2) {
insert2($(elements).eq(i), i, setting.fadein && fadein); //插入元素
}
image = null;
}
}
image.src = src;
} else {//不用考虑图片加载
if (setting.insert_type == 1) {
insert($(elements).eq(i), setting.fadein && fadein); //插入元素
} else if (setting.insert_type == 2) {
insert2($(elements).eq(i), i, setting.fadein && fadein); //插入元素
}
}
});
}
function public_render(elems) {//ajax得到元素的渲染接口
render(elems, true);
}
function insert($element, fadein) {//把元素插入最短列
if (fadein) {//渐显
$element.css('opacity', 0).appendTo(waterfall.$columns.eq(calculateLowest())).fadeTo(setting.fadein_speed, 1);
} else {//不渐显
$element.appendTo(waterfall.$columns.eq(calculateLowest()));
}
}
function insert2($element, i, fadein) {//按序轮流插入元素
if (fadein) {//渐显
$element.css('opacity', 0).appendTo(waterfall.$columns.eq(i % waterfall.column_num)).fadeTo(setting.fadein_speed, 1);
} else {//不渐显
$element.appendTo(waterfall.$columns.eq(i % waterfall.column_num));
}
}
function calculateLowest() {//计算最短的那列的索引
var min = waterfall.$columns.eq(0).outerHeight(), min_key = 0;
waterfall.$columns.each(function (i) {
if ($(this).outerHeight() < min) {
min = $(this).outerHeight();
min_key = i;
}
});
return min_key;
}
function getElements() {//获取资源
$.waterfall.load_index++;
return setting.getResource($.waterfall.load_index, public_render);
}
waterfall._scrollTimer = null; //延迟滚动加载计时器
function onScroll() {//滚动加载
clearTimeout(waterfall._scrollTimer);
waterfall._scrollTimer = setTimeout(function () {
var $lowest_column = waterfall.$columns.eq(calculateLowest()); //最短列
var bottom = $lowest_column.offset().top + $lowest_column.outerHeight(); //最短列底部距离浏览器窗口顶部的距离
var scrollTop = document.documentElement.scrollTop || document.body.scrollTop || 0; //滚动条距离
var windowHeight = document.documentElement.clientHeight || document.body.clientHeight || 0; //窗口高度
if (scrollTop >= bottom - windowHeight) {
render(getElements(), true);
}
}, 100);
}
function onResize() {//窗口缩放时重新排列
if (calculateColumns() == waterfall.column_num) return; //列数未改变，不需要重排
var $cells = waterfall.$waterfall.find(setting.cell_selector);
waterfall.$columns.remove();
waterfall.$columns = creatColumn();
render($cells, false); //重排已有元素时强制不渐显
}
})(jQuery);
配置getResource即可。。自己用ajax读出数据后调用render回调即可
var totalpage = 1;//从数据库中读取总页数赋值给这个js变量，如<%=你的服务器端变量名%>
function getResource(index, render) { if (index + 1 > totalpage || opt.loading) return false; opt.loading = true; $.ajax({ url: '动态页地址', data: { page: index + 1, pagesize: 8}, type: 'POST', complete: function (xhr) { opt.loading = false; $('#pLoading').hide(); render($(xhr.responseText)); } }); }
var opt = { auto_imgHeight: true, insert_type: 1 };
if (totalpage > 1) opt.getResource = getResource;
$('#waterfall').waterfall(opt);
解决方案二：
- 中的数据使用AJAX调用后台页面从数据库中取。
解决方案三：
参考Wookmark-jQuery/example-api这个项目自带的例子。
可以在onScroll里面调用ajax来从服务器上获取数据，例子里面的function loadData()
解决方案四：
是的！一般这种插件都做好了接口的
时间： 2024-09-12 14:08:09