A

Add a column using ALTER TABLE
Append new info to an existing record
Arrays

• numerically indexed
• auto numerically indexed
• loop with key / value
• loop with "foreach"
  only 1/2
• loop with "foreach"
  both sides
• end()
• count()
• array_shift()

Authentication with JavaScript

Authentication with PHP

B

Buttons

• PHP based
• JavaScript based

Browser check

C

Constants

Covering all cases with "case - break - default"

Create a database on the command line

Create a database and table with this script

Create table

• on command line
• from script

Get names of each column with
mysql_fetch_field

D

Date & Time

• time()
• getdate()
• date()
• Get readable date from timestamp on table

delete a record with DELETE

E

F

FInd out how you originally constructed a table

FInd out what mysql is doing

for - Repeat something using "for"

fetch_array - example

fetch_field - example
(Prints column names
in a table)

G

gettype($variable)

gif - How to code PHP to have MySQL output a gif

global - an example

$GLOBALS - print own full URL with this generic code

$GLOBALS - see them all with this code.

H

$HTTP_REFERER

How can I...

• add a column using ALTER
• copy a table
• create databases
• create tables
• delete a record with DELETE
• describe tables
• see how tables were made after the fact
• insert data into a table
• install default databases
• get data out with SELECT
• fix mistakes with UPDATE
• log on to mysql
• remove duplicate entries (forever)
• rename db, table, column
• show databases
• use a batchfile
  • table from batch
• use tables from two databases in the same query

I

if - Contingency using
if - elseif - else

if - Contingency using
if - do - while - else

include another file with "include"

incrementing

Insert data into tables

Install and configure MySQL on Linux

Installation of PHP to
work with MySQL on Linux.

Notes to myself on inst. on RH6.2

installation of PHP on Windows

J

Joins - use tables from two databases in the same query

K

L

show date last modified with "filemtime"

"linkself" - Make something a link with function "linkself"

List all tables on a database with this script

List all databases on a server with this script

List all files in a directory on a server with this script

Loading data into a
table from a text file
with LOAD DATA

M

mysqldump

N

NEW! gif in a table

O

Output table data to a text file.

P

Password protect a page with JavaScript

Passwords

phpMyAdmin

Primary key auto increment first table

R

Rename db, table, column

S

Security

SELECT

Make SELECT statements with multiple WHEREs example

static

T

Templates

• Loop a table with mysql_fetch_array
  (specify fields)
  
• Loop a table with simple while statement

U

Update data with UPDATE

Printing the URL of the current page with $REQUEST_URI

W

JavaScript

Back button

closeme - a function to close windows

Password protect a page

Print own URL