Build Your Own Database Driven Web Site Using PHP & MySQL (Paperback)

~ Kevin Yank (Author), Yank Kevin (Author)

Editorial Reviews

Product Description

Build Your own Database Driven Web Site Using PHP & MySQL is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database-driven web site using PHP & MySQL.

This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live web-based content management system.

While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL that include:
MySQL syntax MySQL functions MysQL column types PHP functions for working with MySQL

About the Author

Kevin Yank is a world-renowned leader in web development. When not writing best sellers, Kevin is the Technical Director of sitepoint.com and editor of the popular SitePoint Tech Times newsletter.

---

Product Details Paperback: 360 pages Publisher: SitePoint; 4 edition (June 15, 2009) Language: English ISBN-10: 0980576814 ISBN-13: 978-0980576818 Product Dimensions: 8.9 x 6.9 x 1 inches Shipping Weight: 1.8 pounds (View shipping rates and policies) Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews) Amazon.com Sales Rank: #37,832 in Books (See Bestsellers in Books) Popular in these categories: (What's this?) #11 in  Books > Computers & Internet > Web Development > Programming > PHP #11 in  Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL #22 in  Books > Computers & Internet > Databases > Database Design

---

What Do Customers Ultimately Buy After Viewing This Item?

	78% buy the item featured on this page: Build Your Own Database Driven Web Site Using PHP & MySQL 4.0 out of 5 stars (2) $26.37
	10% buy PHP and MySQL Web Development (4th Edition) 4.4 out of 5 stars (210) $32.54
	5% buy PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide 4.5 out of 5 stars (152) $29.69
	4% buy Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites (Animal Guide) 4.7 out of 5 stars (3) $26.40

Explore similar items

---

