File manager - Edit - /home/custbahd/public_html/webs/monitor/clients/usssa/crud/index.php
Back
<?php session_start(); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>USSSA ©</title> <link rel="ico" type="ico/jpg" href="logo.jph"> <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css"> <link rel="stylesheet" type="text/css" href="datatable/dataTable.bootstrap.min.css"> <style> .height10{ height:10px; } .mtop10{ margin-top:10px; } .modal-label{ position:relative; top:7px } </style> </head> <body> <div class="container"> <div align="center"> <img src="logo.jpg" class="page-header text-center" width="150px"> </div> <div class="row"> <div class="col-sm-8 col-sm-offset-2"> <div class="row"> <?php if(isset($_SESSION['error'])){ echo " <div class='alert alert-danger text-center'> <button class='close'>×</button> ".$_SESSION['error']." </div> "; unset($_SESSION['error']); } if(isset($_SESSION['success'])){ echo " <div class='alert alert-success text-center'> <button class='close'>×</button> ".$_SESSION['success']." </div> "; unset($_SESSION['success']); } ?> </div> <div class="row"> <a href="#addnew" data-toggle="modal" class="btn btn-primary" style="background: red;border: none;"><span class="glyphicon glyphicon-plus"></span> New</a> <a href="print_pdf.php" class="btn btn-success pull-right" style="background: red;border: none;"><span class="glyphicon glyphicon-print"></span> PDF</a> </div> <div class="height10"> </div> <div class="row"> <table id="myTable" class="table table-bordered table-striped"> <thead> <th>ID</th> <th>Firstname</th> <th>Lastname</th> <th>Phone Number</th> <th>Address</th> <th>Action</th> </thead> <tbody> <?php include_once('connection.php'); $sql = "SELECT * FROM members"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo "<tr> <td>".$row['id']."</td> <td>".$row['firstname']."</td> <td>".$row['lastname']."</td> <td>".$row['phone']."</td> <td>".$row['address']."</td> <td> <a href='#edit_".$row['id']."' class='btn btn-success btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-edit'></span> Edit</a> <a href='#delete_".$row['id']."' class='btn btn-danger btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-trash'></span> Delete</a> </td> </tr>"; include('edit_delete_modal.php'); } ///////////////// //use for MySQLi Procedural // $query = mysqli_query($conn, $sql); // while($row = mysqli_fetch_assoc($query)){ // echo // "<tr> // <td>".$row['id']."</td> // <td>".$row['firstname']."</td> // <td>".$row['lastname']."</td> // <td>".$row['address']."</td> // <td> // <a href='#edit_".$row['id']."' class='btn btn-success btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-edit'></span> Edit</a> // <a href='#delete_".$row['id']."' class='btn btn-danger btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-trash'></span> Delete</a> // </td> // </tr>"; // include('edit_delete_modal.php'); // } ///////////////// ?> </tbody> </table> </div> </div> </div> </div> <?php include('add_modal.php') ?> <script src="jquery/jquery.min.js"></script> <script src="bootstrap/js/bootstrap.min.js"></script> <script src="datatable/jquery.dataTables.min.js"></script> <script src="datatable/dataTable.bootstrap.min.js"></script> <!-- generate datatable on our table --> <script> $(document).ready(function(){ //inialize datatable $('#myTable').DataTable(); //hide alert $(document).on('click', '.close', function(){ $('.alert').hide(); }) }); </script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.4 |
proxy
|
phpinfo
|
Settings