Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Build Your Own Database Driven Website Using PHP and MySQL [Paperback]

Kevin Yank
3.8 out of 5 stars  See all reviews (4 customer reviews)
List Price: CDN$ 57.95
Price: CDN$ 36.51 & FREE Shipping. Details
You Save: CDN$ 21.44 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Paperback CDN $36.51  
Save Up to 90% on Textbooks
Hit the books in Amazon.ca's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
There is a newer edition of this item:
PHP & MySQL: Novice to Ninja PHP & MySQL: Novice to Ninja 3.0 out of 5 stars (1)
CDN$ 25.17
In Stock.
Join Amazon Student in Canada


Book Description

Oct. 11 2004 0975240218 978-0975240212 Third Edition

Build Your Own Database-Driven Website Using PHP & MySQL is a practical guide for first-time users of PHP & MySQL that teaches readers by creating a fully working Content Management System, Shopping Cart and other real-world applications. There has been a marked increase in the adoption of PHP, most notably in the beginning to intermediate levels. PHP now boasts over 30% of the server side scripting market (Source: php.weblogs.com).The previous edition sold over 17,000 copies exclusively through Sitepoint.com alone. With the release of PHP 5, SitePoint have updated this bestseller to reflect best practice web development using PHP 5 and MySQL 4.The 3rd Edition includes more code examples and also a new bonus chapter on structured PHP Programming which introduces techniques for organizing real world PHP applications to avoid code duplication and ensure code is manageable and maintainable. The chapter introduces features like include files, user-defined function libraries and constants, which are combined to produce a fully functional access control system suitable for use on any PHP Website.


Product Details


Product Description

About the Author

Kevin Yank is a world-renowned leader in web development. When not writing best sellers, Kevin is the Technical Director of sitepoint.com and editor of the popular SitePoint Tech Times newsletter.



Kevin's Author credits include: Build Your Own Database Driven Website Using PHP & MySQL (SitePoint and Simply JavaScript (SitePoint).


Inside This Book (Learn More)
Browse and search another edition of this book.
First Sentence
"Content is King." Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

3.8 out of 5 stars
3.8 out of 5 stars
Most helpful customer reviews
4.0 out of 5 stars Great introduction to PHP and MySQL Jan. 10 2007
By Monk
Format:Paperback|Verified Purchase
I'd worked with some PHP code in the past but I hadn't tied it into a database and was missing that part. However if you haven't touched PHP before this book makes it easy.

The author does a good job of maintaining focus throughout. He walks that fine line between giving out too much information and overwhelming the reader and not enough information which would leave the reader confused. He also tends to ensure the reader understands what the code is doing at a core level, it' not just about syntax. Once you've completed the book you'll have just enough understanding of programming ideals to help you better understand what PHP is about.

When it comes to syntax it's a pretty good reference as well covering most of the key concepts. The reason I didn't give it 5 stars is the last few chapters seem to lack the focus the first 8 or so chapters have. It's as though these chapters are meant as catch alls, a place to put all the ideas the author had but couldn't find how to integrate it into the earlier narrative.

The book also has a great companion website at sitepoint.com with very active forums full or helpful PHP veterans that are only too happy to help with any question. Overall I've been very happy with this book and have bought more books from this publisher (sitepoint) on other topics based on the experience I had with this book.

