Editando: view-intern.php
<?php session_start(); $se = $_SESSION["id"]; if (!isset($_SESSION['id'])) { header("Location: login.php"); } include("includes/config.php");; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- <title>AdminLTE 3 | DataTables</title> --> <!-- Google Font: Source Sans Pro --> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback"> <!-- Font Awesome --> <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css"> <!-- DataTables --> <link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css"> <link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css"> <link rel="stylesheet" href="plugins/datatables-buttons/css/buttons.bootstrap4.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> </head> <body class="hold-transition sidebar-mini"> <div class="wrapper"> <!-- Navbar --> <?php require "includes/nav.php" ?> <!-- /.navbar --> <!-- Main Sidebar Container --> <?php require "includes/sidebar.php" ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1> Internship</h1> </div> <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="#">Home</a></li> <li class="breadcrumb-item active">DataTables</li> </ol> </div> </div> </div><!-- /.container-fluid --> </section> <!-- Main content --> <section class="content"> <div class="container-fluid"> <?php if(isset($_SESSION['status']) && $_SESSION != ''){ ?> <div class="alert alert-warning alert-dismissible fade show" role="alert"> <strong>Hey!</strong> <?php echo $_SESSION['status']; ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php unset($_SESSION['status']); } ?> <div class="row"> <div class="col-12"> <!-- /.card --> <div class="card"> <div class="card-header"> <!-- <a href="testimonial.php" class="btn btn-primary waves-effect waves-light"> <i class="fa fa-plus"></i> ADD </a> --> </div> <!-- <div class="col-md-6 text-right"> </div> --> <!-- /.card-header --> <div class="card-body"> <table id="example1" class="table table-bordered table-striped"> <thead> <tr> <th>#</th> <th>Name</th> <th>Email</th> <th>Phone</th> <th>Address</th> <th>Start Date</th> <th>End Date</th> <th>Year</th> <th>University</th> <th>Profile Photo</th> <th>Resume/CV</th> <th>Action</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM internships"; $query_run =mysqli_query($conn, $query); if(mysqli_num_rows($query_run) > 0){ foreach($query_run as $row){ ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['email']; ?></td> <td><?php echo $row['phone']; ?></td> <td><?php echo $row['residential_address']; ?></td> <td><?php echo $row['start_date']; ?></td> <td><?php echo $row['end_date']; ?></td> <td><?php echo $row['year']; ?></td> <td><?php echo $row['university']; ?></td> <td> <?php $file = 'internprofile/' . $row['profilephoto']; // Assuming 'photo' column contains the file name if (!empty($row['profilephoto']) && file_exists($file)) { $ext = strtolower(pathinfo($file, PATHINFO_EXTENSION)); echo "<a href='$file' target='_blank'>"; if (in_array($ext, ['jpg', 'jpeg', 'png', 'gif', 'bmp', 'webp'])) { echo "<img src='$file' alt='Resume Image' style='max-width:100px; max-height:100px;'>"; } elseif ($ext === 'pdf') { echo "<img src='dist/img/pdf.png' alt='PDF File' style='width:50px;'>"; // optional: use a PDF icon // OR if you want to keep the embedded preview in the table: // echo "<embed src='$file' type='application/pdf' width='100' height='100'>"; } else { echo "Unsupported file format"; } echo "</a>"; } else { echo "No file found"; } ?> </td> <td> <?php $file = 'internresume/' . $row['photo']; // Assuming 'photo' column contains the file name if (!empty($row['photo']) && file_exists($file)) { $ext = strtolower(pathinfo($file, PATHINFO_EXTENSION)); echo "<a href='$file' target='_blank'>"; if (in_array($ext, ['jpg', 'jpeg', 'png', 'gif', 'bmp', 'webp'])) { echo "<img src='$file' alt='Resume Image' style='max-width:100px; max-height:100px;'>"; } elseif ($ext === 'pdf') { echo "<img src='dist/img/pdf.png' alt='PDF File' style='width:50px;'>"; // optional: use a PDF icon // OR if you want to keep the embedded preview in the table: // echo "<embed src='$file' type='application/pdf' width='100' height='100'>"; } else { echo "Unsupported file format"; } echo "</a>"; } else { echo "No file found"; } ?> </td> <td> <form action="delete_intern.php" method="post"> <input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>"> <input type="hidden"name="del_intern" value="<?php echo $row['photo']; ?>"> <input type="hidden"name="del_intern1" value="<?php echo $row['profilephoto']; ?>"> <button type="submit" name="delete_intern" class="btn btn-danger">DELETE</button> </form> </td> </tr> <?php }} ?> </tbody> </table> </div> <!-- /.card-body --> </div> <!-- /.card --> </div> <!-- /.col --> </div> <!-- /.row --> </div> <!-- /.container-fluid --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <!-- <footer class="main-footer"> <div class="float-right d-none d-sm-block"> <b>Version</b> 3.2.0 </div> <strong>Copyright © 2014-2021 <a href="https://adminlte.io">AdminLTE.io</a>.</strong> All rights reserved. </footer> --> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> <!-- /.control-sidebar --> </div> <!-- ./wrapper --> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- DataTables & Plugins --> <script src="plugins/datatables/jquery.dataTables.min.js"></script> <script src="plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script> <script src="plugins/datatables-responsive/js/dataTables.responsive.min.js"></script> <script src="plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script> <script src="plugins/datatables-buttons/js/dataTables.buttons.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script> <script src="plugins/jszip/jszip.min.js"></script> <script src="plugins/pdfmake/pdfmake.min.js"></script> <script src="plugins/pdfmake/vfs_fonts.js"></script> <script src="plugins/datatables-buttons/js/buttons.html5.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.print.min.js"></script> <script src="plugins/datatables-buttons/js/buttons.colVis.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.min.js"></script> <!-- AdminLTE for demo purposes --> <script src="dist/js/demo.js"></script> <!-- Page specific script --> <script> $(function () { $("#example1").DataTable({ "responsive": true, "lengthChange": false, "autoWidth": false, "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"] }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); $('#example2').DataTable({ "paging": true, "lengthChange": false, "searching": false, "ordering": true, "info": true, "autoWidth": false, "responsive": true, }); }); </script> </body> </html>
Cancelar
Kerym Chaeceran