Posted by -
Bill Peck
When I first started working at Community Newspapers I quickly learned the programming language Perl. The best way to learn anything is to have a project or goal to accomplish. One of my first goals was to create an online phonebook for the company intranet. This project not only taught me Perl but HTML and SQL.
Before this project I used Perl to do everyday Unix Admin tasks. Since thats what my job actually is. :-) But when you start doing web programming you quickly realize that its different. The whole idea of stateless programming took a while to sink in. Basicly everytime someone accesses a web page they connect, download the content, close the connection, and display. So when you have an application that has thousands of records where you don't want or have the memory to display everything at once you need to deal with it differently than a normal program. For example with the phonebook I wanted to display about 50 records at first and then have the user click to see the next 50. But that user isn't connected anymore so I need to know when they connect again that they want the next 50 and not to start at the begining again. :-)
Its now 4 years later and I'm working directly for Fidelity Capital. One of the capital companies we do work for asked for an online phonebook so I took out the old code and had a look at it (Community Newspapers are still using the original code right now). I thought it was good time to update this aging relic with PHP3 and a MySQL database. Plus I know alot more now. :-)
So I sat down and a couples days of coding spread out over a couple weeks produced a newer sleeker version. (Sounds like a car commercial). The user interface is changed slightly, an annoying bug from the old one prevented you from hitting return after you entered a name in the text search field, thats fixed now. I use javascript popups for paging interface. There is now a built in editor which allows you to, well edit! Assuming you put in the correct admin password. The old system relied on a Microsoft Access front end that used ODBC to connect to Sybase (Can you believe I actually did anything on a Micro$soft system!). It never worked very well, I think it was that the ODBC drivers sucked.
Requirements for this package:
- PHP
- MySql - might work with others that phplib support
- xlHtml - if you want import Excel files
Where to get it.