Sample 4. Advanced PHP DG code
View Live Demo on this sample
1. All modes (Add/Edit/Details/Delete/View).
2. All features.
3. One DataGrid splited on 2 parts with different styles.
<table width="100%" border=0>
<tr>
<td align="left" style="padding-left:15px;">
<a href="sample4_demo.php?pr_mode=add&pr_rid=-1">Add New President</a>
</td>
<td></td>
</tr>
<tr>
<td align="left" valign="top">
$pr_rid = isset($_GET['pr_rid']) ? $_GET['pr_rid'] : "";
$pr_mode = isset($_GET['pr_mode']) ? $_GET['pr_mode'] : "";
$pr_page_size = isset($_GET['pr_page_size']) ? $_GET['pr_page_size'] : "";
$pr_p = isset($_GET['pr_p']) ? $_GET['pr_p'] : "";
$pr_sort_field = isset($_GET['pr_sort_field']) ? $_GET['pr_sort_field'] : "";
$pr_sort_field_by = isset($_GET['pr_sort_field_by']) ? $_GET['pr_sort_field_by'] : "";
$pr_sort_type = isset($_GET['pr_sort_type']) ? $_GET['pr_sort_type'] : "";
$sql_extention = "&pr_page_size=".$pr_page_size."&pr_p=".$pr_p."&pr_sort_field=".$pr_sort_field."&pr_sort_field_by=".$pr_sort_field_by."&pr_sort_type=".$pr_sort_type;
if(($pr_mode == "edit") || ($pr_mode == "details") || ($pr_mode == "add") || ($pr_mode == "cancel")){
$_GET['pr_mode'] = "view";
$_GET['pr_rid'] = "";
$_REQUEST['pr_mode'] = "view";
$_REQUEST['pr_rid'] = "";
if(($pr_mode == "cancel") && ($pr_rid == "-1")){
$_GET['pr_page_size'] = "";
$_REQUEST['pr_page_size'] = "";
}
}
################################################################################
## +---------------------------------------------------------------------------+
## | 1. Creating & Calling: |
## +---------------------------------------------------------------------------+
## *** define a relative (virtual) path to datagrid.class.php file and "pear"
## *** directory (relatively to the current file)
## *** RELATIVE PATH ONLY ***
define ("DATAGRID_DIR", "datagrid423/");
define ("PEAR_DIR", "datagrid423/pear/");
require_once(DATAGRID_DIR.'datagrid.class.php');
require_once(PEAR_DIR.'PEAR.php');
require_once(PEAR_DIR.'DB.php');
##
## *** creating variables that we need for database connection
$DB_USER='username'; // usually like this: prefix_name
$DB_PASS='12345'; // must be already enscrypted
$DB_HOST='localhost'; // often localhost
$DB_NAME='databse_name'; // usually like this: prefix_name
ob_start();
$db_conn = DB::factory('mysql'); /* don't forget to change on appropriate db type */
$result_conn = $db_conn->connect(DB::parseDSN('mysql://'.$DB_USER.':'.$DB_PASS.'@'.$DB_HOST.'/'.$DB_NAME));
if(DB::isError($result_conn)){ die($result_conn->getDebugInfo()); }
## *** put a primary key on the first place
$sql = "
SELECT
presidents.id,
presidents.country_id,
presidents.name,
presidents.birth_date,
presidents.status,
countries.name as country_name,
'Edit' as lnk_edit,
'Details' as lnk_details
FROM presidents
INNER JOIN countries ON presidents.country_id=countries.id
";
## *** set needed options and create a new class instance
$debug_mode = false; /* display SQL statements while processing */
$messaging = true; /* display system messages on a screen */
$unique_prefix = "pr_"; /* prevent overlays - must be started with a letter */
$dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);
## *** set data source with needed options
$default_order_field = "id";
$default_order_type = "ASC";
$dgrid->dataSource($db_conn, $sql, $default_order_field, $default_order_type);
## +---------------------------------------------------------------------------+
## | 2. General Settings: |
## +---------------------------------------------------------------------------+
$modes = array(
"add" =>array("view"=>false, "edit"=>false, "type"=>"link"),
"edit" =>array("view"=>false, "edit"=>true, "type"=>"link", "byFieldValue"=>""),
"cancel" =>array("view"=>true, "edit"=>true, "type"=>"link"),
"details" =>array("view"=>false, "edit"=>false, "type"=>"link"),
"delete" =>array("view"=>true, "edit"=>true, "type"=>"image")
);
$dgrid->setModes($modes);
## *** allow mulirow operations
$multirow_option = false;
$dgrid->allowMultirowOperations($multirow_option);
## *** set DataGrid caption
$dg_caption = "Presidents";
$dgrid->setCaption($dg_caption);
## +---------------------------------------------------------------------------+
## | 3. Printing & Exporting Settings: |
## +---------------------------------------------------------------------------+
## *** set printing option: true(default) or false
$printing_option = false;
$dgrid->allowPrinting($printing_option);
## +---------------------------------------------------------------------------+
## | 4. Sorting & Paging Settings: |
## +---------------------------------------------------------------------------+
## *** set paging option: true(default) or false
$paging_option = true;
$rows_numeration = false;
$numeration_sign = "N #";
$dgrid->allowPaging($paging_option, $rows_numeration, $numeration_sign);
## *** set paging settings
$bottom_paging = array("results"=>true, "results_align"=>"left", "pages"=>true, "pages_align"=>"center", "page_size"=>true, "page_size_align"=>"right");
$top_paging = array();
$pages_array = array("10"=>"10", "25"=>"25", "50"=>"50", "100"=>"100", "250"=>"250", "500"=>"500", "1000"=>"1000");
$default_page_size = 10;
$dgrid->setPagingSettings($bottom_paging, $top_paging, $pages_array, $default_page_size);
## +---------------------------------------------------------------------------+
## | 5. Filter Settings: |
## +---------------------------------------------------------------------------+
## *** set filtering option: true or false(default)
$filtering_option = true;
$show_search_type = false;
$dgrid->allowFiltering($filtering_option, $show_search_type);
## *** set aditional filtering settings
$filtering_fields = array(
"Name"=>array("table"=>"presidents", "field"=>"name", "source"=>"self", "show_operator"=>false, "default_operator"=>"like%", "order"=>"ASC", "type"=>"textbox", "case_sensitive"=>false, "comparison_type"=>"string"),
);
$dgrid->setFieldsFiltering($filtering_fields);
## +---------------------------------------------------------------------------+
## | 6. View Mode Settings: |
## +---------------------------------------------------------------------------+
## *** set view mode table properties
$vm_table_properties = array("width"=>"95%");
$dgrid->setViewModeTableProperties($vm_table_properties);
## *** set columns in view mode
## *** Ex.: "on_js_event"=>"onclick='alert(\"Yes!!!\");'"
## *** "barchart" : number format in SELECT SQL must be equal with number format in max_value
$vm_colimns = array(
"name"=>array("header"=>"Name", "type"=>"label", "align"=>"left", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>""),
"m_birth_date"=>array("header"=>"Date of Birth", "type"=>"label", "align"=>"left", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>""),
"status"=>array("header"=>"Status", "type"=>"label", "align"=>"left", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>""),
"country_name"=>array("header"=>"Country", "type"=>"label", "align"=>"left", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>""),
"lnk_edit"=>array("header"=>"", "type"=>"link", "align"=>"center", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>"", "field_key"=>"id", "field_data"=>"lnk_edit", "rel"=>"", "title"=>"", "target"=>"", "href"=>"sample4_demo.php?pr_mode=edit&pr_rid={0}".$sql_extention.""),
"lnk_details"=>array("header"=>"", "type"=>"link", "align"=>"center", "width"=>"", "wrap"=>"nowrap", "text_length"=>"-1", "tooltip"=>false, "tooltip_type"=>"simple", "case"=>"normal", "summarize"=>"false", "sort_by"=>"", "visible"=>"true", "on_js_event"=>"", "field_key"=>"id", "field_data"=>"lnk_details", "rel"=>"", "title"=>"", "target"=>"", "href"=>"sample4_demo.php?pr_mode=details&pr_rid={0}".$sql_extention.""),
);
$dgrid->setColumnsInViewMode($vm_colimns);
## +---------------------------------------------------------------------------+
## | 7. Add/Edit/Details Mode Settings: |
## +---------------------------------------------------------------------------+
## *** set add/edit mode table properties
$em_table_properties = array("width"=>"95%");
$dgrid->setEditModeTableProperties($em_table_properties);
## *** set details mode table properties
$dm_table_properties = array("width"=>"95%");
$dgrid->setDetailsModeTableProperties($dm_table_properties);
## *** set settings for add/edit/details modes
$table_name = "presidents";
$primary_key = "id";
$condition = "";//table_name.field = ".$_REQUEST['abc_rid'];
$dgrid->setTableEdit($table_name, $primary_key, $condition);
## *** set columns in edit mode
$em_columns = array(
"name" =>array("header"=>"Name", "type"=>"textbox", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Name", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>""),
"country_id" =>array("header"=>"Country", "type"=>"textbox", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Country", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>""),
"birth_date" =>array("header"=>"Birth Date", "type"=>"date", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Date of Birth", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>"", "calendar_type"=>"floating"),
"status" =>array("header"=>"Status", "type"=>"enum", "align"=>"left", "req_type"=>"st", "width"=>"120px", "title"=>"Status", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>"", "source"=>"self", "view_type"=>"dropdownlist", "multiple"=>false, "multiple_size"=>"1"),
);
$dgrid->setColumnsInEditMode($em_columns);
$foreign_keys = array(
"country_id"=>array("table"=>"countries", "field_key"=>"id", "field_name"=>"name", "view_type"=>"dropdownlist", "condition"=>"", "order_by_field"=>"name", "order_type"=>"ASC", "on_js_event"=>""),
);
$dgrid->setForeignKeysEdit($foreign_keys);
## +---------------------------------------------------------------------------+
## | 8. Bind the DataGrid: |
## +---------------------------------------------------------------------------+
## *** bind the DataGrid and draw it on the screen
$dgrid->bind();
ob_end_flush();
##
################################################################################
</td>
<td width="360px" valign="top" align="left">
if(($pr_mode == "edit") || ($pr_mode == "details") || ($pr_mode == "add")){
$_GET['pr_mode'] = $pr_mode;
$_GET['pr_rid'] = $pr_rid;
$_REQUEST['pr_mode'] = $pr_mode;
$_REQUEST['pr_rid'] = $pr_rid;
################################################################################
##
ob_start();
$sql = "
SELECT
presidents.id,
presidents.country_id,
presidents.name,
presidents.birth_date,
presidents.status,
countries.name as country_name,
'Edit' as lnk_edit,
'Details' as lnk_details
FROM presidents
INNER JOIN countries ON presidents.country_id=countries.id
";
## *** set needed options and create a new class instance
$debug_mode = false; /* display SQL statements while processing */
$messaging = true; /* display system messages on a screen */
$unique_prefix = "pr_"; /* prevent overlays - must be started with a letter */
$dgrid1 = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);
## *** set data source with needed options
$default_order_field = "id";
$default_order_type = "ASC";
$dgrid1->dataSource($db_conn, $sql, $default_order_field, $default_order_type);
## +---------------------------------------------------------------------------+
## | 2. General Settings: |
## +---------------------------------------------------------------------------+
$modes = array(
"add" =>array("view"=>false, "edit"=>false, "type"=>"link"),
"edit" =>array("view"=>false, "edit"=>true, "type"=>"link", "byFieldValue"=>""),
"cancel" =>array("view"=>false, "edit"=>false, "type"=>"link"),
"details" =>array("view"=>false, "edit"=>false, "type"=>"link"),
"delete" =>array("view"=>false, "edit"=>false, "type"=>"image")
);
$dgrid1->setModes($modes);
## *** set CSS class for datagrid
## *** "default" or "blue" or "gray" or "green" or your own css file
$css_class = "gray";
$dgrid1->setCssClass($css_class);
## *** set DataGrid caption
$dg_caption = "President Info";
$dgrid1->setCaption($dg_caption);
## +---------------------------------------------------------------------------+
## | 3. Printing & Exporting Settings: |
## +---------------------------------------------------------------------------+
## *** set printing option: true(default) or false
$printing_option = false;
$dgrid1->allowPrinting($printing_option);
## +---------------------------------------------------------------------------+
## | 7. Add/Edit/Details Mode Settings: |
## +---------------------------------------------------------------------------+
## *** set add/edit mode table properties
$em_table_properties = array("width"=>"96%");
$dgrid1->setEditModeTableProperties($em_table_properties);
## *** set details mode table properties
$dm_table_properties = array("width"=>"96%");
$dgrid1->setDetailsModeTableProperties($dm_table_properties);
## *** set settings for add/edit/details modes
$table_name = "presidents";
$primary_key = "id";
$condition = "";
$dgrid1->setTableEdit($table_name, $primary_key, $condition);
## *** set columns in edit mode
$em_columns = array(
"name" =>array("header"=>"Name", "type"=>"textbox", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Name", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>""),
"country_id" =>array("header"=>"Country", "type"=>"textbox", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Country", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>""),
"birth_date" =>array("header"=>"Birth Date", "type"=>"date", "align"=>"left", "req_type"=>"rt", "width"=>"120px", "title"=>"Date of Birth", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>"", "calendar_type"=>"floating"),
"status" =>array("header"=>"Status", "type"=>"enum", "align"=>"left", "req_type"=>"st", "width"=>"120px", "title"=>"Status", "readonly"=>false, "maxlength"=>"-1", "default"=>"", "unique"=>false, "unique_condition"=>"", "visible"=>"true", "on_js_event"=>"", "source"=>"self", "view_type"=>"dropdownlist", "multiple"=>false, "multiple_size"=>"1"),
);
$dgrid1->setColumnsInEditMode($em_columns);
$foreign_keys = array(
"country_id"=>array("table"=>"countries", "field_key"=>"id", "field_name"=>"name", "view_type"=>"dropdownlist", "condition"=>"", "order_by_field"=>"name", "order_type"=>"ASC", "on_js_event"=>""),
);
$dgrid1->setForeignKeysEdit($foreign_keys);
## +---------------------------------------------------------------------------+
## | 8. Bind the DataGrid: |
## +---------------------------------------------------------------------------+
## *** bind the DataGrid and draw it on the screen
$dgrid1->bind();
ob_end_flush();
##
################################################################################
}
</td>
</tr>
</table>