Build Your Own Database Driven Website Using PHP and MySQL

Book Description

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.

Customer Reviews:

Great for biginners, but out of date for today. .......2007-09-10

True to Site Point's method and style, this book makes it easy to jump into the basics of it's subject. Easy to navigate and full of helpful tips and hints, all the matieral is easy to access.
However a word of warning for those who may wish to purchase this book- get a newer version! This version covers PHP4.0 which is being discontinued from use in November of 2007. Learning PHP4.0 will not be very helpful after November, so Look for the newer version of this book and you will be set.
I found this to be the newest version as of this posting: Build Your Own Database Driven Website Using PHP and MySQL
I was quite sad when I realized I had purchased, and then read through, the whole book and then found out that PHP4 will be discontinued. You need PHP5 or PHP6 to be effective and up to date.
Also, if you are not an absolute beginner at the subject, this book is probably not for you. You can find more advanced books on the subject that will help you in your php quest. I found the first couple of chapters to be a bore, and maybe even an insult, because they covered 'how to use windows' how to open notepad, or how to do the equivalent in mac.

Excellent Book.......2006-07-10

I highly recomend this book. I think it best serves those who already know the syntax of PHP, but it is a excellent book. I recomend either "Learning PHP" (The O'Reilly book) or "PHP for the World Wide Web : Visual QuickStart Guide" for a beginner. Both of these books will help you learn the syntax and concepts of PHP, but then it is best to move on to a book that gives practical examples, and this book excells at giving practical examples.

A good book for getting started with php and databases........2006-07-04

By reading just the first 4 chapters I was able to create my own webpages using php and the mySQL database to store tables of data. It has some good example programs that you can follow.

Sitepoint PHP and MySQL.......2006-04-20

Sitepoint (both the books and the website) is an excellent resource for quick learning of the latest and greatest in web development technologies, and this book proves it. Very clearly written and easy reading; a practical, hands-on tutorial. Provides everything necessary to develop and serve up a top-notch website backed by a powerful database.

Very good introduction.......2005-09-14

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 www.php.net and www.mysql.com.

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.

Average customer rating:

Add This To Your Library
A concise introduction to the fundamentals of MySQL
Nice introduction and overview

MySQL Tutorial
Luke Welling , and Laura Thomson
Manufacturer: MySQL Press
ProductGroup: Book
Binding: Paperback

General | Databases | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

ASIN: 0672325845

Book Description

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

Download Description

The MySQL Tutorial consists of a series of short, very concise chapters, each on a tightly targeted topic, with a task-oriented focus.Each chapter is written so it can be read in a single sitting and be easily digested. The main focus is on five key areas: installation and configuration, using MySQL, administering MySQL, optimizing MySQL, and MySQL's associated APIs.With 4 million installations and 27,000 downloads per day, MySQL continues to grow as one of the most widely used databases in the world. Now an enterprise-level database, MySQL features full support for transactions, integrating improvements that enhance MySQL's architectural foundation for building heavy-load commercial applications.

Customer Reviews:

Add This To Your Library.......2004-10-12

Luke Welling and Laura Thomson have the special gift of taking information, disseminating it, and making it simple to understand for everyone. This is the second book I bought from these authors (Php and MySQL Web Development) without any complaints.

It is nice to see books of this size (250 pages) at this price point coming out. Nothing is worse than those large tomes that weigh a ton and cost an arm and a leg. You should be able to get through this in a week, which is perfect for busy professionals.

This tutorial is written very clearly and does what I want from it - nail down the 80% of the necessary information needed to get work done. After each chapter there is a quiz to test your knowledge. The authors tackle both the user and administrator side of using the product. One of my favorite sections in the book is the Database Crash Course which discusses normalization.

If you are serious about using mySQL in your web projects, look to this book to get you started quickly. This book won't turn you into an immediate mySQL expert. But what it will do is give you the skills to be proficient. It was good enough to get my projects started on my website, KerryOnWorld.com. This is a top 30 book in my 15-year technical library. That is how much I like it.

A concise introduction to the fundamentals of MySQL.......2004-05-01

MySQL is the database used by many commercial and open source security products. Although the user is often "shielded" from interacting with the database directly, it's important and sometimes crucial to know basic MySQL administration.

"MySQL Tutorial" is the perfect companion to any security tool which depends on a MySQL database. For example, no one seriously expects to collect large amounts of data with Sguil and Snort unless a MySQL or similar database is working in the background. "MySQL Tutorial" gives the right details on the right subjects for those running integrated MySQL databases.

This book is not for Oracle gurus. It's for people who need basic understanding of MySQL installation, configuration, security, and administration. I found the authors' explanations clear and relevant, hitting the high points I would expect in a 267 page book. The text is example-driven, using a sample "employee" database to demonstrate various administration tasks.

The only real fault I found involves the scripts at the publisher's Web site. They create a sample database whose naming convention differs from the book's description. For example, the scripts create an "employee_skills" table, but the book speaks of "employeeSkills". The best answer to this problem is to manually correct the scripts prior to running them, or to type in the examples by hand.

"MySQL Tutorial" met my expectations, with a page count and price far more reasonable than many tech titles available today. I recommend this book to anyone who uses MySQL in a role supporting intrusion detection systems, Web servers, or similar applications.

Nice introduction and overview.......2004-01-12

This book assumes some familiarity with the basics of databases, and knowledge of some web application language with which you can write your queries.

Its a nice overview of MySQL's capabilites and quirks. After reading the first few chapters I am more convinced than before that MySQL is the best database choice for all but the largest, most critical applications.

Book Description

The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect

MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs.

Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security.

Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from âapprenticeâ to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

Coverage includes

Writing queries, including joins, functions, and subqueries
Updating data
Creating tables, views, and other database objects
Specifying keys and other integrity constraints
Improving efficiency with indexes
Enforcing security via passwords and privileges
Embedding SQL statements within PHP programs
Building stored procedures and triggers
Using transactions, locking, rollback, and isolation levels
Utilizing MySQL’s catalog

All of the book’s sample programs are available for download from www.r20.nl.

About the Author

Rick F. van der Lans is author of the classic Introduction to SQL, the definitive SQL guide that database developers have relied on for more than 20 years. He is a consultant, author, and lecturer specializing in database technology, development tools, data warehousing, and XML. As managing director of the Netherlands-based R20/Consultancy, he has advised many large companies on defining their IT architectures. He chairs the European Meta Data Conference, and writes columns for several magazines.

Contents

About the Author

Preface

PART I Introduction

CHAPTER 1 Introduction to MySQL

CHAPTER 2 The Tennis Club Sample Database

CHAPTER 3 Installing the Software

CHAPTER 4 SQL in a Nutshell

PART II Querying and Updating Data

CHAPTER 5 SELECT Statement: Common Elements

CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries

CHAPTER 7 SELECT Statement:The FROM Clause

CHAPTER 8 SELECT Statement: The WHERE Clause

CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions

CHAPTER 10 SELECT Statement: The GROUP BY Clause

CHAPTER 11 SELECT Statement: The HAVING Clause

CHAPTER 12 SELECT Statement: The ORDER BY Clause

CHAPTER 13 SELECT Statement: The LIMIT Clause

CHAPTER 14 Combining Table Expressions

CHAPTER 15 The User Variable and the SET Statement

CHAPTER 16 The HANDLER Statement

CHAPTER 17 Updating Tables

CHAPTER 18 Loading and Unloading Data

CHAPTER 19 Working with XML Documents

PART III Creating Database Objects

CHAPTER 20 Creating Tables

CHAPTER 21 Specifying Integrity Constraints

CHAPTER 22 Character Sets and Collations

CHAPTER 23 The ENUM and SET Types

CHAPTER 24 Changing and Dropping Tables

CHAPTER 25 Using Indexes

CHAPTER 26 Views

CHAPTER 27 Creating Databases

CHAPTER 28 Users and Data Security

CHAPTER 29 Statements for Table Maintenance

CHAPTER 30 The SHOW, DESCRIBE, and HELP Statements

PART IV Procedural Database Objects

CHAPTER 31 Stored Procedures

CHAPTER 32 Stored Functions

CHAPTER 33 Triggers

CHAPTER 34 Events

PART V Programming with SQL

CHAPTER 35 MySQL and PHP

CHAPTER 36 Dynamic SQL with Prepared Statement

CHAPTER 37 Transactions and Multiuser Usage

APPENDIX A Syntax of SQL

APPENDIX B Scalar Functions

APPENDIX C System Variables

APPENDIX D Bibliography

Index

Customer Reviews:

Excellent translated guide to MySQL.......2007-06-03

Over the last 5 years, I would say I've at least read every book available on MySQL and bought my fair share.

This book is by far the best one available on some of the advanced features of MySQL. It's better than even the Bible and Cookbook series on things like stored procedures, even though it spends too much time on the basics. I loved the large text, but wish there had been more meat on stored procedures, triggers and events (which is why I picked it up to begin with). There are insider knowledge gems sprinkled throughout that will definitely add spice to your SQL, so it's worth a look.

I don't know why even in 2007 authors insist on repeating the MySQL documentation,--it's a MASSIVE amount of wasted space, since anyone using this stuff will be familiar with the online documentation and helpful user commentary. There were a few typos, but that's pretty par for the course. The section on PHP, though, was pretty useless and not particularly good code-wise (in my humble opinion).

One day someone will put out a really advanced cookbook, that doesn't waste space explaining super simple things like "select * from table," but until then it's a great resource. If you can get it at a discount, like on a Borders reward coupon (which they give out like candy) grab it. Clearly, the Europeans still have something to teach us about MySQL! :o))

