PHP与MySQL Web开发权威指南：从新手到专家

3星 · 超过75%的资源需积分: 12 7 浏览量更新于2024-07-24 收藏 7.06MB PDF 举报

《PHP与MySQL Web Development》是由Luke Welling和Laura Thomson合著的一本英文原版教材，专为Web开发人员设计，不论你是初学者还是高级开发者，都能在本书中找到丰富的学习资源。该书出版于2001年，由Sams Publishing公司发行，享有版权保护，未经授权，任何形式的复制、存储或传输都必须获得书面许可。书中深入讲解了PHP（Hypertext Preprocessor）语言和MySQL数据库的集成应用，是web开发领域的一部经典之作。它旨在帮助读者理解如何通过这两种技术构建动态网站，实现数据交互和管理。PHP作为服务器端脚本语言，常用于创建动态网页和网站应用程序，而MySQL则是一种流行的开源关系型数据库管理系统，支持高效的数据处理和查询。作者在书中详细阐述了PHP的基础语法、数据类型、变量、控制结构、函数、数组、字符串操作等内容，确保读者能够扎实地掌握编程基础。同时，还将涵盖MySQL的安装、配置、SQL查询、数据表设计、事务处理等关键知识点，使读者能够有效地与数据库进行交互。书中特别强调了安全性和最佳实践，如防止SQL注入、密码加密、数据验证等，以确保开发出健壮和安全的web应用。此外，还会介绍一些Web开发框架和工具，帮助读者了解如何利用这些工具提升开发效率。版权页的信息包括国际标准书号(ISBN)0-672-31784-2和美国国会图书馆编目号LC Catalog Card Number 99-64841，表明此书已通过官方审核。印刷方面，本书首次印刷日期为2001年3月，印制地在美国。对于商标，书中提到的所有知名商标和服务标记已正确标注，但Sams Publishing并未保证所有提及的信息准确性，用户在使用时需自行确认。《PHP与MySQL Web Development》是一本实用且权威的教程，无论是对于初学者还是希望提升技能的专业人士，都是学习现代Web开发不可或缺的参考资料。通过学习这本书，读者将建立起坚实的PHP和MySQL基础，为进一步开发高质量的网络应用打下坚实的基础。

PHP AND MYSQL WEB DEVELOPMENT

Converting Between PHP and MySQL Date Formats ......................396

Date Calculations ................................................................................398

Using the Calendar Functions ............................................................399

Further Reading ..................................................................................400

Next ....................................................................................................400

19 Generating Images 401

Setting Up Image Support in PHP ......................................................402

Image Formats ....................................................................................403

JPEG ..............................................................................................403

PNG ..............................................................................................403

WBMP ..........................................................................................403

GIF ................................................................................................404

Creating Images ..................................................................................404

Creating a Canvas Image ..............................................................405

Drawing or Printing Text onto the Image ....................................406

Outputting the Final Graphic ........................................................408

Cleaning Up ..................................................................................410

Using Automatically Generated Images in Other Pages ....................410

Using Text and Fonts to Create Images ..............................................410

Setting Up the Base Canvas ..........................................................414

Fitting the Text onto the Button ....................................................415

Positioning the Text ......................................................................418

Writing the Text onto the Button ..................................................419

Finishing Up ..................................................................................419

Drawing Figures and Graphing Data ..................................................419

Other Image Functions ......................................................................428

Further Reading ..................................................................................428

Next ....................................................................................................428

20 Using Session Control in PHP 429

What Session Control Is ....................................................................430

Basic Session Functionality ................................................................430

What Is a Cookie? ........................................................................431

Setting Cookies from PHP ............................................................431

Using Cookies with Sessions ........................................................432

Storing the Session ID ..................................................................432

Implementing Simple Sessions ..........................................................433

Starting a Session ..........................................................................433

Registering Session Variables ........................................................433

Using Session Variables ................................................................434

Deregistering Variables and Destroying the Session ....................434

xvi

00 7842 FM 3/6/01 3:38 PM Page xvi

CONTENTS

Simple Session Example ....................................................................435

Configuring Session Control ..............................................................437

Implementing Authentication with Session Control ..........................438

Further Reading ..................................................................................445

Next ....................................................................................................445

21 Other Useful Features 447

Using Magic Quotes ..........................................................................448

Evaluating Strings: eval() ..................................................................449

Terminating Execution: die and exit ..................................................450

Serialization ........................................................................................450

Getting Information About the PHP Environment ............................451

Finding Out What Extensions Are Loaded ..................................451

Identifying the Script Owner ........................................................452

Finding Out When the Script Was Modified ................................452

Loading Extensions Dynamically ......................................................453

Temporarily Altering the Runtime Environment ................................453

Source Highlighting ............................................................................454

Next ....................................................................................................455

PART V Building Practical PHP and MySQL Projects 457

22 Using PHP and MySQL for Large Projects 459

Applying Software Engineering to Web Development ......................460

Planning and Running a Web Application Project ............................461

Reusing Code ......................................................................................462

Writing Maintainable Code ................................................................463

Coding Standards ..........................................................................463

Breaking Up Code ........................................................................466

Using a Standard Directory Structure ..........................................467

Documenting and Sharing In-House Functions ............................467

Implementing Version Control ............................................................467

Choosing a Development Environment ..............................................469

Documenting Your Projects ................................................................470

Prototyping ..........................................................................................471

Separating Logic and Content ............................................................471

Optimizing Code ................................................................................472

Using Simple Optimizations ........................................................472

Using Zend Products ....................................................................473

Testing ................................................................................................474

Further Reading ..................................................................................475

Next ....................................................................................................475

xvii

00 7842 FM 3/6/01 3:38 PM Page xvii

PHP AND MYSQL WEB DEVELOPMENT

