{"id":24979,"date":"2021-05-24T14:04:00","date_gmt":"2021-05-24T11:04:00","guid":{"rendered":"https:\/\/themewp.inform.click\/?p=24979"},"modified":"2021-10-18T03:10:51","modified_gmt":"2021-10-18T00:10:51","slug":"come-utilizzare-datatable-in-php","status":"publish","type":"post","link":"https:\/\/themewp.inform.click\/it\/come-utilizzare-datatable-in-php\/","title":{"rendered":"Come utilizzare DataTable in PHP"},"content":{"rendered":"

Vuoi integrare DataTable nella tua applicazione? DataTable aggiunge controlli di interazione avanzati alle tue tabelle HTML. Inoltre \u00e8 open-source, quindi tutti possono usarlo gratuitamente. \u00c8 utile quando la tua tabella ha centinaia di voci. Usando DataTable, otterrai le loro funzionalit\u00e0 integrate come l’ordinamento, la ricerca, l’impaginazione, ecc. In questo articolo, ti mostro come utilizzare DataTable in PHP.<\/p>\n

DataTables<\/a> \u00e8 una scelta comune per elencare i record tabulari nell’applicazione. Grazie alla sua semplicit\u00e0 e facilit\u00e0 di installazione, gli sviluppatori hanno preferito utilizzarlo.<\/p>\n

Per il nostro tutorial, creer\u00f2 una tabella nel database e visualizzer\u00f2 i suoi record nel DataTable. L’output finale sar\u00e0 simile allo screenshot seguente:<\/p>\n

Iniziare<\/h3>\n

Per iniziare, vai al tuo phpMyAdmin e crea la tabella utilizzando la seguente query:<\/p>\n

CREATE TABLE `users` (\u00a0`id` int(11) NOT NULL AUTO_INCREMENT,\n\u00a0`first_name` varchar(255) NOT NULL,\n\u00a0`last_name` varchar(255) NOT NULL,\n\u00a0`age` int(11) NOT NULL,\n\u00a0PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/code><\/pre>\n
La tabella "utenti" ha le colonne nome, cognome ed et\u00e0. Aggiungi voci fittizie in questa tabella. L’utente pu\u00f2 utilizzare la libreria Faker<\/a> per seminare la tua tabella con voci fittizie. Utilizzando la libreria dei falsi \u00e8 possibile aggiungere migliaia di voci false nel database in pochi istanti.<\/p>\n
Quindi, crea un config.php<\/code>file e scrivi un codice per la connessione al database.<\/p>\n
config.php<\/strong><\/p>\n
<?php\n$conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);\n\u00a0\nif ($conn->connect_errno) {\n\u00a0\u00a0\u00a0\u00a0echo \"Error: \". $conn->connect_error;\n}<\/code><\/pre>\n
Assicurati di sostituire i segnaposto con i valori effettivi.<\/p>\n
Come utilizzare DataTable in PHP<\/h3>\n
Per integrare DataTable, ci\u00f2 che far\u00f2 \u00e8 recuperare i record dal database, scorrerlo e visualizzarlo in una tabella. E quindi applica DataTable alla tabella HTML.<\/p>\n
Crea un index.php<\/code>file e aggiungi il codice qui sotto.<\/p>\n
<?php\nrequire_once('config.php');\n\u00a0\n$sql = \"SELECT id, first_name, last_name, age FROM users\";\n$result = $conn->query($sql);\n$arr_users = [];\nif ($result->num_rows > 0) {\n\u00a0\u00a0\u00a0\u00a0$arr_users = $result->fetch_all(MYSQLI_ASSOC);\n}\n?><\/code><\/pre>\n
Nel codice sopra, ho recuperato tutte le righe dalla tabella "utenti" e le ho assegnate alla variabile PHP $arr_users<\/code>. Ora, scorrer\u00f2 questa variabile e creer\u00f2 la riga della tabella una per una.<\/p>\n
<table id=\"userTable\">\n\u00a0\u00a0\u00a0\u00a0<thead>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>First Name<\/th>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>Last Name<\/th>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>Age<\/th>\n\u00a0\u00a0\u00a0\u00a0<\/thead>\n\u00a0\u00a0\u00a0\u00a0<tbody>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php if(!empty($arr_users)) { ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php foreach($arr_users as $user) { ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['first_name']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['last_name']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['age']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php } ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php } ?>\n\u00a0\u00a0\u00a0\u00a0<\/tbody>\n<\/table><\/code><\/pre>\n
Qui, ho dato un id ‘userTable’ alla tabella. La prossima cosa che devo fare \u00e8 includere i file richiesti di DataTable nell’HTML.<\/p>\n
<link rel=\"stylesheet\" type=\"text\/css\" href=\"\/\/cdn.datatables.net\/1.10.21\/css\/jquery.dataTables.min.css\"\/>\n<script src=\"\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.5.1\/jquery.min.js\"><\/script>\n<script type=\"text\/javascript\" src=\"\/\/cdn.datatables.net\/1.10.21\/js\/jquery.dataTables.min.js\"><\/script><\/code><\/pre>\n
Infine, chiama il metodo DataTable() sull’id della tabella dato.<\/p>\n
<script>\n$(document).ready(function() {\n\u00a0\u00a0\u00a0\u00a0$('#userTable').DataTable();\n});\n<\/script><\/code><\/pre>\n
Il nostro codice finale \u00e8 il seguente;<\/p>\n
<?php\nrequire_once('config.php');\n\u00a0\n$sql = \"SELECT id, first_name, last_name, age FROM users\";\n$result = $conn->query($sql);\n$arr_users = [];\nif ($result->num_rows > 0) {\n\u00a0\u00a0\u00a0\u00a0$arr_users = $result->fetch_all(MYSQLI_ASSOC);\n}\n?>\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\u00a0\u00a0\u00a0\u00a0<meta charset=\"UTF-8\">\n\u00a0\u00a0\u00a0\u00a0<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n\u00a0\u00a0\u00a0\u00a0<meta http-equiv=\"X-UA-Compatible\" content=\"ie=edge\">\n\u00a0\u00a0\u00a0\u00a0<title>Datatable<\/title>\n\u00a0\u00a0\u00a0\u00a0<link rel=\"stylesheet\" type=\"text\/css\" href=\"\/\/cdn.datatables.net\/1.10.21\/css\/jquery.dataTables.min.css\"\/>\n<\/head>\n<body>\n\u00a0\u00a0\u00a0\u00a0<table id=\"userTable\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<thead>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>First Name<\/th>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>Last Name<\/th>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<th>Age<\/th>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/thead>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<tbody>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php if(!empty($arr_users)) { ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php foreach($arr_users as $user) { ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['first_name']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['last_name']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<td><?php echo $user['age']; ?><\/td>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/tr>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php } ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<?php } ?>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/tbody>\n\u00a0\u00a0\u00a0\u00a0<\/table>\n\u00a0\u00a0\u00a0\u00a0<script src=\"\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/3.5.1\/jquery.min.js\"><\/script>\n\u00a0\u00a0\u00a0\u00a0<script type=\"text\/javascript\" src=\"\/\/cdn.datatables.net\/1.10.21\/js\/jquery.dataTables.min.js\"><\/script>\n\u00a0\u00a0\u00a0\u00a0<script>\n\u00a0\u00a0\u00a0\u00a0$(document).ready(function() {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$('#userTable').DataTable();\n\u00a0\u00a0\u00a0\u00a0});\n\u00a0\u00a0\u00a0\u00a0<\/script>\n<\/body>\n<\/html><\/code><\/pre>\n
Spero che tu possa imparare a usare DataTable in PHP. Per favore condividi i tuoi pensieri nella sezione commenti qui sotto.<\/p>\n
articoli Correlati<\/h4>\n