9 chapters just on SELECT; wow!.......2007-05-07

Van der Lans offers an impressively thorough education in MySQL 5. It is remarkable how much capability is offered for free in the open source MySQL. The book can also be used to learn generic SQL from scratch. Some early chapters give a quick recap, that should be understandable to an experienced programmer, who does not know SQL. If this describes you, the biggest adjustment to learning it might be its declarative nature, as opposed to the procedural ethos of most programming languages.

One striking feature of the book is the extensive explanation of SELECT. This is the key statement of SQL, and you need to be facile with it. Nine [sic] chapters are devoted to SELECT. Gives you some idea of both the power and complexity of the command. Rarely do other SQL books allocate so much space to a rendition of SELECT. Often, they teach you the basic modes of using it, and then you are left on your own. (Gee, thanks!) Whereas here, for example, an entire chapter is about the SELECT HAVING clause, and another chapter is on the SELECT LIMIT clause. Across these nine chapters are enough worked examples that you can fruitfully mine.

Later chapters delve into more specialised aspects of SQL. Sure, these are all significant. But maybe the most useful is the idea of stored procedures and functions. Vital to optimising performance.

Lest this very mass of detail prove offputting, keep in mind the "Reference" in the book's title. You don't have to read it all at once. As you go thru it, you should develop an intuition of what can be safely relegated to a later reading, when you have specific need of those topics.

