How fetch data from a mysql database using ajax (laravel)?

Question

How fetch data from a mysql database using ajax (laravel)? How to update the block dynamically .message_box

AJAX

$(function () {

$.ajax({
    url: "",
    dataType: 'html',

    success: function(responce){
        $('.message_box').html(responce); // this div to be updated
    }
});

});

Blade

<div class="message_box">

    @foreach($message as $content)
        {{ $content->message }}
    @endforeach

</div>

Controller

public function chat()
{
    $message = MessageModel::orderBy('id')->get();
    return view('chat.chat', ['message' => $message]);
}

Updated code

Where is the database query? What is the problem?

Ram
– Ram

2015-12-26 19:07:28 +00:00
Commented Dec 26, 2015 at 19:07 — Ram
– Ram, Commented Dec 26, 2015 at 19:07
@Vohuman, Updated code

Designlenta Gogo
– Designlenta Gogo

2015-12-26 19:11:50 +00:00
Commented Dec 26, 2015 at 19:11 — Designlenta Gogo
– Designlenta Gogo, Commented Dec 26, 2015 at 19:11

Beardslapper · Accepted Answer · 2015-12-26 20:31:25Z

3

Did you add a url to your ajax request?

Routes

Route::get('/chat', 'ChatController@chat');

AJAX

      function update() {
        $.ajax({
           url: "/chat",
           dataType: 'html',

           success: function(responce){
               $('.message_box').html(responce);
           }
        });
    }

    $('#send_message').submit(function (event) {
        event.preventDefault();

        $.ajax({
            type: "post",
            url: "/chat",
            context: this,
            data: $(this).serialize(),
            cache: false,
            async: true,

            success: function () {
                $('#message').val('');
                update();
            },

            error: function () {
                alert('Сообщение не было отправлено');
            }
        });

    });

edited Dec 26, 2015 at 20:31

answered Dec 26, 2015 at 19:16

Beardslapper

1532 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Designlenta Gogo Over a year ago

yes, but .message_box is not updated (if add new content).

Beardslapper Over a year ago

the ajax is being called only once; when the page first loads. Is the chat in real time?

Beardslapper Over a year ago

Are you using additional code, or is this the only code you are using for a real time chat? Are you using node?

Beardslapper Over a year ago

If you want the chat to update when you click send message, then you can just call the update method as shown about. But if you want to chat with other users, then I suggest looking at nodejs and socket.io.

Designlenta Gogo Over a year ago

hm, sorry, but, div.message_box not refreshing :( (copy + past)

|

Collectives™ on Stack Overflow

How fetch data from a mysql database using ajax (laravel)?

1 Answer 1

Routes

AJAX

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Routes

AJAX

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related