Download Latest Version grocerylist-2.0.zip (86.2 kB)
Email in envelope

Get an email when there's a new version of Grocery List

Home / OldFiles
Name Modified Size InfoDownloads / Week
Parent folder
README.txt 2007-06-30 1.5 kB
GL_edititem_Form.php 2007-06-30 2.7 kB
delGLitem.php 2007-06-30 1.4 kB
printGLitem.php 2007-06-30 198 Bytes
confirmdelGLitem.php 2007-06-30 1.9 kB
sendGLitem.php 2007-06-30 200 Bytes
GroceryList.php 2007-06-30 2.5 kB
editGLItem.php 2007-06-30 1.4 kB
addGLItem.php 2007-06-30 841 Bytes
GL_additem_Form.php 2007-06-30 3.5 kB
Totals: 10 Items   16.1 kB 0
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


	

	
	
Source: README.txt, updated 2007-06-30