Structures_DataGrid

simulant

I'm trying to use the PEAR package 'Structures_DataGrid' and having problems getting anything to 'render'. I hope this is the right spot for this question.

Has anyone had any luck getting this to work?

Here is my code:

<?php
require('Structures/DataGrid.php');
$conn = mysqli_connect('localhost','root','pass','citidb');

// Get my data
$result = mysqli_query($conn,'SELECT * FROM users');
while ($record = mysql_fetch_assoc($result)) { 
    $dataSet[] = $record;
}

// Print the DataGrid
$dg =& new Structures_DataGrid();
$dg->bind($dataSet);
$dg->render();
?>

I'm not getting ANY php error messages at all....so I'm not sure what's going on(?)

TIA,
TIM

Weedpacket

Only that you're using mysql_fetch_assoc() instead of mysqli_fetch_assoc()....

simulant

good catch....fixed that and still not getting any output from render().

I am getting my 3 rows in $dataSet, but render() is not displaying anything, nor am I getting any PHP error messages. error_reporting is set to E_ALL in my ini.

output from print_r($dataSet):

Array
(
[0] => Array
(
[userid] => jblow
[fname] => Joe
[lname] => Blow
)

[1] => Array
    (
        [userid] => jdoe
        [fname] => John
        [lname] => Doe
    )

[2] => Array
    (
        [userid] => gijoe
        [fname] => GI
        [lname] => Joe
    )

)

I am using IIS & PHP 5.0.2. I'm wondering if maybe PEAR wasn't set up correctly, although you would think I would get some sort of error message. Here's the setup:

PEAR Base System is under c:\php\PEAR-1.3.4
Structures_DataGrid package is under c:\php\includes\Structures\DataGrid
include_path = ".;c:\php\includes;c:\php\PEAR-1.3.4"

simulant

ok, scratch this.....i found out what's wrong. i didn't install the dependency packages for the DataGrid package. I'm sure it will work once I do that. New to PEAR....

Thanks.