How to get instance of Database

Wednesday 20 October 2004 2:06:20 am

I have created a database in Mysql say test
and have created a table Employee with fields Name,Id,Dept.
Now I want to generate a table in the template file to show the user.
All I could make out from the forums and Documentations is to do this
$db =& eZDB::instance();
$rows =& $db->arrayQuery( "SELECT * FROM employee" );
foreach ( $rows as $row )
{
print( $row["name"] );
}
}

but how do i know eZDB is connecting to my "test" database
is this the correct way of getting the instance of database

Wednesday 20 October 2004 8:19:27 am

- in administration panel u can also create class called Employee with Name, Id, Dept attributes
- create folder where u will store your objects
- fatch data with fetch function

{section loop=fetch(content, list, hash(parent_node_id, $node.node_id))}
{$:item.name} | {$:item.id} | {$:item.dept}
{/section}

You can construc table in html with 1 object per row

<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td> Name </td>
    <td> Id</td>
    <td> Dept </td>
  </tr>
  {section loop=fetch(content, list, hash(parent_node_id, $node.node_id))}
  <tr>
    <td>{$:item.name}</td>
    <td>{$:item.id}</td>
    <td>{$:item.dept}</td>
  </tr>
  {/section}
</table>

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog