Dynamic Link/Content with PHP

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I've created a mySQL database with the fields id, title and content.  
'ID' is a unique field. Any ideas on how I can use PHP to generate a  
list of the titles which are links. When you click on a link you are  
taken to a page with the content held in the database. I'm guessing the  
generated links would be something like /page.PHP?pageid=x based on the  
id, that's if this script is possible at all.

Sorry for being such a newbie, but I guess we all have to start somewhere.


Re: Dynamic Link/Content with PHP

Ben Allen wrote:
Quoted text here. Click to load it


This is exactly what php does, and you seem to be off to a good start.  
Have you tried writing any code yet or do you have any more specific  

If you are just starting out, I would suggest first writing a webpage  
which simply lists all the items in the database. If there are many  
items, you might consider splitting them up into usable chunks of 10-20  
  per page.

Once that is working, turn the list into a list of links, your proposed  
url format looks fine, though I wouldn't name a page 'page.php', how  
about 'display.php'.

  Once you have completed those first two steps you should write the  
display.php page, which retrieves the item details from the database  
using the id you passed in the url (this can be retrieved from the $_GET  
array in php.

Re: Dynamic Link/Content with PHP

Carl wrote:
Quoted text here. Click to load it

Thanks for the quick reply Carl,
I've used php before, a basic form to add stuff to a database and also a  
script to list from a database. It was the turning them automatically  
into links and then clicking on that link to bring up a page filled from  
   a database that confused me. I haven't written any code for this  
particular piece yet. I'm still not sure how to use the $_GET to  
retrieve the information but I guess I'll figure it out, I've use $_get  
before to pass an email address from one page to another (not very  
securely I know, but it was more of a test script). Anyway, I'll give it  
ago, thanks for the information.


Re: Dynamic Link/Content with PHP

Ben Allen wrote:
Quoted text here. Click to load it
It seems I found what I need here:

If, after further reading, this isn't what I need I'll resort to using  
my own code.


Site Timeline