Search edit

<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "class";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$track_num=$_POST['search'];

$sql = "SELECT ctracking, cname, cemail, crport, cdport, clocation, cdestination FROM demo WHERE ctracking='$track_num'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row

echo '<table><tbody>';
echo '<tr><th>Col1</th><th>Col2</th><th>Col3</th><th>Col4</th><th>Col5</th><th>Col6</th><th>Col7</th><th>Col8</th></tr>';

foreach ($row in $result)
{
echo '<tr>';
foreach ($cell in $row)
      {
       echo '<td>';
       echo $cell;
       echo '</td>'
      }
echo '</tr>';
echo '</table></tbody>';
}

 else {
    echo "0 results";
}
$conn->close();

?>