Learning PHP and MySQL

2006

July

• Welcome to the O’Reilly Learning PHP & MySQL blog

September

• Example 17-2 Function comments

• Example 17-1 File comments

• Example 16-17 comment_form.tpl

• Example 16-16 modify_comment.php

• Example 16-15 post_form.tpl

• Example 16-14 modify_posts.php

• Example 16-13 view_post.tpl

• Example 16-12 The view_post.php script displays and a summary of its comments

• Example 16-11 The posts.tpl template file defines how the postings appear on the page

• Example 16-10 The posts.php script displays a listing of posts and their subjects

• Example 16-9 Inserting sample data for the tables

• Example 16-8 SQL to create the users table (may have already been created

• Example 16-7 SQL to create the comments table

• Example 16-6 SQL to create the categories table

• Example 16-5 SQL to create the posts table

• Example 16-4 The login script, called login.php

• Example 16-3 The footer.tpl file

• Example 16-2 The header.tpl file

• Example 16-1 The config.php script defines settings that are used throughout the site

• Example 15-4 Displaying an error from PHP and redisplaying the form with submitted values

• Example 15-3 Using preg_match to return an array of matches that start with ple

• Example 15-2 The file source.js contains functions to check the various fields

• Example 15-1 Building a form that validates its fields before submission

• Example 14-12 Checking for magic quotes

• Example 14-11 Seeing the results of magic quotes

• Example 14-9 session.save_path functionality

• Example 14-10 Suppressing the standard database error message

• Example 14-8 Checking for session hijacking

• Example 14-6 Session using the proper $_SESSION super global

• Example 14-7 Detecting simple variable poisoning

• Example 14-5 Sessions with register_globals on or off in session_test.php

• Example 14-4 Not initializing a variable was a hole in sample.php

• Example 14-3 Comparing the output of md5 to that of sha1

• Example 14-2 Creating an Apache password for .htaccess

• Example 14-1 Using Apache authentication to restrict access to scripts

• Example 13-20 Retrieving additional information for the user

• Example 13-19 Using Auth_HTTP to authenticate a user

• Example 13-18 pear install Auth_HTTP output

• Example 13-17 pear install Auth output

• Example 13-16 Session timeout

• Example 13-15 Destroying a session

• Example 13-14 Checking to see whether a user is valid

• Example 13-13 Referencing a variable set on a prior page in the session

• Example 13-12 Registering a variable by including it in $_SESSION

• Example 13-11 Registering a variable with session_register

• Example 13-10 Simply starting a session

• Example 13-8 The database login details

• Example 13-9 Verifying a username and password against the database

• Example 13-7 Creating the entry in the database for a user with an encrypted password

• Example 13-6 Creating the users table to store login information

• Example 13-5 Checking the values returned from the authentication prompt

• Example 13-4 Using HTTP authentication with a PHP script

• Example 13-3 Destroying a cookie by expiring it in the recent past

• Example 13-2 Viewing the username cookie

• Example 13-1 Creating a cookie

• Example 12-12 Displaying the authors in a list

• Example 12-10 The delete.php code for performing a delete

• Example 12-11 Using mysql_insert_id to link up an author to a title

• Example 12-9 Providing a link to delete a purchase in deletion_link.php

• Example 12-8 Updating a field

• Cross-Site Scripting Attacks

• Example 12-7 Checking for magic quotes

• SQL Injection

• Example 12-6 Using input from a form to add a title

• Example 12-5 The file purchase.php processes the user action based on the title_id parameter

• Example 12-4 Using embedded links to provide a purchase button in pear_purchase_example.php

• Example 12-3 Using a predefined INSERT statement in insert.php

• Example 12-2 Dropping the purchases table in drop.php

• Example 12-1 Creating a table from a PHP page in create_table.php

August

• Example 11-29 Executing df and displaying the results

• Example 11-28 Processing an uploaded file

• Example 11-27 Checking the file type

• Example 11-26 Checking the file size

• Example 11-25 Checking for the existence of an uploaded file

• Example 11-24 Prompting to upload a file

• Example 11-23 Renaming a file

• Example 11-22 Using file_exists, touch, and unlink together

• Example 11-21 Checking the permissions of a file

• Example 11-20 The file_exists.php script checks to see if the file is there

• Example 11-19 Creating a timestamp from the components of a date

• Example 11-18 Validating two dates

• Example 11-17 Adding two days to the date

• Example 11-16 Making the date and time appear like we expect

• Example 11-15 A simple echo of the timestamp

• Example 11-14 Using several functions together to extract a portion of a string

• Example 11-13 Detecting whether a string is contained in another string

• Example 11-12 Using the word case functions

• Example 11-11 Calculating the length of a string

• Example 11-10 Using sprintf with a variable

• Example 11-09 Displaying a real number in money format

• Example 11-08 Right padding with spaces

• Example 11-07 Left padding using the default of spaces

• Example 11-06 Adding the and tags so the spaces display

• Example 11-05 Using left space padding

• Example 11-04 Using left zero padding

• Example 11-03 Displaying the same number in different formats

• Example 11-02 printf puts the numbers into the string

• Example 11-01 Displaying a number in binary format

• Example 10-14 The new table template

<< Back to main