INTRODUCTION
Using MySQL for database design
The Apache web server
The PHP programming environment
Overview of SQL - Structured Query Language
Installing Apache, PHP and MySQL
OVERVIEW OF PHP
The PHP Info function
Embedding PHP in web pages
Sending output to the browser
Manipulating strings
Adding comments
The heredoc syntax
WORKING WITH VARIABLES
Double and single quotes
Variables and heredoc
Initialising Variables
Setting Server Variables
OPERATORS
Arithmetic operators
Comparison operators
Logical operators
COLLECTING DATA
Using the post or get method in forms
Using shortcuts to collect form input
Using the query string
THE DATE FUNCTION
The built-in date() function
Using numbers
Using calculations
Formatting numbers
Incrementing and decrementing
MANIPULATING STRINGS
Trimming strings
The strlen() function
More string functions
The strtolower() function
The strtoupper() function
The ucfirst() function
The ucword() function
The addslashes() function
Questions and answers
THE PHPMYADMIN CONTROL PANEL
Administrating PHP
Building a database
Database terminology
INTRODUCTION TO SQL
SQL commands
Comments
SQL statements
Clauses
Identifiers
Examples of Clauses in SQL statements
Commonly used Clauses
Using conditionals
USING SQL WITH MySQL
Common types in MySQL
Common data types
Full text search
Table types
Inserting data into a table
DATABASE DESIGN
Selecting data from a table
SQL Commands
Database normalisation
Web interface to MySQL
MySQL functions
ADMINISTRATION
Putting it all together
COMBINING PHP AND MySQL
Mysql_connect()
Mysql_query()
Mysql_result()
Selecting specific records
DATA-DRIVEN APPLICATIONS
Building a web interface
Showing and inserting records
Searching records
Updating records
Deleting records
Publishing and testing your site
Questions and answers |
