Get calendar and corresponding events from database

Next topic

Author	Message
Ivan Švogor	Tuesday 04 January 2011 6:38:03 am Hello, I need to access the database so I could do some tweaking of calendar. So what I need is the calendar and its events, in php code. I will than export it to ical format. Can anyone tell me how to access this in code? tnx
Edi Modrić	Monday 10 January 2011 7:16:52 am Hi Ivan, Calendar and events are just regular content objects and you can use eZ Publish PHP API to access them in your code. Take a look at here http://pubsvn.ez.no/doxygen/4.4/html/ , specifically the documentation for eZContentObject and eZContentObjectTreeNode PHP classes. For example, you can use eZContentObjectTreeNode::subTreeByNodeID(false, 123) static function to fetch all nodes below node with node_id = 123 eZ Publish certified developer http://ez.no/certification/verify/350658

Author

Message

Tuesday 04 January 2011 6:38:03 am

Hello, I need to access the database so I could do some tweaking of calendar. So what I need is the calendar and its events, in php code. I will than export it to ical format.

Can anyone tell me how to access this in code?

tnx

Edi Modrić

Monday 10 January 2011 7:16:52 am

Hi Ivan,

Calendar and events are just regular content objects and you can use eZ Publish PHP API to access them in your code.

Take a look at here http://pubsvn.ez.no/doxygen/4.4/html/ , specifically the documentation for eZContentObject and eZContentObjectTreeNode PHP classes.

For example, you can use eZContentObjectTreeNode::subTreeByNodeID(false, 123) static function to fetch all nodes below node with node_id = 123

eZ Publish certified developer

http://ez.no/certification/verify/350658

eZ debug

Timing:	Jan 30 2025 19:44:13
Script start
Timing:	Jan 30 2025 19:44:13
Module start 'layout'
Timing:	Jan 30 2025 19:44:13
Module start 'content'
Timing:	Jan 30 2025 19:44:13
Module end 'content'
Timing:	Jan 30 2025 19:44:13
Script end

Main resources:

Total runtime	0.0216 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0048	588.2813	151.2266
Module start 'layout'	0.0048	0.0034	739.5078	220.7266
Module start 'content'	0.0081	0.0119	960.2344	997.8516
Module end 'content'	0.0201	0.0014	1,958.0859	29.9766
Script end	0.0215		1,988.0625

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	11.0125	14	0.0002
Check MTime	0.0011	4.8984	14	0.0001
Mysql Total
Database connection	0.0009	3.9722	1	0.0009
Mysqli_queries	0.0020	9.1557	3	0.0007
Looping result	0.0000	0.0508	1	0.0000
Template Total	0.0010	4.7	1	0.0010
Template load	0.0008	3.6859	1	0.0008
Template processing	0.0002	1.0157	1	0.0002
Override
Cache load	0.0005	2.3873	1	0.0005
General
dbfile	0.0011	5.2178	8	0.0001
String conversion	0.0000	0.0265	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