Columns Hide/Show 1.7.25 Bootstrap 5 theme
Column hide/show.
HIDE CODE
<?php // Get an instance of the Xcrud class $xcrud = Xcrud::get_instance(); // Set the table to work with $xcrud->table("orderdetails"); // Define which columns to display in the table $xcrud->columns("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total"); // Define which fields are available for data entry or editing $xcrud->fields("orderNumber,productCode,orderLineNumber,quantityOrdered,priceEach,total"); $xcrud->relation("officeCode","offices","officeCode","city"); // Hide the 'extension' field when the 'officeCode' IN '7,3,4'(London, NYC, Paris) $xcrud->set_column_visibility_control(); $xcrud->readonly("total"); $xcrud->label("total","Total"); $xcrud->limit(3); // Render the xcrud instance to display the table and form echo $xcrud->render(); ?> <link href="../xcrud/plugins/select2-develop/dist/css/select2.min.css" rel="stylesheet" type="text/css" /> <!--<script type="text/javascript" src="../xcrud/plugins/select2-develop/dist/js/select2.full.js"></script>-->
xCRUDUnknown column 'orderdetails.total' in 'field list'
SELECT `orderdetails`.`orderNumber` AS `orderdetails.orderNumber` ,`orderdetails`.`productCode` AS `orderdetails.productCode` ,`orderdetails`.`orderLineNumber` AS `orderdetails.orderLineNumber` ,`orderdetails`.`quantityOrdered` AS `orderdetails.quantityOrdered` ,`orderdetails`.`priceEach` AS `orderdetails.priceEach` ,`orderdetails`.`total` AS `orderdetails.total` ,`orderdetails`.`id` AS `primary_key` FROM `orderdetails` LIMIT 0,3