CART

(0) items

Php Programming with MySQL,9780619216870
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Php Programming with MySQL

by
Edition:
1st
ISBN13:

9780619216870

ISBN10:
0619216875
Format:
Paperback
Pub. Date:
12/26/2005
Publisher(s):
Course Technology
List Price: $168.33

Buy Used Textbook

(Recommended)
Usually Ships in 2-3 Business Days
U9780619216870
$117.83

Rent Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

New Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $0.01
See Prices

Questions About This Book?

What version or edition is this?
This is the 1st edition with a publication date of 12/26/2005.
What is included with this book?
  • The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.

Related Products


  • PHP Programming with MySQL The Web Technologies Series
    PHP Programming with MySQL The Web Technologies Series
  • PHP Programming with MySQL: The Web Technology Series, 2nd Edition
    PHP Programming with MySQL: The Web Technology Series, 2nd Edition




Summary

PHP Programming with MySQL, by Don Gosselin is the first true academic textbook in the market to combine PHP with MySQL. This book covers one of the fastest growing technology combinations for developing interactive Web sites. With growth attributed to its open-source nature and usability amongst non-programmers, this text is accessible to users with little programming or database experience and suits personal Web development projects, as well as small to medium business Web development needs.

Table of Contents

Preface xix
Introduction to Web Development
1(50)
The World Wide Web
2(14)
HTML Documents
3(1)
Basic HTML Syntax
4(3)
Creating an HTML Document
7(3)
Web Communication Protocols
10(2)
Publishing Your Web Site
12(4)
Working with Well-Formed Web Pages
16(16)
XHTML Document Type Definitions (DTDs)
17(3)
Writing Well-Formed Documents
20(2)
Cascading Style Sheets
22(7)
The Content-Type <meta> Element
29(1)
Validating Web Pages
30(2)
Understanding Web Development
32(7)
Client/Server Architecture
32(2)
JavaScript and Client-Side Scripting
34(2)
Server-Side Scripting and PHP
36(2)
Should You Use Client-Side or Server-Side Scripting?
38(1)
Chapter Summary
39(1)
Review Questions
40(4)
Hands-On Projects
44(5)
Case Projects
49(2)
Getting Started with PHP
51(56)
Building a Web Development Environment
52(4)
Understanding Binary and Source Code Installations
53(1)
Getting Help
54(2)
Installing and Configuring a Web Server
56(12)
Installing and Running Apache on UNIX and Linux
57(1)
Installing and Running Apache on Windows
58(2)
Installing and Running Internet Information Services on Windows
60(1)
Testing Your Web Server
61(3)
Configuring Apache
64(2)
Configuring Internet Information Services
66(2)
Installing PHP
68(5)
Installing PHP on UNIX and Linux Systems Running Apache
69(1)
Installing PHP on Windows Running Apache or IIS
70(1)
Configuring Apache for PHP
71(1)
Configuring PHP
72(1)
Installing and Running MySQL
73(6)
Installing and Running MySQL on UNIX and Linux
73(3)
Installing MySQL on Windows
76(2)
Testing the MySQL Server
78(1)
Creating Basic PHP Scripts
79(20)
Creating PHP Code Blocks
80(8)
Understanding Functions
88(1)
Displaying Script Results
89(5)
Creating Multiple Code Declaration Blocks
94(3)
Case Sensitivity in PHP
97(1)
Adding Comments to a PHP Script
98(1)
Chapter Summary
99(1)
Review Questions
100(2)
Hands-On Projects
102(3)
Case Projects
105(2)
Working with Data Types and Operators
107(50)
Using Variables and Constants
108(7)
Naming Variables
108(1)
Declaring and Initializing Variables
108(1)
Displaying Variables
109(2)
Modifying Variables
111(2)
Defining Constants
113(2)
Working with Data Types
115(10)
Numeric Data Types
117(1)
Boolean Values
118(1)
Arrays
119(6)
Building Expressions
125(19)
Arithmetic Operators
126(8)
Assignment Operators
134(3)
Comparison and Conditional Operators
137(4)
Logical Operators
141(3)
Special Operators
144(1)
Type Casting
144(3)
Understanding Operator Precedence
147(1)
Chapter Summary
148(1)
Review Questions
149(3)
Hands-On Projects
152(3)
Case Projects
155(2)
Functions and Control Structures
157(50)
Working with Functions
158(4)
Defining Functions
158(1)
Calling Functions
159(1)
Returning Values
160(2)
Understanding Variable Scope
162(8)
The global Keyword
163(1)
Using Autoglobals
164(6)
Making Decisions
170(13)
if Statements
171(3)
if...else Statements
174(2)
Nested if and if...else Statements
176(3)
switch Statements
179(4)
Repeating Code
183(12)
while Statements
183(5)
do...while Statements
188(2)
for Statements
190(3)
foreach Statements
193(2)
Chapter Summary
195(1)
Review Questions
196(3)
Hands-On Projects
199(5)
Case Projects
204(3)
Manipulating Strings
207(50)
Constructing Text Strings
208(10)
Working with String Operators
212(1)
Adding Escape Characters and Sequences
213(3)
Simple and Complex String Syntax
216(2)
Parsing Strings
218(14)
Counting Characters and Words in a String
218(2)
Finding and Extracting Characters and Substrings
220(4)
Replacing Characters and Substrings
224(2)
Dividing Strings into Smaller Pieces
226(4)
Converting Between Strings and Arrays
230(2)
Comparing Strings
232(6)
String Comparison Functions
234(3)
Determining the Similarity of Two Strings
237(1)
Determining if Words Are Pronounced Similarly
237(1)
Handling Form Submissions
238(5)
Using a Single Script to Display and Process a Form
239(1)
Validating Submitted Data
240(3)
Chapter Summary
243(1)
Review Questions
244(2)
Hands-On Projects
246(9)
Case Projects
255(2)
Working with Files and Directories
257(54)
Opening and Closing File Streams
258(6)
Opening a File Stream
258(5)
Closing a File Stream
263(1)
Writing Data to Files
264(14)
Writing an Entire File
265(5)
Handling Magic Quotes
270(3)
Writing Data Incrementally
273(2)
Locking Files
275(3)
Reading Data from Files
278(8)
Reading an Entire File
278(5)
Reading Data Incrementally
283(3)
Managing Files and Directories
286(12)
Working with Directories
286(4)
Obtaining File and Directory Information
290(4)
Copying and Moving Files
294(2)
Renaming Files and Directories
296(1)
Removing Files and Directories
296(2)
Chapter Summary
298(1)
Review Questions
299(3)
Hands-On Projects
302(6)
Case Projects
308(3)
Manipulating Arrays
311(52)
Manipulating Elements
312(13)
Adding and Removing Elements from the Beginning of an Array
315(2)
Adding and Removing Elements from the End of an Array
317(2)
Adding and Removing Elements Within an Array
319(3)
Removing Duplicate Elements
322(3)
Declaring and Initializing Associative Arrays
325(4)
Iterating Through an Array
329(3)
Finding and Extracting Elements and Values
332(5)
Determining if a Value Exists
332(3)
Determining if a Key Exists
335(1)
Returning a Portion of an Array
336(1)
Manipulating Arrays
337(9)
Sorting Arrays
337(5)
Combining Arrays
342(2)
Comparing Arrays
344(2)
Understanding Multidimensional Arrays
346(8)
Creating Two-Dimensional Indexed Arrays
346(4)
Creating Two-Dimensional Associative Arrays
350(1)
Creating Multidimensional Arrays with a Single Statement
351(1)
Working with Additional Dimensions
352(2)
Chapter Summary
354(1)
Review Questions
355(2)
Hands-On Projects
357(4)
Case Projects
361(2)
Working with Databases and MySQL
363(54)
Introduction to Databases
364(10)
Understanding Relational Databases
365(4)
Working with Database Management Systems
369(4)
Querying Databases with Structured Query Language
373(1)
Getting Started with MySQL
374(9)
Logging in to MySQL
375(3)
Working with the MySQL Monitor
378(2)
Understanding MySQL Identifiers
380(1)
Getting Help with MySQL Commands
381(2)
Working with MySQL Databases
383(4)
Selecting a Database
383(2)
Creating Databases
385(1)
Deleting Databases
386(1)
Managing User Accounts
387(7)
Securing the Initial MySQL Accounts
387(2)
Creating Users
389(4)
Deleting Users
393(1)
Defining Tables
394(4)
Specifying Field Data Types
394(1)
Creating Tables
395(2)
Deleting Tables
397(1)
Working with Records
398(10)
Adding Records
398(2)
Retrieving Records
400(1)
Sorting Query Results
401(3)
Filtering Query Results
404(2)
Updating Records
406(1)
Deleting Records
407(1)
Chapter Summary
408(1)
Review Questions
409(3)
Hands-On Projects
412(3)
Case Projects
415(2)
Manipulating MySQL Databases with PHP
417(60)
Connecting to MySQL with PHP
418(6)
Enabling MySQL Support in PHP
418(2)
Opening and Closing a MySQL Connection
420(3)
Selecting a Database
423(1)
Handling MySQL Errors
424(10)
Suppressing Errors with the Error Control Operator
427(1)
Terminating Script Execution
428(2)
Reporting MySQL Errors
430(4)
Executing SQL Statements
434(9)
Working with Query Results
436(5)
Accessing Query Result Information
441(1)
Closing Query Results
442(1)
Working with Databases and Tables
443(8)
Creating and Deleting Databases
443(4)
Creating and Deleting Tables
447(4)
Manipulating Records
451(14)
Adding, Deleting, and Updating Records
451(11)
Returning Information on Affected Records
462(3)
Chapter Summary
465(1)
Review Questions
466(3)
Hands-On Projects
469(5)
Case Projects
474(3)
Managing State Information
477(48)
Understanding State Information
478(6)
Using Hidden Form Fields to Save State Information
484(6)
Using Query Strings to Save State Information
490(2)
Using Cookies to Save State Information
492(14)
Creating Cookies
492(1)
The name and value Arguments
493(4)
The expires Argument
497(2)
The path Argument
499(1)
The domain Argument
500(1)
The secure Argument
500(1)
Reading Cookies
500(6)
Deleting Cookies
506(1)
Using Sessions to Save State Information
506(8)
Starting a Session
507(1)
Working with Session Variables
508(4)
Deleting a Session
512(2)
Chapter Summary
514(1)
Review Questions
515(2)
Hands-On Projects
517(6)
Case Projects
523(2)
Developing Object-Oriented PHP
525(54)
Introduction to Object-Oriented Programming
526(5)
Understanding Encapsulation
527(1)
Object-Oriented Programming and Classes
528(3)
Using Objects in PHP Scripts
531(16)
Working with Database Connections as Objects
533(8)
Defining Custom PHP Classes
541(5)
Collecting Garbage
546(1)
Declaring Data Members
547(5)
What Is Information Hiding?
547(1)
Using Access Specifiers
548(2)
Serializing Objects
550(2)
Working with Member Functions
552(14)
Initializing with Constructor Functions
553(2)
Cleaning Up with Destructor Functions
555(1)
Writing Accessor Functions
556(4)
Serializing Functions
560(6)
Chapter Summary
566(1)
Review Questions
567(2)
Hands-On Projects
569(8)
Case Projects
577(2)
Error Handling and Debugging
579(48)
Understanding Logic and Debugging
580(4)
Syntax Errors
582(1)
Run-Time Errors
582(1)
Logic Errors
583(1)
Handling and Reporting Errors
584(16)
Printing Errors to the Web Browser
590(1)
Setting the Error Reporting Level
591(1)
Logging Errors to a File
592(2)
Implementing Custom Error Handling
594(6)
Using Basic Debugging Techniques
600(15)
Examining Your Code
600(4)
Tracing Errors with echo ( ) Statements
604(6)
Using Comments to Locate Bugs
610(1)
Combining Debugging Techniques
611(2)
Analyzing Logic
613(2)
Chapter Summary
615(1)
Review Questions
616(3)
Hands-On Projects
619(5)
Case Projects
624(3)
APPENDIX A Working with Regular Expressions
627(12)
Understanding Regular Expressions
627(2)
Writing Regular Expression Patterns
629(1)
Matching Any Character
630(1)
Matching Characters at the Beginning or End of a String
631(1)
Matching Special Characters
631(1)
Specifying Quantity
632(1)
Specifying Subexpressions
633(1)
Defining Character Classes
634(3)
Matching Multiple Pattern Choices
637(2)
APPENDIX B Formatting Strings
639(8)
Using the printf() and sprintf() Functions
639(1)
Specifying Types
640(1)
Determining Decimal Number Precision
641(1)
Specifying Padding
642(2)
Formatting Numbers
644(1)
Formatting Alignment
645(2)
APPENDIX C Processing XML
647(16)
The Basics of XML
647(1)
The XML Declaration
648(1)
Parsing XML Documents
649(1)
Writing Well-Formed Documents
650(4)
All XML Documents Must Have a Root Element
650(1)
XML Is Case Sensitive
651(1)
All XML Elements Must Have Closing Tags
651(1)
XML Elements Must Be Properly Nested
652(1)
Attribute Values Must Appear Within Quotation Marks
653(1)
Empty Elements Must Be Closed
654(1)
Generating XML with PHP
654(4)
Parsing XML with SimpleXML Functions
658(5)
APPENDIX D Secure Coding with PHP
663(1)
Understanding PHP Security Issues
663(1)
Disabling the register_globals Directive
664(1)
Validating Submitted Form Data
664(1)
Using Sessions to Validate User Identities
665(1)
Storing Code in External Files
665(1)
Accessing Databases Through a Proxy User
666(1)
Handling Magic Quotes
666(1)
Reporting Errors
667


Please wait while the item is added to your cart...