How to learn PHP/mySQL the right way?

Question

PHP

I myself am learning PHP / Mysql programming, and I want to ask the habra community for advice.
Here is a list of references that I use for individual study:
PHP 5 for dummies (Janet Valeid)
PHP in the original (Dmitry Koterov)
PHP useful tricks (A.Orlov)
PHP/MySQL for beginners (Andy Harris)
MySQL complete guide. Second edition (Paul Dubois) The
question is: Did I choose the right books?
Sometimes I read a book and it seems that the author wrote just to sell the book and make a profit.
Of course, an experienced programmer understands everything that is written in the book, but where exactly is the book in which this or that site is clearly explained, how it works, through which operators and what works.
After all, it's easier to understand with examples than to read a long text about how well a function works in one example and that's it.
Please advise.
Does anyone have a link to interactive video courses?

Answer 1

from the books of the listed books, I would single out Koterov. very good book if you are a beginner. it pretty well and simply describes what happens on the network and how it works. In general, a good basis for further development is given.
I would add to the list of books "development of web applications with php and mysql" by Laura Thomson and Luke Welling. these people were involved in the development of mysql. so they know a lot :) and throughout the book a web store is created. so everything is built on examples :)
good luck with your competition.)

Answer 2

I highly recommend getjump.github.io/en-php-the-right-way I will
quote, so as not to retell in my own words:

There is a lot of outdated information on the Internet, which leads to confusion, the spread of wrong solutions and writing bad code for beginner PHP developers. PHP: The Right Way - An easy-to-read guide for getting up to speed on how to effectively use PHP

Answer 3

Once you get to OOP in PHP5, I suggest you read "PHP 5 for Professionals, Ed Lecky-Thompson, Hyao Eyde-Goodman, Alec Kove, Steven D. Nowitzki, Professional PHP 5". In my opinion, the most normal book about PHP that I have seen :)
And about how to learn correctly ... I think you need a lot of practice, do your ideas, maybe show them to other more experienced developers who have time to talk with you :)

Answer 4

not really for beginners but in the future I advise you to read “Matt Zandstra / Matt Zandstra - PHP Objects, Patterns, and Practice / PHP. Objects, Patterns and Programming Techniques"

Answer 5

From the very beginning, install XAMPP or Denver (or rather a virtual machine and Linux / Unix, it will be very useful in the future), and D. Koterov, no doubt, as far as I remember, the Denver installation process is described in it. As soon as you execute your first echo 'Hello world', master the general syntax (loops, functions, variables, include) take any engine of something, I once picked up punbb 2.2.x, the forum engine - this helped to understand functional programming plus learn to make clean queries to the database, that is, it became a logical continuation of the study of mysql - to make queries, put indexes, joins, etc. to begin with, you can set the task - change the appearance of the main page of the forum, move the “login” block to the main one.
As soon as you feel that you are like a fish in water in this engine, you can take the framework and pick it up to the ground in the same way. I once took Codeigniter - with the help of it I learned a little about OOP, routing, ORM, MVC and then HMVC, caching.

Answer 6

Good video tutorials blog.themeforest.net/screencasts/diving-into-php-video-series/

Answer 7

I taught php.net off-mana
Well, then I read Koterov and OOP in PHP, unfortunately I don’t remember the author.
In general, it is more convenient for someone to teach. For me it is more efficient to read off-line manuals than books. With books, I reinforce the material received, unless of course it is required :)

Answer 8

In addition to the above, I highly recommend the book “PHP. Reference" ("PHP in a Nutshell" in the original) Paul Hudson (Paul Hudson). A very clear and helpful book. Despite the name, this is more of a textbook than a reference book.
And a slightly more complex but very useful book, Advanced PHP Programming by George Schlossnagle. This is certainly not for a beginner, but there are different sections - some can and should be read by a novice programmer.
In general, you can learn only on practical tasks - let’s make a simple, but really working site on some topic that interests you, and there, along the way, tasks and questions will arise that will have to be solved and learn along the way.
Well, one more piece of advice - it may be banal, but do not neglect the php.net site - it is better to find out how this or that function works there, because the books can be outdated and with typos, but here is actually the original source. Install "Denver" and test examples of functions in it. The site will not replace books, but will be a good addition.

Answer 9

The best way is to do something. When questions arise, you seek answers to them. Books alone are of little use.
1) Do a normal useful project (at least something for yourself)
2) A question arose, we are looking for an answer to it, thereby increasing our experience
3) Read various articles / forums on PHP and MySQL. (on Habré such people slip through)
4) always have php / mysql mana on hand (it’s not possible to know everything)

Answer 10

I once started with PHP in the original (Dmitry Koterov)
very well stated for beginners

Answer 11

I used to buy books on the web myself. Year in 2000. Believe my experience, all this is nonsense. The only books left on the desktop are HTML and CSS manuals and the Apache 2 user's bible. I still look sometimes. Although what is written in them is already seriously (but not critically) outdated. There are a couple of books that have not lost their relevance, in particular the MySQL Language Reference and Regular Expressions .
My only advice is practice. We set a problem and solve it. I strongly recommend not to use ready-made platforms like Denver, etc. at the initial stage. Must have experience in configuration. The best source is the official language documentation. Fortunately, there are many different examples on php.net. There are fewer examples on MySQL. But there are a lot of forums where you can ask a question and get a good answer.

Answer 12

I use courses "Specialist"
new-rutor.org/torrent/154641/specialist-videokursy...
there are all the answers to your questions...
Specialist - Video courses on Internet technologies:
- Web,
- HTML,
- CSS,
- PHP,
- JavaScript,
- AJAX
if the antivirus does not let you go to (new-rutor.org) then visit ex.ua, you can download the material there too ...
a very useful thing, although an old version, by the
way, do not configure Apache like in the first video it is written, there is some kind of error, or something has changed in the settings over time ..
good luck ..