CARGO
• Almenum • Osiris • Union Topaz • Trobadour • Aletis/Tertius
All Cargo Ships
DREDGING
• Reimerswaal • M.N.O. Zeezand • Orisant • Andre.L • UKD Orca
All Dredging Ships
PILOTAGE
• Prins Johan Willerm Friso • Happy Eagle • Rathrowan • Rathboyne
All Pilotage Ships
SPECIALS
• Orca • Smit Japan/Smit Siberië • Procyon • Pollux • Polaris
All Special Ships
Fully custom ships by extended building, since 1850
Barkmeijer’s extensive track record demonstrates our capability to meet the needs of our customers. Our substantial portfolio includes cargo vessels, dredgers, sea-basing vessels and many more projects that are highly valued by owners as well as sailors. According to Barkmeijer the best ships are not constructed by the shipyard single-handedly, but in co-operation. Developing a new vessel is a joint operation. The relationship between clients and the shipyard is the base to the shipbuilding process of Barkmeijer. Our clients are not buying in bulk, but want a custom product suited to their needs. That dedication is why customers return to the shipyard in Stroobos. Barkmeijer doesn’t just build a ship, but a companionship: a mate for life.
Tankers Dry cargo Fishing vessels
Dredger Tug Boats Inland vessels
Sea Basing Crew Tenders Specials
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 "
echo "
"; echo ""; echo "
//if(file_exists("/var/www/vhosts/virtek.nl/barkmeijer.virtek.nl/ShipImages/".$row["Bouwnr"]."-1.jpg")) //echo getcwd ();/home/barkm76/domains/barkmeijer.com/public_html if(file_exists("/home/barkm76/domains/barkmeijer.com/public_html/ShipImages/".$row["Bouwnr"]."-1.jpg")) { echo ""; } else { echo ""; } echo "
"; echo $row["Naam"]; echo ""; echo "
"; echo "