urlencode($QUERY_STRING) in DB_Drill (example for FusionMaps_trial)

[uman]

Hi,

 

 

 

I get trying the example of FusionMaps names "DB_Drill"...but I get "Msg error" about "Detailled.php" page like this:

 

 

 

"Notice: Undefined variable: QUERY_STRING in C:wampwwwSUPER MANAGER 3.0adminDetailed.php on line 105"

 

 

 

Can somebody helps me?

 

 

 

Many thanks

[FusionCharts Support]

Hi,

 

 

 

In case you are facing any issue with $QUERY_STRING you can replace all $QUERY_STRING with $_SERVER['QUERY_STRING'].

[uman]

Hi,

 

 

 

$_SERVER['QUERY_STRING'] works!

 

 

 

Thank you very much.

 

 

 

So long..

[Sanjukta]

Hi Uman,

You are welcome.

Glad that your issue is resolved.

Happy FusionChartimg!

[uman]

Hi,

 

 

 

I'm sure I often will coming back here because:

 

- I'm just starting FusionChats and FusionMaps..

 

- ..Your "community" seems to be very nice!

 

 

 

These tools are very powerful to be used as "decision help objective". I'll try to have more time to explore them step by step (I'm very busy with job!).

 

I'm using some of the samples (described onto the documentation) for my actual project.

 

My difficulty, now, is to make "custom maps" to link to a master map. I don't know how to begin. I'm searching across the web...

 

 

 

So thank you for all.

 

 

 

(Sorry for my "poor english". I'm best in french)

[Guest Basundhara Ghosal]

Hi Uman,

Thanks to you for your wonderful appreciation.

My difficulty, now, is to make "custom maps" to link to a master map. I don't know how to begin. I'm searching across the web...

Could you please try using the Drill-Down feature for the same?

Ref.- http://www.fusioncharts.com/maps/docs/Contents/DrillDown/Simple.html

http://www.fusioncharts.com/maps/docs/Contents/DrillDown/Frames.html

http://www.fusioncharts.com/maps/docs/Contents/DrillDown/PopUps.html

http://www.fusioncharts.com/maps/docs/Contents/DrillDown/ClickURL.html

http://www.fusioncharts.com/maps/docs/Contents/DrillDown/JavaScript.html

I hope this helps.

Please feel free to revert to us in case you have any further queries.

[uman]

Hi B. G.,

 

 

 

Many thanks for the detailed links. I'm sure they'll help me later.

 

 

 

The "problem", now, is about "costuming own maps"!

 

I mean:

 

1- I have a master map with towns (included into fusionMaps application. Folder: "Maps")

 

2- When I click on a "town", I hope showing the "town" (as a new map)...onto a new (or the same) page or window.

 

3- Each town is showing with specific informations from a mysql table (for example!)

 

 

 

So, I have, first, to make the maps of the towns....!

 

 

 

How to do it? How to start....

 

 

 

PS. There is an example with only a USA map!!

Edited July 23, 2010 by Guest

[Guest Basundhara Ghosal]

Hi Uman,

Thanks for your appreciation.

In case you wish to build up new maps, you need to assemble :-

1. The SWF File of the map

[uman]

Hi Basundhara Ghosal

 

 

 

Thank you for the informations.

Edited July 23, 2010 by Guest

[Guest Basundhara Ghosal]

Hi,

You are most welcome.

Keep smiling and keep FusionCharting.

[uman]

Hi Basundhara Ghosal

 

 

 

I tried this line:

 

$strQuery = "select a.Internal_Id,a.entity_id,b.group_name,c.subgroup_name,sum(a.data) datap from fcmap_distribution a, fcmap_group_master b, fcmap_subgroup_master c where a.group_id=b.group_id and a.subgroup_id=c.subgroup_id group by a.Internal_Id,a.entity_id,b.group_name,c.subgroup_name having a.Internal_Id='" . $_REQUEST['Internal_Id'] . "' and a.entity_id='" . $_REQUEST['entity_id'] . "' and b.group_name='" . $ors1['group_name'] . "'";

 

 

 

And I got this "error":

 

Notice: Undefined index: Internal_Id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

Notice: Undefined index: entity_id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

Notice: Undefined index: Internal_Id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

Notice: Undefined index: entity_id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

Notice: Undefined index: Internal_Id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

Notice: Undefined index: entity_id in C:wampwwwSUPER MANAGER 3.0adminCharts.php on line 106

 

 

 

Would you please help me?

Edited July 23, 2010 by Guest

[Ayan Pal]

Hi Uman,

please check that you have passed values as Internal_Id and entity_id  to the page using GET or POST methode

[uman]

Hi Ayan Pal

 

 

 

I'm using these pages: (from download package -> Folder: Code/PHP/DB_Drll)

 

- Default.php

 

- Detailed.php

 

- Charts.php

 

 

 

There is no GET or POST method.

 

 

 

Thank you to help me.

Edited July 23, 2010 by Guest

[Ayan Pal]

Hi Uman,

to see this examples please do the below steps

1 add dummy sql data [provided in the download package ( folder name -'db')]

2 configure DBConn.php as per your settings for database

3 set charts' paths in all the three pages as per your local folders

3 open default.php then click on a map area which will open detailed.php with a supplied query_string

4 again click on a map area on detailed.php which will open chart.php  with a supplied query_string

below is an example of the chart.php with query_string

http://localhost/2010/FusionMaps_Trial/Code/php/DB_Drill/Charts.php?Internal_Id=WY&map=FCMap_Wyoming.swf&entity_id=019

this bold text is the supplied query_string using GET method

[uman]

Hi Ayan Pal

 

 

 

All works good now!

 

Thank you very much!

[Sanjukta]

Hi Uman,

You are always welcome.

Glad that your issue is resolved.

Happy FusionCharting!