165 years of excellence

if(isset($_GET['min_year']))
{
$servername = "localhost";
$username = "barkm76_wp1";
$password = "H&ChVqM2I9*oiO7r6K,11^^7";
$dbname = "barkm76_wp1";

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

$sql = "SELECT `Bouwnr`, `Naam`, `Omschrijving`, `Start`, `TWL`, `Oplev`, `Afmetingen`, CAST(`Afmetingen` AS UNSIGNED INTEGER) AS `Afmetingen2`, `Tonnage`, CAST(`Tonnage` AS UNSIGNED INTEGER) AS `Tonnage2`, `Propulsion`, `Opdrachtgever`, `Year`, `Type`, `Subtype`, `Deadweight`, `Capacity`, `Ship_specifics`, `Speed`, `Status`, `Nationality`, `IMO` FROM ShipsTable WHERE (";

$shiptypeselected = 0;

if(!empty($_GET['Specials']))
{
$sql .= "Type LIKE 'Specials'";
$shiptypeselected++;
}
if(!empty($_GET['Dredger']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Dredger'";
$shiptypeselected++;
}
if(!empty($_GET['Inland']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Inland'";
$shiptypeselected++;
}
if(!empty($_GET['Fishing_vessel']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Fishing vessel'";
$shiptypeselected++;
}
if(!empty($_GET['Constructions']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Constructions'";
$shiptypeselected++;
}
if(!empty($_GET['Dry_cargo']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Dry cargo'";
$shiptypeselected++;
}
if(!empty($_GET['Tug']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Tug'";
$shiptypeselected++;
}
if(!empty($_GET['Tanker']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Tanker'";
$shiptypeselected++;
}
if(!empty($_GET['Tender']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'Tender'";
$shiptypeselected++;
}
if(!empty($_GET['sea-basing']))
{
if($shiptypeselected != 0) $sql .= " OR ";
$sql .= "Type LIKE 'sea-basing'";
$shiptypeselected++;
}

if($shiptypeselected == 0)
$sql .= "Type LIKE '%'";

$sql .= ")";

//Search string
if(!empty($_GET['fname']))
$sql .= " AND (Subtype LIKE '%".$_GET['fname']."%' OR Status LIKE '%".$_GET['fname']."%' OR Nationality LIKE '%".$_GET['fname']."%' OR IMO LIKE '%".$_GET['fname']."%' OR Opdrachtgever LIKE '%".$_GET['fname']."%' OR Omschrijving LIKE '%".$_GET['fname']."%' OR Naam LIKE '%".$_GET['fname']."%' OR Bouwnr LIKE '%".$_GET['fname']."%')";

empty($_GET['min_year']) || empty($_GET['max_year'])? "" : $sql .= " AND Year BETWEEN ".$_GET['min_year']." AND ".$_GET['max_year'];

//empty($_GET['min_length']) || empty($_GET['max_length'])? "" : $sql .= " AND Afmetingen BETWEEN ".$_GET['min_length']." AND ".$_GET['max_length'];

empty($_GET['min_T']) || empty($_GET['max_T'])? "" : $sql .= " AND Tonnage BETWEEN ".$_GET['min_T']." AND ".$_GET['max_T'];

$order_by = empty($_GET['SortSelected'])? "Bouwnr" : $_GET['SortSelected'];
$asc_desc= empty($_GET['SortAscDesc'])? "DESC" : $_GET['SortAscDesc'];

$sql .= " GROUP BY " . $order_by ." ". $asc_desc;

//echo $sql;

$result = $conn->query($sql);

if ($result->num_rows > 0)
{
// output data of each row
$rows = 0;
while($row = $result->fetch_assoc())
{
if($rows % 3 == 0)
{
if($rows != 0)
{
echo "[/vc_row]";
}
echo "