Forums / General / Database Integration

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

eZ debug

Timing: Jan 19 2025 03:30:54
Script start
Timing: Jan 19 2025 03:30:54
Module start 'content'
Timing: Jan 19 2025 03:30:54
Module end 'content'
Timing: Jan 19 2025 03:30:54
Script end

Main resources:

Total runtime0.2007 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 589.9609180.8516
Module start 'content' 0.00610.0053 770.812597.8047
Module end 'content' 0.01140.1893 868.6172525.8594
Script end 0.2006  1,394.4766 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00391.9339200.0002
Check MTime0.00140.6741200.0001
Mysql Total
Database connection0.00110.545610.0011
Mysqli_queries0.136467.97431410.0010
Looping result0.00150.74491390.0000
Template Total0.188994.110.1889
Template load0.00090.445510.0009
Template processing0.188093.665010.1880
Override
Cache load0.00070.326810.0007
Sytem overhead
Fetch class attribute can translate value0.00130.647610.0013
XML
Image XML parsing0.00030.146010.0003
General
dbfile0.00542.6830200.0003
String conversion0.00000.002930.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

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

Time used to render debug report: 0.0003 secs