Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Marty Matthews
PHP and MySQL Web Development: A Beginner’s Guide
Cover
Title Page
Copyright Page
Dedication
Contents at a Glance
Contents
Acknowledgments
Introduction
Part I Getting Ready
1 Setting Up Your Workstation
Picking a Development Tool
Full-Featured Development Packages
Powerful Alternatives
Choosing a Testing Server
Testing Environment
Using Testing Browsers
Considering Other Factors
2 Building Web Pages with HTML
HTML5
Using HTML5
Setting Up Aptana
Reviewing HTML
Using Basic Tags
Using Global Attributes
Setting Paragraph Styles
Applying Character Styles
Displaying Special Characters
Working with Images and Image Maps
Adding Hyperlinks and Bookmarks
Defining Forms
Creating Tables
Using New HTML5 Tags
Understanding Deprecated HTML Tags
HTML Authoring Resources
3 Styling with CSS
Creating CSS
Attaching CSS
Understanding CSS Rules
Selecting What to Format
CSS Properties and Values
Applying CSS Concepts
Using Text Properties
Implementing Page Properties
Laying Out with CSS
4 Adding Dynamic Elements with JavaScript
Introducing JavaScript
Characteristics of JavaScript
JavaScript Introduction
Using JavaScript with HTML Pages
JavaScript Basics
Writing and Testing JavaScript
Parts of JavaScript
Variables and Constants
Operators
Statements and Expressions
Functions
Objects
Control Structures
If/Else Statements
While and Do-While Statements
For Statement
Switch Statements
Introducing Event Handlers
Placing Event Handlers in Your Code
Understanding Event Handler Syntax and Usage
Working with the Window Event Handlers
Displaying Messages When a Page Opens/Closes
Placing and Removing Focus
Resizing a Window
Using the Mouse and Keyboard Event Handlers
Working with onclick, ondblclick, and Arrays
Moving the Mouse Pointer to Trigger Events
Using the Keyboard Event Handlers
Reviewing Forms
Understanding Forms
Creating Forms Using HTML
Using JavaScript in Forms
Naming Forms on a Web Page
Form Properties and Methods
Working with Form Element Properties and Methods
Validating a Form
Understanding Validation
Using Validation with Passwords
Part II Exercising the Server with PHP
5 Fundamentals of PHP
About PHP
Tools Needed for PHP
Preparing a PHP Workstation
PHP Introduction
Integrating PHP with HTML
Writing and Testing PHP
PHP Basics
Parts of PHP
Types of Information
Variables and Constants
Operators
Statements and Expressions
Functions
6 PHP Control and File Handling
Control Structures
if/else Statements
while and do-while Statements
for and foreach Statements
switch Statements
PHP File and Directory Management
Basic File Functions
Additional File Functions
Cookies and Session and Server Variables
Session Variables
Cookies
Server Variables
7 PHP Arrays and Forms
Using Arrays
Creating Arrays
Working with Arrays
Looping Through Arrays
Sorting Arrays
Navigating in Arrays
Converting Arrays To and From Strings
Joining and Splitting Arrays
Comparing Arrays
Handling Multidimensional Arrays
Building and Handling Forms
Create a Form in HTML
Add JavaScript to a Form
Accepting and Filing Form Data in PHP
8 Putting PHP to Use
User Authentication
Create an Index Script
Add Registration Scripts
Insert Sign-In Scripts
Attach a Site Page
Part III Creating and Using Relational Databases with MySQL
9 Introduction to Relational Databases
Databases and Relational Databases
Understanding Databases
Understanding a Relational Database
Using phpMyAdmin
Get and Install phpMyAdmin
Opening and Exploring phpMyAdmin
Create and Use a Database in phpMyAdmin
10 Fundamentals of MySQL and SQL
About MySQL
Installing and Using MySQL Workbench
Understanding SQL
Using MySQL
Exploring the MySQL Language
Reviewing MySQL Word Usage
Using MySQL Operators
Exploring MySQL Functions
11 Implementing MySQL Command Statements
MySQL Commands
Understanding the MySQL Command Structure
Preparing the MySQL Workbench
Create Databases and Tables
Creating and Using a Database
Creating a Table and Its Columns
Reviewing MySQL Data Types
Insert Data into Tables
Inserting Data
Select, Replace, Update, and Delete Data in Tables
Selecting Data
Replacing Data
Updating Data
Deleting Data
Alter, Rename, and Drop Tables and Databases
Altering Tables and Databases
Renaming Tables
Dropping Tables and Databases
Create and Use Events, Views, and Triggers
Using Events
Using Views
Using Triggers
Part IV Powering Databases with MySQL and PHP
12 Using a MySQL Database with PHP
Bringing PHP and MySQL Together
Database Manipulation
Database Information
Database Administration
Combining PHP MySQL Functions
Working with Forms and Databases
Expanding PHP Form Handling
Facilitating User Interaction
Interacting with a Database
Improving Security
13 Registering and Responding to Users
Application Design
Design Template and CSS
Database Design
Creating the Scripts
Administrator Authentication
Database Entry and Maintenance
14 Handling Online Purchases
Application Design
Design Template and CSS
Database Design
Creating the Book List and Customer Sales Scripts
Book List and Selection
Customer Sign-in and Verification
Sales and Confirmation
Invoicing
Building an Invoice
Deleting Sales
Writing an Invoice Record
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
PHP and MySQL Web Development: A Beginner’s Guide
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset