<?php
require('admin/html/connection.php');

// Fetch data from contact_info table
$sql = "SELECT * FROM contact_info";
$result = mysqli_query($conn, $sql);

// Display data from contact_info
if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $email = $row['email1'];
    $logo = $row['logo'];
    $address = $row['address'];
    $phone = $row['phone'];
} else {
    echo "0 results";
}


// Fetch data from footer_information table
$sql = "SELECT * FROM footer_content";
$result = mysqli_query($conn, $sql);

// Display data from contact_info
if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $footer_address = $row['branch1'];
    $about_content = $row['about_us'];

    
} else {
    echo "0 results";
}

// Fetch data from services
$sql = "SELECT * FROM tour_packages";
$result = mysqli_query($conn, $sql);

// Display data from contact_info
if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
   $id = $row['id'];
   $service_name = $row['package_name'];
   $service_image = $row['package_image'];
   $service_name = $row['description'];
    
} else {
    echo "0 results";
}


?>