دانلود کتاب BUILD YOUR OWN DATABASE DRIVEN WEB SITE USING PHP & MYSQL

کتابBuild Your own Database Driven Web Site Using PHP & MySQL یک راهنمای کامل و عملی آموزش برنامه نویسی برای یادگیری تمامی ابزار، قواعد، و تکنیک هایی است که برای ساخت یک وبسایت کاملا تابعی و مبتنی بر دیتابیس و با استفاده از PHP و MySQL، مورد نیاز می باشند. این کتاب آموزش php همه ی مباحث مربوطه، از نصب و راه اندازی PHP و MySQL تحت سیستم های اجرایی Linuxt، Windows، و Mac گرفته، تا ساخت یک سیستم مدیریت محتوای web-based، را پوشش می دهد. با وجود اینکه این کتاب بعنوان یک راهنما برای شروع کار در سطح مبتدی طراحی شده است، اما مباحث پیشرفته تری از قبیل ذخیره سازی داده های باینری در MySQL، کوکی ها، و session های PHP را نیز ارائه می دهد. شما می توانید مباحث پیشرفته تر رادر کتاب های آموزش برنامه نویسی مطالعه کنید.

Build Your own Database Driven Web Site Using PHP & MySQL is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database-driven web site using PHP & MySQL. 
This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live web-based content management system. 
While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL that include:
•  MySQL syntax 
•  MySQL functions 
•  MysQL column types 
•  PHP functions for working with MySQL
    Preface xix
