130 likes | 329 Views
ECE 3553 Multifarious systems Final Project. Haren Lalchand. PHP powered forum. Purpose. Possibly 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.
E N D
ECE 3553 Multifarious systems Final Project HarenLalchand
Purpose • Possibly 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
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 CSS • Standardize 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 table • Uses sha1() hashing for security • Check credentials and start a session • Clear session
Creating a category / topic / reply • Simple form for table entry • Will have to bring up relevant entries for association • Use of transactions
Forum / category / topic view • Pull up relevant tables • Might have a need to order information • Cascading table calls • Display
Conclusion • More complex than initially thought • Learned about transactions • Learned relational database tables in MySQL • Intellectually stimulating
Referances • http://www.tizag.com – Web design tutorial and code snippets • http://www.phpeasystep.com – PHP/MySQL tutorials • http://www.tutorialspoint.com/mysql - MySQL documentation • http://www.w3schools.com/ - Web design tutorials • http://css-tricks.com/ - CSS code snippets for “advanced use” • http://www.pandora.com – Amazing music to listen to while coding/working