- 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
PHP and MySQL For Dummies Paperback – 24 Nov 2006
Customers Who Viewed This Item Also Viewed
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.
To get the free app, enter your mobile phone number.
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?
Top Customer Reviews
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
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 ›
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.
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 firstname.lastname@example.org 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 ›
Most Recent Customer Reviews
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 .Published on 29 April 2014 by Peter Reid
I had previously borrowed this from our local library so I knew I wanted a copy to keep.
I always turn to the 'dummies' series when learning something new.
The book is useful but it takes me 20 days to receive the book, poor logistic! I bought it on 12th July but received it on 1 August.Published on 13 Aug. 2012 by zhenxing Huang
Being quite new to php this book is written in a way that even the dumbest (me) person can follow and understand. Read morePublished on 17 July 2011 by Marc Greco
This book is pretty poorly written, lowering the bar for the usually good 'For Dummies' series.
The information is presented terribly, in such a way that makes it... Read more
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... Read morePublished on 13 Oct. 2010 by Potty Monster
This book is good for any skill level, it is very thorough with the explanation and easy to follow. Plus the book is full of tips and tricks that even a well versed web designer... Read morePublished on 5 Jun. 2010 by Mr. Maj Le May
This book was very interesting to read. At the time I read this book I had only knowledge of HTML and was interested in learning PHP. Read morePublished on 27 April 2008 by B S
Look for similar items by category
- Books > Computing & Internet > Databases > Applications
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > New to Computing
- Books > Computing & Internet > Programming > Introduction to Programming
- Books > Computing & Internet > Programming > Languages
- Books > Computing & Internet > Web Development > Web Design > Applications
- Books > Computing & Internet > Web Development > Web Design > Web Graphics & Animation
- Books > Computing & Internet > Web Development > Web Design > Website Design