Who Should Read This Book xx
What's in This Book xxi
Where to Find Help xxiv
The SitePoint Forums xxiv
The Book's Web Site xxiv
The SitePoint Newsletters xxv
Your Feedback xxv
Conventions Used in This Book xxvi
Code Samples xxvi
Tips, Notes, and Warnings xxvii
Chapter i Installation 1
Your Own Web Server 2
Windows Installation 3
All-in-one Installation 3
Installing Individual Packages 9
Mac OS X Installation 20
All-in-one Installation 20
Installing Individual Packages 24
Linux Installation 32
Installing MySQL 33
Installing PHP 37
Post-Installation Set-up Tasks 44
What to Ask Your Web Host 47
Chapter 2 Introducing MySQL 53
An Introduction to Databases 53
Logging On to MySQL 55
Structured Query Language 60
Creating a Database 61
Creating a Table 61
Inserting Data into a Table 64
Viewing Stored Data 66
Modifying Stored Data 69
Deleting Stored Data 70
Let PHP Do the Typing 70
Chapter 3 Introducing PHP 73
Basic Syntax and Statements 75
Variables, Operators, and Comments 78
Arrays 79
User Interaction and Forms 81
Control Structures 94
Hiding the Seams 104
Avoid Advertising Your Technology Choices 104
Use PHP Templates 106
Many Templates, One Controller 109
Bring On the Database 113
Chapter 4 Publishing MySQL Data on the
Web 115
The Big Picture 115
Handling SELECT Result Sets 126
Inserting Data into the Database 132
Deleting Data from the Database 142
Mission Accomplished 149
Chapter 5 Relational Database Design 151
Giving Credit Where Credit is Due 152
Rule of Thumb: Keep Entities Separate 153
SELECT with Multiple Tables 158
Simple Relationships 163
Many-to-Many Relationships 166
One for Many, and Many for One 169
Chapter 6 Structured PHP Programming 171
Include Files 172
Including HTML Content 172
Including PHP Code 174
Types of Includes 180
Shared Include Files 181
Custom Functions and Function Libraries 184
Variable Scope and Global Access 187
Structure in Practice: Template Helpers 191
The Best Way 195
Chapter 7 A Content Management System.... 197
The Front Page 198
Managing Authors 202
Managing Categories 212
Managing Jokes 218
Searching for Jokes 218
Adding and Editing Jokes 225
Deleting Jokes 237
Summary 238
Chapter 8 Content Formatting with Regular
Expressions 241
Regular Expressions 242
String Replacement with Regular Expressions 247
Boldface and Italic Text 248
Paragraphs 249
Hyperlinks 252
Matching Tags 255
Putting It All Together 257
Real World Content Submission 260
Chapter 9 Cookies, Sessions, and Access
Control 261
Cookies 261
PHP Sessions 267
A Simple Shopping Cart 269
Access Control 279
Database Design 279
Controller Code 283
Function Library 290
The Sky's the Limit 311
Chapter io MySQL Administration 313
phpMyAdmin 314
Backing Up MySQL Databases 319
Database Backups Using mysqldump 319
Incremental Backups Using Binary Logs 321
MySQL Access Control 324
Granting Privileges 324
Revoking Privileges 328
Access Control Tips 329
Locked Out? 331
Checking and Repairing MySQL Data Files 332
Better Safe than Sorry 336
Chapter i i Advanced SQL Queries 337
Sorting SELECT Query Results 337
Setting LIMITS 340
LOCKing TABLES 341
Column and Table Name Aliases 344
GROUPing SELECT Results 347
LEFT JOINS 349
Limiting Results with HAVING 353
Further Reading 354
Chapter 12 Binary Data 357
Semi-dynamic Pages 358
Recording Uploaded Files in the Database 369
Binary Column Types 370
Storing Files 372
Viewing Stored Files 374
Putting It All Together 379
Large File Considerations 386
MySQL Packet Size 386
PHP Script Timeout 386
The End 387
Appendix A MySQL Syntax Reference 389
SQL Statements Implemented in MySQL 389
ALTER TABLE 389
ANALYZE TABLE 392
CREATE DATABASE 393
CREATE INDEX 393
CREATE TABLE 393
DELETE 395
DESCRIBE/DESC 396
DROP DATABASE 397
DROP INDEX 397
DROP TABLE 397
EXPLAIN 397
GRANT 398
INSERT 398
LOAD DATA INFILE 400
LOCK/UNLOCK TABLES 400
OPTIMIZE TABLE 401
REVOKE 403
SELECT 403
SET 410
SHOW 411
TRUNCATE 412
UNLOCK TABLES 412
UPDATE 413
USE 414
Appendix B MySQL Functions 415
Control Flow Functions 415
Mathematical Functions 416
String Functions 419
Date and Time Functions 423
Miscellaneous Functions 430
Functions for Use with GROUP BY Clauses 433
Appendix C MySQL Column Types 435
Numerical Types 436
Character Types 440
Date/Time Types 445
Appendix D PHP Functions for Working with
MySQL 449
Common PHP m y s q l i _ * Functions 449
mysqli_affected_rows 449
mysqli character set name 449
mysqli_connect_errno 451
mysqli_connect_error 451
mysqli_data_seek 451
mysqli_errno 452
mysqli_error 452
mysqli_f etch_all 452
mysqli_f etch_array 453
mysqli_f etch_assoc 453
mysqli_f etch_f ield 453
mysqli_fetch_field_direct 454
mysqli_f etch_f ields 454
mysqli_fetch_lengths 455
mysqli_f etch_obj ect 455
mysqli_f etch_row 455
mysqli_f ield_count 455
mysqli_f ield_seek 456
mysqli_f ield_tell 456
mysqli_f ree_result 456
mysqli_get_client_inf o 456
mysqli_get_client_version 456
mysqli_get_host_info 457
mysqli_get_proto_info 457
mysqli_get_server_info 457
mysqli_get_server_version 457
mysqli_info 457
mysqli_insert_id 458
mysqli_num_f ields 458
mysqli_num_rows 458
mysqli_real_escape_string 459
mysqli_real_query 459
mysqli_select_db 460
mysqli_set_charset 460
mysqli_stat 460
mysqli_store_result 460
mysqli_thread_id 461
mysqli_use_result 461
Index 463