I have a question. I am making a system that lets the user build web pages much like a custom CMS to learn about SQL, PHP etc.
Anyway.. I have a login page and the user is allowed to click create new site. This then asks how many pages they want to create. It also asks the user to type the titles and paste in the content (text) The user can currently choose up to 5 pages per new site. But my question is, how would I design the database on phpmyadmin for this.
I need it linked so the system knows what pages are for a particular website and also where to place the content in the templates when it all comes together. I currently have been thinking the following fields but all doesn't add up and I think I am missing something simple. Bear with me it's my 1st time on databases :)
websiteID, WebsiteTitle, noPages, pageID, pageTitles, pageTitleID, content, contentID.
The websiteID will be A/I so it is unique everytime a new website is created but my problem is that a user can click create site, then they have the option to create up to 5 pages which obviously all cant have the same pageID so how would I link all of this in??
Sorry for anyone that is database gurus, I apologise, I am only an amateur at the database side of things and hope to get up to speed soon and hopefully this project is a good way to start.
Thanks for your patience