23 Debugging 477

Programming Errors ..........................................................................478

Syntax Errors ................................................................................478

Runtime Errors ..............................................................................480

Logic Errors ..................................................................................485

Variable Debugging Aid ....................................................................486

Error Reporting Levels ......................................................................489

Altering the Error Reporting Settings ................................................490

Triggering Your Own Errors ..............................................................492

Handling Errors Gracefully ................................................................492

Remote Debugging ............................................................................494

Next ....................................................................................................495

24 Building User Authentication and Personalization 497

The Problem ........................................................................................498

Solution Components ..........................................................................499

User Identification and Personalization ........................................499

Storing Bookmarks ........................................................................500

Recommending Bookmarks ..........................................................500

Solution Overview ..............................................................................500

Implementing the Database ................................................................502

Implementing the Basic Site ..............................................................504

Implementing User Authentication ....................................................506

Registering ....................................................................................507

Logging In ....................................................................................513

Logging Out ..................................................................................517

Changing Passwords ......................................................................518

Resetting Forgotten Passwords ......................................................521

Implementing Bookmark Storage and Retrieval ................................526

Adding Bookmarks ........................................................................526

Displaying Bookmarks ..................................................................529

Deleting Bookmarks ......................................................................530

Implementing Recommendations ......................................................532

Wrapping Up and Possible Extensions ..............................................537

Next ....................................................................................................537

25 Building a Shopping Cart 539

The Problem ........................................................................................540

Solution Components ..........................................................................540

Building an Online Catalog ..........................................................540

Tracking a User’s Purchases While She Shops ............................541

Payment ........................................................................................541

Administration Interface ................................................................542

xviii

00 7842 FM 3/6/01 3:38 PM Page xviii

CONTENTS

Solution Overview ..............................................................................542

Implementing the Database ................................................................546

Implementing the Online Catalog ......................................................548

Listing Categories ..........................................................................551

Listing Books in a Category ..........................................................553

Showing Book Details ..................................................................555

Implementing the Shopping Cart ........................................................556

Using the show_cart.php Script ....................................................557

Viewing the Cart ............................................................................560

Adding Items to the Cart ..............................................................563

Saving the Updated Cart ..............................................................565

Printing a Header Bar Summary ..................................................566

Checking Out ................................................................................566

Implementing Payment ......................................................................572

Implementing an Administration Interface ........................................575

Extending the Project ..........................................................................584

Using an Existing System ..................................................................584

Next ....................................................................................................585

26 Building a Content Management System 587

The Problem ........................................................................................588

Solution Requirements ........................................................................588

Editing Content ..................................................................................589

Getting Content into the System ..................................................589

Databases Versus File Storage ......................................................591

Document Structure ......................................................................592

Using Metadata ..................................................................................592

Formatting the Output ........................................................................593

Image Manipulation ............................................................................594

Solution Design/Overview ..................................................................596

Designing the Database ......................................................................598

Implementation ..................................................................................599

Front End ......................................................................................599

Back End ......................................................................................603

Searching ......................................................................................611

Editor Screen ................................................................................614

Extending the Project ..........................................................................615

27 Building a Web-Based Email Service 617

The Problem ........................................................................................618

Solution Components ..........................................................................619

Solution Overview ..............................................................................620

Setting Up the Database ....................................................................622

xix

00 7842 FM 3/6/01 3:38 PM Page xix

PHP AND MYSQL WEB DEVELOPMENT

Script Architecture ..............................................................................623

Logging In and Out ............................................................................629

Setting Up Accounts ..........................................................................632

Creating a New Account ..............................................................634

Modifying an Existing Account ....................................................636

Deleting an Account ......................................................................636

Reading Mail ......................................................................................637

Selecting an Account ....................................................................637

Viewing Mailbox Contents ............................................................640

Reading a Mail Message ..............................................................643

Viewing Message Headers ............................................................647

Deleting Mail ................................................................................648

Sending Mail ......................................................................................649

Sending a New Message ..............................................................649

Replying To or Forwarding Mail ..................................................651

Extending the Project ..........................................................................652

Next ....................................................................................................653

28 Building a Mailing List Manager 655

The Problem ........................................................................................656

Solution Components ..........................................................................657

Setting Up a Database of Lists and Subscribers ..........................657

File Upload ........................................................................................657

Sending Mail with Attachments ........................................................658

Solution Overview ..............................................................................658

Setting Up the Database ....................................................................660

Script Architecture ..............................................................................663

Implementing Login ..........................................................................672

Creating a New Account ..............................................................673

Logging In ....................................................................................675

Implementing User Functions ............................................................678

Viewing Lists ................................................................................679

Viewing List Information ..............................................................684

Viewing List Archives ..................................................................686

Subscribing and Unsubscribing ....................................................687

Changing Account Settings ..........................................................689

Changing Passwords ......................................................................689

Logging Out ..................................................................................692

Implementing Administrative Functions ............................................693

Creating a New List ......................................................................693

Uploading a New Newsletter ........................................................695

Handling Multiple File Upload ....................................................698

00 7842 FM 3/6/01 3:38 PM Page xx

剩余892页未读，继续阅读

s742150114

粉丝: 0
资源: 8

PHP与MySQL Web开发权威指南：从新手到专家

PHP和MySQL Web Development第五版(2016)原版完整英文版

php and mysql web开发源代码

php和mysql web开发

php和mysql web开发(第四版)

php和mysqlweb开发 源码

php图书管理系统的参考文献

php和mysql web开发(原书第5版)pdf

[美] 卢克·韦林),劳拉·汤姆森.php和mysql web开发:机械工业出版社 ,2018.2

php mysql 英文教材

mysql web可视化

最新资源

php和mysqlweb开发源码