History of Tutorial_Custom_Package
Version 9
Displaying your Own Table in bitweaver
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 bitweaver, 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 bitweaver installation and make a directory:
$ 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
(
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
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:
{$test_tablecolnum.nameid} | {$test_tablecolnum.memo} |
Voila!
Go to http://yourbitweaverURL/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.
- 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:
Planning |
{tikicon ipackage=newPackage iname=iconname iexplain="this is a cool icon"}My New Package |
(:exclaim:) $gTikiLoc.whatever_PKG_URL is a pointer to a folder called whatever in the root...
to use icons check out our cool new icon system called function_tikicon
6)List of available constants in bitweaver
<package>_PKG_PATH --> example: WIKI_PKG_PATH
this will give you the full path to the wiki folder
<package>_PKG_URL --> example: WIKI_PKG_URL
this will give you the full url to the wiki folder
these contain the full path and url to the root of the application
TIKI_ROOT_PATH
TIKI_ROOT_URL
contains the name of the currently active package
ACTIVE_PACKAGE
full path and url to the currently active style
THEMES_STYLE_PATH
THEMES_STYLE_URL
Stay tuned for more Tutorials!
Fire</package></package>