PHP 6 and MySQL 5 for Dynamic Web Sites
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £6.60
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide (Visual QuickPro Guides) for an Amazon.co.uk gift card of up to £6.60, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
|
There is a newer edition of this item:
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.
From the Back Cover
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
6 of 6 people found the following review helpful
Format:Paperback
As someone who has developed "shop front" websites since the late 90s, but who never needed to take it a stage further until the last 18 months, I needed a fast, accessible introduction to both PHP and MySQL in order to build a dynamic, search-driven website for my company - fast.
If you know enough HTML/CSS to knock up a brochure-style site, and can plug in a bit of Javascript, get a form to work, and put the whole thing live with a hosting company, this book will take you by the hand and get you right up to speed with the theory and practise of building your first dynamic site, including keeping it secure.
Larry Ullman employs some pretty nifty and subtle techniques in his method of teaching, and I guarantee that you'll find yourself using this as much as a reference as anything else after you've worked through it from cover to cover as advised.
While his method of printing the code in full then going through it piece by piece may irk those who bemoan the waste of paper or feel patronised by such a steady approach, I loved it because you get the chance to type the code in and try and work out what's going on for yourself before having it explained to you. This is a great way of learning and challenges you to understand what you're typing rather than just doing it by rote.
There is no object-oriented programming in here, no real depth to the MySQL/SQL part, and nothing about "mashups", web services etc, and you're definitely going to want to follow on with more learning on these themes (I also have PHP 5 Advanced by the same author, which covers the PHP parts of these topics), but there is an awful lot of learning to do before you can move on to such subjects, and this book packs it all in clearly and usefully.
By the way, PHP 6 is not released as I write this, but there is little difference between PHP 5 and 6 from the point of view of this book - the Unicode chapter is maybe one to skip from that point of view, but it's a small point. Otherwise, if you fall in to the category I outlined earlier, I'd thoroughly recommend this book.
If you know enough HTML/CSS to knock up a brochure-style site, and can plug in a bit of Javascript, get a form to work, and put the whole thing live with a hosting company, this book will take you by the hand and get you right up to speed with the theory and practise of building your first dynamic site, including keeping it secure.
Larry Ullman employs some pretty nifty and subtle techniques in his method of teaching, and I guarantee that you'll find yourself using this as much as a reference as anything else after you've worked through it from cover to cover as advised.
While his method of printing the code in full then going through it piece by piece may irk those who bemoan the waste of paper or feel patronised by such a steady approach, I loved it because you get the chance to type the code in and try and work out what's going on for yourself before having it explained to you. This is a great way of learning and challenges you to understand what you're typing rather than just doing it by rote.
There is no object-oriented programming in here, no real depth to the MySQL/SQL part, and nothing about "mashups", web services etc, and you're definitely going to want to follow on with more learning on these themes (I also have PHP 5 Advanced by the same author, which covers the PHP parts of these topics), but there is an awful lot of learning to do before you can move on to such subjects, and this book packs it all in clearly and usefully.
By the way, PHP 6 is not released as I write this, but there is little difference between PHP 5 and 6 from the point of view of this book - the Unicode chapter is maybe one to skip from that point of view, but it's a small point. Otherwise, if you fall in to the category I outlined earlier, I'd thoroughly recommend this book.
10 of 11 people found the following review helpful
Format:Paperback
Although this book is useful. I found the layout of the code very annoying. The page is split into two columns, with the code inline with the text, thus also flowing in the two columns... this makes for reading the code very difficult. Also Im no expert but I found some of the coding techniques very messy, for example his form validation, which can be done much neater than the example in this book. Another gripe, is he uses stupid variable names, which are totally none descriptive, for instance in clearly written code you might write $query he'll abbreviate it to just $q, also where everyone else would write $result he just puts $r, which if youre learning can be very un-helpful when trying to make sense of the example... coupled with poor layout, this book gives me a headache when trying to learn from it.
p234 example:
7. Add user to the database.
require_once
> ('../mysqli_connect.php');
$q = "INSERT INTO users (first_name,
>last_name, email, pass,
>registration_date) VALUES ('$fn',
>'$ln', '$e', SHA1('$p'), NOW() )";
$r = @mysqli_query ($dbc, $q)
YES! the code really is formatted like that!!! Its terrible. That query should be on one line, not spread over four. And try making sense of it as a beginner, when he uses $r and $q. I know what this all means now, now that ive coded many sql queries. But when I was learning, this book was a nightmare.
I use this book in combination with the Luke Welling, Laura Thomson "PHP and MySQL Web Development" book (which is a far deeper book IMHO - and much better laid out) along with examples on the web to get a better understanding of a particular area of PHP/MySQL I need to learn.
The layout for this book needs reviewing for the next issue - use the full width of the page guys!
p234 example:
7. Add user to the database.
require_once
> ('../mysqli_connect.php');
$q = "INSERT INTO users (first_name,
>last_name, email, pass,
>registration_date) VALUES ('$fn',
>'$ln', '$e', SHA1('$p'), NOW() )";
$r = @mysqli_query ($dbc, $q)
YES! the code really is formatted like that!!! Its terrible. That query should be on one line, not spread over four. And try making sense of it as a beginner, when he uses $r and $q. I know what this all means now, now that ive coded many sql queries. But when I was learning, this book was a nightmare.
I use this book in combination with the Luke Welling, Laura Thomson "PHP and MySQL Web Development" book (which is a far deeper book IMHO - and much better laid out) along with examples on the web to get a better understanding of a particular area of PHP/MySQL I need to learn.
The layout for this book needs reviewing for the next issue - use the full width of the page guys!
2 of 2 people found the following review helpful
Format:Paperback
I can't say this is an excellent book because of some glaring logic errors in the code.
It's a is good as an introduction to PHP/MySQL and there are some meatier recipes towards the end of the book that are useful - forums/shopping cart/registration.
I bought this book to help with writing custom WordPress Plug-ins and to get into Drupal and for that need it fulfilled that itch I had to scratch.
It was easy to follow and informative if you can overlook the silly mistakes.
I think the good point outweigh the negatives.
Primarily I was irritated by the lack of thought that went into validating form input. Notably checking if field is empty then trimming it. So if a user enters a space, then logic is flawed and null data would be written to the database for it's constraints to pick up.
To me there also seemed to be a lack of precision in defining an email regular expression. For a UK email address, you need to allow for more than one 'dot' after the 'at' symbol.
Also the database design for threaded messages in the forum recipe (chapter 15) didn't seem right for me. It used timestamp to order messages in threads. This sequencing logic/database design is flawed for threaded messages if two people respond to different branches of a thread.
I come from a Java/Spring/Grails background and the lack of structure/seperation of concerns of a framework that implements a MVC architecture struck me the most. I didn't like the fact that variables were defined in one template and used in another for example without even passing parameters around so it's hard to tell at a glance what needs to be setup before a script can run.
I think that can be forgiven as I think this book is targeted for a beginner audience.
O-O coverage only extends to as far as showing how to use the new statement. I'm no PHP expert, but I guess this would be a good book to get before venturing into Symphony, Zend, Cake, etc.
I did learn a couple of new things about MySQL along the way too which was an added bonus for me.
Finally the book is classified as for PHP 6, but the Appendix install guide is for PHP 5. Haven't tried to follow these yet, and wouldn't think it hard to make the switch but buyer/reader be warned. Author was in tricky position of writing book before PHP 6 came out. It sounds like Unicode is primary difference.
i18n/l8n coverage in PHP and MySQL were both good. (though I prefer message properties in Java!)
It would have been nice if there was another Apppendice summarizing all the PHP functions or even URL reference to look online for this stuff. I think that holds the book back from being a good quick reference, although the index looks quite thorough.
It's a is good as an introduction to PHP/MySQL and there are some meatier recipes towards the end of the book that are useful - forums/shopping cart/registration.
I bought this book to help with writing custom WordPress Plug-ins and to get into Drupal and for that need it fulfilled that itch I had to scratch.
It was easy to follow and informative if you can overlook the silly mistakes.
I think the good point outweigh the negatives.
Primarily I was irritated by the lack of thought that went into validating form input. Notably checking if field is empty then trimming it. So if a user enters a space, then logic is flawed and null data would be written to the database for it's constraints to pick up.
To me there also seemed to be a lack of precision in defining an email regular expression. For a UK email address, you need to allow for more than one 'dot' after the 'at' symbol.
Also the database design for threaded messages in the forum recipe (chapter 15) didn't seem right for me. It used timestamp to order messages in threads. This sequencing logic/database design is flawed for threaded messages if two people respond to different branches of a thread.
I come from a Java/Spring/Grails background and the lack of structure/seperation of concerns of a framework that implements a MVC architecture struck me the most. I didn't like the fact that variables were defined in one template and used in another for example without even passing parameters around so it's hard to tell at a glance what needs to be setup before a script can run.
I think that can be forgiven as I think this book is targeted for a beginner audience.
O-O coverage only extends to as far as showing how to use the new statement. I'm no PHP expert, but I guess this would be a good book to get before venturing into Symphony, Zend, Cake, etc.
I did learn a couple of new things about MySQL along the way too which was an added bonus for me.
Finally the book is classified as for PHP 6, but the Appendix install guide is for PHP 5. Haven't tried to follow these yet, and wouldn't think it hard to make the switch but buyer/reader be warned. Author was in tricky position of writing book before PHP 6 came out. It sounds like Unicode is primary difference.
i18n/l8n coverage in PHP and MySQL were both good. (though I prefer message properties in Java!)
It would have been nice if there was another Apppendice summarizing all the PHP functions or even URL reference to look online for this stuff. I think that holds the book back from being a good quick reference, although the index looks quite thorough.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Excellent book for the new PHP programmer
I have bought this book and I must say that this is one of the best IT books that I have ever read. Highly recommended and a much better book than "Learning PHP, MySQL, and... Read more
Published 3 months ago by Andy
Great starting point for PHP& MySQL
Excellent starting point for PHP & MySql. Basic knowledge of HTML and CSS is required, but nothing too advanced. Read more
Published 3 months ago by J. L. Hodgkins
Great resource for intermediate php-ers
I was really reluctant to buy such an expensive book when there are so many websites offering free advice and tutorials. Read more
Published 5 months ago by Nicki
Must be better alternatives
Having gone half way through this book I have to say it is really badly laid out. The general layout is 2 slim columns (less than 40 characters) on almost every page and simple... Read more
Published 11 months ago by piddlydiddly
Excellent for PHP Beginners
I tried using some online tutorials to learn php but I found it difficult to find any decent ones that would also give me enough of an understanding, that's why I wanted a resource... Read more
Published 11 months ago by fingersandthumbs
Very Helpful !!
I found this book very helpful. The examples are constructed very well and build on top of each other. Read more
Published 11 months ago by Pingu123
obscure cluttered
the php section is laboured - poorly structured The examples used are cluttered and repeated ad nauseum till you are constantly skipping back n forth - keep it simple. Read more
Published 12 months ago by G. Watson
Very happy
Great condition, as described, book is very useful. It's half the market price.
Maybe wouldn't recommend to a person who doesn't have a background in SQL or PHP, but... Read more
Maybe wouldn't recommend to a person who doesn't have a background in SQL or PHP, but... Read more
Published 12 months ago by K. Mielczarek
Impossible to follow examples.
This book is bad. It is also misleading. PHP 6 doesn't even exist, yet this book has been out for a few years now. Read more
Published 13 months ago by Facebook Answers
First class writing
I don't write many reviews but this book just deserves praise. I originally read a SAMS learn PHP in 24 hours book by Matt Zandstra which left me frustrated and discouraged. Read more
Published 13 months ago by Kevin Thomson
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > MySQL > Introduction
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Databases & the Web
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Languages > PHP
- Books > Computing & Internet > Web Development > Web Design > Website Design
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
