????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................<?php
$user = 'xceljsr_db';
$password = 'xcel@123#$'; 
  
// Database name is gfg
$database = 'xceljsr_db'; 
  
// Server is localhost with
// port number 3308
$servername='localhost';
$mysqli = new mysqli($servername, $user, 
                $password, $database);
include('session.php');
if(isset($_GET['idk'])){

$id = intval($_GET['idk']);

$sql = "DELETE FROM job_placement WHERE id='$id'";

if($mysqli->query($sql)){
echo "success";
}else{
echo "error";
}

exit;

}
?>

<?php
// Checking for connections
if ($mysqli->connect_error) {
    die('Connect Error (' .
        $mysqli->connect_errno . ') ' .
        $mysqli->connect_error);
}

// SQL query to select data from database
$sql = "SELECT * FROM  job_placement order by id ASC";
$result = $mysqli->query($sql);
// $mysqli->close(); 
$a = 0;
?>

<!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">
    <title>JOB PLACEMENTS | ADMIN PANEL</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../assets/img/logo/url-logo.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
    <script src="https://code.jquery.com/jquery-3.6.4.min.js" integrity="sha256-oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl+cbzUq8=" crossorigin="anonymous"></script>
    <style>
        .btn {
            background-color: red;
            border: none;
            color: white;
            padding: 5px 5px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            font-size: 20px;
            margin: 4px 2px;
            cursor: pointer;
            border-radius: 20px;
        }

        .green {
            background-color: #199319;
        }

        .red {
            background-color: red;
        }
    </style>
</head>

<body>
    <div id="main-wrapper" class="show">


        <?php
        include "sidebar.php";
        ?>


        <?php
        include "header.php";
        ?>


        <div class="content-body">
            <div class="warper container-fluid">
                <div class="new-patients main_container">
                    <div class="row page-titles mx-0">
                        <div class="col-sm-6 p-md-0">
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">Add Placement Details</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                        <form action="insert_job-placement.php" method="post" enctype="multipart/form-data">
                                            <div class="col-xl-12">
                                                <div class="row">
                                                    <div class="col-xl-4">
                                                        <div class="form-group">
                                                            <label class="form-label">Name</label>
                                                            <input type="text" class="form-control" placeholder="Name" name="name">
                                                        </div>
                                                    </div>
                                                    <div class="col-xl-4">
                                                        <div class="form-group">
                                                            <label class="form-label">Company</label>
                                                            <input type="text" class="form-control" placeholder="Company" name="company">
                                                        </div>
                                                    </div>
                                                    <div class="col-xl-4">
                                                        <div class="form-group">
                                                            <label class="form-label">Designation</label>
                                                            <input type="text" class="form-control" placeholder="Designation" name="position">
                                                        </div>
                                                    </div>
                                                </div>

                                                <div class="col-xl-12">
                                                    <div class="row">
                                                        <div class="col-xl-6">
                                                            <div class="form-group">
                                                                <label class="form-label">Package</label>
                                                                <input type="text" class="form-control" placeholder="Package" name="package">
                                                            </div>
                                                        </div>


                                                        <div class="col-xl-6">
                                                            <div class="form-group">
                                                                <label class="form-label">Image</label>
                                                                <input type="file" class="form-control" name="photo">
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>

                                            </div>
                                            <div class="form-group text-right">
                                               <button type="submit" class="btnn">Add Placements</button>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <?php if(isset($_GET['success'])){ ?>
<script>
alert("Placement Added Successfully");
</script>
<?php } ?>

                        <div class="col-md-12">
                            <div class="card shadow">
                                <div class="card-header">
                                    <h4 class="card-title">Our Placed Candidates</h4>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table id="example1" class="display nowrap">
                                            <thead>
                                                <tr>
                                                    <th>SL No</th>
                                                    <th>Name</th>
                                                    <th>Company</th>
                                                    <th>Designation</th>
                                                    <th>Package</th>
                                                    <th>Image</th>
                                                    <th>Action</th>

                                                </tr>
                                            </thead>
                                            <tbody>

                                                <?php   // LOOP TILL END OF DATA 
                                                while ($rows = $result->fetch_assoc()) {
                                                ?>
                                                    <tr id="<?php echo $rows['id']; ?>">
                                                        <td><?php echo ++$a ?></td>
                                                        <td><?php echo $rows['name']; ?></td>
                                                        <td><?php echo $rows['company']; ?></td>
                                                        <td><?php echo $rows['position']; ?></td>
                                                        <td><?php echo $rows['package']; ?></td>
                                                        <td><img src="<?php echo $rows['photo']; ?>" width="100" height="100"></td>

                                                        <td>

                                                            <a class='remove'>
                                                                <span class='fas fa-trash-alt'></span>
                                                            </a>
                                                        </td>
                                                    </tr>

                                                <?php } ?>


                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>




                    </div>

                </div>
            </div>
        </div>
        <!-- End section content -->

        <?php
        include('footer.php');
        ?>


    </div>


    <script>
        $(".remove").click(function(){

var idk = $(this).parents("tr").attr("id");

if(confirm("Are you sure to remove this record?")){

$.ajax({
url:"job-placement.php",
type:"GET",
data:{idk:idk},
success:function(res){

if(res=="success"){
$("#"+idk).remove();
alert("Record deleted successfully");
}else{
alert("Database delete failed");
}

}

});

}

});
    </script>

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Chart js -->
    <script src="assets/plugins/chart/chart/Chart.min.js"></script>
    <script src="assets/js/charts-custom.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>

</html>