Event listen when a user updates db query

I would start by advicing you using Socket rather than Pusher, and then have a look at https://laracasts.com/discuss/channels/general-discussion/step-by-step-guide-to-installing-socketio-and-broadcasting-events-with-laravel-51/

@bluepenlabs Thanks for your reply, I will look into that and consider it for the future, but for now I would like to try out Pusher since I already have it up and running.

Do you know how I could achieve this? Or maybe to simplify it: When the user adds a new contact in the backend that their frontend page just gets refreshed. The key part is that I don't understand how to listen to db events for a specific authorized user and to return actions to the same user..

I had the same question myself. I haven't implemented this yet, but what I plan on doing is having a certain "channel" for each user (probably stored in the user table). Then, I'll have the javascript client listen on that channel (using socket, I imagine pusher would work the same way), and the backend code would broadcast on that user's specific channel. I plan on having it a 16 character random alphanumeric string, so users can't guess other user's channels.

Thats the communications part done, next you'd need to have your javascript client handle the new messages (see if it's a command to refresh the page, or push the new data to an array, etc).

That would be my solution, but someone else may have an easier/better solution.

@nicsouthern Thanks for your idea.. Do you have any idea how I could accomplish this: define a event handler that checks if a list has been updated and then refresh a page of the user that the list belongs to? I have already specified that it's a one-to-many relationship in the model. Thanks!

I would really appreciate it if I could get some help here

@bobeta I will give u something precious :P Laravel and Pusher Workshop.

This is Laravel Workshop with pusher service.

@veve286 Thanks for the example and the time! I have already have pusher running, my question is more oriented to how to code the event listener for that task and how to display the update to only the users that the lists belong to

Might be easiest to store (or use an accessor) in your user model. You can then check if you have an authenticated user in your layout view and build the user-specific channel listener. Likewise with firing the events - fire t using the authenticated user's channel identifier if one exists.

@deringer Thanks, that sounds like a decent solution. Could you please provide some code examples so that I can get a better understanding of how it would work?

This is pretty rough, and untested.

// In your model

public function getChannelAttribute()
{
    return sprintf('notifications-%d', $this->attributes['id']);
}


// In your view

@if(auth()->check())
    // Setup your pusher subscriber and get it to subscribe to auth()->user()->channel
@endif

Then when firing your event, make sure that it gets fired on $user->channel if there's an authenticated user.

First You Need to an a Hidden input for the Auth user ID in your Blade

Second In Your Controller method before you Return it Fire an Event

    event(new App\Events\UserHasAddedAList());

In Your Broadcasting Event File Add something like

 public function broadcastOn()
    {
        // return ['user-'. $this->user->id];
    }

This im not sure coz im using socket.io You Just need to make it pusher

 socket.on('rfn-chanel:user.id', function(data) {
          this.users.unshift(data);
      }.bind(this));