This topic is locked
[SOLVED]

 Google maps display several records

3/18/2012 1:38:01 AM
PHPRunner General questions
M
Mexicomike author

I love PHPRunner and want to come back to it. I strayed from the faith and dallied with another program that came out with a Google maps feature before this update. I wish to repent and come back to the flock. But I need some guidance.
I saw a discussion about this back in January, but did not see or understand the resolution. I have a database of 57 (and growing to 100+) locations I want to show on a map of Mexico. Using another program, I was able to show an overview of the country with all the locations marked. Then the customer could search by area or specific type of location to show only the region he was interested in. When he clicked on any marker, it showed details in a separate column.
Right now, i can show individual maps for my items, but no master map. Can this be done?
Also, i want to be able to programatically change the icon. I searched the Internet and did not see a solution that made sense to me. What i was able to do in the other program (and i really want phprunner to replace it) was to assign a .png or .jpg image of my choosing to each category. Hotels = picture 1. RV parks = picture 2 and so on. Any ideas?
Thank you.

C
cgphp 3/18/2012

You need some manual coding. Check this article for inspiration: https://developers.google.com/maps/articles/phpsqlajax

M
Mexicomike author 3/18/2012

Thanks, Christian. That is certainly inspiring, if a little daunting. Not sure I am up to the task, but as least now i know that this is not something done easilly in PHPRunner. Thank you.

Sergey Kornilov admin 3/18/2012
M
Mexicomike author 3/19/2012

Thanks, Sergey. That is what i used initially to create the map, but i did not get the multiple icons on my map. What did i miss in the help file that mentions multiple icons? Thank you very much.

M
Mexicomike author 3/23/2012

Thanks. Sergey. But what is different about that app than the instructions? I mean what do I do / code in order for the multiple icons to appear? That is the crux of my problem.
And another issue is - is there another way than Christian's suggestion to make the icons show for different conditions?

Data Type=Swimming - Icon=Swimming Pool.

Data Type=Diving - Icon=Diving man

and so on.
Thank you.
There is no doubt that PHPRunner is great, I just am having trouble with this particular item. I have been an owner for years.

Sergey Kornilov admin 3/23/2012

Check this article:

http://xlinesoft.com/phprunner/docs/insert_google_map.htm
I explains what exactly you need to do in order to display a Google map with multiple icons. This is a built-in feature.

M
Mexicomike author 3/23/2012

Sergey,
As I said before. I followed the instructions on the page link you sent me. I do not get a big overview map at all. What i get is the small maps for each individual record. I must be really having a hard time explaining what is wrong because we keep going back to this page. Please help me with some details on what i could be doing wrong to not get the big overview map. If i can't at least get a nudge in the right direction to solve this, i can't use PHPRunner to create my project. I don't expect you to build the project for me, but if the feature is built-in as you say, why will it not work? What could be wrong? That is all I ask.
Also, i asked again is there another way to make the maps programable? I gave the example in my last post:
Is there another way than Christian's suggestion to make the icons show for different conditions?

Data Type=Swimming - Icon=Swimming Pool.

Data Type=Diving - Icon=Diving man

and so on.

Sergey Kornilov admin 3/23/2012

I guess you need to provide more details on what you doing and what results you getting. Since this article explains how to to insert a large map and you are getting maps for each records - that means you are doing something different.
Provide a few screenshots that explain what you doing.
In regards to displaying different icons - PHPRunner doesn't support that. You definitely can program this on you own.

M
Mexicomike author 3/23/2012

Thanks, Sergey,
I kept dogging at it and found my error. The instructions say to click anywhere on the page and insert the large map. Well, that is not technically true. I found that if i inserted it at the very top of the page (below the message placeholder), it would not work. However, if i inserted it in the bar with Details found etc., it showed up. That was what was driving me nuts. So it might help someone else who reads the instructions literally to clarify that if you want.
OK a last qestion on the topic. i have two large maps now for different views. One works great. Big map is centered in Mexico where all my markers are. The other keeps centering on Ghana, although all the records in the set are in Mexico and show correctly. Does this make any sense to you? A common error?

Sergey Kornilov admin 3/23/2012

This doesn't sound right. Probably one or more addresses are incorrect and Google is having trouble placing all markers together.

M
Mexicomike author 3/24/2012

Thanks, that is logical. I will go through all the records again and see if i can find the error. I will be purchasing my update in a few minutes. Thanks for your attention.
Actually, i am now trying to figure out if i need the Enterprise version, so it may be a day or so before i upgrade to one or the other. Thanks.