Web Database Applications with PHP, and MySQL: Your PHP Launchpad Station

July 21, 2009 at 7:02 am 12 comments

Hello all,

Today we would like to preset to you another great O’reilly book that we deep very valuable for beginners willing to kick start their career in PHP/MySQL.

The book is called Web Database Applications with PHP, and MySQL by Hugh E. Williams, David Lane. (Buy it on Amazon)

As the title clearly indicates, this book is all about building websites powered by database applications. The book uses PHP and MySQL, two open source technologies the are often combined to develop web applications, for a scripting language and a database technology respectively, offering a fine mixture of theoretical and practical information on creating web database applications and detailed information on designing relational databases.

Since E-commerce is one of the most popular applications on the web and the development of such an engine employees a great many skills in terms of programming and database design, you will definitely want to get your hands on this book and use it as your personal launchpad into your PHP career since it will teach you both the concepts, planning and design process as well as some hands-on implementation.

Although familiarity with programming and computers is assumed but other than that, not much else is assumed. The authors do an excellent job of explaining some of the fundamental concepts underlying database driven websites, including important elements such as security, multiple users, managing inventory users, and multiple pricing. All problems in the book are addressed with a straight code listing, followed by text that explains what’s happening in the preceding steps.

With about 13 chapters and 5 appendices spanning 550 pages, the authors start out with an introduction to database applications and the web, continuing with an intro to PHP and MySQL, covering the main concepts behind web technologies and ending with the sample wine store application mentioned above. The main concepts discussed are querying databases, writing to databases, validations on the server and client, session management, user authentication and security. The appendices handle installation, modeling and designing relational databases, managing sessions in the database tier, etc.

Overall, the selection of topics is perfect for Intermediate programmers and the explanations are very detailed yet simple. This is probably one of the reasons this book is so popular. I have thoroughly enjoyed using this book and I am not surprised to see such a high quality book from this publisher. I am not familiar with the authors but I am going to keep an eye open in the future for other books by them.

All this is done in simple terms without too much jargon. To top it all off, a tutorial style approach is taken to illustrate how all these concepts come together. The tutorial is on building an online retail site that sells wines, the lovely Hugh and Dave’s Online Wines, a complete (but fictional) online retail site that allows users to browse, search a database, add items to a shopping cart, manage their membership, and purchase wines. Using this site as an example, the book shows you how to implement searching and browsing, store user data, validate user input, manage transactions, and maintain security. If you want to build small to medium-scale web database applications that can run on modest hardware and process more than a million hits a day from users (Not bad, hu?…), this book will show you how.

Programming veterans will want more than this book offers (although they’ll probably find themselves thinking ‘Gee, I wish I’d had this when I began learning PHP’), but newbies will find ‘Web Database Applications with PHP and MySQL’ to be an excellent launch pad for their future endeavors. And veterans who are responsible for teaching PHP to their subordinates couldn’t wish for a better instructional aid

Enjoy creating your own database driven website!


Entry filed under: Books. Tags: , , , , .

Beginning MySQL: Not just for the beginner Professional PHP6: professional to its max

12 Comments Add your own

  • 1. Jack  |  July 21, 2009 at 11:10 am

    Can this book help me to develop drupal?

    • 2. drupalmeister  |  July 28, 2009 at 7:20 am

      This book is not a Drupal book per se, but it sure will help you understand the language powering Drupal.

  • 3. buttyfly  |  July 21, 2009 at 2:42 pm

    What version of PHP is covered in the book?

    • 4. drupalmeister  |  July 28, 2009 at 7:22 am

      I wish you would take a look at the cover. It says PHP5.

  • 5. cram23094  |  July 22, 2009 at 5:26 pm

    Is this book better than the Wrox book you reviews a while ago?

    • 6. drupalmeister  |  July 28, 2009 at 7:20 am

      It’s not better or worse, it is just different. This book focuses on web database applications and has a different approach.

  • 7. ber2  |  July 23, 2009 at 4:14 pm

    i from venezual, i want book but i no book store when have book here. help pleez

  • 8. qualfia  |  July 24, 2009 at 7:51 pm

    how can i get the book for cheap?

    • 9. drupalmeister  |  July 28, 2009 at 7:22 am

      Go to Amazon.com. There you should be able to find some nice deals.

  • 10. emmzee  |  July 26, 2009 at 3:19 pm

    When will the php6 edition be available?

  • 11. vladimir24  |  July 27, 2009 at 12:16 pm

    is this book covering module development?

    • 12. drupalmeister  |  July 28, 2009 at 7:21 am

      As I have said, this is not a Drupal book, but rather a book about the language behind it: PHP and MySQL.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

