SQL in ez..

Next topic

Author	Message
K259	Monday 27 February 2006 5:59:20 am I have made some sql-selects which retrieves useful content from the ez database. This content is presented today with php outside of ez. I want to make this content available inside ez. What's the best way of doing this in a template? Thanks.
Gabriel Ambuehl	Monday 27 February 2006 6:17:42 am It's probably easiest to create a custom template operator that will use your current PHP script and call that in templates. Visit http://triligon.org
K259	Thursday 07 September 2006 7:56:28 am Hi! It's not a script, but a couple of sql's which I want to display inside an ez page. I can create an object of a class, and create an override template for this object(node), but how can I list the results from the sql? Does anyone have an example-code in ez for this? I guess I have to add a file to kernel/ and then add a template under design/xx... and send the result variable to the designtemplates..and print this with the ez template language..but how?
Norman Leutner	Friday 08 September 2006 12:47:10 am Take a look at the template operator I made a while ago, this simply executes a sql command and returns the result to the template: http://ez.no/community/contribs/template_plugins/topauthors Mit freundlichen Grüßen Best regards Norman Leutner ____________________________________________________________ eZ Publish Platinum Partner - http://www.all2e.com http://ez.no/partners/worldwide_partners/all2e_gmbh

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0085	589.0313	152.6094
Module start 'layout'	0.0085	0.0041	741.6406	39.3984
Module start 'content'	0.0127	0.7189	781.0391	572.6094
Module end 'content'	0.7316	0.0014	1,353.6484	12.2031
Script end	0.7330		1,365.8516

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.4725	16	0.0002
Check MTime	0.0014	0.1929	16	0.0001
Mysql Total
Database connection	0.0017	0.2385	1	0.0017
Mysqli_queries	0.6807	92.8714	62	0.0110
Looping result	0.0006	0.0757	60	0.0000
Template Total	0.6955	94.9	2	0.3478
Template load	0.0022	0.2996	2	0.0011
Template processing	0.6933	94.5887	2	0.3467
Template load and register function	0.0002	0.0280	1	0.0002
states
state_id_array	0.0010	0.1336	1	0.0010
state_identifier_array	0.0010	0.1386	2	0.0005
Override
Cache load	0.0018	0.2466	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1233	3	0.0003
Fetch class attribute name	0.0010	0.1337	5	0.0002
XML
Image XML parsing	0.0009	0.1268	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0011	5	0.0000
General
dbfile	0.0009	0.1236	17	0.0001
String conversion	0.0000	0.0014	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
4	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/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: 6

Time used to render debug report: 0.0001 secs