Displaying your Own Table in TikiPro

Introduction

This is a BASIC tutorial that will show you how to make a quick package that loops through a table and displays its data. I wrote this because I am starting from the VERY beginning here in TikiPro, and want to make tutorials as I go to help new opensource developers who are joining the project and need a booster seat to sit at the table! I hope it is useful to you!
Thanks for your help Spiderr

1) Create a New Package

• Go to the root of your tikipro installation and make a directory:

{CODE()}$ mkdir newPackage
$ mkdir newPackage/modules
$ mkdir newPackage/templates{CODE}

2) Create your table

• Using PostgreSQL, and a neat utility like pgAdmin3 create a database called test_table, and add two colums: nameid, and memo, or use the sql below

{CODE()}CREATE TABLE test_table
(
nameid int2 NOT NULL,
memo text[],
CONSTRAINT test_table_pkey PRIMARY KEY (nameid)
) WITHOUT OIDS;{CODE}

3) Create your PHP file

• Go to newPackage/ and create a file called index.php
• Add the following lines

{CODE()}<?php
require_once('../tiki_setup_inc.php'); //initialized the entire system!
$result = $gTikiSystem->query("SELECT * FROM test_table");
$smarty->assign('test_table', $result->GetArray());

$gTikiSystem->display( 'tikipackage:newPackage/newPackage.tpl' );
?>{CODE}

4) Create your Smarty TPL file

• Now go to newPackage/templates and create a file using pico, or whatever you use, called newPackage.tpl
• Add these lines:

{CODE()}<table>
{section name=colnum loop=$test_table}
<tr>
<td>{$test_tablecolnum.nameid}</td>
<td>{$test_tablecolnum.memo}</td>
</tr>
{/section}
</table>{CODE}

Voila!

Go to http://yourTikiProURL/newPackage/ and your table should be displayed!

5) Now, create a Module

• Create a module (a little box that you can display in the left or right columns) with a pointer to your awesome new package.

{CODE()}$ mkdir newPackage/modules{CODE}

• and create a file using pico, or whatever you use, called mod_newPackage.tpl.
• The file name must be formated like this so the tikisystem can include it in the Administration / Modules dropdown list.
• Add these lines to the file:

{CODE()}<table>
<tr>
<td class="boxtitle"><b>Planning</b><br></td>
</tr>
<tr>
<td><a href="{$gTikiLoc.newPackage_PKG_URL/index.php">
<img src="{$gTikiLoc.IMG_PKG_URL}icons/acoolicon.gif" class="icon"
alt="{tr}my new package{/tr}" title="{tr}my new package{/tr}" />My New Package</a></td>
</tr>
</table>{CODE}
(:exclaim:) $gTikiLoc.whatever_PKG_URL is a pointer to a folder called whatever in the root and is a very cool way of accessing icons... check out the IMG folder to fancy up your site!

Stay tune for more Tutorials!
Fire