Simple Project Timer Files

PHP Simple Timer READ ME
The script was written by Tom Reitz http://tomreitz.me and is made available to you for use, additions, changes, modifications, etc. without charge, under the GNU General Public License. eMail me at tom.reitz@me.com if you have any questions.


About this script:
Ok, so this came about because I was annoyed to NOT find an easy project timer application for the Mac nor anything easy in php…  SOOOOO, I decided to finally write one myself. I first did this in a flat file but I quickly hated this as the fwrite() append (ab, r+) and rewind() php functions don't seem to work correctly… I know a flat file SHOULD be quicker but I couldn't get it working how I wanted SO I went to an old standard of PHP / MYSQL connection allowing for everything to work how I wanted…

I'd say this is stable so I'll call it PHP Simple Timer v0.1 (my original flatfile only lasted a few days and am not releasing it it as an alpha) and was officially completed on July 4th, 2011. Happy Independence Day! 

This is even XHTML5 validated! I could have moved the css out of the script but I figured I was trying to keep the files to a minimum…
-Tom

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Installation Notes:

1. Create a NEW mysql database with user and password read and write permissions. Look in index.php and find (NOTE this is in 2 PLACES so be sure to change both):

	mysql_connect('localhost', 'databaseusername', 'databaseuserpassword');
	mysql_select_db ('databasename');

Replace databaseusername with your user name. Replace databaseuserpassword with your user password and databasename with your database name. Tried to keep it obvious so it made sense.

2.  Run included SQL command on the database (in phpmyadmin most likely in the SQL tab):

	CREATE TABLE `timetable` (
	`time_ID` int(4) NOT NULL AUTO_INCREMENT,
	`timestamp` varchar(32) NOT NULL,
	`task` varchar(64) NOT NULL,
	PRIMARY KEY (`time_ID`)
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;

3. Upload files to wherever you want this to run. It is not location specific, so you could put it in public_html/mypersonalprojecttimer/ which of course would correspond with http://domain.com/mypersonalprojecttimer/ or wherever, remember this is not scripted for security so OBSCURITY is BEST so please DO NOT put it in that location.

4. Visit above URL with your private URL and simply add tasks / projects into the one blank available and hit ENTER.  Last entry will appear immediately at the bottom of the page AND at the top of the white window.  Latest entry will always appear at the top.

5. Copy the timestamp information and project notes from the white window regularly and put it in a spreadsheet and calculate your hours and INVOICE CLIENTS!

6. Occasionally go into phpmyadmin, export table for a backup, then delete the data so it doesn't grow too massive.

7. (Optional) Leave the link at the bottom. This is a FREE script so am just looking for some link love. :-D

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Things I want to add / change (in no particular order… will change them as I get annoyed with lack of functionality, whilst always keeping in mind the need to keep it SIMPLE):

	-create a subpage on my site for this script
	-separate the CSS to its own file.
	-LOG IN
	-check for security (I haven't tested this AT ALL, SO I recommend this only being used in a private location (security via obscurity!)
	-easy export tool
	-archive of daily or weekly work
	-project dropdown choice?
	-start stop buttons?
	-calculation of work by project

Revisions:
	-None yet.