Name | Modified | Size | Downloads / 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