瀑布流php+ajax+html+js

来源：互联网发布：龙岗大运软件小镇编辑：程序博客网时间：2024/06/05 00:21

<!DOCUMENT HTML><html><head><meta charset="utf-8"><script type="text/javascript" src="http://192.168.1.45/js/jquery-1.9.1.min.js"></script></head><body><ul></ul><div id="clickAddArt" value=0 style="width:150px;height:40px; text-align:center;line-height:40px;font-size:20px;color:red;background:#eea;" >点击加在更多</div><script type="text/javascript">$(function(){$('#clickAddArt').bind('click',function(){var value=parseInt($(this).attr('value'))+10;//设置value$(this).attr('value',value);//点击每次增加10，，，alert(value);$.ajax({TYPE:"get",url:"http://192.168.1.45/mysql.php",data: {startNum:value-10},        dataType: "html",success: function(data){var arr = data.split("-");var str='';for(var i=0; i<arr.length; i=i+2){aid=arr[i];title=arr[i+1];str += "<li><a href='/html/2013/"+aid+".html'>"+title+"</a></li>";}$('ul li:last').html(str);}});});});</script></body></html>

<pre name="code" class="php"><?php$conn = new mysqli('localhost', 'root', 'root','db_name');mysqli_set_charset($conn, "utf8");$startNum = $_GET['startNum'];$sql="select fy_archives.id,fy_archives.title,fy_archives.typeid from fy_archives,fy_addonarticle where fy_archives.id=fy_addonarticle.aid limit {$startNum},10";$reSql = $conn->query($sql);//var_dump($reSql);$returnHtml = '';while($a =mysqli_fetch_assoc($reSql)){$returnHtml .= $a['id']."-".$a['title']."-";}echo  $returnHtml;

0 0