This is the repository of the application developed during a workshop conducted on 14 October 2018 by IMG at IIT Roorkee.

The main objective of the workshop was to develop a dynamic application in a limited time of 4 hours.

• PHP
• Apache
• MySQL

+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| post_title | varchar(255) | NO   |     | NULL    |                |
| content    | text         | YES  |     | NULL    |                |
| author     | varchar(255) | NO   |     | NULL    |                |
| posted_on  | date         | NO   |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

• HTML, CSS and JS

  • https://www.w3schools.com/

• PHP

  • https://www.w3schools.com/php/ (Basics of PHP)
  • https://github.com/ziadoz/awesome-php (Curated list of all the necessary resources, can be checked after mastering the basics)

• Apache

  • http://howtoubuntu.org/how-to-install-lamp-on-ubuntu (LAMP)
  • http://www.wampserver.com/en/ (WAMP for Window users)

• MySQL

  • https://www.w3schools.com/sql/default.asp (SQL)
  • https://www.tutorialspoint.com/mysql/ (MySQL)
  • https://www.w3schools.com/php/php_mysql_intro.asp (MySQL + PHP)

The commit history can be checked out to get the insights of the different stages of development. Can be seen here

Detailed guidelines for setting up the project can be viewed at SETUP.md

• Make your app pretty using CSS (https://www.w3schools.com/css/)
• Prevent SQL Injection and XSS attacks (https://www.w3schools.com/sql/sql_injection.asp)
• Add user signup and login features
  • Username/Email and Password based login with a Remember Me button
  • Change password feature
  • Save the password as a hash (https://crackstation.net/hashing-security.htm)
• Frontend and backend validations for user signup
  • https://www.w3schools.com/php/php_form_validation.asp
  • https://www.w3schools.com/js/js_validation.asp
• Use sessions (https://www.w3schools.com/php/php_sessions.asp)
• Use cookies (https://www.w3schools.com/php/php_cookies.asp)
• Provide an option to login with facebook, google and github (Find a way to do it)
• Host your app somewhere so that people can see your app live in action and a lot more.

Feel free to open issues if facing problems with the code written. IMG is always there to help.