continuous scrolling. AJAX, PHP, JAVASCRIPT, MYSQL -

-

i creating forum. so, there "order by" dropdown box i.e select tag in html. user selects order time or like, etc. ajax function called dynamically brings content page mysql database.

select menu

<select name="orderby" onchange="showposts(this.value)"> <option value="1" selected>by time</option> <option value="2">by genuine count</option> <option value="3">by dubious count</option> </select>

showposts function

function showposts(str){          orderby=str;          if (window.xmlhttprequest) {             // code ie7+, firefox, chrome, opera, safari             xmlhttp=new xmlhttprequest();         } else { // code ie6, ie5             xmlhttp=new activexobject("microsoft.xmlhttp");         }         xmlhttp.onreadystatechange=function() {             if (xmlhttp.readystate==4 && xmlhttp.status==200) {                 document.getelementbyid("postsdiv").innerhtml=xmlhttp.responsetext;             }         }         xmlhttp.open("get","showposts.php?q="+str,true);         xmlhttp.send(); }

showposts.php page

$sql = "select * posts order date desc "; $result = $connection->query($sql); $username=$_session['username'];  while($row = $result->fetch_assoc()) {     echo "<span id='postspan".$row['id']."' name='postspan".$row['id']."' >";     echo "<span id='editspan".$row['id']."' name='editspan".$row['id']."' >";     echo "-----------------------------------</br>";     echo "-----------------------------------</br>";      echo "posted by: ".$row['user']."&nbsp&nbsp&nbsp&nbsp";     echo "time: ".$row['date']."</br>";     echo "<span id=genuinecount".$row['id'].">genuine count: ".$row['genuine'].";             echo "<span id=dubiouscount".$row['id'].">dubious count: ".$row['dubious']."</span>";     echo "</br>------------------------ </br>";     echo "subject: ".$row['subject']."</br>";      echo "post: ".$row['post'].'<br />';

}

problem so, problem here is, want use continuous scroll option 1 used in facebook. javascripts , jquery libraries saw use logic when user scrolls down page, javascript places content after that. but, here running while loop brings data database @ time. so, couldn't implement javascript code. so, there thing achieve continuous scroll, there possibility break while loop or retrieving entire data , display part part or that?

javascript scrolling

function yhandler(){     var wrap=document.getelementbyid('postsdiv');     var contentheight=wrap.offsetheight;     var yoffset=window.pageyoffset;     var y=yoffset+window.innerheight;     if(y>=contentheight){         showposts(); } } window.onscroll=yhandler();

use pdo class built php , query database return rows array of stdclass objects. use pdostatement::fetchobject() loop through array


Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more