Forums / Developer / Newbie - before choosing right CMS solution.....
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.
GreetingsAleksander
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
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_1do I really need to create such complicated structure and fuctions to extract data from non-ezP tables?
Greetings Aleksander
Sunday 14 August 2005 4:25:10 am
If you need custom databases, it's probably necessary, yes.
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 classhttp://pubsvn.ez.no/doxygen/classeZPersistentObject.html
CheersBruce
My Blog: http://www.stuffandcontent.com/ Follow me on twitter: http://twitter.com/brucemorrison Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
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...
Sunday 14 August 2005 5:00:05 pm
Hi Gabriel
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 ;)