Jooma 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, wich picked an ID based on what line it was.

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

But i cannot figure out how to write the code on that page, so it can populate the table based on that.

My current code 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 doesnt seem to be working.

My first question here, so i hope i got it clear and easy to understand.

My goal is to have one "article template" page called package, wich 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>";

?>