<?php
include("../include/config.inc.php");
?>
 <h2>Import Excel File into MySQL Database using PHP</h2>
    
    <div class="outer-container">
        <form action="process_import.php" method="post"
            name="frmExcelImport" id="frmExcelImport" enctype="multipart/form-data">
            <div>
                <label>Choose Excel
                    File</label> <input type="file" name="file"
                    id="file" accept=".xls,.xlsx">
                    <label>Course</label>
                    <select name="course_id">
                        <option> - - Select - - </option>
                        <?php
                            $courseQ=mysqli_query($con,"select * from course order by id desc");
                            while($courseR=mysqli_fetch_array($courseQ)){
                        ?>
                            <option value="<?=$courseR['id'];?>"><?=$courseR['name'];?></option>
                        <?php
                            }
                        ?>
                    </select>
                    <label>Session</label>
                    <select name="session_id">
                        <option> - - Select - - </option>
                        <?php
                            $sessionQ=mysqli_query($con,"select session.name,course.name as course_name,
                                session.id from session
                                left join course on course.id=session.course_id 
                                order by session.id desc");
                            while($sessionR=mysqli_fetch_array($sessionQ)){
                        ?>
                            <option value="<?=$sessionR['id'];?>"><?=$sessionR['course_name'];?> , <?=$sessionR['name'];?></option>
                        <?php
                            }
                        ?>
                    </select>
                <button type="submit" id="submit" name="import"
                    class="btn-submit">Import</button>
                
            </div>
        
        </form>
        
    </div>
    <div id="response" class="<?php if(!empty($type)) { echo $type . " display-block"; } ?>"><?php if(!empty($message)) { echo $message; } ?></div>
    
         
<?php
    $sqlSelect = "SELECT * FROM tbl_info";
    $result = mysqli_query($con, $sqlSelect);

if (mysqli_num_rows($result) > 0)
{
?>
        
    <table class='tutorial-table'>
        <thead>
            <tr>
                <th>Name</th>
                <th>Description</th>

            </tr>
        </thead>
<?php
    while ($row = mysqli_fetch_array($result)) {
?>                  
        <tbody>
        <tr>
            <td><?php  echo $row['name']; ?></td>
            <td><?php  echo $row['description']; ?></td>
        </tr>
<?php
    }
?>
        </tbody>
    </table>
<?php 
} 
?>