Buy Used
£0.01
+ £2.80 UK delivery
Used: Very Good | Details
Sold by SNaylerBooks
Condition: Used: Very Good
Comment: Orders shipped daily from the UK. Professional seller.
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 – 24 Nov 2006

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
Paperback
"Please retry"
£18.47 £0.01

There is a newer edition of this item:


Top Deals in Books
See the latest top deals in Books. Shop now
click to open popover

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

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



Top Deals in Books
See the latest top deals in Books. Shop now

Product details

  • Paperback: 456 pages
  • Publisher: John Wiley & Sons; 3rd Edition edition (24 Nov. 2006)
  • Language: English
  • ISBN-10: 0470096004
  • ISBN-13: 978-0470096000
  • Product Dimensions: 18.8 x 2.4 x 23.5 cm
  • Average Customer Review: 2.7 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Bestsellers Rank: 931,495 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Build an online catalog and a members–only site

Everything you need to know to create a dynamic PHP and MySQL Web site!

Been thinking of creating a high–quality interactive Web site? This book is just what you need to get started! Here′s the fun and easy way® to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.

Discover how to

  • Plan and implement a Web database application
  • Design and build a MySQL 5 database
  • Build dynamic HTML forms
  • Create scripts that store, retrieve, and update database information
  • Display database information in a Web page

About the Author

Janet Valade is the author of PHP 5 For Dummies, PHP & MySQL Everyday Apps For Dummies, and PHP & MySQL: Your visual blueprint for creating dynamic, database–driven Web sites, as well as the author of first and second editions of this book. In addition, Janet is the author of Spring into Linux and a coauthor of Mastering Visually Dreamweaver 8 and Flash 8.
Janet has twenty years of experience in the computing field. Most recently, she worked as a Web designer and programmer in an engineering firm for four years. Before that, Janet worked for thirteen years in a university environment, where she was a systems analyst. During her tenure, she supervised the installation and operation of computing resources, designed and developed a data archive, supported faculty and students in their computer usage, wrote numerous technical papers, and developed and presented seminars on a variety of technology topics.
To keep in touch, see janet.valade.com.


What Other Items Do Customers Buy After Viewing This Item?

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: 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 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: 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



Feedback