Grocery List Files

Grocery List Install instructions


I. Install Apache, MySQL, and PHP
II. Copy all of the grocery-list *.php files to the apache server's www or htdocs folder.
III. Configure your glist database in mysql
	1. bring up the mysql prompt
	2. type the following command

	mysql> create database glist;

	3. add a new user named 'user' with the following command...

	mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'IDENTIFIED BY 'password' WITH GRANT OPTION;
	
	the current grocery-list php code calls to the mysql server use a user named 'user' with a password of 'password'.

	4. switch to the glist database with the command "use glist;"

	5. add a new table named 'groceries' with the following columns
	
		a. itemid - int, not null, primary key, auto incremented
		b. quantity - double
		c. itemname - varchar(100), not null
		d. size - double
		e. units - varchar(20)
		f. manufacturer - varchar(100)
		g. notes - varchar(200)
		h. time - timestamp, not null, current timestamp
	
	you can do this with the following command:

	mysql>	create table groceries(
	    ->	itemid INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	    ->	quantity REAL,
	    ->	itemname VARCHAR(100) NOT NULL,
	    ->	size REAL,
	    ->	units VARCHAR(20),
	    ->	manufacturer VARCHAR(100),
	    ->	notes VARCHAR(200),
	    ->	time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP);

	That should be all.

IV. Navigate your webrowser to 127.0.0.1/GroceryList.php