Hallo,
ich möchte eine dataTable per Ajax zu aktualisieren.
Mein js:
Mein php:
wenn ich den Button betätige erscheint folgender Fehler:
DataTables warning: table id=tabelle41 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
wo ist der Fehler?
ich möchte eine dataTable per Ajax zu aktualisieren.
Mein js:
Code:
let btnMonatSeite4 = document.getElementById("btnMonatSeite4"); btnMonatSeite4.addEventListener("click", function() { $(document).ready(function() { $('#tabelle41').DataTable( { "paging": false, "info": false, "searching": false, "ajax": "../../src/ticket/tabelle41.php", "bPaginate":true, "bProcessing": true, "columns": [ { mData: 'Fachbereich' } , { mData: 'Anzahl' }, { mData: 'Anteil' } ] } ); } ); }, false);
PHP-Code:
<?php
namespace App\Ticket;
use PDO;
$statement = $this->pdo->prepare("SELECT user22 AS user22,
COUNT(t.tnumber) AS tnumber,
FORMAT((COUNT(t.tnumber) / (SELECT COUNT(t.tnumber) FROM crmdb.tickets t WHERE t.tnumber LIKE ? AND WEEKOFYEAR(from_unixtime(t.createtime)) = ? AND YEAR(from_unixtime(t.createtime)) = ?))*100, 0) AS anteil
FROM crmdb.tickets t
WHERE WEEKOFYEAR(from_unixtime(t.createtime)) = ?
AND YEAR(from_unixtime(t.createtime)) = ?
AND t.tnumber LIKE ?
GROUP BY t.user22 WITH ROLLUP");
$statement->execute(array('HL-%', 44, 2019, 44, 2019, 'HL-%'));
$statement->setFetchMode(PDO::FETCH_CLASS, "App\\Ticket\\TicketModel");
$results = $statement->fetchAll(PDO::FETCH_CLASS, "App\\Ticket\\TicketModel");
echo json_encode($results);
?>
DataTables warning: table id=tabelle41 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
wo ist der Fehler?
Kommentar