RSS Drupal News

  • How to get your news and annoucement post promoted to the front page of Drupal.org July 13, 2008
    Use these guidelines when deciding whether a post should be promoted to the front page.Guidelines for promoting and demoting content to the front pageFront Page Schedule
  • Private Messages for Drupal 8 May 5, 2018
    After a year of testing and bug fixes, Private Message 8.x-1.0 has been released.  Its a full-fledged AJAX based private messaging system, built with Drupal APIs and fully customizable.  Version 8.x-2.x is in development and will have Node.js integration, integration with the Message Stack module, browser notifications, Facebook-style any-page chats, and Vie […]
  • SiteGround Hosting missing Drush April 6, 2018
    Just a note to other Drupalers.  I have been looking for a new Drupal-centric host and have heard good things about SiteGround.  They advertise support for Drush, which would make critical core updates, like the one we had last week, much quicker and easier. HOWEVER, please note that their latest version of Drush is 8.0 dev., which is horribly out of date an […]
  • New module Search Index significantly reduces the dataset table size March 24, 2018
    Hello everyone! I am not sure if this forum is the right place to make  an announcement about new module, but let me try, since I am already typing here ;) There are number of modules which try to output search results restricting per content types, but they all deal with already generated search index, which sometimes can grow really large.  Please find a l […]
  • Predictions for 2018 February 11, 2018
    We have had a tradition since 2005. Every new year we have a posting on the predictions for the year ahead for our beloved open source CMS and community. Sometimes this posting went up in december, sometimes in January. But never in February. Time to start a new tradition, predict the year ahead from February on :-) Leave a comment if you do think that blogg […]
  • Wysiwyg is coming to the forums October 19, 2017
    Hi folks, We are going to be implementing the CK Editor wysiwyg for the forums here in the near future. This forum post is just to let folks know this is happening ahead of time. If you would like to see an example of the wysiwyg is action you can head over to https://www.drupal.org/node/2804241/discuss Once implemented, if you run into issues you can reques […]
  • drupalwebs.com for sale October 3, 2017
    I bought the domain drupalwebs.com a while back and never used it. Any reasonable offers considered. marcus(at)brightonart.co.uk
  • How to Uninstall/Disable Module in Drupal 8? September 7, 2017
    Check this thread -> https://sachinsuryavanshi.wordpress.com/2017/09/07/how-to-uninstalldisable-module-in-drupal-8/ Cheers, SachinDrupal version: Drupal 8.x
  • Registration for DrupalCon Vienna is open June 5, 2017
    We're shouting it from the rooftops today. DrupalCon Vienna registration is now open. Early bird pricing is happening now until 4 August, but for the next two weeks only you can also get a conference t-shirt if you register and are a Drupal Association Individual Member. You can also receive a t-shirt if you sign up to be a sprint mentor, or you volunte […]
  • Nikki Stevens: Winner of the 2017 Aaron Winborn Award May 9, 2017
    The Aaron Winborn Award was created in 2015 after the loss of one of one of the Drupal community’s most prominent members, Aaron Winborn, to Amyotrophic Lateral Sclerosis (also referred to as Lou Gehrig's Disease in the US and Motor Neuron Disease in the UK). Aaron’s commitment to the Drupal project and community made him the epitome of our unofficial m […]

%d bloggers like this: