PHP Detail page help

[daveeboi]

I have developed a search facility on my site which is now working as intended and produces pages of relevent records from the search. On the resuly pages I have created href links for records that I wish to use to forward users to a detailed html page for their item. I am planning on doing this using adetail.php script where the id will be taken and used to identify the corresponding file. Only problem is I've never done this before do I just post the id in and change the header part accordingly?

[Atli]

Hi.

If I am understanding you correctly, you only need to create a <a> link that points to your addetail.php, including the ID of the item you want to view.
Then, in the addetail.php, you use the $_GET super-global to get the ID and get the item information.

For example: (doing this in one page, but you get the idea)

<?php
# Get and validate the itemID
$itemID = $_GET['itemID'];
if($itemID != abs($itemID) or $itemID <= 0) {
  echo("<p>Item ID is invalid.</p>");
}
else {
  # Get and display data from MySQL
  $result = mysql_query("SELECT * FROM myTable WHERE id = $itemID");
  while($row = mysql_fetch_assoc($result)) {
    echo "<b>Item details:</b><br>";
    foreach($row as $key => $value) {
      echo " - $key = $value<br>";
    }
  }
}
?>
 
<a href="thisPage.php?itemID=1">Show details</a>
 

[daveeboi]

Hi.

If I am understanding you correctly, you only need to create a <a> link that points to your addetail.php, including the ID of the item you want to view.
Then, in the addetail.php, you use the $_GET super-global to get the ID and get the item information.

For example: (doing this in one page, but you get the idea)

<?php
# Get and validate the itemID
$itemID = $_GET['itemID'];
if($itemID != abs($itemID) or $itemID <= 0) {
  echo("<p>Item ID is invalid.</p>");
}
else {
  # Get and display data from MySQL
  $result = mysql_query("SELECT * FROM myTable WHERE id = $itemID");
  while($row = mysql_fetch_assoc($result)) {
    echo "<b>Item details:</b><br>";
    foreach($row as $key => $value) {
      echo " - $key = $value<br>";
    }
  }
}
?>
 
<a href="thisPage.php?itemID=1">Show details</a>
 

It is kind of what I'm aiming for. In my previuos post you were kind enough to help out with also, I had a search form accessing my database to extract all relevent records for criteria. I have a link established for each search output which is..

echo "<div id=\"right\"><img src=\"".$info['image']."\"><a href=\"detail.php\">".$info['title']."</a></div>\n";
 

but it's linking it through detail.php I need to establish. What to put in detail.php?

[Atli]

If you'd put the code I posted (leave out the link tho) into your details.php, you could change your links to this, in order to get it working:

echo "<div id=\"right\"><img src=\"".$info['image']."\"><a href=\"detail.php?itemID=". $info['id']. "\">".$info['title']."</a></div>\n";
 

Assuming that your $info array includes the ID of the item to show.

[daveeboi]

is it possible to use header location command for this purpose? I already have made up html detail pages and would like to use them.