Tags Customers Associate with This Product  (What's this?) Click on a tag to find related items, discussions, and people. Check the boxes next to the tags you consider relevant or enter your own tags in the field below.  database(1) scripts(1) servers(1) Agree with these tags? Your tags: Add your first tag

Search Products Tagged with   See most popular tags

---

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

---

 

Customer Reviews

2 Reviews 5 star:    (0) 4 star:  (2) 3 star:    (0) 2 star:    (0) 1 star:    (0)           Average Customer Review 4.0 out of 5 stars (2 customer reviews)		Share your thoughts with other customers:
Most Helpful Customer Reviews 4.0 out of 5 stars php and sql book, November 13, 2009 By  Mauricio Quiroga I. Websites "I Love Doing We... (houston, TX USA) - See all my reviews Amazon Verified Purchase This is a good book in an overall point of view. If you want to learn from the ground up without any help from any web editor this is your choice. It is a little difficult for a beginner but the examples in the book are pretty clear and straightforward. What is most interesting about this book is the use of php templates and the coding style that the book wants the reader to learn. The book shows a wide use of php templates. 2 of 4 people found the following review helpful: 4.0 out of 5 stars Requires companion books, but is otherwise very good., September 30, 2009 By  Robert P. Beveridge "xterminal" (Cleveland, OH) - See all my reviews (TOP 50 REVIEWER)    (REAL NAME)       Kevin Yank, Build Your Own Database-Driven Web Site with PHP and MySQL (Sitepoint, 2009) I have just finished my first read through Kevin Yank's Build Your Own Database-Driven Web Site with PHP and MySQL. I can tell you that it will not be my last read through it, by any means. While there are a few places it glosses over and a few rather shocking omissions in the name of simplicity, it was (and I can rarely say this with a computer book) exactly what I was looking for. Using simple, easy-to-understand tutorials, Yank takes you through the development of a very simple website that has a database as its back end. This should not surprise you, given the title of the book. Impressively, it neither manages to talk down to its reader (assuming a complete newb) nor spirals off into overly technical jargon (assuming a MySQL-certified reader). Granted, if you've been a database developer for ten years (that would be me) some of this will be redundant, but it's a good refresher course for basic database concepts and a perfect way to immerse yourself in MySQL if you're coming from a different DBMS. That said, my main problem with the book was Yank's breezy passing by the idea of using the InnoDB engine and letting your code handle foreign key constraints. That's workable (though very, very iffy) for the four-table database Yank builds here, but any real-life (read: complex) solution will quickly get unmanageable; any minor change to the table structure, depending on how many tables it relates to, could require hours of hunting and changing code. As any programmer learns within the first ten minutes of starting his first programming course, that is a recipe for bugs. My other problem with it, though this is far more minor, is that (I think) content management systems like this usually store site settings in the database as well, and Yank doesn't address this at all beyond logins and passwords, choosing to refer the user to learning CSS. I thought CSS was dead, or close to it. I'd have expected that in a book written in 2004, but in 2009? But my inexperience with web apps--I've always been a back-end developer--may be more at fault than Yank's writing, so I'll defer judgment on that to those who actually know what they're doing with this stuff, who will hopefully get round to reviewing the book eventually. In any case, the stuff that's actually here, the parts on data access and getting your data from database to website, are clear as well as being very easy to understand and implement, and that's a rare thing in computer books. Highly recommended, though you'll need other books to cover the places where this is lacking. ****		Ad feedback   Search Customer Reviews Only search this product's reviews

---

Customer Discussions

This product's forum Discussion Replies Latest Post No discussions yet Ask questions, Share opinions, Gain insight Start a new discussion Topic: First post: Receive e-mail when new posts are made Prompts for sign-in   Guidelines Active discussions in related forums Discussion Replies Latest Post textbook Textbooks for Kindle DX? 62 12 hours ago textbook Anyone need psychology testbook- trying to sell a used copy 2 2 days ago textbook textbook scam 72 2 days ago Search Customer Discussions Search all Amazon discussions

The Database community Latest activity 7 hours ago 746 customers have contributed 451 products, 31 lists & guides and more... › Explore the community The Web Development community Latest activity 5 hours ago 1,769 customers have contributed 781 products, 79 lists & guides and more... › Explore the community Related forums database php (2 discussions) textbook (19 discussions) textbooks... web development (6 discussions) Explore more › See all Customer Communities › Your communities

---

Listmania!

MySQL Book List: A list by Ardiel Soeker "Mac Aficionado"   Web technologies: A list by A. Korelc "web slave"   Learn PHP & MySQL: A list by M. Woods Create a Listmania! list

Search Listmania!

---

So You'd Like to...

Learn Programming with PHP/MySQL and CSS/HTML: A guide by Gene Ballard "wolfix"   be a webmaster: A guide by Fuad A Kamal   become an Open Source Web Developer: A guide by Jeff Parker "Jeff Parker" Create a guide

Search Guides

---

Product Information from the Amapedia Community

Beta (What's this?)

Be the first person to add an article about this item at Amapedia.com.

› See featured Amapedia.com articles

---

Look for Similar Items by Category

• Books > Computers & Internet > Databases > Database Design
• Books > Computers & Internet > Databases > SQL
• Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
• Books > Computers & Internet > Graphic Design
• Books > Computers & Internet > Programming > Graphics & Multimedia
• Books > Computers & Internet > Software
• Books > Computers & Internet > Web Development > Programming > PHP
• Books > Reference > Words & Language > Vocabulary

---

Look for Similar Items by Subject

Search Books by subject:
Web graphics & design
Microcomputer Database Management Software
Computers
Computer - Internet
Computers - Data Base Management
Computer Books: Database
Computers / Database Management / General
Computers / Internet / Web Page Design
Computers / Programming / General
Computers / Programming Languages / SQL
Database Management - General
Programming - General
Programming Languages - SQL
Web - Page Design
Design
PHP (Computer program language)
SQL (Computer program language)
Web sites
Computing: Professional & Programming


i.e., each book must be in subject 1 AND subject 2 AND ...

Ad feedback

 

Feedback If you need help or have a question for Customer Service, contact us.  Would you like to update product info or give feedback on images? Is there any other feedback you would like to provide? Your comments can help make our site better for everyone. Please note that we are unable to respond directly to all feedback submitted via this form, but we'll ask you to sign in so we can contact you if needed.

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

› View and edit your browsing history

Get to Know Us Careers Investor Relations Press Releases Amazon and Our Planet Make Money with Us Sell on Amazon Join Associates Self-publish with Us › See all Let Us Help You Shipping Rates & Policies Amazon Prime Returns Help

Canada | China | France | Germany | Japan | United Kingdom  And don't forget: Amazon Windowshop | AmazonWireless | Askville | Audible | DPReview | Endless | IMDb | Shopbop | SoundUnwound | Warehouse Deals by Amazon | Zappos Conditions of Use | Privacy Notice  © 1996-2009, Amazon.com, Inc. or its affiliates

Product Details

• Paperback: 360 pages
• Publisher: SitePoint; 4 edition (June 15, 2009)
• Language: English
• ISBN-10: 0980576814
• ISBN-13: 978-0980576818
• Product Dimensions: 8.9 x 6.9 x 1 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #37,832 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #11 in	Books > Computers & Internet > Web Development > Programming > PHP
  #11 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
  #22 in	Books > Computers & Internet > Databases > Database Design

Customer Reviews

Most Helpful Customer Reviews

4.0 out of 5 stars php and sql book, November 13, 2009

By	Mauricio Quiroga I. Websites "I Love Doing We... (houston, TX USA) - See all my reviews

Amazon Verified Purchase

This is a good book in an overall point of view. If you want to learn from the ground up without any help from any web editor this is your choice. It is a little difficult for a beginner but the examples in the book are pretty clear and straightforward.
What is most interesting about this book is the use of php templates and the coding style that the book wants the reader to learn. The book shows a wide use of php templates.

2 of 4 people found the following review helpful:

4.0 out of 5 stars Requires companion books, but is otherwise very good., September 30, 2009

By	Robert P. Beveridge "xterminal" (Cleveland, OH) - See all my reviews (TOP 50 REVIEWER)    (REAL NAME)

Kevin Yank, Build Your Own Database-Driven Web Site with PHP and MySQL (Sitepoint, 2009)

I have just finished my first read through Kevin Yank's Build Your Own Database-Driven Web Site with PHP and MySQL. I can tell you that it will not be my last read through it, by any means. While there are a few places it glosses over and a few rather shocking omissions in the name of simplicity, it was (and I can rarely say this with a computer book) exactly what I was looking for.

Using simple, easy-to-understand tutorials, Yank takes you through the development of a very simple website that has a database as its back end. This should not surprise you, given the title of the book. Impressively, it neither manages to talk down to its reader (assuming a complete newb) nor spirals off into overly technical jargon (assuming a MySQL-certified reader). Granted, if you've been a database developer for ten years (that would be me) some of this will be redundant, but it's a good refresher course for basic database concepts and a perfect way to immerse yourself in MySQL if you're coming from a different DBMS. That said, my main problem with the book was Yank's breezy passing by the idea of using the InnoDB engine and letting your code handle foreign key constraints. That's workable (though very, very iffy) for the four-table database Yank builds here, but any real-life (read: complex) solution will quickly get unmanageable; any minor change to the table structure, depending on how many tables it relates to, could require hours of hunting and changing code. As any programmer learns within the first ten minutes of starting his first programming course, that is a recipe for bugs.

My other problem with it, though this is far more minor, is that (I think) content management systems like this usually store site settings in the database as well, and Yank doesn't address this at all beyond logins and passwords, choosing to refer the user to learning CSS. I thought CSS was dead, or close to it. I'd have expected that in a book written in 2004, but in 2009? But my inexperience with web apps--I've always been a back-end developer--may be more at fault than Yank's writing, so I'll defer judgment on that to those who actually know what they're doing with this stuff, who will hopefully get round to reviewing the book eventually. In any case, the stuff that's actually here, the parts on data access and getting your data from database to website, are clear as well as being very easy to understand and implement, and that's a rare thing in computer books. Highly recommended, though you'll need other books to cover the places where this is lacking. ****