Tip: to skip the part about installing PHP and MySQL download the Xampp service, you'll be glad you did. (just google xampp)
Was this review helpful to you?
5.0 out of 5 stars This Tutorial WORKS March 3 2004
Format:Paperback
This book is the first tutorial that actually GOT me there. I was able to set up my G3 266 running OS X (that's right kids, 10.2.8) and get Apache set up right, MySQL installed, tested and working securely and PHP connected up. When I got my first test page working and pulled my first record up, I came to the realization that the instructions in the book worked. Exactly right. First time. Well-written, well-formatted and CLEAR. The Mac section had everything I needed. When I began doing the exercises, I began to dread typing in all the code - then I finally keyed on the CODE ARCHIVE!!!! No CDs to screw around with - just go to the site, punch in some numbers and BINGO, complete set of files, ready to use. Gotta love that. I'm confident now, having finally gotten over the 'hump' of setting up my system and UNDERSTANDING what I was doing, that I'll be able to build database-driven sites with good insight.
I strongly recommend this title.
Was this review helpful to you?
5.0 out of 5 stars Marja, Read this July 8 2004
Format:Paperback
If Marja (from Amsterdam) knew any thing about PHP or programming for that matter he or she would know that it is not nessecary to declare variables before calling them in PHP! Kevin's book is auwsome; I learned so much from it, infact I couldn't have built my last ten sites with out it.
Was this review helpful to you?
0 of 3 people found the following review helpful
By Marja
Format:Paperback
Thank god the 1st 4 chapters of this book are free. As I need to build a website using mysql & php, I thought this book would be exactly what I needed. I already know sql & html and only needed to know php and how to connect the three. Unfortunately none of the code in the book actually works. Having programmed before I know you cannot call variables without declaring them first (quite a stupid mistake for someone who calls hiself a glorious leader). changing a method from get to post can't really be done that way either!!!
I would have expected Kevin to have at least checked his code before publising. All in all quite a useless book, specially for a beginner. Not worth 1 star but Amazon doesn't allw 0 stars.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.9 out of 5 stars  47 reviews
121 of 131 people found the following review helpful
3.0 out of 5 stars Not worth the price, though worth buying? Nov. 26 2002
By A Customer - Published on Amazon.com
Format:Paperback
I am an absolute beginner when it comes to php/mysql, so my review should be helpful to the majority of people considering this book. I decided to buy it after reading the positive reviews here, and while I don't wholefully regret buying it, I can certainly tell you it's not worth the $35 cost.
Very first thing you should know about this book is that it's incredibly thin and small- about the size of your printer's manual, if you have one of those. So small in fact, I wasn't sure it was the book when I first received it (thought it was a booklet that came with the book). The 230 page count doesn't do this book's minute size justice.
The book is written completely in a top-bottom, tutorial fashion. It builds on a single example for the most part, first telling you how to view and define your database, then slowly populate and manipulate the tables inside. Such a style means that it's hard to get left behind, even if you're the absolute beginner and non-geek. Bottom line, I did learn how to create a database and add to it dummy values using PHP through this book. If that's your stumbling block- the absolute first step- this book will help you overcome it. The book's top-bottom/single example style is its allure, though ultimately, its fatal flaw too.
Now to elaborate on the reasons why "Build your own database driven site (php/mysql)" isn't all that great, and not worth the $[money]:
1) From the get-go, you can obviously tell it wasn't put together in a professional setting- lots of spelling mistakes, unprofessional font (for the example codes). "Not a big deal" I told myself as I worked my way through. However, I quickly realized the book doesn't even contain an INDEX at the end! Having read the book once already, it became a nightmare to try and quickly brush up on a particular syntax without wasting tons of time flipping through pages. I end up just going to [the website] often and looking up the syntax directly. This means the book is useful only for the first read, 2nd at most. As another irritating side note, the book is so small, I can't even get it to open up without having to press my fingers between the two covers to keep it open at all times. Otherwise, it'll just fold back up.
2) The book is truly for absolute beginners, and not just in its writing style, but amount of information contained inside as well. Having just read another beginner's book on mysql, I gradually realized just how much essential (not advanced, essential) information on mysql syntax was left out of it, info that's invaluable when you're just creating your first database. Syntax like variations of the various commands that make it so much easier to insert and modify tables, how to populate data via a text file etc, were all not included. And for the info that was there, as mentioned above, since there is no index, they're hard to look up.
3) This book is priced at $35. I guess the author thought he could get away with it, since there are currently no other php/mysql books written in such a tutorial and gentle style. Perhaps, though is that justification to price it at the highest price level of similar books, and for one that's 1/3 the size and amount of info as the rest? The amount of editing done is also significantly less than most other books (lack of index, spelling mistakes etc). I feel like being in the mix of a price fix here. The moment I saw the size of the book and to the end, I couldn't help but feel cheated, even though the info contained inside is good.
Bottom line, as mentioned above, if your stumbling block at this point is the absolute first step in creating mysql databases and using php to interact with it, this book is worth getting, though not "worth it" any way you look at it.
Do I have another suggestion then? Buy a couple of other beginner books on the subject first, and if you still don't get it, come to this one (buy used if possible). You're feel a lot more comfortable with your decision then, as it was your last resort anyway.
62 of 66 people found the following review helpful
3.0 out of 5 stars Introduction for beginners, has technical flaws Nov. 10 2004
By Jack D. Herrington - Published on Amazon.com
Format:Paperback
I'd like to recommend this book because there is a lot going for it. The text is readable. The illustrations and screenshots are well done. And the book presents a nice learning curve from beginner to reasonably high level concepts. But the book has some technical flaws that other beginning PHP books do not. An example is the authors use of SQL, a primary feature of this type of book, which is implemented using string concatenation. This type of SQL is not only inefficient, it's also prone to SQL injection attacks which means that any code based on this book will have serious security issues.

