Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxrwsr-x
certificates	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxrwxrwx
halltickets	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxrwxr-x
img	[ DIR ]	drwxrwxr-x
imported_files	[ DIR ]	drwxrwxrwx
stud_name_uploads	[ DIR ]	drwxrwxrwx
student_photos	[ DIR ]	drwxrwxrwx
study_material	[ DIR ]	drwxrwsr-x
teacher_photos	[ DIR ]	drwxrwsr-x
tmpphotos	[ DIR ]	drwxrwsr-x
upload	[ DIR ]	drwxrwxrwx
MainPage.html	22.11 KB	-rw-rw-r--
collegeInfoPopup.html	4.35 KB	-rw-rw-r--
flash.html	2.23 KB	-rw-rw-r--
forgotpassword.html	3.38 KB	-rw-rw-r--
getAppdet.php	8 KB	-rw-rw-r--
getSeatdet.php	7.84 KB	-rw-rw-r--
homepage.html	3.35 KB	-rw-rw-r--
index.html	6.27 KB	-rw-rw-r--
index_stop.php	5.09 KB	-rw-rw-r--
indexlogin.html	6.5 KB	-rw-rw-r--
indexlogin_old.html	6.18 KB	-rw-rw-r--
pgadm.php	13.75 KB	-rw-rw-r--
ru_new_college_codes.pdf	82.77 KB	-rwxrwxrwx
seatdet.php	13.66 KB	-rw-rw-r--
valdet.php	12.86 KB	-rw-rw-r--

Code Editor : seatdet.php

<!DOCTYPE html>
<html>

<head>
    <meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate" />
    <meta http-equiv="Pragma" content="no-cache" />
    <meta http-equiv="Expires" content="0" />
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=Edge">
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <title>Course wise statistics</title>
    
    <link rel="icon" href="favicon.ico" type="image/x-icon">
    <link href="https://universitysolutions.in/bcu/adm/plugins/bootstrap/css/bootstrap_adm.css" rel="stylesheet">

<link href="https://universitysolutions.in/bcu/adm/plugins/node-waves/waves.css" rel="stylesheet" />

<link href="https://universitysolutions.in/bcu/adm/css/style_adm.css" rel="stylesheet">
    
    <link href="https://fonts.googleapis.com/css?family=Roboto:400,700&subset=latin,cyrillic-ext" rel="stylesheet" type="text/css">
    <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet" type="text/css">
    <link href="https://universitysolutions.in/bcu/adm/css/themes/all-themes.css" rel="stylesheet" />

</head>

<?php

include("/var/www/config.php");

// $servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
    // $username   = "admin";
    // $password  = "Logisys2104";

$servername = SERVERNAME;
    $username   = USERNAME;
    $password  = PASSWORD;

$conn = new  mysqli($servername, $username, $password);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    // echo "<br/><br/><br/><br/>";
    $url = $_SERVER['REQUEST_URI'];
    $path = explode("/", $url);

// var_dump($path[1]);
    if ($path[1] == "bcu")
        $db = "logisys3_bcu";
    else if ($path[1] == "bnu")
        $db = "logisys3_bnu";
    else if ($path[1] == "dud")
        $db = "logisys3_dud";
    else if ($path[1] == "rcub")
        $db = "logisys3_rcu";
    else if ($path[1] == "ru")
        $db = "logisys3_rur";

$Query = "select fboardcode, fboardname, 
funivcode, funivname, date_format(now(), '%d/%m/%Y %r') as fdate
FROM {$db}.masboard, {$db}.control c order by fboardcode";
    $result = mysqli_query($conn, $Query);
    $row = mysqli_fetch_assoc($result);

$Query2 = "select distinct fdegree, fdescpn from {$db}.entdeg where fdegree in(select distinct fdegree from {$db}.entseatallot where ifnull(fpaymentstatus,'') = 'success') ";
    $result2 = mysqli_query($conn, $Query2);
    $row2 = mysqli_fetch_assoc($result2);

<section class="content">
        <div class="container-fluid">
            <div class="tab-content" id="loadtab">
                
                <div class="row clearfix" id="personal_det">
                    <div class="col-lg-10 col-md-12 col-sm-12 col-xs-12">
                        <div class="card ">
                            <div class="header bg-blue text-center">
                                <h2>College wise Course wise statistics</h2>
                            </div>
                            <div class="row clearfix  body" style='margin-right: 0px;margin-left: 0px;' id="idPerDet">
                                <div class="field">
                                    <div class="col-md-6">
                                        <b>Select Degree </b>
                                        <div class="form-group p-b-20">
                                            <div>
                                                <select id="fdegree" onchange="getAppDet();" class="form-control" name="Combination">
                                                    
                                                    <option value="All">All</option>
                                                    <?php
                                                    echo "<option value='{$row2['fdegree']}'>{$row2['fdegree']}-{$row2['fdescpn']}</option>";
                                                    while ($row = mysqli_fetch_assoc($result2)) {
                                                        echo "<option value='{$row['fdegree']}'>{$row['fdegree']}-{$row['fdescpn']}</option>";
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<script src="https://universitysolutions.in/bcu/adm/plugins/bootstrap/js/bootstrap.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/bootstrap-select/js/bootstrap-select.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/jquery-slimscroll/jquery.slimscroll.js"></script>

<script src="https://universitysolutions.in/bcu/adm/plugins/node-waves/waves.js"></script>

var tot_app = 0;
 for(let i of apptab){
    $html += `<tr>
         <td><center>${slno++}</center></td>
         <td><center>${i.fcollcode}</center></td>
         <td>${i.fcollname}</td>
         <td><center>${i.fdegree}</center></td>
         <td>${i.fdescpn}</td>
         <td style='text-align:center'>${i.cnt}</td>
         </tr>`;

//  paid += ${i.paid};
        //  not_paid = not_paid + apptab['not_paid'];
        // console.log(i.tot_app);
         tot_app += parseInt(i.cnt);
        
    //   console.log(apptab['tot_app']);
 }

$html += `<tr>
    <td colspan='5'  style='text-align:center'><b>Total</b></td>
    <td style='text-align:center'><b>${tot_app}</td>

</tr>`;
}

$("#appdet").html($html);

}
            });
        }

// function getBoardDet() {
        //     var fdeggrp = $("#fdegree").val();
        //     var sem = $("#sem").val();
        //     $.ajax({
        //         type: "POST",
        //         async: false,
        //         data: "type=board" + "&fdeggrp=" + fdeggrp + "&sem=" + sem,
        //         url: "getQPdet.php",
        //         success: function(responce) {
        //             var board = JSON.parse(responce);
        //             var options;
        //             options += `<option value="%">All Boards</option>`;
        //             for (var i = 0; i < board.length; i++) {
        //                 options += `<option value="${board[i].fboardcode}">${board[i].fboardcode} - ${board[i].fboardname}</options>`;
        //             }

//             $("#fboard").html(options);

//         }
        //     });
        // }
    </script>

</body>

</html>

<?php

${this.title}

Code Editor : seatdet.php