Untitled

<?php
session_start();
include "dbFunctions.php";
IF (isset($_SESSION['parent_nric'])){
    $theNRIC = $_SESSION['parent_nric'];
        $name = $_SESSION['parent_name'];

//$query = "SELECT student.student_id, cca.cca_id, cca.cca_name, cca.cca_size, cca_category.category_id, cca_category.category_name FROM choices, student, parent, cca, cca_category WHERE student.student_id = choices.student_id and choices.cca_id=cca.cca_id AND cca.category_id=cca_category.category_id and student.parent_nric = parent.parent_nric and parent.parent_nric='".$theNRIC."'";
$query = "SELECT student_id, parent_email FROM student, parent WHERE student.parent_nric = parent.parent_nric and parent.parent_nric='".$theNRIC."'";
$result = mysqli_query($link, $query) or die('Error querying database');
$row = mysqli_fetch_array($result);

// create sql query
$categoryQuery = "SELECT * FROM cca_category";

// execute sql query
$categoryResult1 = mysqli_query($link, $categoryQuery) or die('Error querying database');
$categoryResult2 = mysqli_query($link, $categoryQuery) or die('Error querying database');
$categoryResult3 = mysqli_query($link, $categoryQuery) or die('Error querying database');

?>

<!DOCTYPE html>
<html lang="en">

    <head>
        <title>CCA Registration System</title>

        <!-- Bootstrap Core CSS -->
        <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="css/shop-homepage.css" rel="stylesheet">
    <script language="javascript" type="text/javascript">
            function showCCADropDown1() {
                var str1 = document.getElementById("choice1").value;
                if (window.XMLHttpRequest) {
                    // code for IE7+, Firefox, Chrome, Opera, Safari
                    xmlhttp = new XMLHttpRequest();
                } else {
                    // code for IE6, IE5
                    xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
                }
                xmlhttp.onreadystatechange = function () {
                    if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                        document.getElementById("ajaxDiv1").innerHTML = xmlhttp.responseText;
                    }
                };
                xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str1, true);
                xmlhttp.send();
            }
            function showCCADropDown2() {
                var str2 = document.getElementById("choice2").value;
                if (window.XMLHttpRequest) {
                    // code for IE7+, Firefox, Chrome, Opera, Safari
                    xmlhttp = new XMLHttpRequest();
                } else {
                    // code for IE6, IE5
                    xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
                }
                xmlhttp.onreadystatechange = function () {
                    if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                        document.getElementById("ajaxDiv2").innerHTML = xmlhttp.responseText;
                    }
                };
                xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str2, true);
                xmlhttp.send();
            }
            function showCCADropDown3() {
                var str3 = document.getElementById("choice3").value;
                if (window.XMLHttpRequest) {
                    // code for IE7+, Firefox, Chrome, Opera, Safari
                    xmlhttp = new XMLHttpRequest();
                } else {
                    // code for IE6, IE5
                    xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
                }
                xmlhttp.onreadystatechange = function () {
                    if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                        document.getElementById("ajaxDiv3").innerHTML = xmlhttp.responseText;
                    }
                };
                xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str3, true);
                xmlhttp.send();
            }
