php jquery json mysql实现瀑布流图片加载

<?php $link = mysql_connect("localhost","root","root"); $sql = "use demo"; mysql_query($sql,$link); $sql = "set names utf8"; mysql_query($sql,$link); //每次加载出从后面追加开始的几项，比如最后一个是5，那么就从6开始加4个 $num = $_POST['num'] *4; if($_POST['num'] != 0) $num +1; //分页大小，也就是每次加载出来几个 $sql = "select img,title from pubuliu limit ".$num.",4"; $result = mysql_query($sql,$link); $temp_arr = array(); while($row = mysql_fetch_assoc($result)){ $temp_arr[] = $row; } $json_arr = array(); foreach($temp_arr as $k=>$v){ $json_arr[] = (object)$v; } //print_r($json_arr); echo json_encode( $json_arr );