><?php bloginfo('name'); ?> - IMPEXTER INTERNATIONAL CUSTOMER VERIFICATION SYSTEM oncontextmenu="return false">
Importer/Exporter Verification System
Find Any Data

Note: Fields can be used separately for basic searches or in combination for advanced searches. Our advanced search engine uses AI to provide more accurate results. For example, you can enter a single word or a full company name in the company field.

CLICK HERE FOR EXPORT DATA
connect_error) { die("Connection failed: " . $conn->connect_error); }// Constants for pagination $itemsPerPage = 100; $page = isset($_GET['page']) ? intval($_GET['page']) : 1;if (isset($_POST['submit'])) { $searchText = $_POST['search_text']; $PCT = $_POST['PCT']; $PRODUCT = $_POST['PRODUCT']; $df = $_POST['df']; $dt = $_POST['dt'];// Create the SQL query with dynamic conditions $sql = "SELECT * FROM IMPO2023 WHERE 1";if (!empty($searchText)) { $sql .= " AND (IMPORTER LIKE '%$searchText%' OR EXPORTER LIKE '%$searchText%')"; }if (!empty($PCT)) { $sql .= " AND PCT LIKE '%$PCT%'"; } if (!empty($BL)) { $sql .= " AND BL LIKE '%$BL%'"; }if (!empty($PRODUCT)) { $sql .= " AND PRODUCT LIKE '%$PRODUCT%'"; }if (!empty($df)) { $sql .= " AND DATE >= '$df'"; } if (!empty($dt)) { $sql .= " AND DATE <= '$dt'"; }$result = $conn->query($sql);if ($result->num_rows > 0) { // Get total number of items $totalItems = $result->num_rows; // Calculate total pages $totalPages = ceil($totalItems / $itemsPerPage); // Ensure page is within valid range $page = max(1, min($page, $totalPages)); // Calculate the offset for the current page $offset = ($page - 1) * $itemsPerPage; // Modify the SQL query to add pagination $sql .= " LIMIT $offset, $itemsPerPage";$result = $conn->query($sql); // Display search results in a table echo ""; echo "";while ($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; }echo "
IDGDDATEHSCODEPRODUCTBLPODNTNIMPORTEREXPORTERORIGINPOLDVLAVLCURQTYUOMIMPVLCDECDPCDSTESTPSTITEITPITADSTREDADCFEDANTIDSRO1SRO2SRO3SRO4AGENTACODEGDNAMEPARTYIMPORTERADDTERMINALGDDATEVIRLINEVESSEL
" . $row['ID'] . "" . $row['GD'] . "" . $row['DATE'] . "" . $row['HSCODE'] . "" . $row['PRODUCT'] . "" . $row['BL'] . "" . $row['POD'] . "" . $row['NTN'] . "" . $row['IMPORTER'] . "" . $row['EXPORTER'] . "" . $row['ORIGIN'] . "" . $row['POL'] . "" . $row['DVL'] . "" . $row['AVL'] . "" . $row['CUR'] . "" . $row['QTY'] . "" . $row['UOM'] . "" . $row['IMPVL'] . "" . $row['CD'] . "" . $row['ECD'] . "" . $row['PCD'] . "" . $row['ST'] . "" . $row['EST'] . "" . $row['PST'] . "" . $row['IT'] . "" . $row['EIT'] . "" . $row['PIT'] . "" . $row['ADST'] . "" . $row['RED'] . "" . $row['ADC'] . "" . $row['FED'] . "" . $row['ANTID'] . "" . $row['SRO1'] . "" . $row['SRO2'] . "" . $row['SRO3'] . "" . $row['SRO4'] . "" . $row['AGENT'] . "" . $row['ACODE'] . "" . $row['GDNAMEPARTY'] . "" . $row['IMPORTERADD'] . "" . $row['TERMINAL'] . "" . $row['GDDATE'] . "" . $row['VIR'] . "" . $row['LINE'] . "" . $row['VESSEL'] . "
";// Previous and Next page links
1) { ?> Previous Next