using database values in a class

Next topic

Author	Message
rex nedoli	Sunday 04 January 2004 12:53:44 pm I would like to create a class which would contain, among others, drop down list (selection). Not being much of a developer, I find myself confronted with two problems: 1. the list of values that I want to use this way (countries and states(provinces)) is long. Logic dictates that I store them in database tables and call them up somehow from the class. Is this possible, and how can I do it? 2. Assuming that the above is possible; and with the two list (tables) mentioned above -countries and states - i would also like to make the choice presented in the states selection list to be dependent upon the the choice made in the countries selection - e.g. if the country selected is "Canada", I would like the states list to present only the names of the provinces (states) in "Canada". On top of being a soso developer, I only have 2.5 days experience with EZ publish - so I do need a some help :) I, Rex
Kåre Køhler Høvik	Monday 05 January 2004 4:12:55 am Hi You should probably create a new datatype to do this. Take a look at this documentation page on how to create a new datatype: http://ez.no/developer/ez_publish_3/documentation/development/extensions/datatypes/new_datatype_ -- Kåre Høvik Kåre Høvik

Author

Message

Sunday 04 January 2004 12:53:44 pm

I would like to create a class which would contain, among others, drop down list (selection). Not being much of a developer, I find myself confronted with two problems:

1. the list of values that I want to use this way (countries and states(provinces)) is long. Logic dictates that I store them in database tables and call them up somehow from the class. Is this possible, and how can I do it?

2. Assuming that the above is possible; and with the two list (tables) mentioned above -countries and states - i would also like to make the choice presented in the states selection list to be dependent upon the the choice made in the countries selection - e.g. if the country selected is "Canada", I would like the states list to present only the names of the provinces (states) in "Canada".

On top of being a soso developer, I only have 2.5 days experience with EZ publish - so I do need a some help :)

I, Rex

Kåre Køhler Høvik

Monday 05 January 2004 4:12:55 am

You should probably create a new datatype to do this. Take a look at this documentation page on how to create a new datatype: http://ez.no/developer/ez_publish_3/documentation/development/extensions/datatypes/new_datatype_

--
Kåre Høvik

Kåre Høvik

eZ debug

Timing:	Jan 31 2025 04:27:04
Script start
Timing:	Jan 31 2025 04:27:04
Module start 'layout'
Timing:	Jan 31 2025 04:27:04
Module start 'content'
Timing:	Jan 31 2025 04:27:04
Module end 'content'
Timing:	Jan 31 2025 04:27:04
Script end

Main resources:

Total runtime	0.0137 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.0051	588.1406	151.2109
Module start 'layout'	0.0051	0.0030	739.3516	36.6484
Module start 'content'	0.0082	0.0042	776.0000	90.1563
Module end 'content'	0.0123	0.0013	866.1563	29.9922
Script end	0.0136		896.1484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	18.2035	14	0.0002
Check MTime	0.0011	8.0008	14	0.0001
Mysql Total
Database connection	0.0008	5.6453	1	0.0008
Mysqli_queries	0.0028	20.3062	3	0.0009
Looping result	0.0000	0.1011	1	0.0000
Template Total	0.0010	7.2	1	0.0010
Template load	0.0007	5.4117	1	0.0007
Template processing	0.0002	1.7173	1	0.0002
Override
Cache load	0.0005	3.7589	1	0.0005
General
dbfile	0.0003	2.3293	8	0.0000
String conversion	0.0000	0.0663	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