PHP and MySQL For Dummies and over 2 million other books are available for Amazon Kindle . Learn more
£17.59
  • RRP: £21.99
  • You Save: £4.40 (20%)
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Trade in your item
Get a £2.79
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

PHP and MySQL For Dummies Paperback – 4 Dec 2009


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£17.59
£7.92 £5.79

Frequently Bought Together

PHP and MySQL For Dummies + HTML, XHTML and CSS For Dummies
Price For Both: £35.18

Buy the selected items together


Trade In this Item for up to £2.79
Trade in PHP and MySQL For Dummies for an Amazon Gift Card of up to £2.79, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 456 pages
  • Publisher: John Wiley & Sons; 4th Edition edition (4 Dec 2009)
  • Language: English
  • ISBN-10: 0470527587
  • ISBN-13: 978-0470527580
  • Product Dimensions: 18.8 x 2.5 x 23.4 cm
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: 57,813 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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 www.dummies.com/go/php&mysqlfd4e 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

About the Author

Janet Valade is a technical writer, Web designer/programmer, and systems analyst. She has designed and developed data archives, supervised computer resource operations, and conducted seminars and workshops. She has written all previous editions of PHP & MySQL For Dummies.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

3.2 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By Jonathan Tarrant on 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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By Karim on 19 Dec 2010
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 ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Potty Monster on 13 Oct 2010
Format: Paperback
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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
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? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again


Feedback