This book teaches how to develop dynamic Web sites with PHP and MySQL, covering the
knowledge that most developers require. The information is discussed using a step-by-step
approach with corresponding images. The focus is on real-world, practical examples.
This book is written for a wide range of people within the beginner-to-intermediate range.
This book does not formally teach HTML or Web-page design, so experience with HTML is
helpful. The book does teach PHP and MySQL from A to Z, covering everything you'll need
to know to develop real-world Web sites.
Chapter 1 Introduction to PHP
• Basic Syntax
• Sending Data to the Web Browser
• Writing Comments
• What Are Variables?
• Introducing Strings
• Concatenating Strings
• Introducing Numbers
• Introducing Constants
• Single vs. Double Quotation Marks
• Basic Debugging Steps
Chapter 2 Programming with PHP
• Creating an HTML Form
• Handling an HTML Form
• Conditions and Operators
• Validating Form Data
• Introducing Arrays
• For and While Loops
Chapter 3 Creating Dynamic Web Sites
• Including Multiple Files
• Handling HTML Forms Revisited
• Making Sticky Forms
• Creating Your Own Functions
Chapter 4 Introduction to MySQL
• Naming Database Elements
• Choosing Your Column Types
• Choosing Other Column Properties
• Accessing MySQL
Chapter 5 Introduction to SQL
• Creating Databases and Tables
• Inserting Records
• Selecting Data
• Using Conditionals
• Using LIKE and NOT LIKE
• Sorting Query Results
• Limiting Query Results
• Updating Data
• Deleting Data
• Using Functions
Chapter 6 Database Design
• Normalization
• Creating Indexes
• Using Different Table Types
• Languages and MySQL
• Time Zones and MYSQL
• Foreign Key Constraints
Chapter 7 Advanced SQL and MySQL
• Performing Joins
• Grouping Selected Results
• Advanced Selections
• Performing FULLTEXT Searches
• Optimizing Queries
• Performing Transactions
• Data Encryption
Chapter 8 Error Handling and Debugging
• Error Types and Basic Debugging
• Displaying PHP Errors
• Adjusting Error Reporting in PHP
• Creating Custom Error Handlers
• PHP Debugging Techniques
• SQL and MySQL Debugging Techniques
Chapter 9 Using PHP with MySQL
• Modifying the Template
• Connecting to MySQL
• Executing Simple Queries
• Retrieving Query Results
• Ensuring Secure SQL
• Counting Returned Records
• Updating Records with PHP
Chapter 10 Common Programming Techniques
• Sending Values to a Script
• Using Hidden Form Inputs
• Editing Existing Records
• Paginating Query Results
• Making Sortable Displays
Chapter 11 Web Application Development
• Sending Email
• Handling File Uploads
• PHP and JavaScript
• Understanding HTTP Headers
• Date and Time Functions
Chapter 12 Cookies and Sessions
• Making a Login Page
• Making the Login Functions
• Using Cookies
• Using Sessions
• Improving Session Security
Chapter 13 Security Methods
• Preventing Spam
• Validating Data by Type
• Validating Files by Type
• Preventing XSS Attacks
• Using the Filter Extension
• Preventing SQL Injection Attacks
Chapter 14 Perl-Compatible Regular Expressions
• Creating a Test Script
• Defining Simple Patterns
• Using Quantifiers
• Using Character Classes
• Finding All Matches
• Using Modifiers
• Matching and Replacing Patterns
Chapter 15 Introducing jQuery
• What is jQuery?
• Incorporating jQuery
• Using jQuery
• Selecting Page Elements
• Event Handling
• Using Ajax
Chapter 16 An OOP Primer
• Fundamentals and Syntax
• Working with MySQL
• The DateTime Class
Chapter 17 Example - Message Board
• Making the Database
• Creating the Index Page
• Creating the Forum Page
• Creating the Thread Page
• Posting Messages
Chapter 18 Example - User Registration
• Creating the Templates
• Writing the Configuration Scripts
• Creating the Home Page
• Registration
• Activating an Account
• Logging in and Logging Out
• Password Management
Chapter 19 Example - E-Commerce
• Creating the Database
• The Administrative Site
• Creating the Public Template
• The Product catalog
• The Shopping Cart
• Recording the Orders
A reader says, "This book is well written and expertly explains what one needs to know
to get started with PHP and MySQL. The book assumes you know basic Web Development (HTML and CSS)
and having a good understanding of javascript will certainly be helpful. The book starts
off with PHP fundamentals ... then introduces MySQL fundamentals ... then SQL. It then
brings it all together using PHP to work with MySQL, which is the purpose of the book.
"The examples are very practical as the concepts⁄code that is used can be seen as
general templates necessary for any database website development. If you are new to PHP
and⁄or MySQL this book will certainly be a good tool for getting you on to the
right track. I am glad I bought it."
About BTH
User Agreement
Privacy
Site Map
Contact
News Feeds
RSS Feed
Follow @Stephen Bucaro
Active Server Pages
