/PHP/MySQL table in new page after click php

MySQL table in new page after click php

$result = mysqli_query($conn,"SELECT * FROM job ORDER BY `CreatedTime` DESC");


echo "<table border='0' cellpadding='0' cellspacing='0' class='table-fill'> 
<tr>
<th width='250px' position='fixed'>Job Title</th> 
<th width='150px'>Company Name</th>
<th width='100px'>Location</th>
<th>Closing Date</th>
<th>View Job</th>
</tr>";


while($row = mysqli_fetch_array($result) ) {
echo "<tr>";
echo "<td>" . $row['positiontitle'] . "</td>";
echo "<td>" . $row['companyname'] . "</td>";
echo "<td>" . $row['location'] . "</td>";
echo "<td>" . $row['closingdate'] . "</td>";
echo "<td><a href='job_details.php?id=".$row['job_id']."'>View Job</td>";

echo "</tr>";
}



And in job_details.php fetch the details against the id and display the result on that page.

jobdetails.php :

<?php

   $result = mysqli_query($conn,"SELECT * FROM job WHERE job_id = '".$_GET['id']."' ORDER BY `CreatedTime` DESC");

   $jobdetails = mysqli_fetch_assoc($result);

   echo 'Position : '.$jobdetails['positiontitle'].'<br>';
   echo 'Company Name: '.$jobdetails['companyname'].'<br>';
   echo 'Location: '.$jobdetails['location'].'<br>';
   echo 'Closing Date: '.$jobdetails['closingdate'].'<br>';


?>

Source: stackoverflow.com

Similar codes

0 vote303 views1 answer
Wordpress add block from single.php
PHP Wordpress
1 vote318 views1 answer
Redirect http to https htaccess laravel 8
PHP Laravel
0 vote268 views1 answer
Lcomposer symfony/filesystem
PHP
-1 vote281 views1 answer
Notice: Undefined variable: _SESSION in C:\xampp\htdocs\practice\header.php on line 7
PHP
2 votes262 views3 answers
Sort array by date php
PHP
-1 vote260 views5 answers
Php version 7.4
PHP
3 votes255 views2 answers
Order number generate laravel
PHP
3 votes241 views1 answer
Php docs
PHP
0 vote237 views1 answer
Php serve a video (THE ONLY WORKING CODE)
PHP
7 votes252 views2 answers
Laravel ui
PHP Laravel