ECE 3553 Multifarious systems Final Project

Haren Lalchand

PHP powered forum

PurposePossibly learn more advanced PHP and SQL

through relational tables

Figure out how a forum really works

Standard in most large websites

Mostly taken for granted

Implementation

Tables

List of files Header.php Footer.php Connect.php Signin.php Signout.php Signup.php Create_cat.php Create_topic.php Reply.php Index.php Category.php Topic.php Change.php Style.css Dragon.jpg

Header and Footer system with CSSStandardize menus

Uniform look on all pages

Allow for quick changes

Reduces amount of code needed in other files

Signing up/in/off

Insert new user into users tableUses sha1() hashing for security

Check credentials and start a session

Clear session

Creating a category / topic / replySimple form for table entry

Will have to bring up relevant entries for association

Use of transactions

Forum / category / topic viewPull up relevant tables

Might have a need to order information

Cascading table calls

Display

ConclusionMore complex than initially thought

Learned about transactions

Learned relational database tables in MySQL

Intellectually stimulating

Referanceshttp://www.tizag.com – Web design tutorial and

code snippetshttp://www.phpeasystep.com – PHP/MySQL

tutorialshttp://www.tutorialspoint.com/mysql - MySQL

documentationhttp://www.w3schools.com/ - Web design tutorialshttp://css-tricks.com/ - CSS code snippets for

“advanced use”http://www.pandora.com – Amazing music to

listen to while coding/working