Forums / General / Storing cities of a country in a dropdown box

Storing cities of a country in a dropdown box

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

eZ debug

Timing: Jan 19 2025 00:11:18
Script start
Timing: Jan 19 2025 00:11:19
Module start 'content'
Timing: Jan 19 2025 00:11:19
Module end 'content'
Timing: Jan 19 2025 00:11:19
Script end

Main resources:

Total runtime0.2640 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0120 588.9688180.8203
Module start 'content' 0.01200.0232 769.789193.8984
Module end 'content' 0.03530.2287 863.6875522.3750
Script end 0.2640  1,386.0625 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00381.4330200.0002
Check MTime0.00150.5560200.0001
Mysql Total
Database connection0.00160.620010.0016
Mysqli_queries0.177567.23661410.0013
Looping result0.00170.64211390.0000
Template Total0.228186.410.2281
Template load0.00110.423810.0011
Template processing0.226985.946110.2269
Override
Cache load0.00060.214710.0006
Sytem overhead
Fetch class attribute can translate value0.00140.542010.0014
XML
Image XML parsing0.00030.100310.0003
General
dbfile0.01937.3271200.0010
String conversion0.00000.002630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs