Live Examples

Example 10: Set Read Only Data Fields in Datagrid

Often during editing, you would like certain fields to be not editable, or ready only. You can call set_fields_readonly() and set those fields to be read only. 

$dg = new C_DataGrid($hostName, $userName, $password, $dbName);
 
$dg -> set_gridpath     ("include/");
$dg -> set_sql          ("SELECT * FROM Employees");
$dg -> set_sql_table    ("Employees");
$dg -> set_sql_key      ("EmployeeId");
 
// change column titles
$dg -> set_col_title    ("EmployeeId", "Employee ID");
$dg -> set_col_title    ("LastName", "Last Name");
$dg -> set_col_title    ("FirstName", "First Name");
 
// set background and mouse over color
$dg -> set_alt_bgcolor  ("#ffcc99, #ffccdd");
$dg -> set_onmouseover  ("yellow");
 
// hide a column
$dg -> set_col_hidden   ("Notes");
 
// display URL as hyperlink
$dg -> set_col_link    ("ReportsTo", 
                        "/query.php?EmployeeId=", 
                        "EmployeeId", 
                        "target='_new'"); 
 
// set page size
$dg -> set_page_size   (20);
 
// make the datagrid editable
$dg -> set_allow_actions(true);
 
// set data administrative level
// "V" means View, "E" means Edit, and "D" means Delete.
$dg -> set_action_type ("VE");   // view and edit only
 
// make BirthDate and HomePhone read only

$dg -> set_fields_readonly("LastName, HomePhone");
 
$dg -> display();