Calling PHP methods from a template

Next topic

Author	Message
Mike Makris	Wednesday 13 October 2010 1:06:10 pm I am trying to call a php method from a template in order to query the database and return an array. The parameter I pass is the ID of a ContentObject and I query for a set that is external to the ezpublish data. My problem is that the ID I pass gets truncated to the first digit. Also, if i return a count of my result set, that number also gets truncated back in the template. Why is this happening? How do I fix it? Finally, how do I return the array of records back into the template to print them out with a foreach loop? Thank you Mike MikeM
Thiago Campos Viana	Wednesday 13 October 2010 1:24:51 pm You could create a custom fetch function, there's a tutorial about that: Understanding and developing fetch functions eZ Publish Certified Developer: http://auth.ez.no/certification/verify/376924 Twitter: http://twitter.com/tcv_br

Author

Message

Wednesday 13 October 2010 1:06:10 pm

I am trying to call a php method from a template in order to query the database and return an array. The parameter I pass is the ID of a ContentObject and I query for a set that is external to the ezpublish data.

My problem is that the ID I pass gets truncated to the first digit. Also, if i return a count of my result set, that number also gets truncated back in the template. Why is this happening? How do I fix it?

Finally, how do I return the array of records back into the template to print them out with a foreach loop?

Thank you

Mike

MikeM

Thiago Campos Viana

Wednesday 13 October 2010 1:24:51 pm

You could create a custom fetch function, there's a tutorial about that: Understanding and developing fetch functions

eZ Publish Certified Developer: http://auth.ez.no/certification/verify/376924

Twitter: http://twitter.com/tcv_br

eZ debug

Timing:	Jan 18 2025 05:10:21
Script start
Timing:	Jan 18 2025 05:10:21
Module start 'layout'
Timing:	Jan 18 2025 05:10:21
Module start 'content'
Timing:	Jan 18 2025 05:10:22
Module end 'content'
Timing:	Jan 18 2025 05:10:22
Script end

Main resources:

Total runtime	0.6040 sec
Peak memory usage	4,096.0000 KB
Database Queries	55

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0067	589.0547	152.6250
Module start 'layout'	0.0067	0.0023	741.6797	39.4531
Module start 'content'	0.0090	0.5939	781.1328	526.5078
Module end 'content'	0.6029	0.0010	1,307.6406	8.1563
Script end	0.6040		1,315.7969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.5249	16	0.0002
Check MTime	0.0013	0.2110	16	0.0001
Mysql Total
Database connection	0.0012	0.1985	1	0.0012
Mysqli_queries	0.5603	92.7764	55	0.0102
Looping result	0.0005	0.0838	53	0.0000
Template Total	0.5710	94.5	2	0.2855
Template load	0.0020	0.3351	2	0.0010
Template processing	0.5690	94.2031	2	0.2845
Template load and register function	0.0001	0.0217	1	0.0001
states
state_id_array	0.0014	0.2383	1	0.0014
state_identifier_array	0.0012	0.1972	2	0.0006
Override
Cache load	0.0016	0.2715	12	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1189	2	0.0004
Fetch class attribute name	0.0014	0.2280	3	0.0005
XML
Image XML parsing	0.0006	0.1056	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0013	3	0.0000
General
dbfile	0.0013	0.2197	16	0.0001
String conversion	0.0000	0.0013	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 8 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs