Custom Database Tables

Next topic

Author	Message
Raghu Rao	Monday 01 November 2010 4:02:57 pm Hi there, I have been asked to create a resource sharing system (the resource could be as simple as an article) for which i need to track the progress of the article. This involves who was the first creator, who the resource got shared with, weather the new user copied the resource etc etc. My main question is, 1. is it possible to create custom database tables in ezpublish 2. If its possible, how Thanks in advance :-) Cheers RD
Jean-Luc Nguyen	Tuesday 09 November 2010 9:04:19 am Hi, Yes you can create and use custom tables in eZ Publish. In a "classes" subdirectory, you will create your helloWorld PHP class for a hello_world table. Your PHP class will extends eZ Publish "default used class", like: class helloWorld extends eZPersistentObject { function definition() ... } http://www.acidre.com

Author

Message

Monday 01 November 2010 4:02:57 pm

Hi there,

I have been asked to create a resource sharing system (the resource could be as simple as an article) for which i need to track the progress of the article. This involves who was the first creator, who the resource got shared with, weather the new user copied the resource etc etc. My main question is,

1. is it possible to create custom database tables in ezpublish

2. If its possible, how

Thanks in advance :-)

Cheers

Jean-Luc Nguyen

Tuesday 09 November 2010 9:04:19 am

Hi,

Yes you can create and use custom tables in eZ Publish.
In a "classes" subdirectory, you will create your helloWorld PHP class for a hello_world table.
Your PHP class will extends eZ Publish "default used class", like:
class helloWorld extends eZPersistentObject
{
function definition() ...
}

http://www.acidre.com

eZ debug

Timing:	Jan 31 2025 05:59:55
Script start
Timing:	Jan 31 2025 05:59:55
Module start 'layout'
Timing:	Jan 31 2025 05:59:55
Module start 'content'
Timing:	Jan 31 2025 05:59:55
Module end 'content'
Timing:	Jan 31 2025 05:59:55
Script end

Main resources:

Total runtime	0.0129 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.0046	588.1250	151.2109
Module start 'layout'	0.0046	0.0018	739.3359	36.6406
Module start 'content'	0.0064	0.0054	775.9766	90.1250
Module end 'content'	0.0118	0.0011	866.1016	29.9766
Script end	0.0129		896.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0021	16.5030	14	0.0002
Check MTime	0.0010	7.3775	14	0.0001
Mysql Total
Database connection	0.0007	5.2775	1	0.0007
Mysqli_queries	0.0019	14.4031	3	0.0006
Looping result	0.0000	0.0700	1	0.0000
Template Total	0.0009	6.8	1	0.0009
Template load	0.0006	4.7654	1	0.0006
Template processing	0.0003	1.9692	1	0.0003
Override
Cache load	0.0004	3.3304	1	0.0004
General
dbfile	0.0019	14.6444	8	0.0002
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