beginner for smarty and adodb

wanaka

Hi,

I am new to adodb & smarty. I have done a page but end up with a blank page no error display on the page. Any idea?

template file

<html>
<body>
<table cellpadding=1 cellspacing=0 border=0 width=100%>
{section name=nr loop=$results}
<tr>
<td>{$results[nr].projectdescription}</td>
</tr>
{/section}

</table>

</body>
</html>

php file
<?php
require_once("./config.php");

$db = NewADOConnection("$database_type");
$db->pConnect("$host", "$user", "$password", "$database") or die("Unable to connect!");

$query = "SELECT * from view_device_quantity";
$db->SetFetchMode(ADODB_FETCH_ASSOC);

$rs = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());

while ($row = $rs->FetchNextObject())

{ $results = array (
'projectdescrption' => $row->projectdescription,
'server' => $row->server,
'firewall' => $row->firewall,
'storage' => $row->storage,
'router' => $row->router,
'switch' => $row->switch);
}

$db->Close();

$smarty->assign('results', $results);
$smarty->display('stat.tpl');

mrhappiness

Originally posted by wanaka
'projectdescrption' => $row->projectdescription

i think you meant
'projectdescription' => $row->projectdescription

wanaka

I have fixed that type but same the page just blank

mrhappiness

try
$results[] = array (

and do

print_r($result);

directly after $db->Close();

what is th eoutput?

wanaka

The output is like
Array ( [0] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [1] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [2] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [3] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [4] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [5] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [6] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [7] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [8] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [9] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [10] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [11] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) [12] => Array ( [projectdescription] => [server] => [firewall] => [storage] => [router] => [switch] => ) )

mrhappiness

semms like you don't get the results you expect...

do print_r($row); inside the while

wanaka

but the smarty part still show nothing atl all.

mrhappiness

you did print_r($row); inside the while?

you posted the results?

wanaka

Hi,

the result is like this

adofetchobj Object ( [PROJECTDESCRIPTION] => abc Pte Ltd [PROJECTID] => 43 [FIREWALL] => 0 [ROUTER] => 0 [SERVER] => 1 [STORAGE] => 0 [SWITCH] => 0 )
adofetchobj Object ( [PROJECTDESCRIPTION] => Fund Services [PROJECTID] => 62 [FIREWALL] => 0 [ROUTER] => 0 [SERVER] => 12 [STORAGE] => 0 [SWITCH] => 0 )

Barb54

Hi,
I know very little about php and even less about Smarty BUT, don't you have to state the "path" to Smarty config file at the top of your page?

????

Barb

wanaka

No I did it was included inside config.php