HTML, XHTML and CSS All-In-One for Dummies - Andy Harris [4]
Adding session variables to your code
Book V: Chapter 6: Working with Files and Directories
Text File Manipulation
Writing text to files
Writing a basic text file
Reading from the file
Using Delimited Data
Storing data in a CSV file
Viewing CSV data directly
Reading the CSV data in PHP
Working with File and Directory Functions
opendir()
readdir()
chdir()
Generating the list of file links
Book V: Chapter 7: Connecting to a MySQL Database
Retrieving Data from a Database
Understanding data connections
Building a connection
Passing a query to the database
Processing the results
Extracting the rows
Extracting fields from a row
Printing the data
Improving the Output Format
Building definition lists
Using XHTML tables for output
Allowing User Interaction
Building an XHTML search form
Responding to the search request
Breaking the code into functions
Processing the input
Generating the output
Book VI: Managing Data with MySQL
Book VI: Chapter 1: Getting Started with Data
Examining the Basic Structure of Data
Determining the fields in a record
Introducing SQL data types
Specifying the length of a record
Defining a primary key
Defining the table structure
Introducing MySQL
Why use MySQL?
Understanding the three-tier architecture
Practicing with MySQL
Setting Up phpMyAdmin
Changing the root password
Adding a user
Using phpMyAdmin on a remote server
Making a Database with phpMyAdmin
Book VI: Chapter 2: Managing Data with SQL
Writing SQL Code by Hand
Understanding SQL syntax rules
Examining the buildContact.sql script
Dropping a table
Creating a table
Adding records to the table
Viewing the sample data
Running a Script with phpMyAdmin
Using AUTO_INCREMENT for Primary Keys
Selecting Data from Your Tables
Selecting only a few fields
Selecting a subset of records
Searching with partial information
Searching for the ending value of a field
Searching for any text in a field
Searching with regular expressions
Sorting your responses
Editing Records
Updating a record
Deleting a record
Exporting Your Data and Structure
Exporting SQL code
Creating XML data
Book VI: Chapter 3: Normalizing Your Data
Recognizing Problems with Single-Table Data
The identity crisis
The listed powers
Repetition and reliability
Fields that change
Deletion problems
Introducing Entity-Relationship Diagrams
Using MySQL Workbench to draw ER diagrams
Creating a table definition in Workbench
Introducing Normalization
First normal form
Second normal form
Third normal form
Identifying Relationships in Your Data
Book VI: Chapter 4: Putting Data Together with Joins
Calculating Virtual Fields
Introducing SQL Functions
Knowing when to calculate virtual fields
Calculating Date Values
Using DATEDIFF to determine age
Adding a calculation to get years
Converting the days integer into a date
Using YEAR() and MONTH() to get readable values
Concatenating to make one field
Creating a View
Using an Inner Join to Combine Tables
Building a Cartesian join and an inner join
Enforcing one-to-many relationships
Counting the advantages of inner joins
Building a view to encapsulate the join
Managing Many-to-Many Joins
Understanding link tables
Using link tables to make many-to-many joins
Book VII: Into the Future with AJAX
Book VII: Chapter 1: AJAX Essentials
AJAX Spelled Out
A is for asynchronous
J is for JavaScript
A is for . . . and?
And X is for . . . data
Making a Basic AJAX Connection
Building the HTML form
Creating an XMLHttpRequest object
Opening a connection to the server
Sending the request and parameters
Checking the status
All Together Now — Making the Connection Asynchronous
Setting up the program
Building the getAJAX() function
Reading the response
Book VII: Chapter 2: Improving JavaScript and AJAX with jQuery
Introducing jQuery
Installing jQuery
Importing jQuery