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

«

Previous topic

|

|

Next topic

»

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.

eZ debug

Timing:	Jan 19 2025 00:10:44
Script start
Timing:	Jan 19 2025 00:10:44
Module start 'layout'
Timing:	Jan 19 2025 00:10:44
Module start 'content'
Timing:	Jan 19 2025 00:10:44
Module end 'content'
Timing:	Jan 19 2025 00:10:44
Script end

Main resources:

Total runtime	0.0179 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.0469	152.6406
Module start 'layout'	0.0064	0.0040	740.6875	39.4766
Module start 'content'	0.0105	0.0056	780.1641	97.4922
Module end 'content'	0.0161	0.0018	877.6563	38.3047
Script end	0.0179		915.9609

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	13.5757	14	0.0002
Check MTime	0.0010	5.7874	14	0.0001
Mysql Total
Database connection	0.0011	6.0292	1	0.0011
Mysqli_queries	0.0038	20.9189	3	0.0013
Looping result	0.0000	0.1169	1	0.0000
Template Total	0.0014	8.0	1	0.0014
Template load	0.0008	4.2183	1	0.0008
Template processing	0.0007	3.7945	1	0.0007
Override
Cache load	0.0005	2.8485	1	0.0005
General
dbfile	0.0003	1.4973	8	0.0000
String conversion	0.0000	0.0571	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs