Query about Datagrid
| From: | Bagare, Jayanth | Date: | Tue, 01 Mar 2005 10:03:48 +0000 |
| Subject: | Query about Datagrid | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-17750@lists.php.net to get a copy of this message | ||
Hi,
I've got a problem in Structures_Datagrid, I'm not able to pass a value
to another page, when something is selected in the datagrid, attached is
the code, please help.
<?php
require_once("Structures\Datagrid.php");
class clsDataGrid
{
/*
This class is a wrapper around the DataGrid given by Pear.
*/
// Get my data
function fn_build_grid()
{
$sql = 'SELECT FORM_NAME,FIELD_NAME,FIELD_TYPE,FIELD_DESC FROM
SSFORMDF';
$result = $_SESSION['db']->fn_read_data($sql);
while ($record = mysql_fetch_assoc($result))
{
$dataSet[] = $record;
}
$dg =& new Structures_DataGrid(10);
$column = new Structures_DataGrid_Column('',null,null,
array('width' => '10'), '<input type="radio"
name="idList[]" value =
"'.$record['FORM_NAME'].'">',null);
$dg->addColumn($column);
$column = new Structures_DataGrid_Column('Form Name',
'FORM_NAME', 'FORM_NAME', array('width' => '10'),
null,null);
$dg->addColumn($column);
$column = new Structures_DataGrid_Column('Field Name',
'FIELD_NAME', 'FIELD_NAME', array('width' => '10'),
null,null);
$dg->addColumn($column);
$column = new Structures_DataGrid_Column('Field Type',
'FIELD_TYPE', 'FIELD_TYPE', array('width' => '10'),
null,null);
$dg->addColumn($column);
$column = new Structures_DataGrid_Column('Field Description
', 'FIELD_DESC', 'FIELD_DESC', array('width' =>
'10'), null,null);
$dg->addColumn($column);
$dg->renderer->setTableHeaderAttributes(array('bgcolor' =>
'EEFFCCC',"align"=>"center"));
$dg->renderer->setTableEvenRowAttributes(array('bgcolor' =>
'#FFFFFF'));
$dg->renderer->setTableOddRowAttributes(array('bgcolor' =>
'#EEEEEE'));
$dg->renderer->setTableAttribute('width', '100%');
$dg->renderer->setTableAttribute('cellspacing', '0');
$dg->renderer->setTableAttribute('cellpadding', '2');
$dg->renderer->setTableAttribute('border', '1');
$dg->renderer->setTableAttribute('class', 'datagrid');
$dg->renderer->sortIconASC = '⇑';
$dg->renderer->sortIconDESC = '⇓';
$dg->bind($dataSet);
$dg->sortRecordSet('FIELD_NAME','ASC');
echo $dg->renderer->getPaging();
$dg->render();
echo('Selected is '.$record["FORM_NAME"]);
echo("<a href =
/class/dispatcher.php?form_name=".$record["FORM_NAME"].">Display</a>");
}
private function fn_write_element($element_type)
{
switch($element_type)
{
case 'CHECKBOX':
break;
case 'RADIO':
break;
}
}
}
?>
Thank You
Young J