Newbie - before choosing right CMS solution.....

Author Message

Aleksander Lech

Sunday 14 August 2005 12:47:31 am

Hi there!

I'm trying to make decission about choosing right CMS solution for my company's client.

ezPublish looks pretty cool, but I have now one question.

Is there possibility to make db queries in "PHP way" - I mean - in some php file I have script line which connects me to the db, than I have an SQL query, which (when executed) stores the result in some resultset variable. I can then use the result in the way I want.

Can I do this in ezPublish the same way or do I have to create classes, objects etc. I'd never had to use php classes and objects before :( And after long hours of ezp forum reading, I'm confused a little.

Greetings
Aleksander

Gabriel Ambuehl

Sunday 14 August 2005 2:21:56 am

You will likely not need to define your own SQL for most tasks. If you need to, you'll most likely have to write an extension (possibly template operator) and that does need PHP knowledge.

Visit http://triligon.org

Aleksander Lech

Sunday 14 August 2005 3:59:19 am

Well, most likely I will need to define my own SQL queries, because there will be a lot of non-ezPublish tables which I'll have to search. So probably there's no easy way to incorporate custom php scripts and pass their results to ezP templates?

I know, that I can create extension/module but - according to this: http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1
do I really need to create such complicated structure and fuctions to extract data from non-ezP tables?

Greetings
Aleksander

Gabriel Ambuehl

Sunday 14 August 2005 4:25:10 am

If you need custom databases, it's probably necessary, yes.

Visit http://triligon.org

Aleksander Lech

Sunday 14 August 2005 4:45:02 am

Thank you very much Gabriel for ypur quick responses.
I'll start learning ezP soon then.

Aleksander

Bruce Morrison

Sunday 14 August 2005 2:51:39 pm

Hi Aleksander

I know, that I can create extension/module but - according to this: http://ez.no/products/ez_publish_...nsions/module/module_tutorial_part_1
do I really need to create such complicated structure and fuctions to extract data from non-ezP tables?

While it may seem complicated once you get your head around it you will find that most of the functions you require are provided by eZ.

Also look at the eZPersistentObject class
http://pubsvn.ez.no/doxygen/classeZPersistentObject.html

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

Gabriel Ambuehl

Sunday 14 August 2005 3:07:52 pm

The fact that functions are provided by eZ doesn't necessarily mean it's easier. In some case one could truly argue it to be much harder if you try to use the integrated API as opposed to just firing SQL against the DB...

Visit http://triligon.org

Bruce Morrison

Sunday 14 August 2005 5:00:05 pm

Hi Gabriel

The fact that functions are provided by eZ doesn't necessarily mean it's easier. In some case one could truly argue it to be much harder if you try to use the integrated API as opposed to just firing SQL against the DB...

Sure and sometimes you have to do that. It all depends on what you need to do and how complex that database structure is.

What I was pointing out is that the eZ framework provides a lot of functionality that if used can save a lot of time. It may seem complicated on the surface but once you get used to using it, it can be quite simple*.

* See paragraph 1 ;)

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

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