Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
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.
| Preface | ix | |
| Who Should Read This Book | x | |
| What's In This Book | x | |
| The Book's Website | xiii | |
| The Code Archive | xiii | |
| Updates and Errata | xiii | |
| The SitePoint Forums | xiv | |
| The SitePoint Newsletters | xiv | |
| Your Feedback | xiv | |
| 1 | Installation | 1 |
| Windows Installation | 2 | |
| Installing MySQL | 2 | |
| Installing PHP | 6 | |
| Linux Installation | 12 | |
| Removing Packaged Software | 13 | |
| Installing MySQL | 14 | |
| Installing PHP | 17 | |
| Mac OS X Installation | 20 | |
| Installing MySQL | 20 | |
| Installing PHP | 22 | |
| Mac OS X and Linux | 22 | |
| Post-Installation Setup Tasks | 22 | |
| If Your Web Host Provides PHP and MySQL | 25 | |
| Your First PHP Script | 26 | |
| Summary | 28 | |
| 2 | Getting Started with MySQL | 29 |
| An Introduction to Databases | 29 | |
| Logging On to MySQL | 31 | |
| So, What's SQL? | 34 | |
| Creating a Database | 34 | |
| Creating a Table | 35 | |
| Inserting Data into a Table | 37 | |
| Viewing Stored Data | 38 | |
| Modifying Stored Data | 40 | |
| Deleting Stored Data | 41 | |
| Summary | 41 | |
| 3 | Getting Started with PHP | 43 |
| Introducing PHP | 43 | |
| Basic Syntax and Commands | 45 | |
| Variables and Operators | 47 | |
| Arrays | 48 | |
| User Interaction and Forms | 50 | |
| Control Structures | 56 | |
| Multipurpose Pages | 61 | |
| Summary | 66 | |
| 4 | Publishing MySQL Data on the Web | 67 |
| A Look Back at First Principles | 67 | |
| Connecting to MySQL with PHP | 69 | |
| Sending SQL Queries with PHP | 71 | |
| Handling SELECT Result Sets | 72 | |
| Inserting Data into the Database | 75 | |
| A Challenge | 80 | |
| Summary | 80 | |
| "Homework" Solution | 80 | |
| 5 | Relational Database Design | 85 |
| Giving Credit where Credit is Due | 85 | |
| Rule of Thumb: Keep Things Separate | 87 | |
| Dealing with Multiple Tables | 90 | |
| Simple Relationships | 94 | |
| Many-to-Many Relationships | 96 | |
| Summary | 99 | |
| 6 | A Content Management System | 101 |
| The Front Page | 102 | |
| Managing Authors | 105 | |
| Deleting Authors | 107 | |
| Adding Authors | 110 | |
| Editing Authors | 112 | |
| Magic Quotes | 115 | |
| Managing Categories | 117 | |
| Managing Jokes | 123 | |
| Searching for Jokes | 123 | |
| Adding Jokes | 129 | |
| Editing and Deleting Jokes | 137 | |
| Summary | 142 | |
| 7 | Content Formatting and Submission | 143 |
| Out with the Old | 144 | |
| Regular Expressions | 145 | |
| String Replacement with Regular Expressions | 148 | |
| Boldface and Italic Text | 149 | |
| Paragraphs | 149 | |
| Hyperlinks | 150 | |
| Matching Tags | 152 | |
| Splitting Text into Pages | 155 | |
| Putting it all Together | 157 | |
| Automatic Content Submission | 162 | |
| Summary | 163 | |
| 8 | MySQL Administration | 165 |
| Backing up MySQL Databases | 166 | |
| Database Backups using mysqldump | 167 | |
| Incremental Backups using Update Logs | 168 | |
| MySQL Access Control | 170 | |
| Using GRANT | 171 | |
| Using REVOKE | 174 | |
| Access Control Tips | 174 | |
| Locked Out? | 177 | |
| Checking and Repairing MySQL Data Files | 178 | |
| Summary | 181 | |
| 9 | Advanced SQL Queries | 183 |
| Sorting SELECT Query Results | 183 | |
| Setting LIMITs | 186 | |
| LOCKing TABLES | 187 | |
| Column and Table Name Aliases | 189 | |
| GROUPing SELECT Results | 192 | |
| LEFT JOINs | 194 | |
| Limiting Results with HAVING | 197 | |
| Summary | 198 | |
| 10 | Binary Data | 199 |
| Semi-Dynamic Pages | 199 | |
| Handling File Uploads | 204 | |
| Assigning Unique File Names | 206 | |
| Recording Uploaded Files in the Database | 208 | |
| Binary Column Types | 209 | |
| Storing Files | 210 | |
| Viewing Stored Files | 212 | |
| The Complete Script | 215 | |
| Large File Considerations | 220 | |
| MySQL Packet Size | 220 | |
| PHP Script Timeout | 220 | |
| Summary | 220 | |
| 11 | Cookies and Sessions in PHP | 221 |
| Cookies | 221 | |
| PHP Sessions | 225 | |
| A Simple Shopping Cart | 228 | |
| Summary | 234 | |
| 12 | Structured PHP Programming | 235 |
| What is Structured Code? | 235 | |
| The Need for Structured Code | 236 | |
| Include Files | 238 | |
| Types of Includes | 242 | |
| Including HTML Content | 244 | |
| Locating Include Files | 246 | |
| Returning from Includes | 249 | |
| Custom Functions and Function Libraries | 253 | |
| Variable Scope and Global Access | 257 | |
| Optional and Unlimited Arguments | 261 | |
| Constants | 263 | |
| Structure In Practice: Access Control | 265 | |
| Summary | 274 | |
| A | MySQL Syntax | 277 |
| ALTER TABLE | 277 | |
| ANALYZE TABLE | 280 | |
| CREATE DATABASE | 280 | |
| CREATE INDEX | 281 | |
| CREATE TABLE | 281 | |
| DELETE | 283 | |
| DESCRIBE | 284 | |
| DROP DATABASE | 285 | |
| DROP INDEX | 285 | |
| DROP TABLE | 285 | |
| EXPLAIN | 285 | |
| GRANT | 286 | |
| INSERT | 286 | |
| LOAD DATA INFILE | 287 | |
| LOCK/UNLOCK TABLES | 288 | |
| OPTIMIZE TABLE | 289 | |
| RENAME TABLE | 289 | |
| REPLACE | 290 | |
| REVOKE | 290 | |
| SELECT | 291 | |
| Joins | 295 | |
| Unions | 297 | |
| SET | 297 | |
| SHOW | 298 | |
| UNLOCK TABLES | 299 | |
| UPDATE | 299 | |
| USE | 300 | |
| B | MySQL Functions | 301 |
| Control Flow Functions | 301 | |
| Mathematical Functions | 301 | |
| String Functions | 305 | |
| Date and Time Functions | 309 | |
| Miscellaneous Functions | 315 | |
| Functions for Use with GROUP BY Clauses | 318 | |
| C | MySQL Column Types | 321 |
| Numerical Types | 322 | |
| Character Types | 324 | |
| Date/Time Types | 327 | |
| D | PHP Functions for Working with MySQL | 331 |
| mysql_affected_rows | 331 | |
| mysql_client_encoding | 331 | |
| mysql_close | 332 | |
| mysql_connect | 332 | |
| mysql_create_db | 333 | |
| mysql_data_seek | 333 | |
| mysql_db_name | 333 | |
| mysql_db_query | 333 | |
| mysql_drop_db | 334 | |
| mysql_errno | 334 | |
| mysql_error | 334 | |
| mysql_escape_string | 334 | |
| mysql_fetch_array | 335 | |
| mysql_fetch_assoc | 335 | |
| mysql_fetch_field | 335 | |
| mysql_fetch_lengths | 336 | |
| mysql_fetch_object | 336 | |
| mysql_fetch_row | 337 | |
| mysql_field_flags | 337 | |
| mysql_field_len | 337 | |
| mysql_field_name | 337 | |
| mysql_field_seek | 337 | |
| mysql_field_table | 338 | |
| mysql_field_type | 338 | |
| mysql_free_result | 338 | |
| mysql_get_client_info | 338 | |
| mysql_get_host_info | 339 | |
| mysql_get_proto_info | 339 | |
| mysql_get_server_info | 339 | |
| mysql_info | 339 | |
| mysql_insert_id | 339 | |
| mysql_list_dbs | 340 | |
| mysql_list_fields | 340 | |
| mysql_list_processes | 340 | |
| mysql_list_tables | 340 | |
| mysql_num_fields | 341 | |
| mysql_num_rows | 341 | |
| mysql_pconnect | 341 | |
| mysql_ping | 341 | |
| mysql_query | 342 | |
| mysql_real_escape_string | 342 | |
| mysql_result | 342 | |
| mysql_select_db | 343 | |
| mysql_stat | 343 | |
| mysql_tablename | 343 | |
| mysql_thread_id | 343 | |
| mysql_unbuffered_query | 343 | |
| Index | 345 |
Anonymous
Posted Tue Nov 02 00:00:00 EST 2004
The combination of PHP and MySQL open source applications for developing a website has garnered wide attention. Yank explains why in this concise book. The scenario is that you want to build a website that has a back end database. From that database and also with input from the user, the web server has to get data and generate (ie. publish) dynamic HTML webpages. The book quickly covers the panoply of topics needed to implement this goal. Yank starts by explaining how to use separately MySQL and PHP. Then a chapter on relational databases. The weakest part of the book. No mention of the intricacies of normalisation or how to seriously design multiple tables with related keys. He gives a simple example that is correct insofar as it goes, and which lets him finesse not providing a fuller theoretical framework. If you have had no prior exposure to relational databases, then this chapter may be of limited usefulness in the context of your situation. Perhaps the best that can be said of the chapter is that it can motivate you to investigate designing a relational database, using a more extensive text devoted to that subject. Later chapters then show how to combine the MySQL and PHP into an entire system. These chapters are better done.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
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 ...