Skip to main content
Inspiring
January 8, 2008
Question

go to details in php

  • January 8, 2008
  • 1 reply
  • 221 views
I am trying to create a go to details page using PHP and MySQL but cannot figure out how to get the parameter passed into my update record table. I know with Coldfusion there is a very simple server behavior built into Dreamweaver to acomplish this. Can anyone assist me with how to handle the same task with PHP?

what i want is for clients to be able to add new records, (which is working) and then view all records and go to a certain record for editing (which is what i am having trouble with). Any help is appreciated. Thanks.
This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

Inspiring
January 8, 2008
fbcojman wrote:
> I am trying to create a go to details page using PHP and MySQL but cannot
> figure out how to get the parameter passed into my update record table.

When creating the link to the details page, pass the primary key of the
record as a query string at the end of the URL like this:

details.php?article_id=5

The way to code this is to select the link in Design view, and click the
folder icon to the right of the Link field in the Property inspector.
Select the name of the details page, but don't click OK. Instead, click
the Parameters button in the dialog box. In the new dialog box that
opens, type the name of the primary key into the Name field. Then click
the lightning bolt icon to the right of the Value field, and select the
primary key from the recordset.

In the details page, use URL parameter as the filter to select the
appropriate record.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/