database and tpl?

Next topic

Author	Message
Rizwan Ahmad	Friday 11 July 2003 5:23:46 am How to use database related function in the tpl?
Karsten Jennissen	Friday 11 July 2003 5:34:14 am Could you please explain a bit more what you are trying to do? This info is too short to give an answer. :-) Karsten P.S.: Please don't double or cross-post. Thanks.
Rizwan Ahmad	Sunday 13 July 2003 11:57:07 pm I want to write a qurey in the tpl to extract the data according to the query. The fetch command extract the specified data only. What if I want to use my own query. Although the answer is available at http://www.ez.no/developer/ez_publish_3/documentation/development/libraries/ez_db/data_retrieval but that does not specify how I can incorporate the php in tpl
Karsten Jennissen	Monday 14 July 2003 12:51:13 am Hi, now we have two threads with the same question. :-) Anyhow, PHP is not available in templates (seperation of code and layout). If you want to do something that the current template functions / operators do not support, you will have to write an extension. If it is a quick PHP call you want in your template, you might consider writing a template operater. In the Admin under Set-up there is a point called RAD. You can use this to write the operator. Check the docs on extensions (link I posted in the other thread), on how to do this. Karsten

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	587.7969	152.6094
Module start 'layout'	0.0048	0.0028	740.4063	39.4141
Module start 'content'	0.0076	1.5140	779.8203	475.3984
Module end 'content'	1.5216	0.0013	1,255.2188	12.1875
Script end	1.5230		1,267.4063

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2203	16	0.0002
Check MTime	0.0013	0.0825	16	0.0001
Mysql Total
Database connection	0.0007	0.0439	1	0.0007
Mysqli_queries	1.4772	96.9950	60	0.0246
Looping result	0.0006	0.0406	58	0.0000
Template Total	1.4875	97.7	2	0.7437
Template load	0.0022	0.1467	2	0.0011
Template processing	1.4852	97.5179	2	0.7426
Template load and register function	0.0002	0.0145	1	0.0002
states
state_id_array	0.0012	0.0798	1	0.0012
state_identifier_array	0.0015	0.0956	2	0.0007
Override
Cache load	0.0017	0.1097	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0012	0.0756	2	0.0006
Fetch class attribute name	0.0013	0.0840	4	0.0003
XML
Image XML parsing	0.0002	0.0141	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0007	4	0.0000
General
dbfile	0.0030	0.1983	10	0.0003
String conversion	0.0000	0.0005	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs