Example Code
| Examples of code that I have written | |
| Time clock - Written after simplex went out of the time clock business and the company that it was sold to would not support our hardware/software. They wanted a ridiculous amount of money to transition us onto their own proprietary system. I wrote my own saving thousands of dollars and added many more features than the vendor’s product. It uses PHP and Mysql as the server and a regular PC with a bar code reader as the client. It is still in use in the Auxiliary Services department of Mt. San Antonio College which has a half dozen department and around a hundred part-time employees during rush. It has the ability to cover multiple departments. Has security features such as locking punches after a time period has closed so no one can modify old punches, records each change to punches and which supervisor made them. Can designate which departments each supervisor can view and modify employee punches. Sends an email warning to supervisor after an employee has been punched in for over 8 hours. Creates PDF time sheets for each employee for easy and neat printing. Will give a PDF report for total hours and days an employee has worked between specified dates. Report that shows who is clocked in and when they clocked in and who has recently clocked out, and lots of things I am probably forgetting. Use test test to log in as administrator and test2 test2 to log in as a supervisor. (note data is fairly old use 2003 as the year when testing, and this box is an old 200mhz box and reports take a long time to run) | |
| Job Viewer - Written in PHP and uses MySQL as back end, authenticates with a nocat wireless server using https and curl to authenticate students id and pin. If valid turns over control to my script which then registers the user the first time and allows them to search the jobs that are compiled from the career center. The career center has an access database which is exported into an XML file and imported into a MySQL database. Curl authentication has been overridden in this example any id and pin will work use 123 123 so that you don’t have to register. | |
| Bookstore - This was a test to see if it was possible to write the code necessary to run an e-commerce site for www.sacbookrac.com instead of using the Campus Hub e-commerce service. Exports flat files from a Universe database. Imports into mysql, front end in PHP. Customer could then pick semester, class, teacher, used or new books. Test was successfully but implementation was not done as I had too many other responsibilities to maintain code that would have to be very secure. | |
| Forms - Written as a quick way to post fillable PDF forms and save and email them. It was used campus wide at MT Sac for several years.(No longer being used, also is broken as FDF toolkit not installed on this server). | |
| Zip Code distance - Written for a consulting project that never paned out. Uses a Mysql database of zip codes and their longitude/latitude from the US census data. Calculates the distance between two zip codes and how many zip codes are within X miles of the first zip code. | |
| Algorithma - Was the project for my software engineering class in college. We were broken into different teams coders, managers, documentation and interface. The project was to create new java applets that graphically showed how different algorithms worked. I was on the interface team. I wrote a PERL script that would create the templates for each applet so that only one script had to be run to recreate all the pages after a change was made to the main template. | |
Comments
Comment from Murray Mintz
Time: March 7, 2008, 7:58 am
I have been searching the web for a simple job listing program — When trying to peek at Job Viewer, I get a mysql error
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@'localhost’ (using password: YES) in /home/jeffhnet/public_html/jobs/connect.inc on line 2
There was an error on the server
Please let me know when it works.
thanks,
Write a comment