MySQL

Still using http://hotwired.lycos.com/webmonkey/99/21/index2a_page5.html?tw=programming as my tutor.

Create a db:
mysqladmin -u root create mydb

Load records into mydb database.

Create a file mydb.dump with the following text and save it in the /tmp directory.

CREATE TABLE employees (  id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,  first varchar(20),  last varchar(20),  address varchar(255),  position varchar(50),  PRIMARY KEY (id),  UNIQUE id (id));INSERT INTO employees VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing Manager');
INSERT INTO employees VALUES (2,'John','Roberts','45 There St , Townville','Telephonist');
INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd, Snowston','Doorman');


From the command line, type:
mysql -u root mydb < /tmp/mydb.dump
Now test pages, (these are only accessible from my LAN):
http://purdy/~bruceo/mysql_test.php3
It works!
http://purdy/~bruceo/mysql02.php3
http://purdy/~bruceo/mysql03.php3
 
To Do List: