Hi, I need a very basic content management system written in PHP and using MySQL.
The content management system will comprise of:
1. Login Page
2. Main page that views all topics
- Add a main topic
- Add a sub topic relating to the main topic
- Delete a topic and sub topic
- Date picker
- Basic form validation
- Session variable to track the user login.
3. Sign up page
- Enter standard user information
4. Database table structure
User
- UserID (Primary Key, Integer)
- FirstName (varchar(max))
- LastName (varchar(max))
- Email (varchar(max))
- Address (varchar(max)
- Phone (varchar(max))
- Country (varchar(max))
- MarketingPermission (boolean)
MainTopic
- MainTopicID (Primary Key, Integer)
- Title (varchar(max)
- DueDate (varchar(max)
- Comment (varchar(max)
SubTopic
- SubTopicID (Primary Key, Integer)
- MainTopicID (Foreign Key, Integer)
- Title (varchar(max)
- DueDate (varchar(max)
- Comment (varchar(max)
Other Information.
- Code must be clean and clearly commented.
- Database connection must be to a mySQL database.
- Installation notes, such as SQL queries to create the database tables and structure.
- The code is very simple, all it is just inserting, updating and deleting from the database, you may reuse existing code from your previous projects if you want to save time and not reinvent the wheel.
- Have fun with the project, its very basic :)