return DataTables::use('tb_kelas')
->select("id, CONCAT(tingkat, abjad) as kelas")
->addColumn('action', function($data) {
return "<a href=\"" . base_url('Kelas/'. $data->id . "/ubah")."\" class=\"btn btn-sm btn-success mr-1\"><i class=\"fas fa-edit\"></i> Ubah</a>
<a href=\"#\" onclick=\"konfirmasiHapus(" . $data->id .")\" class=\"btn btn-sm btn-danger\"><i class=\"fas fa-trash\"></i> Hapus</a>";
})->rawColumns(['action'])
->make(true);
{
"title": "mysqli_sql_exception",
"type": "mysqli_sql_exception",
"code": 500,
"message": "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 5",
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Database\\MySQLi\\Connection.php",
"line": 292,
"trace": [
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Database\\MySQLi\\Connection.php",
"line": 292,
"function": "query",
"class": "mysqli",
"type": "->",
"args": [
"SELECT COUNT(*) AS `numrows`\nFROM `tb_kelas`\nWHERE (\nabjad) LIKE '%%' ESCAPE '!'\n )",
0
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Database\\BaseConnection.php",
"line": 670,
"function": "execute",
"class": "CodeIgniter\\Database\\MySQLi\\Connection",
"type": "->",
"args": [
"SELECT COUNT(*) AS `numrows`\nFROM `tb_kelas`\nWHERE (\nabjad) LIKE '%%' ESCAPE '!'\n )"
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Database\\BaseConnection.php",
"line": 598,
"function": "simpleQuery",
"class": "CodeIgniter\\Database\\BaseConnection",
"type": "->",
"args": [
"SELECT COUNT(*) AS `numrows`\nFROM `tb_kelas`\nWHERE (\nabjad) LIKE '%%' ESCAPE '!'\n )"
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Database\\BaseBuilder.php",
"line": 1527,
"function": "query",
"class": "CodeIgniter\\Database\\BaseConnection",
"type": "->",
"args": [
"SELECT COUNT(*) AS `numrows`\nFROM `tb_kelas`\nWHERE (\nabjad) LIKE :abjad): ESCAPE '!'\n )",
{
"abjad)": [
"%%",
true
]
},
false
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\irsyadulibad\\codeigniter4-datatables\\src\\TableProcessor.php",
"line": 35,
"function": "countAllResults",
"class": "CodeIgniter\\Database\\BaseBuilder",
"type": "->",
"args": [
false
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\irsyadulibad\\codeigniter4-datatables\\src\\DataTableMethods.php",
"line": 101,
"function": "count",
"class": "Irsyadulibad\\DataTables\\TableProcessor",
"type": "->",
"args": []
},
{
"file": "D:\\Project\\Sekolah\\vendor\\irsyadulibad\\codeigniter4-datatables\\src\\TableProcessor.php",
"line": 42,
"function": "filterRecords",
"class": "Irsyadulibad\\DataTables\\DataTableMethods",
"type": "->",
"args": []
},
{
"file": "D:\\Project\\Sekolah\\vendor\\irsyadulibad\\codeigniter4-datatables\\src\\TableProcessor.php",
"line": 27,
"function": "doQuery",
"class": "Irsyadulibad\\DataTables\\TableProcessor",
"type": "->",
"args": []
},
{
"file": "D:\\Project\\Sekolah\\app\\Controllers\\KelasController.php",
"line": 32,
"function": "make",
"class": "Irsyadulibad\\DataTables\\TableProcessor",
"type": "->",
"args": [
true
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\CodeIgniter.php",
"line": 824,
"function": "ajaxList",
"class": "App\\Controllers\\KelasController",
"type": "->",
"args": []
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\CodeIgniter.php",
"line": 410,
"function": "runController",
"class": "CodeIgniter\\CodeIgniter",
"type": "->",
"args": [
{
"kelas": {
"pager": null
},
"validation": {}
}
]
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\CodeIgniter.php",
"line": 318,
"function": "handleRequest",
"class": "CodeIgniter\\CodeIgniter",
"type": "->",
"args": [
null,
{
"handler": "file",
"backupHandler": "dummy",
"storePath": "D:\\Project\\Sekolah\\writable\\cache/",
"cacheQueryString": false,
"prefix": "",
"ttl": 60,
"reservedCharacters": "{}()/\\@:",
"file": {
"storePath": "D:\\Project\\Sekolah\\writable\\cache/",
"mode": 416
},
"memcached": {
"host": "127.0.0.1",
"port": 11211,
"weight": 1,
"raw": false
},
"redis": {
"host": "127.0.0.1",
"password": null,
"port": 6379,
"timeout": 0,
"database": 0
},
"validHandlers": {
"dummy": "CodeIgniter\\Cache\\Handlers\\DummyHandler",
"file": "CodeIgniter\\Cache\\Handlers\\FileHandler",
"memcached": "CodeIgniter\\Cache\\Handlers\\MemcachedHandler",
"predis": "CodeIgniter\\Cache\\Handlers\\PredisHandler",
"redis": "CodeIgniter\\Cache\\Handlers\\RedisHandler",
"wincache": "CodeIgniter\\Cache\\Handlers\\WincacheHandler"
}
},
false
]
},
{
"file": "D:\\Project\\Sekolah\\public\\index.php",
"line": 37,
"function": "run",
"class": "CodeIgniter\\CodeIgniter",
"type": "->",
"args": []
},
{
"file": "D:\\Project\\Sekolah\\vendor\\codeigniter4\\framework\\system\\Commands\\Server\\rewrite.php",
"line": 43,
"args": [
"D:\\Project\\Sekolah\\public\\index.php"
],
"function": "require_once"
}
]
}