<?php

error_reporting(E_ALL);
ini_set('display_errors', 'on');

include_once('config.php');

$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';

$master = $conn->query("select master_id, master_name, source from `csp_sp_master_category` where source='OLY' order by master_id");

?>
<div>View Missing Images Master Wise / Column Wise</div>
<table>
    <tr>
        <th>#N</th>
        <th>Master Id</th>
        <th>Master Name</th>
        <th>Instruction</th>
        <th>Question</th>
        <th>Option1</th>
        <th>Option2</th>
        <th>Option3</th>
        <th>Option4</th>
        <th>Option5</th>
        <th>Solution</th>
    </tr>
    <?php 
    $i=1;
    while ($row = $master->fetch_assoc()) {
        $mId = $row['master_id'];
        $mName = $row['master_name'];
    ?>
        <tr>
            <td><?php echo $i; ?></td>
            <td><?php echo $mId; ?></td>
            <td><?php echo $mName; ?></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=question_instruction" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=question_statement" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=option_1" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=option_2" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=option_3" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=option_4" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=option_5" target="_blank">View</a></td>
            <td><a href="find_missing_image_master.php?master_id=<?php echo $mId; ?>&colm=question_solution" target="_blank">View</a></td>
        </tr>
    <?php $i++; } ?>
</table>
<style>
    table,
    th,
    td {
        border: 1px solid #ccc;
        border-collapse: collapse;
        padding: 5px;
    }
</style>