question about Structures_DataGrid

Hi, I am a web programmer from Russia.
First of all, excuse my bad english =)
I have a question about *Structures_DataGrid* class.
I read documentation on
http://pear.php.net/manual/en/packag...rid-datasource
but
i didn't understand how it work.
Please, help me.I think that i will understand all, if i saw a correctly
code.
For example, lets take such task: create table with 2 columns and 3 rows.
First - checkboxes and secont - simple static text (not edit).
In the beginning we have array with data. And table we need to build on that
array (take from array information about which checkbox is checked and what
is the static text will be near it). Which php code will generate such
table if we a using pear *Structures_DataGrid* class?
Please, write all code from "<?php" till "?>".
I hope you will understand my problem and will help me.

This isn't exactly what you asked for, but this is a working example of how
to take data from a db using MDB2 pear library and have Structures_DataGrid
turn it into a sortable table with page numbers

<?php

$dsn = array(
'phptype' => 'mysql',
'username' => DB_DEV_USER,
'password' => DB_DEV_PASS,
'hostspec' => DB_DEV_HOST,
'database' => DB_DEV_NAME,
);

$db =& MDB2::connect($dsn);

if (PEAR::isError($db)) {
die($db->getMessage());
}

$db->setFetchMode(MDB2_FETCHMODE_ASSOC);
$db->loadModule('Extended');

// 2 records per page
$datagrid =& new Structures_DataGrid(2);

// Setup your datasource
$test = $datagrid->bind("SELECT * FROM tbllessons", array( 'dbc' => $db ));
if (PEAR::isError($test)) {
echo $test->getMessage();
}

// Print the DataGrid with the default renderer (HTML Table)
$html = $datagrid->getOutput();
$html .= $datagrid->getOutput(DATAGRID_RENDER_PAGER);

echo $html;

?>

-----Original Message-----
From: Anton Tobolchenko [mailto:tobolchenko@gmail.com]
Sent: Tuesday, May 15, 2007 2:00 PM
To: pear-general@lists.php.net
Subject: [PEAR] question about Structures_DataGrid

Hi, I am a web programmer from Russia.
First of all, excuse my bad english =)
I have a question about *Structures_DataGrid* class.
I read documentation on
http://pear.php.net/manual/en/packag...tagrid.php#pac
kage.structures.structures-datagrid.structures-datagrid-datasource
but
i didn't understand how it work.
Please, help me.I think that i will understand all, if i saw a correctly
code.
For example, lets take such task: create table with 2 columns and 3 rows.
First - checkboxes and secont - simple static text (not edit).
In the beginning we have array with data. And table we need to build on that
array (take from array information about which checkbox is checked and what
is the static text will be near it). Which php code will generate such
table if we a using pear *Structures_DataGrid* class?
Please, write all code from "<?php" till "?>".
I hope you will understand my problem and will help me.

Hi,

Anton Tobolchenko wrote:
> Hi, I am a web programmer from Russia.
> First of all, excuse my bad english =)
> I have a question about *Structures_DataGrid* class.
> I read documentation on
> http://pear.php.net/manual/en/packag...rid-datasource
> but
> i didn't understand how it work.
> Please, help me.I think that i will understand all, if i saw a correctly
> code.
> For example, lets take such task: create table with 2 columns and 3 rows.
> First - checkboxes and secont - simple static text (not edit).
> In the beginning we have array with data. [...]

This can be achieved by the code that you've sent yesterday. Just
correct it (I gave you the needed hints in my answer) and you're done.

> And table we need to build on that
> array (take from array information about which checkbox is checked and what
> is the static text will be near it). Which php code will generate such
> table if we a using pear *Structures_DataGrid* class?

If you want to have the checkbox next to the text in one column, you
need a column formatter. Explaination and examples can be found in the
manual:
http://pear.php.net/manual/en/packag....formatter.php
http://pear.php.net/manual/en/packag...e-advanced.php

If you want to have a separate checkbox column, our new
CheckableHTMLTable renderer might be interesting for you. It can be
found in CVS. (This renderer is still in development, its name and code
might change prior to a first official release.)

Regards,
Mark

--
http://www.markwiesemann.eu

Hi,

just a short comment on your example:

Mark Steudel wrote:
[...]
> $db =& MDB2::connect($dsn);
>
> if (PEAR::isError($db)) {
> die($db->getMessage());
> }
>
> $db->setFetchMode(MDB2_FETCHMODE_ASSOC);
> $db->loadModule('Extended');

These two calls are only if needed if you use the MDB2 object also
outside of Structures_DataGrid.

Regards,
Mark

--
http://www.markwiesemann.eu