What book to buy to learn mySQL + php at an advanced level?

Question

PHP

Hello! Studied the basics of PHP and SQL from the book by David Sklar:

1. working with sessions and cookies
   
2. storing information in a database
   
3. Exception Handling
   
4. classes, functions, variables and other lexical units
   
5. working with APIs of other web services
   
6. work with COMPOSER
   
7. sending mail with SwiftMailer
   
8. Server configuration
   
9. And so on...
   

I would like to master mySQL and php itself at an "adult level". I need a book not for beginners, but not quite for pros either.
I am reviewing the book Developing Web Applications with PHP and MySQL by Luke Welling, Laura Thomson - https://www.ozon.ru/context/detail/id/4538872/. What can you say about her? What do you advise?
Thanks in advance to everyone for the replies!

Answer 1

Books are good, of course) you can learn a lot of new tricks and rethink your code. But they will not replace practice. Best for learning, start coding)

Answer 2

As stated above: “you need to start coding!”
But! It is even desirable to have a reference book.
Therefore: PHP 7. Dmitry Koterov, Igor Simdyanov.
I highly recommend)

Answer 3

There are no such books, all books on PHP + MySQL are aimed mainly at beginners and will not differ in general from the book you read. Usually in this state, they move on to a deeper reading of the documentation or specialized articles.

Answer 4

It may not be relevant anymore, but for non-beginners, you already need to learn databases and PHP separately.
For PHP, the main book https://www.ozon.ru/context/detail/id/33506422/
For MySQL, or you need a really in-depth book, but I think that any tutorial on the Internet on basic syntax will suffice. A lot of things can be gleaned from video from conferences, where they really tell how the same databases are arranged inside.