programmieren:sqlite3:datatable
Dies ist eine alte Version des Dokuments!
Datatables
mit https://datatables.net/ hat man eine einfache Möglichkeit ein Datenbank Grid in PHP zu realisieren.
- index.php
<!DOCTYPE html> <html lang="de"> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/dataTables.bootstrap4.min.css" > </head> <body> <div class="container"> <h2>PHP - Jquery Datatables Example</h2> <table id="my-example" class='table table-bordered table-striped dt-responsive nowrap' style='width:100%;'> <thead> <tr> <th>Id</th> <th>Name</th> <th>Email</th> </tr> </thead> </table> </div> <script type="text/javascript"> $(document).ready(function() { $('#my-example').dataTable({ "Processing": true, 'ajax':{ url:"load.php" }, "Columns": [ { Data: 'id' } , { Data: 'name' }, { Data: 'email' } ] }); }); </script> <script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/1.10.21/js/dataTables.bootstrap4.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script> </body> </html>
- load.php
<?php $db_name = "database.db"; $db_table = "user"; $db = new SQLite3($db_name); $results = $db->query("SELECT * FROM $db_table"); while ($row = $results->fetchArray()) { $data[] = $row; } $results = ["sEcho" => 1, "iTotalRecords" => count($data), "iTotalDisplayRecords" => count($data), "aaData" => $data ]; echo json_encode($results); ?>
programmieren:sqlite3 (516 views) · Zuletzt geändert: 26/05/2020 15:20 von conny