Column hide/show.

<?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>-->

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