Help with mysql automatically generating web pages

[madjack87]

I am creating a drink recipe site.

 

So far I have created the mysql table and the page where i can enter in the drink name ingredients ect. and it inserts into the table.

 

Could some one point me in the right direction where when I make an entry into this table a new page is created from the content.

 

How would I go about doing this?

 

 

[Adam]

You wouldn't actually create a new page as such. Basically once you have the data stored, you'd pass some type of unique identifier (normally an ID) through the URL parameters. Within the code you'd read this ID, perform the database query to return the associated data and then display it, or a fitting "page cannot be found" error message if not found of course.

[cliffdodger]

MrAdam is correct. However to accomplish that idea...

 

If your php script has a query in it along the idea of

$drink_page = mysql_query("SELECT * FROM drinks_table ORDER BY `id` ASC") or die(mysql_error());

for example. (you'll need something different, just an example)

 

Then loop through the data and start putting some html code into a php string mixed with your database results then output that variable to a file.

 

file_put_contents is probably the easiest way to do the final step

http://php.net/manual/en/function.file-put-contents.php