Ratchet | Asynchronous WebSocket server | Websocket library

I want to build a query based one table. From this one table I want to create two virtual tables based on an count aggregation query. In my example it would split to original table into a table where Xbox Games per Player are counted and one where Playstation Games per player are counted. Then the results of the queries are joined based on the PlayerID.

I created a react app where I display different video games and the app decides which game to play. I also have a file where I stored the data of video games. The goal I'm trying to achieve is to render the youtube video trailer of the corresponding video game when clicking on a button while using React Hooks. I've been using the npm package react-player. If someone could help, I'd appreciate it.

This is the code for the Video Game component:

I have the following table for example

I'm attempting to parse out a fairly nested XML file. I've spent the last few hours trying to find a solution with no luck. I'm not sure if the issue is with namespaces, or needing to findall within the loop.

I am able to extract the higher level elements but the deeper nested elements are not being extracted. I am looking to export Part_number, manufacturer_name, name, Product and Retail to a df.

XML sample here (there isn't perfect uniformity across all submissions, some missing fields):

I was asked me to make an api call using websocket with php Ratchet at work. Since I'm totally unfamilier with websocket so I googled and watched youtube videos to solve this problem, but The more I searched, the more I felt it is impossible to call api with websocket.

Am I missing something or is it really impossible to call api by websocket? If it is possible, can you please show me an example how to do it

I know i might sound awkward since I don't have a solid understanding of websockets, English isn't even my first language, but i'm really desperate please help me

My development environment is this:

• OS: Microsoft Windows 10
• PHP framework: Laravel 8.0
• PHP version 7.4
• Websocket server: cboden/ratchet 0.4.3
• WAMP server 3.2.0 (Apache 2.4.41)
• Firefox 91.0.1 (64-bit) / chrome

I created a new Laravel app to implement a Secure Websocket Server and get connected to it using plain javascript on the client side (Laravel blade file). The websocket server works fine, as far as I can see it running, but the web browser is not able to connect, as seen on this image:

I have tried using different URLs, with and without port number, but to no avail. I created a SSL certificate and private key files, using openssl.exe tool, and put them in the command folder for testing purposes.

This is my handle code for the Secure Websocket Server:

After checking similar questions on stackoverflow I did not find anything much helpful for what I want to do in my project. Reading and researching I successfully made the application work having multiple connections to my Ratchet PHP websocket server, but I noticed every time the user reloaded a page or opened a link in a new tab, the client websocket got disconnected and then reconnected again.

So, I wonder how to get only one persistent connection to a WebSocket Server, for multiple users, in a web application using a Sharedworker.

What I have in the client side is this:

I am developing a scorecard application where certain group of members are playing and can update their score in chart which needs to be reflected in team members screen too.

For this purpose I am using cboden/ratchet.

Each team have a common team code which I will pass using URL localhost:8000/{token} which will be passed from controller to twig.

I have following in command:

I am new to websockets and I want to implement such service in my Laravel application. I have already read several posts/pages about this topic, but none explains what I need to do. All of them show how to create an "Echo" websocket server, where the server only responds to messages received from clients, which is not my case.

As a starting base I used the code provided at:

https://medium.com/@errohitdhiman/real-time-one-to-one-and-group-chat-with-php-laravel-ratchet-websocket-library-javascript-and-c64ba20621ed

Where the websocket server is ran from the command line or another console. The server has its own class to define it and imports the WebSocketController class (MessageComponentInterface), which contains the classic WebSocket server events (onOpen, onMessage, onClose, onError).

All that works fine as is but, how can I "tell" the WebSocket Server to send a message to a specific connection (client) from another class, which also belong to another namespace?. This is the case of a notification or event, where new web content must be sent to that specific client. There are no subscriptions nor publications on the way from the client side.

As @Alias asked in his post Ratchet PHP - Push messaging service I obviously cannot create a new instance of the Websocket server or its events management class, so what would be the best approach to send content or messages to the client?

As you all can see, the communication is only in one way: from the WebSocket Server to the client(s) and not the opposite. I already have a notification class and a listener class prepared for this but, I still don't know how to address the communication with clients from the handle() method: