jquery - Using AJAX/PHP/mysqli to create a load more button -


in code below trying create load more button using ajax. have main.php includes php code calling blogs database initially, jquery code , load more button. have ajax_more.php calls more data database when load more clicked. load more buttons displayed , when clicked change loading , disappear. nothing else happens , main.php still shows 2 initial blogs call first. please code , code has gone wrong.

main.php

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript">     $(document).ready(function () {         $(document).on('click', '.show_more', function () {             var id = $(this).attr('id');             $('.show_more').hide();             $('.loding').show();             $.ajax({                 type: 'post',                 url: 'ajax_more.php',                 data: 'id=' + id,                 success: function (html) {                     $('#show_more_main' + id).remove();                     $('.columns').append(html);                 }             });         });     }); </script>  <?php $query = "     select blogs_id, title, body, posted_by, full_name, bio, posted, category     blogs          inner join categories              on categories.category_id=blogs.category_id      category='cat1' or category='catt2' or category='cat3' or category='cat4'      order blogs_id desc      limit 2 "; $result = mysqli_query($con,$query); $rowcount = mysqli_num_rows($result);  if($rowcount > 0){     while ($row = mysqli_fetch_assoc($result)) {         $blogs_id = $row['blogs_id'];         $title = $row['title'];         $body = $row['body'];         $posted_by = $row['posted_by'];         $full_name = $row['full_name'];         $bio = $row['bio'];         $posted = $row['posted'];          echo "             <div class='db'>                 <h2>$title</h2>                 <p>$body</p>                 <p>$bio</p>             </div>         "; ?> <div class="show_more_main" id="show_more_main<?php echo $blogs_id; ?>">     <span id="<?php echo $blogs_id; ?>" class="show_more" title="load more posts">show more</span>     <span class="loding" style="display: none;"><span class="loding_txt">loading…</span></span> </div>

ajax_more.php

<?php if(isset($_post["blogs_id"]) && !empty($_post["blogs_id"])) {     $query = "         select blogs_id, title, body, posted_by, full_name, bio, posted, category          blogs              inner join categories on categories.category_id=blogs.category_id          category='entertainment' or category='politics' or category='sports' or category='travel'             , blogs_id < ".$_post['blogs_id']."          order blogs_id desc          limit 2     ";     $result = mysqli_query($con,$query);     $rowcount = mysqli_num_rows($result);     if($rowcount > 0){         while ($row = mysqli_fetch_assoc($result)) {             $blogs_id = $row['blogs_id'];             $title = $row['title'];             $body = $row['body'];             $posted_by = $row['posted_by'];             $full_name = $row['full_name'];             $bio = $row['bio'];             $posted = $row['posted'];              echo "                 <div class='db'>                 <h2>$title</h2>                 <p>$body</p>                 <p>$bio</p>                 </div>             "; ?>

you should change query this

$query = "select blogs_id, title, body, posted_by, full_name, bio, posted, category  blogs inner join categories on categories.category_id=blogs.category_id (category='entertainment' or category='politics' or category='sports' or category='travel')   , blogs_id < " . $_post['blogs_id'] . " order blogs_id desc limit 2";

all or's must enclosed in brackets....


Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more