Week 12 progress report
turtle power! — Sun, 11/16/2008 - 15:12
I got sick this weekend, that's why this is late, but anyway, here's the progress we've made so far: we've set up the server in my apartment for testing purposes, but then we were informed to use the client's testing server. Once we got the FTP information, we set up the FTP, MSSQL database with tables and have started creating the framework for the backend. We have a secure login completed and have started the administrative portal, where depending on what type of account the user has, they will be able to do different things, such as upload files, post jobs or just view job postings. What we hope to accomplish in the upcoming week is to create the job postings form, have that upload to the database, then work on the administrative features and make sure the site is completely secure. We will also make sure to prevent SQL Injection, where a hacker could potentially crash the database. Also, we are making sure that we are creating the fields long enough so the user will be able to enter enough text and won't crash the database.
Since we are planning on text entry boxes for the entire site, we are going to use an HTML text editor, known as the FCKeditor. This is a widely used text editor that saves actual HTML markup into the database, then when the database object is called, it will pull the HTML tags and render appropriately.