Untitled

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

$redirectQuery = "SELECT * "
        . "FROM student, parent, student_cca "
        . "WHERE student.student_id = student_cca.student_id "
        . "AND student.parent_nric = parent.parent_nric "
        . "AND parent.parent_nric ='".$theNRIC."'";
$redirectResult = mysqli_query($link, $redirectQuery) or die(mysql_error());
$totalrows = mysqli_num_rows($redirectResult);
if ($totalrows > 0)
{   // has results
    header("Location: parent_view_cca.php");
    exit(0);
}
else
{   // no result
    echo "<h4>Welcome to Maintain CCA!</h4>";
}

$query = "SELECT student.student_id, parent.parent_email, cca.cca_name, 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."'";
$result = mysqli_query($link, $query);
$numrow = mysqli_num_rows($result);
if ($numrow > 0)
{   // has results
    echo "<h5>Please check your choices accordingly.</h5>";
}
else
{   // no result
    //echo "<h4>You have not chosen a CCA! <a href='parent_add_submit_cca_choice.php'>Click here to do so!</a>.</h4>";
    header("Location: parent_add_submit_cca_choice.php");
    exit(0);
}
$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');
?>

<!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">
    <meta name="description" content="">
    <meta name="author" content="">

    <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("category1").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("category2").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();
            }
        </script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
    <script type="text/javascript">
        $(function() {
            // jQuery functions go here.
            $('#toggle1').click(function() {
                $('.toggle1').toggle();
                return false;
            });
        });
    </script>


    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->

</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 System</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">
                    <li>
                        <a href="#">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 Student Information</a>
                    </li>
                    <li>
                        <a href="logout.php">Logout</a>
                    </li>
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div><!-- /.container -->
    </nav>
        <center>

        <!-- Page Content -->
        <h1><u>Maintain CCA</u></h1>
        <br>
        <form method="post" action="do_parent_submit_cca_choice.php">
            <div style="width:350px;">
                <label for="1stchoice">1st Choice:</label>
                <br>
            <select class="form-control" id="1stchoice" name="1stchoice">
                        <option value ="<?php echo $row['category_id']; ?>">
                                    <?php echo $row['category_name']; ?>
                                </option>
                    </select>
            <br>
            <select class="form-control" id="1stchoice" name="1stchoice">
                        <option value ="<?php echo $row['cca_id']; ?>">
                                    <?php echo $row['cca_name']; ?>
                                </option>
                    </select>
            <br></br>
            <label for="2ndchoice">2nd Choice:</label>
                <br>
            <select class="form-control" id="2ndchoice" name="2ndchoice">
                        <option value ="<?php echo $row['category_id']; ?>">
                                    <?php echo $row['category_name']; ?>
                                </option>
                    </select>
            <br>
            <select class="form-control" id="2ndchoice" name="2ndchoice">
                        <option value ="<?php echo $row['cca_id']; ?>">
                                    <?php echo $row['cca_name']; ?>
                                </option>
                    </select>
            <label for="3rdchoice">3rd Choice:</label>
                <br>
            <select class="form-control" id="3rdchoice" name="3rdchoice">
                        <option value ="<?php echo $row['category_id']; ?>">
                                    <?php echo $row['category_name']; ?>
                                </option>
                    </select>
            <br>
            <select class="form-control" id="3rdchoice" name="3rdchoice">
                        <option value ="<?php echo $row['cca_id']; ?>">
                                    <?php echo $row['cca_name']; ?>
                                </option>
                    </select>
            </div>
             </form>
        <form method="post" action="do_parent_delete_cca_choice.php" name="delete_form">
            <input type="hidden" name="student_id" value="<?php echo $row['student_id'] ?>" />

            <input class="btn btn-danger" type="submit" value="Delete CCA Choices"/>
        </form>
                    <?php }else {
    echo"you are unable to view this page";
}
    ?>
        <br>
        </centre>

        <!-- 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>