Dimensional Data Warehousing with MySQL: A Tutorial

Average customer rating:

A lucid Introduction to data warehousing

Dimensional Data Warehousing with MySQL: A Tutorial
Djoni Darmawikarta
Manufacturer: BrainySoftware
ProductGroup: Book
Binding: Paperback

Data Warehousing | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0975212826

Book Description

Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial on building dimensional data warehouses. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. It comes complete with a hands-on case—scaled-down from a real project—as well as an electronic copy of all MySQL scripts and sample data available for download. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.

Customer Reviews:

A lucid Introduction to data warehousing.......2007-09-28

I'm new to MySQL and this was my first book on the subject. The author has done a great job of writing for a specific skillset and not wasting our time with alot of fundamentals or too advanced stuff. I'm somewhat learning challenged and found the organization of the material to aid greatly in my grasp of the subject.

Average customer rating:

Dreamweaver 8 Dynamic Development
Daniel Short
Manufacturer: lynda.com, Inc.
ProductGroup: Book
Binding: CD-ROM

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

Dreamweaver 8 Beyond the Basics

ASIN: 1596711639

Product Description

Are you ready to develop your website into something more than a collection of static pages? In Dreamweaver 8 Dynamic Development, instructor Dan Short teaches you how to use Dreamweaver to build a robust and dynamic site. This video tutorial delves into the possibilities offered by Dreamweaver 8, including the integration of a back-end database, SQL queries, customized blogs with filtered content, and search forms. Dan breaks down the skills that will help turn you from designer into developer: understanding data types, creating a database, and inserting and updating database records. He also walks you through the construction of both the front and back ends of an interactive blog. While this title uses ColdFusion to demonstrate dynamic development in Dreamweaver, the same procedures and concepts also apply to ASP, PHP, .NET, or any other server-side language. Exercise files accompany the training videos, allowing you to follow along and learn at your own pace.

