Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Kindle Price: £17.04

Save £4.95 (23%)

includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

PHP and MySQL For Dummies by [Valade, Janet]
Kindle App Ad

PHP and MySQL For Dummies Kindle Edition

2.7 out of 5 stars 19 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
£17.04

Length: 457 pages Enhanced Typesetting: Enabled Page Flip: Enabled

Kindle Books from 99p
Load up your Kindle library before your next holiday -- browse over 500 Kindle Books on sale from 99p until 31 August, 2016. Shop now

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.


Product details

  • Format: Kindle Edition
  • File Size: 4499 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:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Enabled
  • Average Customer Review: 2.7 out of 5 stars 19 customer reviews
  • Amazon Bestsellers Rank: #587,868 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?

Customer Reviews

2.7 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
I am new to PHP and have learned other things before using for dummies books and found them very good, however i was extremely disappointed. I found this book boring and irritating. After about 6 hours of reading i was thinking 'when am i going to be set a task to practice what i have just learned' well that time never come. If you think you can learn a just by constant reading with no task to follow and nothing practice then this book would be ideal for you.

When my friend ( who has been using php for nearly 7 years) looked at this book he said he couldn't believe how poor the script was inside the book and told me to ignore some of it altogether.

I would never recommend anyone ever buying this book, and i am going to find another book that will teach me PHP preferably not written by Janet Valade
Comment 21 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I am usually a fan of the for dummies series but this book disappointed me. I couldn't beleive how bored and annoyed I was when trying to learn something from it. Trying to remember some of the stuff was so hard because there was no practice to reinforce it into my brain. Very disappointed.
Comment 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I know No HTML or PHP coding, and i mean the max i know is < b > etc etc.

I have started an online business and this book gave me the information I needed for creating dynamic pages, connecting to databases and so on and so forth. All the examples in the book can be downloaded from [...] which i found very useful, each file she creates you are allowed to use on your own without having to add any information apart from your database credentials.

The book starts with the very basics, telling you how print simple statements like "it is raining" using the echo" " functions. It then progresses with using if statements and conditionals, functions and other parts of the PHP code which are useful. The book then goes into in depth information on how to build a MYSQL database with PHP MYSQL queries, it tells you how to DROP, CREATE, UPDATE, DELETE etc which i personally found useful

The book then carries on and shows a live running example on what PHP applications can be used for, giving a useful example of a online catalogue and a Members only Area which is what i use. The code can be edited to your needs, for example i added a user level to the database and extra code to the top of every page that disallowed entry depending on the user entry (if you want that code, please email me at dominic.langmead@college-downloads.co.uk and i will send it to you).

The online catalgoue is also very useful, i added it to my site then removed it for the paypal alternative. Janet Explains what she is doing in her coding examples with #number which is explained on the pages after, very useful i must say.
Read more ›
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

click to open popover