Aviation Services

The Aviation Yellow Pages has a comprehensive list of contacts for all your aviation requirements! We aim to have all the correct contact details and links to as many websites as possible to ensure you get as much detail from our information as possible. However, if you know of any information that may be wrong or outdated, please contact us with the correct details. Thank you!
Submit

[insert_php]
// MySQL server
define(‘DB_HOST’, ‘localhost’);

// Database name
define(‘DB_NAME’, ‘aviation_db’);

// MySQL username
define(‘DB_USER’, ‘aviation_db’);

// MySQL password
define(‘DB_PASS’, ‘!@aviationD#$PPC’);

$DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);
$result = mysql_query(“SELECT DISTINCT (Country) FROM aviation_services”);

// COUNTRY
$num_row_country = mysql_num_rows($result);

$x = 1;
echo ‘

    );
    $country_found2 = $country[‘Country’];

    echo ‘ tab’ . $x . ‘=”‘ . $country_found . ‘” tab’. $x .’_icon=”icon-globe”‘;

    // MySQL server
    define(‘DB_HOST’, ‘localhost’);

    // Database name
    define(‘DB_NAME’, ‘aviation_db’);

    // MySQL username
    define(‘DB_USER’, ‘aviation_db’);

    // MySQL password
    define(‘DB_PASS’, ‘!@aviationD#$PPC’);

    $DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
    mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);

    $resultCategory = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);

    $x++;
    }
    echo ‘]’;

    //////////////////////////////////////////////////////////////////////////////////////////////////////////
    // Find all the category for the menu only ( Distinct)

    // MySQL server
    define(‘DB_HOST’, ‘localhost’);

    // Database name
    define(‘DB_NAME’, ‘aviation_db’);

    // MySQL username
    define(‘DB_USER’, ‘aviation_db’);

    // MySQL password
    define(‘DB_PASS’, ‘!@aviationD#$PPC’);

    $DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
    mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);

    $result = mysql_query(“SELECT DISTINCT (Country) FROM aviation_services”);

    while($country = mysql_fetch_array($result)) {
    $country_found = str_replace(‘ ‘, ”, $country[‘Country’]);
    $country_found2 = $country[‘Country’];

    $resultCategory = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);

    //////////////////////////////////////////////////////////////////////////////////////////////////////////
    // CATEGORY

    $num_row = mysql_num_rows($resultCategory);

    echo ‘

    Please Choose an Option

    $a=1;
    while($category = mysql_fetch_array($resultCategory)) {
    $category_found2 = $category[‘Category’];
    $category_found = str_replace(‘ ‘, ”, $category_found2);

    echo ‘

    ‘;
    $a++;
    }
    echo ‘

     

    ‘;

    //////////////////////////////////////////////////////////////////////////////////////////////////////////
    // Find all the category for details alone
    // MySQL server
    define(‘DB_HOST’, ‘localhost’);

    // Database name
    define(‘DB_NAME’, ‘aviation_db’);

    // MySQL username
    define(‘DB_USER’, ‘aviation_db’);

    // MySQL password
    define(‘DB_PASS’, ‘!@aviationD#$PPC’);

    $DB = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die (“Couldn’t connect”);
    mysql_select_db(DB_NAME, $DB) or die (“Couldn’t select database”);

    $resultCategory_new = mysql_query(“SELECT DISTINCT (Category) FROM `aviation_services` WHERE `Country` = ‘$country_found2′”);

    while($categoryTest = mysql_fetch_array($resultCategory_new)) {

    $category_found_new2 = $categoryTest[‘Category’];
    $category_found_new = str_replace(‘ ‘, ”, $category_found_new2);

    echo ‘

    ‘;
    }
    echo ‘

    ‘;
    }
    [/insert_php]
    ©Copyright 2016, Aviation Direct (Pty) Ltd, All Rights Reserved. Another website SPICED up by PeriPeriCreative.