Average customer rating:

Dreamweaver CS3 Dynamic Development
David Gassner
Manufacturer: lynda.com, Inc
ProductGroup: Book
Binding: CD-ROM

General | Education | Nonfiction | Subjects | Books
ASIN: 1596713658

Product Description

In Dreamweaver CS3 Dynamic Development, instructor David Gassner demonstrates how to use Dreamweaver CS3 to create professional, data-driven websites that are interactive and seamlessly integrated. From choosing servers and databases to installing MySQL to designing and building web-based data entry systems and displays, this training provides in-depth, hands-on guidance through the process of building strong dynamic sites. Exercise files accompany the tutorials.

Topics Include:

Understanding dynamic applications
Working with databases
Installing MySQL on Windows and Mac OSX
Setting up an application server
Creating a dynamic application
Displaying data on dynamic pages
Building data entry systems
Authenticating users
Using Dreamweaver CS3 with ASP.NET and PHP
Creating interfaces and validating forms with Spry

Duration: 7 hours
On 2 CD-ROMs

Average customer rating:

PHP with MySQL Essential Training
Kevin Skoglund
Manufacturer: lynda.com, Inc
ProductGroup: Book
Binding: CD-ROM

General | Education | Nonfiction | Subjects | Books

Product Description

Website and database assimilation is a necessity for many of today's businesses, and learning to work with PHP is key to integration success. The objective of PHP with MySQL Essential Training is to teach both new and experienced web developers the comprehensive steps for building dynamic, data-driven, interactive websites. Instructor Kevin Skoglund demonstrates the entire process of building a content management system. He starts with the basics of the PHP language (variables, arrays, loops, functions, etc.) and works up to building dynamic web pages with a MySQL back end. Kevin also covers blueprinting applications; structuring and interacting with databases; building, validating, and processing forms; and regulating user access with passwords. In addition, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques for improving existing code. Exercise files accompany the tutorials.

Topics Include:

Viewing PHP configuration information
Exploring data types
Understanding logical expressions
Working with loops
Defining and using functions
Building web pages
Creating a database in MySQL
Building a content management system

Duration: 10.75 hours
On 2 CD-ROMs

Tutorial MySQL: uma Introdução Objetiva aos Fundamentos do Banco...

Average customer rating:

Tutorial MySQL: uma Introdução Objetiva aos Fundamentos do Banco...

Manufacturer: Ciência Moderna
ProductGroup: Book
Binding: Paperback

Portuguese | Foreign Language Nonfiction | Nonfiction | Subjects | Books

Portuguese | Foreign Language Books | Specialty Stores | Books
ASIN: 8573933348

Books:

Books Index

Books Home

Recommended Books