Back-End Networking, Databases and Multiplayer

Question

I recently decided to finally approach php after years of fear and finished the course. However I'm no closer to finding out what is needed.
Information I received from comments and research are mostly things like "You need a [A-Z]AMP thing; this's better; that's slower; that's costly; less space.."
All the uncertainties stopped me from continuing the SQL course, especially since everyone claims it is rather useless now, and apparently people dislike SoloLearn teaching MySQL.
Also, I heard that PHP is dying and I should use a js framework which are much faster than php, and use something like NoSQL or [insert weird name]SQL.

But at the end it seems different things are good for specific purposes.
My questions are:
If I want to make a website so users can sign up/login and store info, what do I use.
What do I use for multiplayer real time games such as ROTMG or LoL, incorporating these with javascript of course.

I would appreciate any explanations and articles that may point me in the right direction.

Answer 1

In JavaScript, you can use the XMLHttpRequest object to send a request without a form... maybe use that? I’m really not sure, that’s just an idea.

Answer 2

Whos saying that? I use what ever language I feel comfortable with.
PHP, mysql, nodejs and socket.io for real time socket server.

Answer 3

Toni Isotalo so real time socket server is what's used for multiplayer, or for website accounts and data storage as such?