What programming books should a PHP programmer read?

Question

PHP

I started studying without books, worked for a couple of months, then read "php objects, templates and programming techniques". Now I went to order "Perfect Code", but it turned out that there was not enough cost for the delivery to be free (that's how greedy I am). And I know there's more to read, but what? Maybe there is something for professionals in mysql (because I know the basics and a little more)?
Now I work on UII, and I know that there is a book on it "Yii. A book of recipes - Alexander Makarov" but the price is just crazy and they say that the second UII will be released soon and will become irrelevant. And this also leads to the question - is it necessary to delve into sql when there is an ORM in the framework?
Conclusions: what else, besides "php objects, patterns and programming techniques", "Perfect code" need to be read in order to steal big money from customers, to the last penny? (humor)

Answer 1

Here's a Yii book for you. Recipe book - Alexander Makarov" (for a crazy price) rutracker.org/forum/viewtopic.php?t=4538214
nnm-club.me/forum/viewtopic.php?t=701430
download from where you like

Answer 2

On MySQL for professionals, I think this one will be interesting:
MySQL. Optimization produces...

Answer 3

For starters - Koterov and Kostarev PHP5 in the original.

Answer 4

And this also leads to the question - is it necessary to delve into sql when there is an ORM in the framework?

Necessary. The programmer must know what SQL query each ORM expression is converted to.
For the performer, such books (from the bare essentials, in fact, there are more of them): The
Architecture of Enterprise Software Applications by Grady
Booch - Object-Oriented Analysis and Design with Sample Applications even if you don't intend to use it. Something on unix to own it at the level of an advanced user and a novice system administrator. However, if you want money and a good team, then the list of references will increase greatly.

Answer 5

for starters, something on the basics of algorithmization, why something on client-server architectures. You need to have at least some concept in your head of what and how to sculpt.
ps books ala "perfect code" to read too early I think you would have the basics of the basics, and not necessarily php. Read Fowler there ... about design patterns, about weak / strong ties, etc. At the very beginning, you must understand for yourself that writing a project is garbage, but writing it so that in a year its support would not become hell is already difficult. Yet project support is almost always more expensive than initial development.

Answer 6

is it necessary to go deeper into sql when there is an ORM in the framework?

ORM solves 30% of tasks, but what about complex queries to get statistics and other non-trivial things? Without knowing it, you will swim strongly.