Database Integration

Author Message

Tiziano Zonta

Wednesday 06 July 2005 1:49:31 am

I have have a mysql database that comes from an other web application with 1000 products i need to integrate this databese with the ez database.Where I can find some information?Is it possible do that?Somebody can help me?

Tnx

Björn Dieding@xrow.de

Wednesday 06 July 2005 4:08:34 am

That's a hard task for a newbie...

You can find examples here

http://ez.no/community/contribs/import_export

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Bruce Morrison

Thursday 07 July 2005 4:32:16 pm

Hi Tiziano

You have two options. The first (as Björn pointed out) is to import the existing database information into eZ publish CMS objects. This would allow for the data to be managed as well as being displayed via the CMS.

The other option is to create an extension to the CMS that reads the information from the database and displays it via the CMS.

Both options require php programing and eZ experience.

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Friday 08 July 2005 12:02:57 am

Are there any examples how to programmatically connect to another mysql database and query, insert and display data ?
If so, where ?

Tiziano Zonta

Friday 08 July 2005 12:13:29 am

it's too hard!! :=))

tnx for help

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 01:15:13
Script start
Timing: Jan 31 2025 01:15:13
Module start 'layout'
Timing: Jan 31 2025 01:15:13
Module start 'content'
Timing: Jan 31 2025 01:15:13
Module end 'content'
Timing: Jan 31 2025 01:15:13
Script end

Main resources:

Total runtime0.0232 sec
Peak memory usage4,096.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 589.1406151.1953
Module start 'layout' 0.00580.0034 740.3359220.6719
Module start 'content' 0.00910.0128 961.00781,001.7422
Module end 'content' 0.02190.0012 1,962.750033.9922
Script end 0.0232  1,996.7422 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002611.0434140.0002
Check MTime0.00114.6698140.0001
Mysql Total
Database connection0.00125.125810.0012
Mysqli_queries0.00198.257230.0006
Looping result0.00000.043110.0000
Template Total0.00093.710.0009
Template load0.00072.895110.0007
Template processing0.00020.814410.0002
Override
Cache load0.00041.925610.0004
General
dbfile0.00135.758480.0002
String conversion0.00000.033940.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs