php - AJAX pagination w/ MySQL database subset -

-

i have page uses mysql & meekrodb pull info database. results limited 15 per page & alphanumeric subset of database - in example, 1-3 & a-b

i want add pagination when click either #goleft or #gort, pull correct items database.

how call ajax call pagination.php & pass variable $start it? not sure everything, please correct if have in wrong place. not sure if $start,15 correct in pagination.php

i've gotten far:

main page:

<?php require_once 'meekrodb.2.2.class.php'; require_once 'dconnect.php';  // database login info // pulling $results database on initial pg load $results = db::query("select substr(theme, 1, 1) alphabet, theme, developer, thumb, thumb_lg gallery order (case alphabet   when '1' 1   when '2' 2   when '3' 3     when 'a' 4   when 'b' 5   else 6   end), theme   limit 15"); // count of relevant items $tcount = db::query("select substr(theme, 1, 1) alphabet, theme, developer, thumb, thumb_lg gallery order (case alphabet   when '1' 1   when '2' 2   when '3' 3     when 'a' 4   when 'b' 5   else 6   end), theme"); // count of relevant items $counter = db::count(); $ipp = 15;  // items per page $tpages = ceil($counter / $ipp);  // total pages  // write each entry specific div; $x = 0; foreach ($results $row) {   $x++;   if ($x == 1) {     $t1 = $row['theme'];     $d1 = $row['developer'];     $th1 = $row['thumb'];     $thlg1 = $row['thumb_lg'];   }   ... additional if's through 15th item } ?>  basic html:  <img src="<?php echo($th1); ?>" data-retina="<?php echo($thlg1); ?>" alt="<?php echo($t1); ?>" /> <span><p class="hname"><?php echo($t1); ?></p> <div class="bull">&bull;</div> <p class="hdev"><?php echo($d1); ?></p></span> ... <div id="thumbnav"><div id="goleft"></div><div id="gort"></div></div>

main pg jquery:

// previous button var curpg = 1; $('#goleft').mouseup (function() {   var newpg = curpg - 1;   if (newpg == 0) {newpg = 1} // reset page if going first page   curpg = newpg;   var $start = (newpg - 1) * 15 + 1;   // how pass $start pagination.php ?? });  // next button $('#gort').mouseup (function() {   var newpg = curpg + 1;   var $totpgs = <?php echo $tpages; ?>;  // doesn't echo !!!   console.log('total pages: ' + $totpgs);   if (newpg > $totpgs) {newpg = $totpgs}  // limit page total pages   curpg = newpg;   var $start = (newpg - 1) * 15 + 1;   console.log('start: ' + $start);   // how pass $start pagination.php ?? });

pagination.php:

<?php require_once 'meekrodb.2.2.class.php'; require_once 'dconnect.php';  // database login info // pull database using specific page items $results = db::query("select substr(theme, 1, 1) alphabet, theme, developer, thumb, thumb_lg gallery order (case alphabet   when '1' 1   when '2' 2   when '3' 3     when 'a' 4   when 'b' 5   else 6   end), theme   limit $start,15"); ?>

update 1: pagination.php

<?php $start = $_post['start'];  // capture input ajax require_once 'meekrodb.2.2.class.php'; require_once 'dconnect.php'; // pull database using specific page items $navresults = db::query("select substr(theme, 1, 1) alphabet, theme, developer, thumb, thumb_lg gallery order (case alphabet   when '1' 1   when '2' 2   when '3' 3     when 'a' 4   when 'b' 5   else 6   end), theme   limit $start,15"); $x = 0; foreach ($navresults $row) {   $x++;   if ($x == 1) {     $t1 = $row['theme'];     $d1 = $row['developer'];     $th1 = $row['thumb'];     $thlg1 = $row['thumb_lg'];   }   ... 15th variable set }

main jquery:

//next pagination $('#gort').mouseup (function() {   var newpg = curpg + 1;   var $totpgs = <?php echo $tpages; ?>; // doesn't show echo !!!   console.log('total pages: ' + $totpgs);   if (newpg > $totpgs) {newpg = $totpgs}  // limit page total pages   curpg = newpg;   var $start = (newpg - 1) * 15 + 1;   console.log('start: ' + $start);   $.ajax({     url:'pagination.php',     type:'post',     data:{start:$start},     datatype:'text'   }); });

you need make ajax call pagination.php

$('#goleft').mouseup (function() {     var newpg = curpg - 1;     if (newpg == 0) {newpg = 1} // reset page if going first page     curpg = newpg;     var $start = (newpg - 1) * 15 + 1;     $.ajax({         url:'pagination.php',         type:'post',         data:{start:$start},         datatype:'json'     }).done(function(response) {         tableparser(response);     }); });

so, see, need function (which named tableparser) parse json , fill html table.

at same time, need pagination.php script answer valid json

<?php $start = $_post['start'] // i'm capturing input sent ajax require_once 'meekrodb.2.2.class.php'; require_once 'dconnect.php';  // database login info // pull database using specific page items $results = db::query("select substr(theme, 1, 1) alphabet, theme, developer, thumb, thumb_lg gallery order (case alphabet   when '1' 1   when '2' 2   when '3' 3     when 'a' 4   when 'b' 5   else 6   end), theme   limit $start,15");  echo json_encode($results);

i don't know particular implementation of db query, once have results in array, need output them json_encoded jquery receive them object.


Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more