Welcome to Bucaro TecHelp!

Bucaro TecHelp
Maintain Your Computer and Use it More Effectively
to Design a Web Site and Make Money on the Web

About Bucaro TecHelp About BTH User Agreement User Agreement Privacy Policy Privacy Site Map Site Map Contact Bucaro TecHelp Contact RSS News Feeds News Feeds

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites

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."

Click here for more information.

RSS Feed RSS Feed

Follow Stephen Bucaro Follow @Stephen Bucaro

Fire HD
[Site User Agreement] [Privacy Policy] [Site map] [Search This Site] [Contact Form]
Copyright©2001-2018 Bucaro TecHelp 13771 N Fountain Hills Blvd Suite 114-248 Fountain Hills, AZ 85268