<?php
################################################################################
## +---------------------------------------------------------------------------+
## | 1. Creating & Calling: |
## +---------------------------------------------------------------------------+
## *** only relative (virtual) path (to the current document)
define ("DATAGRID_DIR", "datagrid/"); /* Ex.: "datagrid/" */
require_once(DATAGRID_DIR.'datagrid.class.php');
## *** creating variables that we need for database connection
$DB_USER="username";
$DB_PASS="password";
$DB_HOST="host";
$DB_NAME="database name";
ob_start();
## *** set needed options
$debug_mode = false;
$messaging = true;
$unique_prefix = "f_";
$dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix);
## *** put a primary key on the first place
$sql=" SELECT "
." demo_countries.id, "
." demo_countries.name, "
." demo_countries.description, "
." demo_countries.picture_url, "
." FORMAT(demo_countries.population, 0) as population, "
." CASE WHEN demo_countries.is_democracy = 1 THEN 'Yes' ELSE 'No' END as is_democracy "
."FROM demo_countries ";
## *** set data source with needed options
$default_order = array("name"=>"ASC");
$dgrid->DataSource("PEAR", "mysql", $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS, $sql, $default_order);
$dg_caption = '<b>Simplest ApPHP DataGrid</b>';
$dgrid->SetCaption($dg_caption);
## +---------------------------------------------------------------------------+
## | 6. View Mode Settings: |
## +---------------------------------------------------------------------------+
## *** set columns in view mode
$dgrid->SetAutoColumnsInViewMode(true);
## +---------------------------------------------------------------------------+
## | 7. Add/Edit/Details Mode settings: |
## +---------------------------------------------------------------------------+
## *** set settings for edit/details mode
$table_name = "demo_countries";
$primary_key = "id";
$condition = "";
$dgrid->SetTableEdit($table_name, $primary_key, $condition);
$dgrid->SetAutoColumnsInEditMode(true);
## +---------------------------------------------------------------------------+
## | 8. Bind the DataGrid: |
## +---------------------------------------------------------------------------+
## *** set debug mode & messaging options
$dgrid->Bind();
ob_end_flush();
?>