Build Your Own Database-Driven Website Using PHP & MySQL: Covers PHP 5, MySQL4 and Mac OS X

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (31) from $1.99   
  • New (3) from $29.51   
  • Used (28) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$29.51
Seller since 2014

Feedback rating:

(280)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(178)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(178)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

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 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.

Read More Show Less

Product Details

  • ISBN-13: 9780975240212
  • Publisher: SitePoint
  • Publication date: 1/28/2004
  • Edition description: Third Edition
  • Edition number: 3
  • Pages: 373
  • Product dimensions: 7.18 (w) x 9.02 (h) x 0.86 (d)

Meet 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.

Read More Show Less

Table of Contents

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
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted November 2, 2004

    weak description of relational databases

    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  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)