PhpRiot
Browse Articles
Ajax (4), APC (1), CAPTCHA (1), CSS (3), Debugging (1), File Upload (1), Google (3), Google Maps (2), JavaScript (11), JSON (2), MVC (1), MySQL (6), onbeforeunload (1), OOP (1), PHP (27), PhpDoc (1), PostgreSQL (6), Prototype (10), Reflection (1), RFC 1867 (1), Robots (1), Scriptaculous (1), SEO (1), Sessions (1), SimpleXML (1), Smarty (5), SOAP (1), SPL (1), Templates (2), W3C (1), XHTML (1), Zend Framework (1), Zend_Search_Lucene (1)

Buy My Book
Practical Web 2.0 Applications with PHP

Practical Web 2.0 Applications with PHP

Want to assert yourself as a cutting–edge PHP web developer? Take a practical approach...

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional)

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional)
  • Media: Book (Paperback, 952 pages)
  • ISBN: 1590595521
  • Publisher: Apress
  • Release Date: Jan 23, 2006

Buy from Amazon Buy from Amazon


Product Description

  • Written for the budding web developer searching for a powerful, low-cost solution for building flexible, dynamic web sites.
  • Essentially three books in one: provides thorough introductions to the PHP language and the MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
  • Provides over 500 code examples, including real-world tasks such as creating an auto-login feature, sending HTML-formatted e-mail, testing password guessability, and uploading files via a web interface.
  • Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

From the Back Cover

Interested in becoming a master of the PHP language and MySQL database but don't know where to begin? This best-selling book ranks among the most thorough and practical guides in print, covering all of the key concepts and features, and showing you how to effectively integrate PHP and MySQL to build powerful web sites.

The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.

Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5&emdash;specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.

What You Will Learn from This Book

  • Install and configure Apache, PHP, and MySQL on both Windows and Linux.
  • Accept and process information submitted via HTML forms.
  • Authenticate users and track user preferences and data using PHP's session-handling capabilities.
  • Process web-based file uploads using the HTTP_Upload PEAR package.
  • Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.
  • Use both command-line and graphical MySQL clients to effectively manage your data.
  • Secure the MySQL server, creating roles and restricting access even at very granular levels.
  • Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.

Rating: 5/5 Great book on PHP and MySQL

I have recently bought this book and have to say it is execellent, it does help if you have a little prior knowledge as some new readers could find it a little difficult to understand. But if you have an interest in PHP and MySQL it is a great book to get your hands on. I highly recommend it.
Submitted 14 May 2008

Rating: 2/5 Not for the novice!

Despite the title, this book is not for the novice. Even the introductory first 100 pages or so assume that you are above a novice level. The examples lead to more questions (for me, the novice) than they answer.

Having said that, this book has a tremendous amount of information in it and, as other reviews mention, it will work well as a reference. Now, I hope to find a true beginning PHP book to provide the basis to use this book!

Submitted 6 May 2008

Rating: 5/5 This was my first PHP/MySQL book

I purchased this book because I needed to use PHP and MySQL for a project at work. I never had any exposure to either before reading this book. By using this book and the w3schools website I was able to successful build a meager database and have a fully functioning php front end. It was very pleasing to see the project come to fruition and I have this book to thank for that. I used it mainly as a reference book. For example, I knew exactly what I wanted to do so I would search this book for an example of that and adapt the code to my situation. I didn't use this book to "learn PHP." I think you need to have a project to do in order to best use this book.
Submitted 2 May 2008

Rating: 5/5 The Ultimate Bible for Web Programming!

First off let me address a common review, that the book is too advanced for beginners. Plain and simple, it is not beginning programming, it's beginning PHP and MySQL. To even know what these applications are, you should have some programming background anyhow.

That said, even if you don't have any prior experience, the book does a great job of introducing you to the key concepts, and is flooded with examples, the best way to learn.

This book has become my programming bible, but it maintains a great balance. It has everything you could ever wish to look up later (and you will), but still follows a nice rhetoric and flow for someone looking for a tutorial-esque book. Some of the examples he wrote are key frameworks in my website! I actually used his book as my main source to build my website from the ground up. Even if it doesn't have something, it arms you with enough knowledge to know the right questions to ask. Which leads me to the greatest part of all... he backs his product!

I battled a bug for over 4 months that I was unable to solve from searching anywhere on the Internet. It's then I remembered that he listed his E-Mail address in the book and challenged readers to contact him if they needed help! Not expecting a response, I was shocked when he speedily replied that day, and solved my problem finally to boot!

To sum up: Not necessarily for beginners period, great for programmers beginning PHP and MySQL, the only book you should have to buy, and a very supportive author.
Submitted 11 Apr 2008

Rating: 4/5 Great amount of depth, not so much context

This is a great reference book. It delves very deep into both PHP and MySQL. One thing I found lacking was some context. Practical examples so that I can see what I've learned being implemented in real world applications.

Other books that do not get so deep often include these types of exercises and I find them extremely helpful to gain a true understanding of the material.

In my opinion, if this book included excerises, case studies, etc.. it would be perfect.
Submitted 6 Mar 2008

You May Also Like ...




PHP 5 Recipes: A Problem-Solution Approach


CSS Mastery: Advanced Web Standards Solutions