To set fields as required in an editable grid, use set_col_required() method. If required fields are left blank, an “* required” message will be displayed. One more more columns can be specified as required fields in this method.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | // Always include namespace and conf.php on TOP of the script. use phpCtrl\C_DataGrid; require_once("/file/path/to/conf.php"); $dg = new C_DataGrid("SELECT * FROM Orders", "orderNumber", "Orders"); // change column titles $dg -> set_col_title("orderNumber", "Order No."); $dg -> set_col_title("orderDate", "Order Date"); $dg -> set_col_title("shippedDate", "Shipped Date"); $dg -> set_col_title("customerNumber", "Customer No."); // enable edit $dg -> enable_edit("INLINE", "CRUD"); // hide a column $dg -> set_col_hidden("requiredDate"); // read only columns, one or more columns delimited by comma $dg -> set_col_readonly("orderDate, customerNumber"); // required fields $dg -> set_col_required("orderNumber, customerNumber"); $dg -> display(); |
To test, click on any row to toggle inline edit, leave a required fields blank, then hit Enter.