Where's my result?

Next topic

Author	Message
Aleksander Lech	Sunday 14 August 2005 10:53:18 am hello, here's part of my custom extension code: include_once( 'kernel/common/template.php' ); $tpl =& templateInit(); $Result = array(); $Result['content'] =& $tpl->fetch( 'design:mymod/overview.tpl' ); $Result['path'] = array( array( 'url' => false, 'text' => 'MyMod' ) ); include_once( 'lib/ezdb/classes/ezdb.php' ); $db =& eZDB::instance(); $Result['wynik'] =& $db->arrayQuery( 'SELECT * FROM firma WHERE id<2', array( 'offset' => 0, 'limit' => 10 ) ); Result of the query is in $Result['wynik'] array. How to get it from there and use it in template? Regards Aleksander
Gabriel R.	Sunday 14 August 2005 11:39:58 am use the template 'setVariable' function: php extension code ... $db =& eZDB::instance(); $wynik =& $db->arrayQuery( 'SELECT * FROM firma WHERE id<2', array( 'offset' => 0, 'limit' => 10 ) ); $tpl->setVariable( 'wynik', $wynik ); template example my result: {$wynik\|attribute(show)}

Author

Message

Sunday 14 August 2005 10:53:18 am

hello,
here's part of my custom extension code:

include_once( 'kernel/common/template.php' );

$tpl =& templateInit();

$Result = array();
$Result['content'] =& $tpl->fetch( 'design:mymod/overview.tpl' );
$Result['path'] = array( array( 'url' => false,
                                'text' => 'MyMod' ) );
                                

   include_once( 'lib/ezdb/classes/ezdb.php' );  
   $db =& eZDB::instance();
   $Result['wynik'] =& $db->arrayQuery( 'SELECT * FROM firma WHERE id<2',
                            array( 'offset' => 0, 'limit' => 10 ) );

Result of the query is in $Result['wynik'] array. How to get it from there and use it in template?

Regards
Aleksander

Gabriel R.

Sunday 14 August 2005 11:39:58 am

use the template 'setVariable' function:

php extension code

...

$db =& eZDB::instance();
   $wynik =& $db->arrayQuery( 'SELECT * FROM firma WHERE id<2',
                            array( 'offset' => 0, 'limit' => 10 ) );

$tpl->setVariable( 'wynik', $wynik );

template example

my result: {$wynik|attribute(show)}

eZ debug

Timing:	Jan 18 2025 22:13:44
Script start
Timing:	Jan 18 2025 22:13:44
Module start 'layout'
Timing:	Jan 18 2025 22:13:44
Module start 'content'
Timing:	Jan 18 2025 22:13:44
Module end 'content'
Timing:	Jan 18 2025 22:13:44
Script end

Main resources:

Total runtime	0.0248 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.2266	152.6094
Module start 'layout'	0.0058	0.0048	741.8359	39.4297
Module start 'content'	0.0106	0.0113	781.2656	89.3203
Module end 'content'	0.0219	0.0028	870.5859	30.3047
Script end	0.0247		900.8906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	12.1716	14	0.0002
Check MTime	0.0011	4.6385	14	0.0001
Mysql Total
Database connection	0.0007	2.9707	1	0.0007
Mysqli_queries	0.0037	14.9075	3	0.0012
Looping result	0.0000	0.1049	1	0.0000
Template Total	0.0023	9.3	1	0.0023
Template load	0.0013	5.0898	1	0.0013
Template processing	0.0010	4.1573	1	0.0010
Override
Cache load	0.0009	3.4836	1	0.0009
General
dbfile	0.0030	12.2861	8	0.0004
String conversion	0.0000	0.0404	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs