Forums / General / How to get info out of database for other uses?

How to get info out of database for other uses?

« 
Previous topic
|
General
|
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 18 2025 22:18:32
Script start
Timing: Jan 18 2025 22:18:32
Module start 'content'
Timing: Jan 18 2025 22:18:33
Module end 'content'
Timing: Jan 18 2025 22:18:33
Script end

Main resources:

Total runtime0.6556 sec
Peak memory usage4,096.0000 KB
Database Queries68

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0072 587.8359180.8203
Module start 'content' 0.00720.6395 768.6563635.3281
Module end 'content' 0.64680.0087 1,403.984446.0703
Script end 0.6555  1,450.0547 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00270.4102140.0002
Check MTime0.00120.1862140.0001
Mysql Total
Database connection0.00060.093710.0006
Mysqli_queries0.605892.4070680.0089
Looping result0.00070.1129660.0000
Template Total0.626195.520.3131
Template load0.00180.278620.0009
Template processing0.624395.227120.3121
Template load and register function0.00020.034810.0002
states
state_id_array0.00090.139110.0009
state_identifier_array0.00130.205020.0007
Override
Cache load0.00150.2307230.0001
Sytem overhead
Fetch class attribute can translate value0.00080.124140.0002
Fetch class attribute name0.00110.167970.0002
XML
Image XML parsing0.00130.192240.0003
class_abstraction
Instantiating content class attribute0.00000.001770.0000
General
dbfile0.00120.1756240.0000
String conversion0.00000.000930.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 18
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs