Dynamic Link/Content with PHP

[Ben Allen]

Hi,
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.

Thanks,
Ben

[Carl]

Re: Dynamic Link/Content with PHP

Ben Allen wrote:[color=blue]
> Hi,
> 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.
>
> Thanks,
> Ben[/color]


Ben,

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
questions?

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.

http://www.php.net/manual/en/index.php

http://www.php.net/manual/en/ref.mysql.php

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'.

http://idocs.com/tags/linking/_A.html

http://www.php.net/variables.external

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.

http://www.php.net/variables.external

http://www.php.net/manual/en/reserved.variables.php#reserved.variables.get

[Ben Allen]

Re: Dynamic Link/Content with PHP

Carl wrote:[color=blue]
> Ben Allen wrote:
>[color=green]
>> Hi,
>> 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.
>>
>> Thanks,
>> Ben[/color]
>
>
>
> Ben,
>
> 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
> questions?
>
> 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.
> http://www.php.net/manual/en/index.php
> http://www.php.net/manual/en/ref.mysql.php
>
> 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'.
> http://idocs.com/tags/linking/_A.html
> http://www.php.net/variables.external
>
>
> 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.
> http://www.php.net/variables.external
> http://www.php.net/manual/en/reserve....variables.get[/color]

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.

Cheers,
Ben

[Ben Allen]

Re: Dynamic Link/Content with PHP

Ben Allen wrote:[color=blue]
> Hi,
> 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.
>
> Thanks,
> Ben[/color]
It seems I found what I need here:

http://www.php-mysql-tutorial.com/cms-php-mysql.php

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

Thanks,
Ben