// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error)
{
die(“Connection failed: ” . $conn->connect_error);
}

$sql = “SELECT * FROM ShipsTable WHERE Bouwnr = “.$_GET[‘Bouwnr’].”;”;
//echo $sql;

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

if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$Bouwnr = $row[“Bouwnr”];
$Naam= $row[“Naam”];
$Omschrijving = $row[“Omschrijving”];
$Start= $row[“Start”];
$TWL = $row[“TWL”];
$Oplev= $row[“Oplev”];
$Afmetingen = $row[“Afmetingen”];
$Tonnage = $row[“Tonnage”];
$Propulsion = $row[“Propulsion”];
$Opdrachtgever = $row[“Opdrachtgever”];
$Year = $row[“Year”];
$Type = $row[“Type”];
$Subtype = $row[“Subtype”];
$Deadweight = $row[“Deadweight”];
$Deadweight = $row[“Deadweight”];
$Ship_specifics = $row[“Ship_specifics”];
$Speed = $row[“Speed”];
$Status = $row[“Status”];
$Nationality = $row[“Nationality”];
$IMO = $row[“IMO”];
}
}
else
{
echo “0 results”;
}
$conn->close();
}
[/insert_php]

$i = 2;
$exist = true;
while ($exist)
{
echo ‘

‘;
for($j = 0; $j < 3; $j++) { if(file_exists("/var/www/vhosts/virtek.nl/barkmeijer.virtek.nl/ShipImages/".$Bouwnr."-".$i.".jpg")) { echo '[vc_column width="1/3" css=".vc_custom_1445437565069{margin: 0px !important;border-width: 0px !important;padding: 0px !important;}"]'; echo '[vc_column_text css=".vc_custom_1445437556173{margin: 0px !important;border-width: 0px !important;padding: 0px !important;}"]'; echo '‘;
echo ‘ ‘;
echo ‘‘;
echo ‘[/vc_column_text]‘;
echo ‘[/vc_column]‘;
}
else
{
$exist = false;
}
$i++;
}
echo ‘