There are some very good parts, however. The chapter that introduces relational databases is very well done.

I recommend O'Reilly's Learning PHP 5 as an alternative to this book.
28 of 28 people found the following review helpful
4.0 out of 5 stars Great place to start when diving into the topic Feb. 9 2005
By Meryl K. Evans - Published on Amazon.com
Format:Paperback
This book is for those who like step-by-step directions accompanied by explanations of how things work. I learned many things using this approach. This book is a stepping stone to creating dynamic Web sites.

Yank does a fine job covering a little of everything without overpowering the reader with too much. Anyone who has experimented with Perl, PHP, ASP.NET, MySQl, Access, some of them or all of them will like the book. Those who can write PHP and MySQL with little help need to find a more advanced book (don't have suggestions, but I am sure others do).

I rarely ran into problems while following the examples. I've worked with other technical books and hit a brick wall at times requiring a call for help or serious research. While working with this book, I only got stuck once and immediately figured out the problem with a little research.

Yank uses visual aids and avoids jargon when explaining the process of laying out the database tables. A reviewer commented that Yank missed important concepts regarding databases. This book is not meant to go into such details. There are other books for that.

This book is well-rounded in covering all the necessary components of building a Web site using a database. While adding data, viewing tables, and querying the database, you're learning tasks that will come in handy for future projects.

Not only do you get instructions for PHP and MySQL, but also advice on structuring code so that it's used effectively.

If you've never installed Apache, PHP, or MySQL or can't recall how to do it, the steps for Windows, Linux, and Mac OS X are in the first chapter. Since the latest edition covers PHP 5, the author addresses the differences in PHP 4.3. When working on the first PHP script, there is no "Hello World!" for a change.

The early chapters provide a good overview of PHP and MySQL. By Chapter 4, the contents of the earlier chapters are integrated as the backend database connects to the Web page with PHP. The next chapters show how to use forms to manage, add, delete, edit, and search data. By midpoint, the reader has designed a database, organized it, created Web pages for the data, added administration pages, and administered the database. Yank also explains how to generate cookies and build a simple shopping cart.

The appendices include MySQL syntax, functions, column types, and PHP functions to use with MySQL. The book has an accompanying Web site that includes errata and four free sample chapters. Having edited a few tech books, I know how easy it is to miss things when you're working on different computer set ups and application versions. Check the site especially since it has the code from the book. When running into problems, compare your code to the code from the site.

One chapter has a challenge along with the solution (a couple of pages later, so you're not tempted to peek). Having a challenge like this in most chapters, I believe, would help cement the learning. Overall, it will make the purchaser happy.

The four free sample chapters give you a good idea of what the book is about and its style <[...]>.
25 of 26 people found the following review helpful
4.0 out of 5 stars Very good introduction Sept. 13 2005
By Kerry DeMatteis - Published on Amazon.com
Format:Paperback
Author Kevin Yank states up front that this book is intended for intermediate- to advanced-level Web designers. I think this is an appropriate designation, as a beginner would quickly become overwhelmed at the rate with which Yank introduces such heady topics as Relational Database Design (Chapter 5) and Regular Expressions (Chapter 7). It's important to note that this book is an introduction to server-side technologies, not web site design; therefore, I recommend that the reader have experience with creating web sites and with client-side coding (HTML, JavaScript). Consider the pace: Chapters 1-3 of the book cover installation, your first MySQL database, and your first PHP page. Then by Chapter 6, the reader is coding a (admittedly rudimentary) content-management system!

Is this book for you? Consider that for the price, you get a basic introduction to a broad number of topics: 1) PHP installation, 2) MySQL installation, 3) relational database design, 4) using server-side programming to reduce client-side coding, 5) database administration, 6) writing effective SQL queries, 7) structured programming techniques, such as using includes, and 8) implementing cookies and sessions. If you are already comfortable with at least half of the topics in this list, then you are probably ready to graduate to a more in-depth book than this one. If much of this sounds new to you, then you will find Yank's book an excellent introduction. Yank writes as if he was a friendly tour guide, at each step of the way walking you through what he has done and why he chose to do it that way. Because the style is so conversational, it's easy to go back and re-read a chapter, which many readers might find themselves doing.

