Start reading PHP and MySQL For Dummies on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
PHP and MySQL For Dummies

PHP and MySQL For Dummies [Kindle Edition]

Janet Valade
3.2 out of 5 stars  See all reviews (8 customer reviews)

Print List Price: £21.99
Kindle Price: £14.20 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £7.79 (35%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £14.20  
Paperback £14.95  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Special Offers and Product Promotions

  • Purchase any Kindle Book sold by and receive £1 credit to try out our Digital Music Store. Here's how (terms and conditions apply)

Customers Who Bought This Item Also Bought

Product Description

Product Description

Here's what Web designers need to know to create dynamic, database-driven Web sites

To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result.

PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited.

  • Explains the easy way to install and set up PHP and MySQL using XAMPP, so it works the same on Linux, Mac, and Windows
  • Shows you how to secure files on a Web host and how to write secure code
  • Packed with useful and understandable code examples for Web site creators who are not professional programmers
  • Fully updated to ensure your code will be compliant based on PHP 5.3 and MySQL 5.1.31
  • Provides clear, accurate code examples

PHP & MySQL For Dummies, 4th Edition provides what you need to know to create sites that get results.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Note: The Kindle edition of this book does not include any CDs or DVDs.

From the Back Cover

Learn to use the tools that bring Web sites to life —it′s easy and fun! Static Web sites don′t cut it anymore. To serve up HTML, CSS,and database–driven pages, you need to know your way around PHP and a MySQL backend database. This book shows you how to build two common applications: a product catalog and a member–only site requiring a username and password. You′ll learn a basic design you can expand however you choose! New to all this? — get acquainted with PHP and MySQL and find out how to install them on Windows®, Mac®, or Linux® A perfect partnership — see how the language and database work together to produce dynamic Web pages with less hassle MySQL moving and storage — store data in your database and display it on your Web pages Up to code — learn to build PHP scripts and program pieces with code that meets the latest standards The sum of the parts — organize all the parts of your application, ensure security, and complete your documentation Visit the companion Web site at to find all the code examples used in the book Open the book and find: How to keep up with PHP and MySQL updates What′s different in the newest versions Pros and cons of Web hosting companies How to back up and restore data in your database Error messages and what they mean Why you must plan your database application Advice on what offers value to your users Ten "gotchas" that will mess up your code

Product details

  • Format: Kindle Edition
  • File Size: 4490 KB
  • Print Length: 457 pages
  • Page Numbers Source ISBN: 0470527587
  • Publisher: For Dummies; 4 edition (10 Dec 2009)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B0030V0PQU
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: #335,067 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.2 out of 5 stars
3.2 out of 5 stars
Most Helpful Customer Reviews
8 of 9 people found the following review helpful
1.0 out of 5 stars Bad practice 19 Dec 2010
By Karim
Format:Kindle Edition
I was bought this as a joke "secret santa" present by my client. I am already a PHP and MySQL programmer and am interested to see how Janet Valade introduces beginners to database design and programming.

I was appauled to read the database schema on page 20. This is very bad database design indeed and certainly NOT what new programmers should be doing.

I can only conclude that Janet does not understand relational database design.

For example, Janet suggests a primary key on the PetType table named PetType which is a character field containing the Name of the pet category. This is very bad practise because:

1. Primary keys should NEVER be name of the data content because you may need to change the name in the future and you NEVER amend a primary key field.

2. Primary keys should be integer fields so that the database can automatically allocate the next number in sequence when a new record is added.

3. The database engine works more efficiently if the primary key is an integer.

4. It is more consistent to use the same field type and naming convention for all primary keys in your database. e.g. Integer primary key fields: petTypeID, petID and petColorID

Another bad example is the schema for the PetColor table:

1. There is a composite primary key on 2 character fields. Is is very bad practice to have composite primary keys (see 1,2,3 and 4 above!)

2. There should be a foreign key field on table Pet named petColorID that references the primary key petColorID on the PetColor table. There SHOULD NOT be a field petName on the PetColor table as this is a look-up table.
Read more ›
Was this review helpful to you?
1 of 1 people found the following review helpful
2.0 out of 5 stars For dummies? Not! 11 Aug 2013
Format:Paperback|Verified Purchase
I chose this as I have not used PHP except for pre-made scripts, and wanted to learn how to incorporate PHP and MySQL myself for custom projects. Unfortunately, on the introduction Janet says she's assuming knowledge of PHP and writing scripts. For Dummies? FAIL.

The book uses 2 examples: a simple online shop for a Pet Store; and a Membership Site. These examples are followed through the book until almost the final chapter where instructions on how to use the PHP and MySQL in a website are shown - but at this, possibly most important step - she refers to the Membership Site as the Pet Store customers database. This new nomenclature made me stop and go back and re-read and stop, and go back and re-read again until I realised this was actually the same thing.

There are literally chapters devoted to how to use a database, how to execute various queries on an SQL database. The instructions on how to actually use the wretched things in a web building environment are one chapter and rushed through.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
I was fortunate enough to pick this book up early on when trying to learn PHP and MySQL. It simply and clearly guides you in to this deep and complex subject teaching you everything you need to know to get started. If your tempted to learn website development I strongly encourage you to get this book, especially if you have no previous experience. Once you've gone through this book you'll def be wanting to move up to other more complex literature, but the areas covered here will give you a great foundation to build upon.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars good book to learn from 29 April 2014
Format:Paperback|Verified Purchase
This is a good book to learn from,i found this book easy to understand .The book was sent out very fast,and I am very happy with my order .
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category