Help with PHP & Tables

[Sponge Bob]

Hello All,

I need some small help here.

At first i have a database:



Secondly i have a table where all downloads are being called:



I want a script whereby, if i click on one download, it opens another page and displays in that page, all information of the particular download.

Meaning as you can see on the table u cant see the download links, just title and description for now. (I will remove the description from the table too)

SO when someone clicks the download he/she wants they get to the download page, which displays the title, description and download.

Please assist how i can do this.

Thanks

Sponge Bob Reviewed by Sponge Bob on 5th May 2011. Help with PHP & Tables Hello All, I need some small help here. At first i have a database: http://i.imgur.com/8Nwpp.png Secondly i have a table where all downloads are being called: Rating: 5

[Lifetalk]

From what I can recommend, create a file:

detail.php

Which accepts a GET based id:

detail.php?id=ID

where ID is the post ID in your database. From there on, php can call the relevant post details from the database using the ID supplied in the GET query.

Of course, you're gonna have to sanitize/escape the MySQL arguments, and the standard security procedures, etc.

[Mr Happy]

<?php
// First check if we have a id of a download to show in detail
if(isset($G_GET['id']) && is_numeric($_GET['id']) && (strlen($_GET['id'] < 7)) {
    $sql = mysql_query("SELECT id, title,desc,bla,bla2,etc FROM table WHERE id=".$_GET['id']);
    // output your detailed info here. Smart to check if it exists first. Throw a message if it doesn't exist and if it does show the download.
}
// if no download number then we'll just show the list as normal
else
{
    $sql = mysql_query("SELECT id, title FROM table LIMIT 30");
    while($row = mysql_fetch_assoc($sql))
    {
        echo '<tr><td>'.$row['type'].'</td><td><a href="index.php?id='.$row['id'].'">'.$row['title'].'</a></td></tr>';
    }
}

[Sponge Bob]

From what I can recommend, create a file:

detail.php

Which accepts a GET based id:

detail.php?id=ID

where ID is the post ID in your database. From there on, php can call the relevant post details from the database using the ID supplied in the GET query.

Of course, you're gonna have to sanitize/escape the MySQL arguments, and the standard security procedures, etc.

Ok,

Is it possible you can provide me with that GET query, so i can add a Download link at the end of the table, thus when clicking it, i can point it to

/details.php?id=id

Please assist with the code if possible.

Thanks

[Lifetalk]

Mr Happy just posted a sample code for you

[Sponge Bob]

Hey Mr. Happy it tells me this:




Also is there a way i can make the links on the table clickable?

[Cory]

<?php

$action = $_GET["action"];

$query  = "SELECT * FROM my_table";
$result = mysql_query ($query) or die ("Query failed");
$data   = mysql_fetch_object($result)) {

$id          = $data->id;
$title       = $data->title;
$description = $data->description;
$date        = $data->date;
$download    = $data->download;


if($action && is_numeric($id)) {
//tables here
echo $title;
echo "<br /><br />";
echo $description;
echo "<br /><br />";
echo "Date: $date";
echo "<br /><br />";
echo "<a href=\"$download\">Download</a>";
}

?>

Basic code, I created.

Same way as others, execute it by details.php?id=number_here

[Mr Happy]

Show us your code.

And the links are clickable. This is the part that makes them clickable

<a href="index.php?id='.$row['id'].'">'.$row['title'].'</a> 

[Sponge Bob]

Well @Happy, I am now all confused as i dont know what i am doing.

Can you also give me a good table script where i can add the table, together with the links being clickable.

Secondly, i added

<?php
// First check if we have a id of a download to show in detail
if(isset($G_GET['id']) && is_numeric($_GET['id']) && (strlen($_GET['id'] < 7)) {
$sql = mysql_query("SELECT id, title,desc,bla,bla2,etc FROM table WHERE id=".$_GET['id']);
// output your detailed info here. Smart to check if it exists first. Throw a message if it doesn't exist and if it does show the download.
}
// if no download number then we'll just show the list as normal
else
{
$sql = mysql_query("SELECT id, title FROM table LIMIT 30");
while($row = mysql_fetch_assoc($sql))
{
echo '<tr><td>'.$row['type'].'</td><td><a href="index.php?id='.$row['id'].'">'.$row['title'].'</a></td></tr>';
}
}
?>

To the details.php and went to /details.php?id=2 but i got this error:

[Cory]

He made a typo;

Find:

$G_GET['id'] 

Change:

$_GET['id']