1#@!#!123s

: / home3 / encodto1 / attraction.encodersunlimited.com /
Filename : academy.php
back
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">

    <title>Ramada | Academy</title>

    <!-- Fav Icon -->
    <link rel="icon" href="assets/images/favicon.ico" type="image/x-icon">

    <!-- Google Fonts -->
    <link href="https://fonts.googleapis.com/css2?family=Mrs+Saint+Delafield&amp;display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css2?family=Jost:ital,wght@0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,300;1,400;1,500;1,600;1,700;1,800;1,900&amp;display=swap" rel="stylesheet">

    <!-- Stylesheets -->
    <link href="assets/css/font-awesome-all.css" rel="stylesheet">
    <link href="assets/css/flaticon.css" rel="stylesheet">
    <link href="assets/css/owl.css" rel="stylesheet">
    <link href="assets/css/bootstrap.css" rel="stylesheet">
    <link href="assets/css/jquery.fancybox.min.css" rel="stylesheet">
    <link href="assets/css/animate.css" rel="stylesheet">
    <link href="assets/css/nice-select.css" rel="stylesheet">
    <link href="assets/css/imagebg.css" rel="stylesheet">
    <link href="assets/css/color.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <link href="assets/css/responsive.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css" rel="stylesheet">

    <style>
        .workshop-section {
            display: flex;
            flex-wrap: wrap;
            align-items: center;
            padding: 1.5rem; /* Reduced padding */
            background-color: #f9f9f9;
        }

        .workshop-section.reverse {
            flex-direction: row-reverse;
        }

        .workshop-image img {
            width: 100%;
            height: auto;
            border-radius: 0.5rem;
        }

        .workshop-content {
            padding: 1.5rem; /* Reduced padding */
        }

        .workshop-title {
            font-size: 1.5rem; /* Reduced font size */
            font-weight: bold;
            margin-bottom: 1rem;
            text-align: center;
        }

        .workshop-description {
            font-size: 0.9rem; /* Reduced font size */
            margin-bottom: 1rem; /* Reduced margin */
            text-align: center;
        }

        .enquire-btn {
            border: 1px solid #000;
            border-radius: 0.25rem;
            padding: 0.5rem 1.5rem;
            font-size: 0.9rem; /* Reduced font size */
            font-weight: 500;
            background-color: transparent;
            display: block;
            margin: 0 auto;
            text-align: center;
        }

        @media (max-width: 768px) {
            .workshop-section {
                flex-direction: column;
            }

            .workshop-section.reverse {
                flex-direction: column;
            }
        }

        .learning-points {
            display: flex;
            flex-wrap: wrap;
            gap: 10px; /* Reduced gap */
            margin-top: 15px; /* Reduced margin */
        }

        .learning-column {
            flex: 1;
            min-width: 220px; /* Reduced minimum width */
            background-color: #fff;
            border: 1px solid #ddd;
            border-radius: 8px;
            padding: 15px; /* Reduced padding */
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
            transition: transform 0.2s;
        }

        .learning-column:hover {
            transform: translateY(-5px);
        }

        .learning-column h3 {
            font-size: 1rem; /* Reduced font size */
            font-weight: bold;
            margin-bottom: 8px; /* Reduced margin */
            color: #333;
        }

        .learning-column ul {
            list-style: none;
            padding: 0;
            margin: 0;
        }

        .learning-column ul li {
            display: flex;
            align-items: center;
            margin-bottom: 8px; /* Reduced margin */
            color: #555;
            font-size: 0.9rem; /* Reduced font size */
        }

        .learning-column ul li i {
            font-size: 16px; /* Reduced icon size */
            color: rgb(0, 0, 0);
            margin-right: 8px; /* Reduced margin */
        }

        .course-details {
            text-align: center;
            margin-top: 15px; /* Reduced margin */
        }

        .course-details p {
            margin-bottom: 8px; /* Reduced margin */
            font-size: 1rem; /* Reduced font size */
        }

        .course-details .price {
            font-size: 1.3rem; /* Reduced font size */
            font-weight: bold;
            color: rgb(0, 0, 0);
        }
    </style>
</head>

<body>
    <div class="boxed_wrapper">

        <?php include 'header.php' ?>

        <section class="page-title centred" style="background-image: url(assets/images/background/abouts.jpg);">
            <div class="auto-container">
                <div class="title-box">
                    <span class="title-text"></span>
                    <h1></h1>
                </div>
            </div>
        </section>

        <?php
        // Database connection
        include('config.php'); // Ensure this file contains your database connection details

        // Query to fetch data from the academy table
        $query = "SELECT id, name, description, image, duration, price, spec, specs FROM academy";
        $result = mysqli_query($conn, $query);

        // Check if there are results
        if (mysqli_num_rows($result) > 0) {
            $counter = 0; // Initialize counter
            // Loop through each record and display the content
            while ($row = mysqli_fetch_assoc($result)) {
                $id = $row['id'];
                $name = $row['name'];
                $description = $row['description'];
                $image = $row['image'];
                $duration = $row['duration'];
                $price = $row['price'];
                $spec = $row['spec'];
                $specs = $row['specs'];

                // Convert specs to an array and display each spec
                $specs_array = explode(",", $specs);
                $specs_list = "";
                foreach ($specs_array as $single_spec) {
                    $specs_list .= "<li><i class='fas fa-check'></i> " . trim($single_spec) . "</li>";
                }

                // Convert spec to an array and display it
                $spec_array = explode(",", $spec);
                $spec_list = "";
                foreach ($spec_array as $single_spec) {
                    $spec_list .= "<li><i class='fas fa-check'></i> " . trim($single_spec) . "</li>";
                }

                // Add a class for alternating the layout
                $reverse_class = ($counter % 2 == 0) ? '' : 'reverse';
                $counter++; // Increment counter

                // Display the data within HTML
                echo "
        <section class='workshop-section container-fluid $reverse_class'>
            <div class='workshop-image col-lg-6 col-md-12 mb-4 mb-lg-0'>
                <img src='attadminraction/uploads/$image' alt='$name'>
            </div>
            <div class='workshop-content col-lg-6 col-md-12'>
                <h2 class='workshop-title'>$name</h2>
                <p class='workshop-description'>
                    $description
                </p>
                <div class='learning-points'>
                    <div class='learning-column'>
                        <h3>Spec</h3>
                        <ul>
                            $spec_list
                        </ul>
                    </div>
                    <div class='learning-column'>
                        <h3>Specs</h3>
                        <ul>
                            $specs_list
                        </ul>
                    </div>
                </div>
                <div class='course-details'>
                    <p><strong>Duration:</strong> $duration</p>
                    <p class='price'>Price: ₹ $price</p>
                </div>
                <a href='getquote.php'><button class='enquire-btn'>Enquire Now</button></a>
            </div>
        </section>";
            }
        } else {
            echo "<p>No workshops found.</p>";
        }

        mysqli_close($conn); // Close the database connection
        ?>

        <?php include 'footer.php' ?>
    </div>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/js/bootstrap.bundle.min.js"></script>
</body>

</html>