Article content to load from mysql based on ID in url

Question

On my old website built in PHP, I had a link on a page which picked an ID based on what line was clicked.

<td width=124><a href="tp/package.php?ID=<?php echo $row[0];?>">Package</a></td>

When the link was pressed, it brought that ID with it, and helped populate the next page (package.php) with values from mysql based on that ID.

Like:

$query = "SELECT * FROM `TABLE_NAME` WHERE `ID`='" . $id . "'";

Now I am trying to do the same in Joomla. I have the link ready:

echo '<td class="first"><a href="index.php/package?ID='. $row->ID .'">

I just cannot figure out how to write the code on that page, so it can populate the table based on that id.

The current code that I am experimenting with on the package-page:

$option = array();
$option['driver'] = 'mysql';
$option['host'] = 'HOST';
$option['user'] = 'USER';
$option['password'] = 'PASSWORD';
$option['database'] = 'DATABASE';
$option['prefix'] = '';

$db = JDatabaseDriver::getInstance($option);

$query = $db->getQuery(true);
$query->select($db->quoteName(array('ID', 'DESCRIPTION', 'MGRS')));
$query->from($db->quoteName('redsands_strike'));
$query = "SELECT * FROM `redsands_strike` WHERE `ID`='" . $id . "'";

$db->setQuery($query);$results = $db->loadObjectList();
 
while($row = mysqli_fetch_array($result)){ 
    echo "<table id='customers' >";
        echo "<tr>";
            echo "<th>T/ID#:</th>";
            echo "<th>" . $row['ID'] . "</th>";
        echo "</tr>";

        echo "<tr>";
            echo "<th>Description:</th>";
            echo "<td>" . $row['DESCRIPTION'] . "</td>";
        echo "</tr>";
                
        echo "<tr>";
            echo "<th>MGRS:</th>";
            echo "<td>" . $row['MGRS'] . "</td>";
        echo "</tr>";

        echo "<tr>";
            echo "<th>LL DDM:</th>";
            echo "<td>" . $row['DDM'] . "</td>";
        echo "</tr>";

        echo "<tr>";
            echo "<th>LL DMS:</th>";
            echo "<td>" . $row['DMS'] . "</td>";
        echo "</tr>";

        echo "<tr>";
            echo "<th>Altitude:</th>";
            echo "<td>" . $row['ALT'] . "</td>";
        echo "</tr>";

        echo "<tr>";
            echo "<th>Recon images:</th>";
            echo '<td><img src="/tp/'. $row['ID'] .'_a.jpg"/><br><br><img src="/tp/'. $row['ID'] .'_b.jpg"/></td>';
        echo "</tr>";
    }
echo "</table>";

But this doesn't seem to be working.

This is my first question here, so I hope I get clear and easy to understand support.

My goal is to have one "article template" page called "package" which will pull the proper information based on the ID given from URL that is brought by pressing the link from the page before.

Answer 1

I got it working, by using the entire code from before. Didnt even think about testing it int its purity since i assumed that the connection needed to be rebuilt. But it worked with a simple copy/paste.

Thanks for all help!

Answer 2

Just the same code as i had on my old clean php website. Copied the code and pasted it and it worked right away. 
Might work on it more when i have the website opened. Right now im all for it to work. 

// Create connection
$conn = new mysqli($servername, $username, $password, $db_name);
// Check connection
if ($conn->connect_error){
  die("Connection failed: " . $conn->connect_error);
} 
$id = $_GET['ID'];
$id = mysqli_real_escape_string($conn,$id);
$query = "SELECT ID,SUBSTRING(DESCRIPTION, 4) AS DESCRIPTION, MGRS, DDM, DMS, ALT FROM `redsands_strike` WHERE `ID`='" . $id . "'";
$result = mysqli_query($conn,$query);

while($row = mysqli_fetch_array($result)){
echo "<table id='customers' >";
                echo "<tr>";
                echo "<th>T/ID#:</th>";
                echo "<td>" . $row['ID'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th>Description:</th>";
                echo "<td>" . $row['DESCRIPTION'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th>MGRS:</th>";
                echo "<td>" . $row['MGRS'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th>LL DDM:</th>";
                echo "<td>" . $row['DDM'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th>LL DMS:</th>";
                echo "<td>" . $row['DMS'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th>Altitude:</th>";
                echo "<td>" . $row['ALT'] . "</td>";
                echo "</tr>";

                echo "<tr>";
                echo "<th valign='top'>Recon images:</th>";
                echo '<td><img src="/tp/'. $row['ID'] .'_a.jpg"/><br><br><img src="/tp/'. $row['ID'] .'_b.jpg"/></td>';
                echo "</tr>";

            }
echo "</table>";

?>