Storing cities of a country in a dropdown box

Next topic

Author	Message
Robert Ledoux	Monday 04 August 2008 10:00:32 am Hi everybody I try to make a website with ez publish. I need to create a custom class for store and display my products. However, I need to know for all product where it is (geolocalisation) I think to store that in my custom class "Products" this information but how ? Can I make a dropdown box with all city of my country ? How do that ? Can I separate state/city width 2 linked dropdown box? Thanks a lot for your responses. Chap
Łukasz Serwatka	Tuesday 05 August 2008 12:28:01 am I don't know how many cities in your country is but I assume a thousands thus I don't see point in keeping all country cities in one dropdown box. Just use text string and let users to fill that filed. For states you can create new class and use object relation list which support dropdown list style. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Robert Ledoux	Wednesday 06 August 2008 4:31:08 am Thanks for your answer Łukasz Serwatka. Howerver, I founded this contrib "Datatype: eZCountry". Do you think I can make two other datatype named Region and city? I have read an article about creating datatype in an extension. But now my problem is : If a user selects "France" in the first attribute "ezCountry" on my object, can I propose to the second select box all the city in France. You now what I mean? Thanks

Author

Message

Monday 04 August 2008 10:00:32 am

Hi everybody

I try to make a website with ez publish. I need to create a custom class for store and display my products. However, I need to know for all product where it is (geolocalisation)

I think to store that in my custom class "Products" this information but how ?

Can I make a dropdown box with all city of my country ? How do that ?
Can I separate state/city width 2 linked dropdown box?

Thanks a lot for your responses.

Chap

Łukasz Serwatka

Tuesday 05 August 2008 12:28:01 am

I don't know how many cities in your country is but I assume a thousands thus I don't see point in keeping all country cities in one dropdown box. Just use text string and let users to fill that filed. For states you can create new class and use object relation list which support dropdown list style.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Robert Ledoux

Wednesday 06 August 2008 4:31:08 am

Thanks for your answer Łukasz Serwatka.

Howerver, I founded this contrib "Datatype: eZCountry". Do you think I can make two other datatype named Region and city? I have read an article about creating datatype in an extension.

But now my problem is :
If a user selects "France" in the first attribute "ezCountry" on my object, can I propose to the second select box all the city in France. You now what I mean?

Thanks

eZ debug

Timing:	Jan 18 2025 16:12:41
Script start
Timing:	Jan 18 2025 16:12:41
Module start 'layout'
Timing:	Jan 18 2025 16:12:41
Module start 'content'
Timing:	Jan 18 2025 16:12:41
Module end 'content'
Timing:	Jan 18 2025 16:12:41
Script end

Main resources:

Total runtime	0.7884 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.1563	152.6406
Module start 'layout'	0.0058	0.0027	741.7969	39.4766
Module start 'content'	0.0085	0.7784	781.2734	535.8984
Module end 'content'	0.7869	0.0015	1,317.1719	12.1250
Script end	0.7884		1,329.2969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.4328	16	0.0002
Check MTime	0.0013	0.1694	16	0.0001
Mysql Total
Database connection	0.0010	0.1306	1	0.0010
Mysqli_queries	0.7391	93.7452	57	0.0130
Looping result	0.0006	0.0745	55	0.0000
Template Total	0.7556	95.8	2	0.3778
Template load	0.0021	0.2648	2	0.0010
Template processing	0.7535	95.5649	2	0.3767
Template load and register function	0.0002	0.0289	1	0.0002
states
state_id_array	0.0009	0.1171	1	0.0009
state_identifier_array	0.0014	0.1831	2	0.0007
Override
Cache load	0.0017	0.2144	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0013	0.1625	2	0.0006
Fetch class attribute name	0.0009	0.1203	4	0.0002
XML
Image XML parsing	0.0007	0.0898	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0012	4	0.0000
General
dbfile	0.0008	0.0996	18	0.0000
String conversion	0.0001	0.0160	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs