I looking for a book(s) about PHP and MySQL that deals with ratings systems, registering, login, comments, adding articles and so on.
I found Web database applications with PHP and MySQL, (O'Reilly) by Hugh E. Williams and David Lane to be quite good, and covers most of what you mention (it's not so blog-slanted as your post, the app programmed in the book is a wine store). Might be getting a bit long in the tooth by now, though, but it does cover PHP 5 and MySQL 4.1
Edit: if you want to learn frameworks, I'd recommend both Beginning CakePHP: From Novice To Professional by David Golding, and Practical CakePHP Projects, by Kai Chan and John Omokore, both books by Apress. I'd say 'check Beginning PHP and MySQL: From Novice to Professional', but I haven't read that one.
Why not learn symfony a little? Jobeet tutorial is very good. It's an online book.
http://www.symfony-project.org/jobeet/1%5F2/Doctrine/en/
You will learn the best framework also ;)