Transcript ECE 3553 Multifariou..

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
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
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