Tabulator Relations Bootstrap 4.5 theme
Tabulator Relations
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table('employees');
$xcrud->table_name('Tabulator relation');
$xcrud->relation('officeCode','offices','officeCode','city');
$xcrud->label('officeCode','Office in');
$xcrud->label('firstName','First Name');
$xcrud->label('lastName','Last Name');
$xcrud->columns('firstName,lastName,officeCode');
$xcrud->fields('firstName,lastName,officeCode');
$xcrud->column_width('firstName','35%');
$xcrud->column_width('lastName','25%');
$xcrud->column_width('officeCode','30%');
$xcrud->tabulator_active(true);
$xcrud->tabulator_main_properties('
movableColumns: true,
headerVisible:true,
width: "100%",
height: "400px",
groupStartOpen:true,
placeholder:"No Data Available",
tooltipsHeader:true,
tooltips:true'); //'layout: "fitColumns",
$xcrud->limit(10);
echo $xcrud->render();
?>
Fatal error: Uncaught mysqli_sql_exception: Table 'suppsales_charts.employees' doesn't exist in D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php:61 Stack trace: #0 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php(61): mysqli->query('SHOW COLUMNS FR...', 1) #1 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud.php(4896): Xcrud_db->query('SHOW COLUMNS FR...') #2 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud.php(1992): Xcrud->_get_table_info() #3 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\pages\tabulator_relations.php(31): Xcrud->render() #4 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\html\template.php(82): include('D:\\aaa_iVzuvi\\t...') #5 D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\demos\index.php(31): include('D:\\aaa_iVzuvi\\t...') #6 {main} thrown in D:\aaa_iVzuvi\test\Shafa\Telegram_Item_Parser\htdocs\Charts\xcrud_1.7.0.7\xcrud\xcrud_db.php on line 61