How to get info out of database for other uses?

Next topic

Author	Message
Joanie Chembars	Friday 01 April 2005 10:11:39 am Does anyone know if it is possible for me to query my eZpublish database from say, Dreamweaver, and pull out articles a user may have submitted? Or am I just dreaming?
Gabriel Ambuehl	Friday 01 April 2005 11:55:56 pm Not without custom programming. Visit http://triligon.org
Ekkehard Dörre	Sunday 03 April 2005 3:41:13 am Hi, via RSS: http://ez.no/community/forum/developer/php_script_to_fetch_latest_published_articles or: http://ez.no/community/forum/developer/articles_table_in_database Database diagram: http://ez.no/community/forum/developer/datamodel_image Greetings, ekke http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing
Gabriel Ambuehl	Sunday 03 April 2005 3:51:04 am I'm in the process of writing a CSV export extension, BTW. Haven't decided on the license yet, though. Right now it supports all primitive types (i.e. strings, text, xmltext, ints, floats, email, url). Visit http://triligon.org
Fabricio Guerrero	Wednesday 04 May 2005 2:21:30 am i need a similar script... the idea would be to export advancesearch results to a csv. either that or make the advancesearch results downloadable PDF http://www.solobromasychistes.com <<Joomla Site :P http://www.recipesforhealthyfood.com/ <<Drupal Site :P http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

eZ debug

Timing:	Jan 19 2025 00:22:57
Script start
Timing:	Jan 19 2025 00:22:57
Module start 'layout'
Timing:	Jan 19 2025 00:22:57
Module start 'content'
Timing:	Jan 19 2025 00:22:58
Module end 'content'
Timing:	Jan 19 2025 00:22:58
Script end

Main resources:

Total runtime	0.9750 sec
Peak memory usage	4,096.0000 KB
Database Queries	67

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	589.1563	152.6406
Module start 'layout'	0.0056	0.0034	741.7969	39.4766
Module start 'content'	0.0091	0.9646	781.2734	630.2344
Module end 'content'	0.9737	0.0013	1,411.5078	12.1250
Script end	0.9750		1,423.6328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3363	16	0.0002
Check MTime	0.0013	0.1373	16	0.0001
Mysql Total
Database connection	0.0007	0.0686	1	0.0007
Mysqli_queries	0.9184	94.1993	67	0.0137
Looping result	0.0008	0.0778	65	0.0000
Template Total	0.9449	96.9	2	0.4724
Template load	0.0021	0.2112	2	0.0010
Template processing	0.9428	96.6986	2	0.4714
Template load and register function	0.0002	0.0252	1	0.0002
states
state_id_array	0.0007	0.0726	1	0.0007
state_identifier_array	0.0017	0.1726	2	0.0008
Override
Cache load	0.0017	0.1747	23	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1145	4	0.0003
Fetch class attribute name	0.0015	0.1542	7	0.0002
XML
Image XML parsing	0.0020	0.2002	4	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0016	7	0.0000
General
dbfile	0.0012	0.1202	22	0.0001
String conversion	0.0000	0.0011	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
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	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: 18 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs