<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://getbootstrap.com/docs/5.3/assets/css/docs.css" rel="stylesheet">
    <title>COMMENTa</title>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
  <style>
      body {
  background-color: aqua;
            }
      
      
  </style>
  <style>
.footer {
   position: fixed;
   left: 0;
   bottom: 0;
   width: 100%;
   background-color: red;
   color: white;
   text-align: center;
}
</style>
  
  </head>
  <body class="p-3 m-0 border-0 bd-example m-0 border-0" bgcolor="aqua">
     <?php   include 'menu.php';?> 
     
     <?php
     
     //counting the total number of hits
     //connecting to the database
        
        $servername = "localhost";
        $username = "commemay_sono";
        $password = "Masiu@5$5$5$";
        $dbname = "commemay_csc";

        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);
        // Check connection
        if ($conn->connect_error) {
              die("Connection failed: " . $conn->connect_error);
        }
        
        
         
        
         //creating a query   
        $sql = "SELECT *  FROM hits  ";
        $result = $conn->query($sql);
        
        if ($result->num_rows > 0) {
         // output data of each row
         while($row = $result->fetch_assoc()) {
       
         $hits = $row["hits"];
         //incrementing hits
         $hits++;


        
        
        
        
            }
         }
       
       
       //updating  the hits table
        
        $sql = "UPDATE hits SET hits ='$hits' WHERE num = '1' ";

if (mysqli_query($conn, $sql)) {
 $account = "Hits updated successfully.";
}    
       
       
      $conn->close(); 
      
        
     ?>
     
     
   
     
     
      
      
<font face = 'verdana'>
    <!-- Example Code -->
    
    <center><h4 style="color:red;" ><i> <u>Welcome to COMMENTa</u>  <br/><br/> Platform for improving our schools.</i></h4></center>
   <center> <h1> <span class="badge text-bg-danger">COMMENTa</span> </h1> </center>
   
    <center> <h3 style="color:red;">  <u>In the best interest of the learner/s</u> </h3> </center>

    <center>
        
        <center><h4 style="color:red;" ><i> <br/>Your input will be highly appreciated.</i></h4></center>
        
   <div ><i>
        <p>Please help us improve our school by placing your opinion about our school. We believe that it will make a positive impact in our school. You can make a contribution in the form of complain, suggestion or compliment to any school in the country. </p>
        <p> Our platform allows you to communicate directly with school governing body of any school in the country. </p></i>
        
   </div>
    </center>
   
     
    
    
   
   
    

   
    
  
   <div class="alert alert-primary" role="alert">
    <center> <a href="/parents.php" class="alert-link">PARENTS EXPECTATION</a></center>
   </div>
   <!--
    
   <div class="alert alert-danger" role="alert">
    <center> <a href="https://chat.whatsapp.com/GQzrqTuona8CpFQJHHqLUx" class="alert-link">JOIN COMMENTa WHATSAPP GROUP</a></center>
   </div>
   -->
   <div class="alert alert-danger" role="alert">
    <center> <a href="/school.php" class="alert-link">SCHOOL EXPECTATION</a></center>
   </div>
   
  <div class="alert alert-info" role="alert">
 <center> <a href="joinwhatsapp.php" class="alert-link">JOIN WHATSAPP GROUP</a></center>
 </div>
 
 <div class="alert alert-primary" role="alert">
 <center> <a href="addcsc.php" class="alert-link">PLACE COMPLAIN/<br />SUGGESTION/COMPLIMENT</a></center>
 </div>
  <div class="alert alert-danger" role="alert">
 <center> <a href="viewcsc.php" class="alert-link">CONCERNS STATS</a></center>
 </div>
 <!--
 <div class="alert alert-danger" role="alert">
 <center> <a href="contactus.php" class="alert-link">VIEW COMPLIMENTS</a></center>
 </div>
 -->
 <div class="alert alert-info" role="alert">
 <center> <a href="cscsignup.php" class="alert-link">SIGN UP</a></center>
 </div>
 
 <div class="alert alert-primary" role="alert">
 <center> <a href="/csclogin.php" class="alert-link">LOGIN</a></center>
 </div>
 
 <div class="alert alert-danger" role="alert">
 <center> <a href="sgb.php" class="alert-link">SGB MEMBERS</a></center>
 </div>
   
  </font>  
  
   <center> <h3 style="color:red;">  <u>In the best interest of the learner/s.</u> </h3> </center> <BR />

  <!--
  <center><button type="button" class="btn btn-primary">
 COMMENTa <span class="badge text-bg-warning"><?php //echo $hits; ?></span>
</button></center>

-->
    <!-- End Example Code -->
    <br />
    <div class="footer"><br />
  <p>Powered by : Concerned Parent</p>
</div>
  </body>
</html>