Creating Pages from a MySQL Database

John_Saunders

I am starting a backend administration section for my site. Currently, when I have to make page for a new user, I just use notepad to copy the .html file and edit sections of it where the name needs to be then upload it. This is getting to be a real pain.

Can somebody tell me how I can do this with an administration page that submits data to a database then how I can get it to display this information? It seems like it would be very easy to do.

Would it be best to somehow create a separate page for each user? Or just have one page then call it something like users.php?name=billgates, users.php?name=stevejobs, etc.? If the second way, how can I make it through the backend area so people can't just go in and do users.php?name=johnholmes and pick anything they want?

Also, can I just use one MySQL database for several different things then just use separate tables? Or do I need to just use one database for each project?

John

JDcrack

Sounds like your are going to need some sort of user authentication script.

Once the user is authenticated, you could easily create 1 page, like a template for every user, that has information pulled from your DB. (users.php?name=billgates) however this is not the most secure way.

You will want to take a look at this thread it has some great resources for understanding user authenrication:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10211775

Once you understand user authentication / cookies / sessions, creating a 'template page' will be cake! 😃

John_Saunders

Hi JDcrack,

Actually, I don't really need a user authentication system. I just want a way of creating the pages through a browser with just a few mouse clicks instead of the old way. I don't need them to be automatically created from another user, just from when I set it up.

I'm not really concerned about security because it's no big deal if someone else views the page. I just want to know how I can enter the data in a form that sends it to mysql, then the template page pulls the info. I do however, want to make sure that only pages I create are allowed (see my example above about johnholmes).

John