<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(); $('.posts').append(html); } }); }); }); </script>
<?php $sql = "SELECT * FROM posts ORDER BY id desc limit 3"; $query = $db->prepare($sql); $query->execute(); $row = $query->fetch(PDO::FETCH_ASSOC); $ID = $row['blogs_id']; ?> <div class="posts"> <table> <tr> <?php do { //horizontal looper?> <td> <div><h2><?php echo $row['title']; ?></h2></div> <div><p><?php echo $row['body']; ?></p></div> <img src='<?php echo $row['pic']; ?>'> <div><p><?php echo $row['about']; ?></p></div> </td> <?php $row = $query->fetch(PDO::FETCH_ASSOC); if (!isset($nested_List)) { $nested_List= 1; } if (isset($row) && is_array($row) && $nested_List++%3==0) { echo "</tr><tr>"; } } while ($row); //end horizontal looper ?> </table> <div class="show_more_main" id="show_more_main<?php echo $ID; ?>"> <span id="<?php echo $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> </div>
if(isset($_POST["id"]) && !empty($_POST["id"])){ $id=$_POST['id']; $query = $db->prepare("SELECT * FROM posts WHERE id < :getid ORDER BY id desc LIMIT 3"); $query->execute(array(':getid'=>$id)); $row = $query->fetch(PDO::FETCH_ASSOC); $ID = $row['blogs_id']; ?> <table> <tr> <?php do { //horizontal looper?> <td> <div><h2><?php echo $row['title']; ?></h2></div> <div><p><?php echo $row['body']; ?></p></div> <img src='<?php echo $row['pic']; ?>'> <div><p><?php echo $row['about']; ?></p></div> </td> <?php $row = $query->fetch(PDO::FETCH_ASSOC); if (!isset($nested_List)) { $nested_List= 1; } if (isset($row) && is_array($row) && $nested_List++%3==0) { echo "</tr><tr>"; } } while ($row); //end horizontal looper ?> </table> <div class="show_more_main" id="show_more_main<?php echo $ID; ?>"> <span id="<?php echo $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> <?php } ?>
var ID = $($(this).attr('id')).val();
<span id="tableid" value="<?php echo $ID; ?>" class="show_more" title="Load more posts">Show more</span>
var ID = $('#tableid').val();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)