rodhow Posted November 29, 2011 Share Posted November 29, 2011 Hello, I am about to upload records into my mysql database that will easily total into the thousands. Each row represents a page so when someone searches for information, the search page displays the requested rows as links. However, I haven't started making the files yet to these links as I would have to create one for every row. Is there an alternative to this madness? Is there a dynamic page script that would display information from that row when the link is clicked on? Can someone point me in the right direction via tutorial, or just give me some information on how to do this. I would not want to make thousands of individual pages; the maintenance would be disastrous. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/252045-1000s-of-pages-to-be-created-stoppoint-me-to-an-alternative/ Share on other sites More sharing options...
Spring Posted November 29, 2011 Share Posted November 29, 2011 Generate the results on one page depending on a unique id? Quote Link to comment https://forums.phpfreaks.com/topic/252045-1000s-of-pages-to-be-created-stoppoint-me-to-an-alternative/#findComment-1292216 Share on other sites More sharing options...
KevinM1 Posted November 29, 2011 Share Posted November 29, 2011 The whole point of using PHP and a database is to make dynamic sites. As in, one (or several) HTML templates that can show any number of individual rows of database..err..data. To flesh out what tonyhh said above, your links should look something like: www.mysite.com?id=2234214 You can then use that id (which would be available in $_GET) as a parameter in a SELECT query. From there, you can plug in the data that's returned into a template. Quote Link to comment https://forums.phpfreaks.com/topic/252045-1000s-of-pages-to-be-created-stoppoint-me-to-an-alternative/#findComment-1292220 Share on other sites More sharing options...
rodhow Posted November 29, 2011 Author Share Posted November 29, 2011 Okay thanks...to both of you. I wasn't sure about the unique ID but now I am. I didn't create those in the links and the two of you pointed me into a great direction. Got the results I was looking. Thanks and this problemd has been SOLVED! Quote Link to comment https://forums.phpfreaks.com/topic/252045-1000s-of-pages-to-be-created-stoppoint-me-to-an-alternative/#findComment-1292297 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.