Research Catalog

Title

PHP and MySQL Web development / Luke Welling and Laura Thomson.

Author

Welling, Luke, 1972-

Publication

Indianapolis, IN : Sams, c2001.

Items in the Library & Off-site

Holdings

Details

Additional Authors

Thomson, Laura

Description

xxii, 867 p. : ill.; 23 cm. +

Summary

Accompanying CD-ROM contains source code developed in the book, PHP 4 source code and binaries, MySQL source code and binaries, and Apache source code and binaries.

Subject

• PHP (Computer program language)
• SQL (Computer program language)
• Web sites > Design

Genre/Form

CD-ROMs.

Note

• Includes index.

Bibliography (note)

• Includes bibliographical references and index.

System Details (note)

• System requirements for accompanying computer disc: PC running Windows 95 or later, Windows NT 4 or later, Linux or Unix.

Processing Action (note)

• committed to retain

Contents

Why Use PHP and MySQL? 2 -- Some of PHP's Strengths 3 -- Some of MySQL's Strengths 4 -- How Is This Book Organized? 5 -- What's New in PHP Version 4? 6 -- Finally 6 -- Part I Using PHP 7 -- 1 PHP Crash Course 9 -- Using PHP 11 -- Sample Application: Bob's Auto Parts 11 -- Embedding PHP in HTML 13 -- Adding Dynamic Content 17 -- Accessing Form Variables 19 -- Identifiers 21 -- User-Declared Variables 22 -- Assigning Values to Variables 22 -- Variable Types 22 -- Constants 24 -- Variable Scope 25 -- Operators 25 -- Using Operators: Working Out the Form Totals 33 -- Precedence and Associativity: Evaluating Expressions 34 -- Variable Functions 36 -- Control Structures 38 -- Making Decisions with Conditionals 38 -- Iteration: Repeating Actions 43 -- Breaking Out of a Control Structure or Script 47 -- Next: Saving the Customer's Order 47 -- 2 Storing and Retrieving Data 49 -- Saving Data for Later 50 -- Storing and Retrieving Bob's Orders 50 -- Overview of File Processing 52 -- Opening a File 52 -- Writing to a File 57 -- Closing a File 58 -- Reading from a File 59 -- Other Useful File Functions 63 -- File Locking 65 -- Doing It a Better Way: Database Management Systems 66 -- 3 Using Arrays 69 -- What Is an Array? 70 -- Numerically Indexed Arrays 71 -- Associative Arrays 73 -- Multidimensional Arrays 75 -- Sorting Arrays 79 -- Sorting Multidimensional Arrays 80 -- Reordering Arrays 83 -- Loading Arrays from Files 85 -- Other Array Manipulations 88 -- 4 String Manipulation and Regular Expressions 93 -- Example Application: Smart Form Mail 94 -- Formatting Strings 96 -- Joining and Splitting Strings with String Functions 101 -- Comparing Strings 104 -- Matching and Replacing Substrings with String Functions 105 -- Introduction to Regular Expressions 109 -- Finding Substrings with Regular Expressions 114 -- Replacing Substrings with Regular Expressions 115 -- Splitting Strings with Regular Expressions 115 -- Comparison of String Functions and Regular Expression Functions 116 -- 5 Reusing Code and Writing Functions 117 -- Why Reuse Code? 118 -- Using require() and include() 119 -- Using require() for Web Site Templates 121 -- Using Functions in PHP 129 -- Why Should You Define Your Own Functions? 132 -- Basic Function Structure 132 -- Parameters 134 -- Pass by Reference Versus Pass by Value 138 -- Returning from Functions 140 -- Returning Values from Functions 141 -- Recursion 143 -- 6 Object-Oriented PHP 147 -- Object-Oriented Concepts 148 -- Creating Classes, Attributes, Operations in PHP 150 -- Instantiation 152 -- Using Class Attributes 152 -- Calling Class Operations 154 -- Implementing Inheritance in PHP 155 -- Designing Classes 158 -- Writing the Code for Your Class 159 -- Part II Using MySQL 169 -- 7 Designing Your Web Database 171 -- Relational Database Concepts 172 -- How to Design Your Web Database 176 -- Web Database Architecture 180 -- 8 Creating Your Web Database 183 -- A Note on Using the MySQL Monitor 185 -- How to Log In to MySQL 185 -- Creating Databases and Users 187 -- Users and Privileges 187 -- Introduction to MySQL's Privilege System 188 -- Setting Up a User for the Web 193 -- Using the Right Database 193 -- Creating Database Tables 194 -- MySQL Identifiers 199 -- Column Data Types 200 -- 9 Working with Your MySQL Database 207 -- What Is SQL? 208 -- Inserting Data into the Database 209 -- Retrieving Data from the Database 211 -- Updating Records in the Database 223 -- Altering Tables After Creation 223 -- Deleting Records from the Database 225 -- Dropping Tables 226 -- Dropping a Whole Database 226 -- 10 Accessing Your MySQL Database from the Web with PHP 227 -- How Web Database Architectures Work 228 -- Basic Steps in Querying a Database from the Web 232 -- Checking and Filtering7 Input Data 232 -- Setting Up a Connection 234 -- Choosing a Database to Use 235 -- Querying the Database 235 -- Retrieving the Query Results 236 -- Disconnecting from the Database 238 -- Putting New Information in the Database 238 -- Other Useful PHP-MySQL Functions 241 -- Other PHP-Database Interfaces 242 -- 11 Advanced MySQL 245 -- Understanding the Privilege System in Detail 246 -- Making Your MySQL Database Secure 251 -- Getting More Information About Databases 254 -- Speeding Up Queries with Indexes 261 -- General Optimization Tips 261 -- Different Table Types 263 -- Loading Data from a File 263 -- Part III E-commerce and Security 265 -- 12 Running an E-commerce Site 267 -- What Do You Want to Achieve? 268 -- Types of Commercial Web Sites 268 -- Risks and Threats 277 -- Deciding on a Strategy 280 -- Next 280 -- 13 E-commerce Security Issues 281 -- How Important Is Your Information? 282 -- Security Threats 283 -- Balancing Usability, Performance, Cost, and Security 290 -- Creating a Security Policy 291 -- Authentication Principles 291 -- Using Authentication 292 -- Encryption Basics 293 -- Private Key Encryption 294 -- Public Key Encryption 295 -- Digital Signatures 296 -- Digital Certificates 297 -- Secure Web Servers 298 -- Auditing and Logging 299 -- Firewalls 300 -- Backing Up Data 301 -- Physical Security 302 -- Next 302 -- 14 Implementing Authentication with PHP and MySQL 303 -- Identifying Visitors 304 -- Implementing Access Control 305 -- Basic Authentication 312 -- Using Basic Authentication in PHP 314 -- Using Basic Authentication with Apache's .htaccess Files 316 -- Using Basic Authentication with IIS 319 -- Using mod_auth_mysql Authentication 321 -- Creating Your Own Custom Authentication 324 -- 15 Implementing Secure Transactions with PHP and MySQL 327 -- Providing Secure Transactions 328 -- Using Secure Sockets Layer (SSL) 332 -- Screening User Input 336 -- Providing Secure Storage 336 -- Why Are You Storing Credit Card Numbers? 338 -- Using Encryption in PHP 338 -- Part IV Advanced PHP Techniques 349 -- 16 Interacting with the File System and the Server 351 -- Introduction to File Upload 352 -- Using Directory Functions 358 -- Interacting with the File System 361 -- Using Program Execution Functions 365 -- Interacting with the Environment: getenv() and putenv() 367 -- 17 Using Network and Protocol Functions 369 -- Overview of Protocols 370 -- Sending and Reading Email 371 -- Using Other Web Services 371 -- Using Network Lookup Functions 374 -- Using FTP 378 -- Generic Network Communications with cURL 387 -- 18 Managing the Date and Time 391 -- Getting the Date and Time from PHP 392 -- Converting Between PHP and MySQL Date Formats 396 -- Date Calculations 398 -- Using the Calendar Functions 399 -- 19 Generating Images 401 -- Setting Up Image Support in PHP 402 -- Image Formats 403 -- Creating Images 404 -- Using Automatically Generated Images in Other Pages 410 -- Using Text and Fonts to Create Images 410 -- Drawing Figures and Graphing Data 419 -- Other Image Functions 428 -- 20 Using Session Control in PHP 429 -- What Session Control Is 430 -- Basic Session Functionality 430 -- Implementing Simple Sessions 433 -- Simple Session Example 435 -- Configuring Session Control 437 -- Implementing Authentication with Session Control 438 -- 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 -- Loading Extensions Dynamically 453 -- Temporarily Altering the Runtime Environment 453 -- Source Highlighting 454 -- 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 -- Implementing Version Control 467 -- Choosing a Development Environment 469 -- Documenting Your Projects 470 -- Prototyping 471 -- Separating Logic and Content 471 -- Optimizing Code 472 -- Testing 474 -- 23 Debugging 477 -- Programming Errors 478 -- 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 -- 24 Building User Authentication and Personalization 497 -- Implementing the Database 502 -- Implementing the Basic Site 504 -- Implementing User Authentication 506 -- Implementing Bookmark Storage and Retrieval 526 -- Implementing Recommendations 532 -- Wrapping Up and Possible Extensions 537 -- 25 Building a Shopping Cart 539 -- Implementing the Database 546 -- Implementing the Online Catalog 548 -- Implementing the Shopping Cart 556 -- Implementing Payment 572 -- Implementing an Administration Interface 575 -- Extending the Project 584 -- Using an Existing System 584 -- 26 Building a Content Management System 587 -- Solution Requirements 588 -- Editing Content 589 -- Using Metadata 592 -- Formatting the Output 593 -- Image Manipulation 594 -- Solution Design/Overview 596 -- Designing the Database 598 -- Implementation 599 -- Extending the Project 615 -- 27 Building a Web-Based Email Service 617 -- Setting Up the Database 622 -- Script Architecture 623 -- Logging In and Out 629 -- Setting Up Accounts 632 -- Reading Mail 637 -- Sending Mail 649 -- Extending the Project 652 -- 28 Building a Mailing List Manager 655 -- File Upload 657 -- Sending Mail with Attachments 658 -- Solution Overview 658 -- Setting Up the Database 660 -- Script Architecture 663.

ISBN

0672317842 (pbk.)

LCCN

^^^99064841^

OCLC

46762860

Owning Institutions

Harvard Library