Saturday, June 11, 2005

I Did Something Useful =P

Hey, my first entry!! As the titles of the blog and post indicate, my blog will be about programming and what not. Although I'm no guru, and I don't know over 30 languages, I have had enough experience to understand the common travails of things like debugging, making a workaround for something, or when your client/supervisor asks for last minute changes >:-|.

My most recent project involved making a quasi-CMS system (not as many as features, but more secure ;)). First, I made a setup script so the user doesn't have to run any queries themselves. It sets up a DB and table (user specified names) and also uses the password provided to connect to the MySQL DB as a means for logging onto the CMS after setup. The setup script shows all the queries that were run and highlights them so that a more experienced user can review the changes in their database.

If the setup file isn't deleted, the CMS page won't work, and displays an error. The password that was stored in a logon table was encrypted, and is checked against the user provided password in the CMS logon form. A session will begin when logged on in order to decide on whether or not to show admin features on other pages. The CMS page provides an intuitive web based interface for adding entries (products, news, w/e). You can upload up to 5 pictures as well. You can markup entries with bbCode like tags ([b]bold[/b], [i]italic[/i], etc.) for certain style/link needs.

So, that's basically what I've been up to, and I'm still working out some of the kinks as well. In time, I should have a rather customizable interface running. You may be wondering in what I coded this...PHP!! Although, I do like Perl, I just would prefer to do most Web related apps with PHP. Due to limited experience, I also haven't provided support for other databases. We'll see about that in the future.


Me here, signing off.....peace