Required fields

Fri, 17 Sep 2010 00:02:29 +0000

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();

See Live Example!

To test, click on any row to toggle inline edit, leave a required fields blank, then hit Enter.

The post Required fields appeared first on phpGrid - PHP Datagrid.

set_col_required()

Wed, 15 Sep 2010 18:31:06 +0000

Parameter(s):
- $col_names: Comma delimited one or more column names
Description:
- Set one more more columns as required field during edit
Remark:
- Use this function for any database table fields that are NOT NULL, or the INSERT will fail.
Example:

1	$dg -> set_col_required("phone, email");

The post set_col_required() appeared first on phpGrid - PHP Datagrid.

required fields Archives | phpGrid - PHP Datagrid

Required fields

set_col_required()