Paging comments mysqli and JSON

0

I have this code to page comments and answers but does not recognize it: ListaDeComentarios.php:

require_once ("Conexion.php");

$memberId = 1;
$commentId = $_POST['comentario_id'];
$likeOrUnlike = 0;
if($_POST['like_unlike'] == 1)
{
$likeOrUnlike = $_POST['like_unlike'];
}

$sql = "SELECT * FROM megusta_nomegusta WHERE comentario_id=" . $commentId . " and member_id=" . $memberId;
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

if (! empty($row)) 
{
    $query = "UPDATE megusta_nomegusta SET like_unlike = " . $likeOrUnlike . " WHERE  comentario_id=" . $commentId . " and member_id=" . $memberId;
} else
{
    $query = "INSERT INTO megusta_nomegusta(member_id,comentario_id,like_unlike) VALUES ('" . $memberId . "','" . $commentId . "','" . $likeOrUnlike . "')";
}
mysqli_query($conn, $query);

respuesta JSON enviada desde el código php:

 function listComment() {
        $.post("ListaDeComentarios.php",
                  function (data) {
                            var data = JSON.parse(data);

                            var comments = "";
                            var replies = "";
                            var item = "";
                            var parent = -1;
                            var results = new Array();

                            var list = $("<ul class='outer-comment'>");
                            var item = $("<li>").html(comments);

                            for (var i = 0; (i < data.length); i++)
                            {
                                var commentId = data[i]['comentario_id'];
                                parent = data[i]['parent_comentario_id'];

                                var obj = getLikesUnlikes(commentId);

I like it and I do not like Ajax function:

function getLikesUnlikes(commentId)
            {
/*Llamamos al archivo php*/
                $.ajax({
                    type: 'POST',
                    async: false,
                    url: 'Envio_MeGusta.php',
                    data: {comentario_id: commentId},
                    success: function (data)
                    {
                        totalLikes = data;
                    }

                });

}

Paginate:

(function ($) {
    'use strict';

    function log(d) {
        console.log(d);
    }

    //    $(document).ready(function () {

    $.fn.pagination = function (options) {
        //        alert('prout');
        var paginationContainer = this,
            itemsPerPage,
            itemsToPaginate,
            defaults,
            settings,
            i,
            numberOfPaginationLinks;

        log(paginationContainer);

        defaults = {
            itemsPerPage: 5
        };

        settings = {};

        $.extend(settings, defaults, options);

        itemsPerPage = settings.itemsPerPage;

        itemsToPaginate = $(settings.itemsToPaginate);
        numberOfPaginationLinks = Math.ceil((itemsToPaginate.length / itemsPerPage));
        log(numberOfPaginationLinks);

        // Création de list dans la div ciblée
        $('<ul></ul>').prependTo(paginationContainer);

        // Boucle qui créer des li
        for (i = 0; i < numberOfPaginationLinks; i += 1) {
            paginationContainer.find('ul').append('<li>' + (i + 1) + '</li>');
        }

        itemsToPaginate.filter(':gt(' + (itemsPerPage - 1) + ')').hide();

        paginationContainer.find('ul li').click(function () {

            var itemsToHide,
                linkNumber,
                itemsToShow,
                $this = $(this);

            $this.addClass(settings.activeClass);
            $this.siblings().removeClass(settings.activeClass);

            linkNumber = $this.text();

            itemsToHide = itemsToPaginate.filter(':lt(' + ((linkNumber - 1) * itemsPerPage) + ')');

            $.merge(itemsToHide, itemsToPaginate.filter(':gt(' + ((linkNumber * itemsPerPage) - 1) + ')'));

            itemsToHide.hide();

            itemsToShow = itemsToPaginate.not(itemsToHide);
            itemsToShow.show();

        });
    };
    //    });

}(jQuery));

custom.js:

(function ($) {
    'use strict';
    $(document).ready(function () {

        // Appel du plugin
        $('.pagination').pagination({
            itemsToPaginate: ".output",
            activeClass: 'active'
        });

    });

}(jQuery));

$('.pagination').pagination({

      itemsPerPage: 10 // default: 5
    });
    
asked by Alfredo Marquez 28.07.2018 в 03:37
source

0 answers