Product Overview
Looking for the old edition of “Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition?”
Download the code archive or view errata of the old edition here.
Build Your Own Database Driven Web Site, 4th Edition
Table Of Contents
- Here's a look at the table of contents:
- Preface
- Who Should Read This Book
- What’s in This Book
- Where to Find Help
- The SitePoint Forums
- The Book’s Web Site
- The SitePoint Newsletters
- Your Feedback
- Conventions Used in This Book
- Code Samples
- Tips, Notes, and Warnings
- Installation
- Your Own Web Server
- Windows Installation
- All-in-one Installation
- Installing Individual Packages
- Mac OS X Installation
- All-in-one Installation
- Installing Individual Packages
- Linux Installation
- Installing MySQL
- Installing PHP
- Post-Installation Set-up Tasks
- What to Ask Your Web Host
- Your First PHP Script
- Full Toolbox, Dirty Hands
- Introducing MySQL
- An Introduction to Databases
- Logging On to MySQL
- Structured Query Language
- Creating a Database
- Creating a Table
- Inserting Data into a Table
- Viewing Stored Data
- Modifying Stored Data
- Deleting Stored Data
- Let PHP Do the Typing
- Introducing PHP
- Basic Syntax and Statements
- Variables, Operators, and Comments
- Arrays
- User Interaction and Forms
- Control Structures
- Hiding the Seams
- Avoid Advertising Your Technology Choices
- Use PHP Templates
- Many Templates, One Controller
- Bring On the Database
- Publishing MySQL Data on the Web
- The Big Picture
- Connecting to MySQL with PHP
- Sending SQL Queries with PHP
- Handling SELECT Result Sets
- Inserting Data into the Database
- Deleting Data from the Database
- Mission Accomplished
- Relational Database Design
- Giving Credit Where Credit is Due
- Rule of Thumb: Keep Entities Separate
- SELECT with Multiple Tables
- Simple Relationships
- Many-to-Many Relationships
- One for Many, and Many for One
- Structured PHP Programming
- Include Files
- Including HTML Content
- Including PHP Code
- Types of Includes
- Shared Include Files
- Custom Functions and Function Libraries
- Variable Scope and Global Access
- Structure in Practice: Template Helpers
- The Best Way
- Include Files
- A Content Management System
- The Front Page
- Managing Authors
- Deleting Authors
- Adding and Editing Authors
- Managing Categories
- Managing Jokes
- Searching for Jokes
- Adding and Editing Jokes
- Deleting Jokes
- Summary
- Content Formatting with Regular
Expressions
- Regular Expressions
- String Replacement with Regular
Expressions
- Boldface and Italic Text
- Paragraphs
- Hyperlinks
- Matching Tags
- Putting It All Together
- Real World Content Submission
- Cookies, Sessions, and Access Control
- Cookies
- PHP Sessions
- A Simple Shopping Cart
- Access Control
- Database Design
- Controller Code
- Function Library
- Managing Passwords and Roles
- A Challenge: Joke Moderation
- The Sky’s the Limit
- MySQL Administration
- phpMyAdmin
- Backing Up MySQL Databases
- Database Backups Using mysqldump
- Incremental Backups Using Binary Logs
- MySQL Access Control
- Granting Privileges
- Revoking Privileges
- Access Control Tips
- Locked Out?
- Checking and Repairing MySQL Data Files
- Better Safe than Sorry
- Advanced SQL Queries
- Sorting SELECT Query Results
- Setting LIMITs
- LOCKing TABLES
- Column and Table Name Aliases
- GROUPing SELECT Results
- LEFT JOINs
- Limiting Results with HAVING
- Further Reading
- Binary Data
- Semi-dynamic Pages
- Handling File Uploads
- Assigning Unique Filenames
- Recording Uploaded Files in the Database
- Binary Column Types
- Storing Files
- Viewing Stored Files
- Putting It All Together
- Large File Considerations
- MySQL Packet Size
- PHP Script Timeout
- The End
- A. MySQL Syntax Reference
- SQL Statements Implemented in MySQL
- ALTER TABLE
- ANALYZE TABLE
- CREATE DATABASE
- CREATE INDEX
- CREATE TABLE
- DELETE
- DESCRIBE/DESC
- DROP DATABASE
- DROP INDEX
- DROP TABLE
- EXPLAIN
- GRANT
- INSERT
- LOAD DATA INFILE
- LOCK/UNLOCK TABLES
- OPTIMIZE TABLE
- RENAME TABLE
- REPLACE
- REVOKE
- SELECT
- SET
- SHOW
- TRUNCATE
- UNLOCK TABLES
- UPDATE
- USE
- SQL Statements Implemented in MySQL
- B. MySQL Functions
- Control Flow Functions
- Mathematical Functions
- String Functions
- Date and Time Functions
- Miscellaneous Functions
- Functions for Use with GROUP BY Clauses
- C. MySQL Column Types
- Numerical Types
- Character Types
- Date/Time Types
- D. PHP Functions for Working with
MySQL
- Common PHP
mysqli_*Functionsmysqli_affected_rowsmysqli_character_set_namemysqli_closemysqli_connectmysqli_connect_errnomysqli_connect_errormysqli_data_seekmysqli_errnomysqli_errormysqli_fetch_allmysqli_fetch_arraymysqli_fetch_assocmysqli_fetch_fieldmysqli_fetch_field_directmysqli_fetch_fieldsmysqli_fetch_lengthsmysqli_fetch_objectmysqli_fetch_rowmysqli_field_countmysqli_field_seekmysqli_field_tellmysqli_free_resultmysqli_get_client_infomysqli_get_client_versionmysqli_get_host_infomysqli_get_proto_infomysqli_get_server_infomysqli_get_server_versionmysqli_infomysqli_insert_idmysqli_num_fieldsmysqli_num_rowsmysqli_pingmysqli_querymysqli_real_escape_stringmysqli_real_querymysqli_select_dbmysqli_set_charsetmysqli_statmysqli_store_resultmysqli_thread_idmysqli_use_result
- Common PHP
- Index
Now that you realize this book can advance you … how can you possibly go wrong investing $29.95 on something that can dramatically change the course of your career?
Instant Download!
This title available in Adobe PDF, Kindle (mobi) and ePub (IOS) formats
Customer Reviews
Live, unmoderated reviews from our customers, typos and all.
Very readable, covers a stack of things at a nice pace. I am starting to feel confident I actually know what I'm doing!
Nathan Keen, USA 
You didn't send me the link to download the ebook version on any of the books
why
Manoj Padhi, USA 
A book really done for non expert. I've learnt quickly and developed a real application quite soon. Strongly suggested.
pietro onesti, USA
Easy to read.
Information was pitched at just the right level.
Good to see security and some other "gotcha's" covered really early on.
Steve Hamlyn, USA
Practical, current, effective information. Very utilitarian.
Don Amos, USA
Originally bought a copy of this book for a Christmas gift for my daughter, and found myself going through it, so bought a 2nd copy for personal use. Very well written and easy to follow.
WIlliam H Stahl, USA
i'm new to study Php and MySql, but first time found the book was writing exactly for me. 10 from 10. You are a great teacher Kevin and thank you much for this wonderfull job.
Samoylenko Volodymyr, USA
So far so good, but haven't had the opportunity to get too far into into. Like the way it is written. Clear and concise.
Steve Coleman, USA 
Very smoothly written book. It is easy to read with LOTS of explainations and examples. Great book.
Royce Metcalfe, USA
Excellent book. Simple and clear explanations got my site "talking" to my MySQL in no time. And I actually wrote my code myself which means that this is a book to learn and understand, not just copy-paste. Beautiful.
The only thing that bother's me is that every few lines there is a reference to another Site-Point title which give's the feeling that they give you less information than they should in order to push you to buy another book. This is just a feeling. In effect I don't think I was missing information. But I would be more comfortable with less self-promoting and\or more external references.
Harel Cohen, USA
The book is well written.I enjoyed and still working to learn the basics. I would like to see a book with more detail on php framework with some more practical example projects. How to use the framework to develop a project.
Thanks for keeping the books economical.
Best Wishes
Nibir
Nibir Dhar, USA
This has been the best buy I had about PHP and MySQL, I have learned so much already with it, and my God, how many bad habits I had learned through the years and how many have I corrected thanks to this book. Specially trying to change my procedural style to a better object oriented style. If I had 4 hands I would give 4 thumbs up. But because I don't I give 5 stars.
Rafael Vila, USA
This book is fabulous. I am a student, and work full time. The book(s) are a wonderful addition to my growing resource library for school as well as for my professional life!
Regrettably, I missed my free month of Learnable, but will subscribe once my budget again allows it. I was a previous subscriber at the per-course price, but I guess that course went away when I signed up for the free month. With my schedule of work and school, a resource like the book works better for me than tutorials right now anyway. Thanks for all you do to give us access to great resource materials!
Happy coding,
Joyce Keller
Joyce W Keller, USA
I found the book excellent as a referral and would highly recommend it. I found it was tough to read through but as a 'goto' book, its been excellent for me. Solves the usual gotchas and explains the rationale behind laying out a database which I found very useful as well.
Todd Thompson, USA
Excellent pre sales, really helpful on question about the book and generally about web design. Not so helpful with web design question I had after the purchase, perhaps the individual is not a web designer but still he would be aware of what the industry is generally doing. Only slight gripe, goods delivered well beyond the estimated time period of 10-15 days and there was no way of determining, by myself or the Sitepoint salesperson, where it was.
No big deal really. Not read the book yet but layout etc look fine! Can't wait to start building the web-site, hope I can get some assist from you guys when needed. Cheers.
Jim Ogle, USA
I am very pleased with every aspect of this book. Kevin has done an excellent job. The whole book is well structured and the pace of new features presented at just above the comfort level, so the reader is encouraged to learn each topic well before moving on. For me, the most important experience with this book is the quality of the examples with extremely helpful notes that would otherwise be hard to obtain in appropriate contexts.
Nigel Cunningham, United Kingdom
Great! Awesome! I read a lot of books on the subject as I'm a Web Designer, and this author has an exceptional way of explaining complex concepts! This is the best book I've read yet. Regardless of your level of knowledge, this book makes sense!
Liana Jeffreys, Canada
If you're wanting to learn PHP/MySQL from the ground up, this is certainly the way to do it. The book came highly recommended, and I now know why.
Excellent layout, step-by-step instruction, and carefully crafted examples that really bring the points of the text home.
If you're like me, you've looked at many books on this subject. I had great difficulty finding one that not only TAUGHT me how to use PHP, but did so with real-world examples AND attention to standards!
I can't say this enough... buy it, you won't be disappointed!
Bryan D, USA
Well Kevin you have done it again only better. I thought Vol.3 was as good as it could get but this has improved on that. The screen prints with arrows showing what to click on were a real help to me. Keep up the good work.
One critisism though ;-( Is there some way you can put on this site something to show when a URL or the filename changes as in PHP has changed from 5.2 to 5.3.
Still I would recommend this to anyone who wants to learn PHP/MySQL from the ground up.
Kenneth Hart, Canada
Product Details
| Edition: |
4th |
| Price: | $29.95 |
| Pages: | 479 |
| ISBN: | 978-0-9805768-1-8 |
| Last Updated: | July 2009 |
SitePoint Books
- advocate best practice techniques
- lead you through practical examples
- provide working code for your web site
- make learning easy and fun