While the cover of the 3rd Edition (February 2005 update) goes at length to point out that the book covers PHP5, there is negligible content that goes beyond PHP4.x. None of the coding, and none of the author's discussions on effective programming techniques, addresses OO programming at all, let alone how it's implemented in PHP5. This is not necessarily a negative aspect of the book since, again, it's essentially an introduction. Just don't let the packaging fool you into thinking you're getting more than you actually are.

For me, the primary value of a book like this is in the initial chapter, where it provides all of the necessary steps for installing PHP and MySQL in one place. While the online documentation for both technologies is excellent, I have found that it can be confusing to switch back and forth between the two sites to get your own set-up installed and configured. If you're like me and must add Apache installation to the process, it only compounds the problem. Yank provides clear instructions for Windows and Linux users, with a nod to Mac X users, on installation and post-installation tasks.

Mainly for this information, this book is an excellent way to get started with server-side technology, but it is not at all suitable for production purposes. As with any server or server-side technology, security is a major and much-debated topic of concern with PHP and MySQL. Yank does address some of the basic methods of protecting a MySQL server from attacks, including how to password-protect the root user account and how to grant only necessary access to new users. I'm sure many PHP programmers will argue with Yank's recommendation that PHP's "Magic Quotes" feature be left On, since turning it Off "exposes you to hackers attempting SQL injection attacks on your Website if you are not very careful to write scripts that protect themselves from such malicious behavior" (p. 24). Mind you, he is simply quoting the recommendation at php.net, since the On setting is recommended for beginners, but it points out why this book is not suitable for production-ready applications. Yank does provide abundant footnotes for the reader to find more detailed information, including the online documentation at [...] and [...]

Yank very often invites the reader to consult the forums at [...] for further information and advice. Do not construe this as a mere marketing ploy. The SitePoint forums are indeed an excellent resource, with an active and often well-experienced audience.

All of the code listed in the book is available as a download from [...]. Simply provide your e-mail address, then you will be prompted with a question that you can answer only if you have the book in front of you.
19 of 19 people found the following review helpful
5.0 out of 5 stars Absolutely essential book for PHP and mySQL beginners! June 28 2002
By A Customer - Published on Amazon.com
Format:Paperback
Sometimes you buy and read through two-three books that should teach you how to do something, but you read and read and do not understand what those guys are talking about. This books actually explains why and how things work in mySQL and PHP, explains mySQL interface and tells you how to stick thing together.
As complete novice to mySQL and PHP, I was looking for some help and there it was - a book, that takes you step-by-step of setting your system, database, PHP and tells you how to build a db-driven site from scratch in no time (O.K. you'd need to read the book first), gives an advice and shares some developer's secrets. If you wonder how things are working behind the scenes of back-end programming this book is for you.
I am not sure if PHP-mySQL Wiz would need the book but I found it absolutely essential.
Search Customer Reviews
Only search this product's reviews

Look for similar items by category


Feedback