</script>


 </head>

    <body>

        <!-- Navigation -->

        <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">

            <div class="container">
                <!-- Brand and toggle get grouped for better mobile display -->
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                        <span class="sr-only">Toggle navigation</span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </button>
                    <a class="navbar-brand" href="#">CCA Registration Portal</a>
                </div>
                <!-- Collect the nav links, forms, and other content for toggling -->
                <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">

                    <ul class="nav navbar-nav navbar-right">

                        <li>
                            <form role="form" method="post" action="doSearch.php" style="padding-top:10px;">
                                <input type="text" placeholder="Enter CCA Name" name="cca_name">
                                <input type="submit" Value="Search" class="btn btn-info btn-xs"/>
                            </form>
                        </li>
                        <?php if (isset($_SESSION['student_id']) || isset($_SESSION['parent_nric']) || isset($_SESSION['staff_id'])) { ?>
                            <li>
                                <a href="#"><?php echo $name; ?></a>
                            </li>
                            <li>
                                <a href="logout.php">Logout</a>
                            </li>
                             </ul>
                            <ul class="nav navbar-nav navbar-left">
                            <li><a href="index.php"><img src="images/schoollogo2.jpg" alt="" width="500px" height=90/></a>
                    </li>
                        <?php } ?>
                    </ul>
                    <ul class="nav navbar-nav">
                        <li>
                            <a href="browseCCA.php">Browse CCA</a>
                        </li>
                    <li>
                                <a href="parent_cca_choice.php">CCA Choices</a>
                            </li>
                            <li>
                                <a href="parent_edit_maintain_personal_information.php">Maintain Personal Information </a>
                            </li>
                            <li>
                                <a href="parent_maintain_student_information.php">Maintain Parents Information</a>
                            </li>
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div>
<!-- /.container -->
    </nav>
<center>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
        <!-- Page Content -->
        <h3><u>Add CCA Choices</u></h3>
        <br>
        <form role="form" method="post" action="do_parent_add_submit_cca_choice.php">
                    <div style="width:350px;">
                        <label for="choice1">1st Choice:</label>
                        <select class="form-control" id="choice1" name="choice1" onchange="showCCADropDown1()">
                            <option value="0">All Category</option>
                            <?php
                            while ($categoryRow1 = mysqli_fetch_assoc($categoryResult1)) {
                                ?>
                                <option value ="<?php echo $categoryRow1['category_id']; ?>">
                                    <?php echo $categoryRow1['category_name']; ?>
                                </option>
                                <?php
                            }
                            ?>
                        </select>
                        <div id='ajaxDiv1'></div>
                    </div>
            <br>
            <div class="row">
                <div style="width:350px;">
                    <label for="choice2">2nd Choice:</label>
                    <select class="form-control" id="choice2" name="choice2" onchange="showCCADropDown2()">
                        <option value="0">All Category</option>
                        <?php
                        while ($categoryRow2 = mysqli_fetch_assoc($categoryResult2)) {
                            ?>
                            <option value ="<?php echo $categoryRow2['category_id']; ?>">
                                <?php echo $categoryRow2['category_name']; ?>
                            </option>
                            <?php
                        }
                        ?>
                    </select>
                    <div id='ajaxDiv2'></div>
                </div>
            </div>
            <br>
            <div class="row">
                <div style="width:350px;">
                    <label for="choice3">3rd Choice:</label>
                    <select class="form-control" id="choice3" name="choice3" onchange="showCCADropDown3()">
                        <option value="0">All Category</option>
                        <?php
                        while ($categoryRow3 = mysqli_fetch_assoc($categoryResult3)) {
                            ?>
                            <option value ="<?php echo $categoryRow3['category_id']; ?>">
                                <?php echo $categoryRow3['category_name']; ?>
                            </option>
                            <?php
                        }
                        ?>
                    </select>
                    <div id='ajaxDiv3'></div>
                </div>
            </div>
            <br>
            <input type="hidden" id="student_id" name="student_id" value="<?php echo $row['student_id'] ?>" />
            <input type="hidden" id="parent_email" name="parent_email" value="<?php echo $row['parent_email'] ?>" />
            <input type="submit" Value="Submit Choices" class="btn btn-info btn-lg"/>
        </form>
        <?php }else {
    echo"you are unable to view this page";
}
    ?>


        </center>
<!-- Footer -->
        <footer>
            <div class="row">
                <div class="col-lg-12">
                    <p>Copyright &copy; 4 Aces</p>
                </div>
            </div>
        </footer>

    </div>
    <!-- /.container -->

    <!-- jQuery -->
    <script src="js/jquery.js"></script>

    <!-- Bootstrap Core JavaScript -->
    <script src="js/bootstrap.min.js"></script>

</body>

</html>