Query an external Database

Previous topic

General

Next topic

Author	Message
Nayef Abu Ebaid	Monday 18 December 2006 6:28:09 am Hi Everyone, I have a toolbar that i use to as an advertising template, every section on the site has its own ad, so every ad has zone i, i use the template to tell the toolbar in which section i am and it will get the ads for me, i have a database that has all the zone ids in it, i want the toolbar somehow to query the database and get the zone id depned on the section, so I was thinking of writing a query using php to query this db. how can do that?! Nayef
kracker (the)	Monday 18 December 2006 10:01:45 am Yes. Use the 'wrap_operator' it will work perfectly for your needs. <i>http://ez.no/community/forum/setup_design/include_website_in_another#msg115898</i> //kracker <i>tv : reading rainbow ...</i> Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/
Xavier Dutoit	Monday 18 December 2006 4:46:35 pm and beware the various caches so you have your toolbar recalculated for each different sections instead of reusing one from a previously cached one. X+ http://www.sydesy.com

Author

Message

Nayef Abu Ebaid

Monday 18 December 2006 6:28:09 am

Hi Everyone,

I have a toolbar that i use to as an advertising template, every section on the site has its own ad, so every ad has zone i, i use the template to tell the toolbar in which section i am and it will get the ads for me, i have a database that has all the zone ids in it, i want the toolbar somehow to query the database and get the zone id depned on the section, so I was thinking of writing a query using php to query this db. how can do that?!

Nayef

kracker (the)

Monday 18 December 2006 10:01:45 am

Yes. Use the 'wrap_operator' it will work perfectly for your needs.

<i>http://ez.no/community/forum/setup_design/include_website_in_another#msg115898</i>

//kracker
<i>tv : reading rainbow ...</i>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

Xavier Dutoit

Monday 18 December 2006 4:46:35 pm

and beware the various caches so you have your toolbar recalculated for each different sections instead of reusing one from a previously cached one.

X+

http://www.sydesy.com

eZ debug

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

Main resources:

Total runtime	0.0267 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.0067	589.3359	152.6250
Module start 'layout'	0.0067	0.0042	741.9609	39.4453
Module start 'content'	0.0109	0.0136	781.4063	89.2891
Module end 'content'	0.0244	0.0023	870.6953	34.3047
Script end	0.0267		905.0000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	10.5765	14	0.0002
Check MTime	0.0012	4.4352	14	0.0001
Mysql Total
Database connection	0.0010	3.5915	1	0.0010
Mysqli_queries	0.0035	12.9167	3	0.0012
Looping result	0.0000	0.0642	1	0.0000
Template Total	0.0017	6.3	1	0.0017
Template load	0.0009	3.5317	1	0.0009
Template processing	0.0007	2.7157	1	0.0007
Override
Cache load	0.0006	2.3750	1	0.0006
General
dbfile	0.0003	1.0319	8	0.0000
String conversion	0.0000	0.0330	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