|
JavaScript - Question About Insert Query Of Google Fusion Table Implement By Javascript
Can anyone give me some advice on how to manipulate Google Fusion Table using Javascript??? I've read the Fusion table's Developer Guider. But still feel confused.
Can anyone tell me the specific solution?? Or give me a sample code?? Thanks very much!!!!!! Similar TutorialsHey, I have a location lookup tool that pulls data from a Google Fusion table. User's type their address in and it drops a pin and info window at the place / result that matches their location. It works great with one location, but now I need it to display multiple results / drop multiple pins if they match the criteria Here's the working code that drops one pin (sorry it's a lot): Code: google.load('visualization', '1', {'packages':['corechart', 'table', 'geomap']});
var FusionTableID = 'tableid';
var map = null;
var geocoder = null;
var infowindow = null;
var marker = null;
function initialize() {
geocoder = new google.maps.Geocoder();
infowindow = new google.maps.InfoWindow({size: new google.maps.Size(150,50) });
// create the map
var myOptions = {
zoom: 7,
center: new google.maps.LatLng(41.9908, -93.4208),
mapTypeControl: true,
mapTypeControlOptions: {style: google.maps.MapTypeControlStyle.DROPDOWN_MENU},
navigationControl: true,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
map = new google.maps.Map(document.getElementById("map_canvas"),
myOptions);
layer = new google.maps.FusionTablesLayer({
query: {from:FusionTableID},
styles: [{
polygonOptions: {
fillColor:'#000000',
fillOpacity: 0.01,
strokeColor:'#000000',
strokeOpacity: 0.01
}
}],
suppressInfoWindows:true
});
layer.setMap(map);
google.maps.event.addListener(layer, "click", function(e) {
var content = "<b>"+e.row['name'].value+"</b>";
infowindow.setContent(content);
infowindow.setPosition(locationgeocode);
infowindow.open(map);
});
document.getElementById('submit').onclick = function() {
document.getElementById("submit").value = "Searching";
};
}
function showAddress(address) {
var contentString = address+"<br>Outside Area";
geocoder.geocode( { 'address': address}, function(results, status) {
if (status == google.maps.GeocoderStatus.OK) {
var point = results[0].geometry.location;
contentString += "<br>";
// query FT for data
var queryText ="SELECT 'County', 'Name', 'Location Name', 'Location Address', 'Location City', 'Location State', 'Location Zip', 'geocode' FROM "+FusionTableID+" WHERE ST_INTERSECTS(\'geometry\', CIRCLE(LATLNG(" + point.toUrlValue(6) + "),0.01));";
// document.getElementById('FTQuery').innerHTML = queryText;
queryText = encodeURIComponent(queryText);
var query = new google.visualization.Query('http://www.google.com/fusiontables/gvizdata?tq=' + queryText);
//set the callback function
query.send(openInfoWindowOnMarker);
} else {
alert("Geocode was not successful for the following reason: " + status);
}
});
}
function openInfoWindowOnMarker(response) {
if (!response) {
alert('no response');
return;
}
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
FTresponse = response;
//for more information on the response object, see the documentation
//http://code.google.com/apis/visualization/documentation/reference.html#QueryResponse
numRows = response.getDataTable().getNumberOfRows();
numCols = response.getDataTable().getNumberOfColumns();
var content = "<b>Outside of Iowa</b><!--";
var unionBounds = null;
// alert(numRows);
for (var i=0; i < numRows; i++) {
var county = FTresponse.getDataTable().getValue(i,0);
var precinct = FTresponse.getDataTable().getValue(i,1);
var locationname = FTresponse.getDataTable().getValue(i,2);
var locationaddress = FTresponse.getDataTable().getValue(i,3);
var locationcity = FTresponse.getDataTable().getValue(i,4);
var locationstate = FTresponse.getDataTable().getValue(i,5);
var locationzip = FTresponse.getDataTable().getValue(i,6);
var locationgeocode = FTresponse.getDataTable().getValue(i,7);
// var kml = FTresponse.getDataTable().getValue(i,1);
// create a geoXml3 parser for the click handlers
content = "<b>"+locationname+"</b><br />"+locationaddress+"<br />"+locationcity+locationstate+" "+locationzip+"<br/><a href='http://maps.google.com/maps?daddr="+locationaddress+" "+locationcity+" IA "+locationzip+"' target='_blank' >Click here for Directions</a><br /></br></p><!--";
/*
var geoXml = new geoXML3.parser({
map: map,
zoom: false
});
// alert(kml);
geoXml.parseKmlString("<Placemark>"+kml+"<\/Placemark>");
geoXml.docs[0].gpolygons[0].setMap(null);
if (!unionBounds) unionBounds = geoXml.docs[0].gpolygons[0].bounds;
else unionBounds.union(geoXml.docs[0].gpolygons[0].bounds);
*/
}
// zoom to the bounds
// map.fitBounds(unionBounds);
setTimeout(function() {
google.maps.event.addListener(marker, 'click', function() {
infowindow.open(map,marker);
});
infowindow.setContent(content+marker.getPosition().toUrlValue(6));
google.maps.event.trigger(marker, 'click');
document.getElementById("submit").value = "Search";
}, 150);
geocoder.geocode( { 'address': locationaddress+","+locationcity+locationstate+" "+locationzip}, function(results, status) {
if (status == google.maps.GeocoderStatus.OK) {
var point = results[0].geometry.location;
map.setCenter(point);
map.setZoom(12);
if (marker && marker.setMap) marker.setMap(null);
marker = new google.maps.Marker({
map: map,
position: point
});
};
});
}
I basically need it to drop multiple pins if multiple queries match var queryText ="SELECT 'County', 'Name', 'Location Name', 'Location Address', 'Location City', 'Location State', 'Location Zip', 'Hours', 'geocode' FROM "+FusionTableID+" WHERE ST_INTERSECTS(\'geometry\', CIRCLE(LATLNG(" + point.toUrlValue(6) + "),0.01));"; Any thoughts, fixes, or even a point in the right direction would be incredibly helpful. I'm really stuck on this one and have been trying at it for a couple of days now. Even something like getting it to print a second query that I can mark in the table as a second location would be helpful. Something like a second pin that matches: Code: var queryText2 ="SELECT 'County', 'Name', 'Location Name', 'Location Address', 'Location City', 'Location State', 'Location Zip', 'Hours', 'geocode' FROM "+FusionTableID+" WHERE ST_INTERSECTS(\'geometry\', CIRCLE(LATLNG(" + point.toUrlValue(6) + "),0.01)); AND locationname = 'Location 2'";
Thanks!! Hi all, I'm desperately trying to figure out how to "transform" Javascript commands into HTML code. Excuse my noobness but I really know nothing about Javascript. Basically, I have this Google API Search code: Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>My Google AJAX Search API Application</title>
<script src="http://www.google.com/jsapi?key=CUT"></script>
<script language="Javascript" type="text/javascript">
//<![CDATA[
google.load("search", "1");
function OnLoad() {
// Create a search control
var searchControl = new google.search.SearchControl();
// Add in a full set of searchers
var localSearch = new google.search.LocalSearch();
searchControl.addSearcher(localSearch);
searchControl.addSearcher(new google.search.WebSearch());
searchControl.addSearcher(new google.search.VideoSearch());
searchControl.addSearcher(new google.search.BlogSearch());
// Set the Local Search center point
localSearch.setCenterPoint("New York, NY");
// Tell the searcher to draw itself and tell it where to attach
searchControl.draw(document.getElementById("searchcontrol"));
// Execute an inital search
searchControl.execute("Google");
}
google.setOnLoadCallback(OnLoad);
//]]>
</script>
</head>
<body>
<div id="searchcontrol">Loading...</div>
</body>
</html>
Now, what I'm desperately trying to do since 4-5 hours is to have the search results between the <div id="searchcontrol"></div> encoded as HTML in the loaded page. Currently, when the page is loaded and I look at the source code, I have the word 'Loading...' in the <div> tags, despite in the normal view there are G results listed. I need those results encoded as HTML for SEO reasons. Researching on this matter I thought the problem could be the OnLoad command, that makes the script load after all the other HTML elements are loaded. But I tried to make it load before all the elements in the page, and the problem persists. How can I solve this? Thanks in advance for any help! I have noooo idea if I am even posting this in the correct area, let alone the correct site. If not I apologize and maybe someone could direct me elsewhere. I am trying to add a custom search into my site. http://www.jeffknowsloans.com you can see it about the middle of the page. I am using the following script to do so. Code: <script type="text/javascript">
function dosearch() {
var sf=document.searchform;
var submitto = sf.sengines.options[sf.sengines.selectedIndex].value + escape(sf.searchterms.value);
window.location.href = submitto;
return false;
}
</script>
<form name="searchform" onSubmit="return dosearch();">
Select County
<select name="sengines">
<option value="http://www2.co.washington.mn.us/opip/mod/addresssrch/result.asp?housenum=&street=" selected>Washington</option>
<option value="http://rrinfo.co.ramsey.mn.us/public/characteristic/PropertySearchResults.aspx?pin=&Nbr=&Street=&pg=1" selected>Ramsey</option>
<option value="http://www.altavista.com/web/results?q=">Alta Vista</option>
<option value="http://www.dogpile.com/info.dogpl/search/web/">Dogpile</option>
</select>
Street Address:
<input type="text" name="searchterms">
<input type="submit" name="SearchSubmit" value="Search">
</form>
here is the problem i am running into. I dont know how to ignore or add certain parts of the search when it sends. for example. take a look at Code: <option value="http://rrinfo.co.ramsey.mn.us/public/characteristic/PropertySearchResults.aspx?pin=&Nbr=&Street=&pg=1" selected>Ramsey</option> When i try to do a search under this drop down selection it doesnt work. because it needs the &pg=1 to be added to the users search request. Meaning if I set it to Code: http://rrinfo.co.ramsey.mn.us/public/characteristic/PropertySearchResults.aspx?pin=&Nbr=&Street= they type in their street name and the street name inputs into the search query but it wont fully work because it doesnt add the &pg=1 after it all. how in the world do I get it to add things like that? ie how do i tell it to add certain strings that the outside source requires? like blank=&blank= or how do i get it to ignore certain &blank= commands. another example taking a look at Code: <option value="http://www2.co.washington.mn.us/opip/mod/addresssrch/result.asp?housenum=&street=" selected>Washington</option> this search function should technically be Code: <option value="http://www2.co.washington.mn.us/opip/mod/addresssrch/result.asp?" selected>Washington</option> however since i dont know how to add certain functions to the search i have to skip the housenum option. that means my customers cant search by street number. I want them to be able to type in their house number and their street address and it will change to what each seperate (outside) search engine needs. Does this make any sense at all? Hi, I have been trying to create a google graph from an input combobox but I'm having trouble passing the variable to the query on the spreadsheeet. The graph is able to query the spreadsheet when I don't use a varible, and my combobox is recieveing the variable but I'm having trouble connecting the two. The code I'm trying to use is below and I also attached a text file, so any help would be so fantastic! This is the code I have for it: Code: <!-- try 1 Rivas, try 2 San jose
You are free to copy and use this sample in accordance with the terms of the
Apache license (http://www.apache.org/licenses/LICENSE-2.0.html)
-->
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>
Google Visualization API Sample
</title>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['linechart']});
</script><script src="http://www.google.com/uds/?file=visualization&v=1&packages=linechart" type="text/javascript"></script><script src="http://www.google.com/uds/api/visualization/1.0/3dc85ad905db9d2ce85ec8d8389c32d5/default,browserchart,linechart.I.js" type="text/javascript"></script>
<script type="text/javascript">
function storeValue(obj){
if(obj.selectedIndex == 0){return;}
var MonthChosen = obj.value;
alert('You chose: '+ MonthChosen);
}
window.onload = function(){
document.getElementsByName('combo1')[0].onchange=function(){storeValue(this);}
}
var visualization;
function drawVisualization() {
// To see the data that this visualization uses, browse to
// http://spreadsheets.google.com/ccc?key=pCQbetd-CptGXxxQIG7VFIQ
var query = new google.visualization.Query(
'https://spreadsheets.google.com/ccc?key=0Ais9xMj35wQmdDBTMUxHRS1CRHVkcGI4dnZ0c2xLZXc&hl=en');
// Apply query language.
query.setQuery('SELECT H WHERE E ="MonthChosen" ORDER BY F');
// Send the query with a callback function.
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
var data = response.getDataTable();
visualization = new google.visualization.LineChart(document.getElementById('visualization'));
visualization.draw(data, {legend: 'bottom'});
}
google.setOnLoadCallback(drawVisualization);
</script>
<h2> What month would you like to see the 10 year comparative data from?</h2>
<form>
<table>
<tbody><tr>
<td>Combo Box</td>
<td>
<select id="combo1" name="combo1" onchange="input1.value = combo1.value">
<option value="’1’">January</option>
<option value="’2’">February</option>
<option value="’3’">March</option>
<option value="’4’">April</option>
<option value="’5’">May </option>
<option value="’6’">June </option>
<option value="’7’"> July</option>
<option value="’8’">August </option>
<option value="’9’">September </option>
<option value="’10’">October </option>
<option value="’11’">November </option>
<option value="’12’">December </option>
</select>
</td>
</tr>
<tr>
<td>Input Box</td>
</tr>
</tbody></table>
</form>
<div id="visualization" style="height: 400px; width: 400px;"></div>
Hello all i have to implement simple LIFO algorithm ( if i can call it like this .. ) say i have html table and and i fetching data i like thet the last data that fetched to be the first record in the table for example : im fetching the string "111" so it will be the first record next im fetching the string "222" now the string "111" will be the second and the string "222" will be the first .. and so on Hi there! I'm creating a map that starts at the users location, has multiple locations marked out (that are fetched from JSON), tells if the person is withing a 100m range of the location and shows an overlay when a location is clicked on. Is this even possible? (doesn't feel like it atm ) and if it's possible, which parts of google's api do I use? If anyone has far to much spare time and feels like showing me how to do 1/2 of these things I would be extremley grateful, but I don't expect that. Cheers. hi, I am working on adding a datepicker on each row of the table grid using javascript . I have a done like below. Code: oCell.innerHTML = "<input type='text' name='DateTime' id='DateTime' size='18' class='maincontent1'>
<a href=javascript:NewCssCal('DateTime','yyyymmdd','arrow',true,24,false);><img src='images/cal.gif' width='16' height='16' border='0'alt='Pick a date'> </a> ";
Code: oCell = newRow.insertCell(); Is this correct way? with the above code , cursor control pointing to previous textbox not the current one. can anyone help me? thanks Hi to All, I have this problem: I' dl ike that, if one clicks a button, appear window_explorer in which it' s possible to choose an image that it will put in the specific td of the table. <head> <script> function add_pic() { document.forms[0].pic.value == code to choose image ... } </script> </head> <body> <form method="POST" name="FrontPage_Form1"> ... <table> <tr><td><button onClick="add_pic()">Insert Statitistic map</button></td></tr> <tr><td>Comments</td></tr> <tr><td id="pic" name="pic"> PLACE IN WHICH IMAGE APPEAR </td></tr> </table> ... </body> Thanks in advance !!! P.S. I use IE6 and Windows XP Hi I make a query to a database, normally it gives back a 0, now I want that the script keeps in touch with the database till the row gives back one. Till now I made it with a setInterval and went through the function again and again, but I think it's not really good for the database. Can't the function wait in the query till comes back a 1 and then doing something? Here is what I got so far: Quote: function latestCheckFB() { var query = FB.Data.query('SELECT uid FROM page_fan WHERE page_id = 164524456919432 AND uid = 100001762758708'); query.wait(function (rows) { if (rows.length > 0) { // like found var msg = "you like it"; $("#halloA").text(msg); }else{ var msg = "you do not like it"; $("#halloA").text(msg); } }); } setInterval(function() { latestCheckFB(); }, 100); hello all, what i would like to implement is the following : http://mon.grnet.gr/network/maps/lite/?load&ip but, the problem is that, although the numerical data that show the traffic volume passing through a link are available to me, i do not have clue on how i can display them onto the map ... ? i would be thankful, if you could give me a piece of advice. Hey all, I was wondering if someone would be able to help me with a problem I've been having. I'm attempting to find coordinates for several addresses at a time. I'm using a for-loop to loop through an array of addresses. I figured it would be best to have a separate function to evaluate the coordinate given an address, and just call it in every loop. Note that my code below is simplified (I removed the for loop because that's not where I'm having trouble). I know that the issue is probably because I'm trying to return a value from an anonymous function... I tried making the variable global, I tried having a return line from within the anonymous function, nothing has worked... any tips? Thanks -- Code follows Code: function initialize(){
var geocoder = new google.maps.Geocoder(); // creating a new geocode object
var locCood = findcood('44106', geocoder);
}
function findcood(addr, geocoder)
{
var cood;
if (geocoder) {
geocoder.geocode({'address': addr}, function(results, status, cood){
if (status == google.maps.GeocoderStatus.OK)
cood = results[0].geometry.location;
else {
cood = null;
alert("Geocode was not successful for the following reason: " + status);
}
});
}
else
{
alert("No Geocode");
cood = null;
}
alert(cood);
return cood;
}
http://www.cricketcoachingclinics.com.au/ I am having a problem with site in IE7 this is identified as a problem?? Can someone at least rule out this js error? This is js generated when adding google maps Error Class is not defined <CODE>var GoogleMap=Class.create(Widget,{widgetIdentifier:"com-apple-iweb-widget-GoogleMap",initialize:function($super,instanceID,widgetPath,sharedPath,sitePath,preferences,runningI nApp) {if(instanceID){$super(instanceID,widgetPath,sharedPath,sitePath,preferences,runningInApp);}},mapReq uestTemplate:'center=#{center}&zoomLevel=#{zoomLevel}&showZoom=#{showZoom}&mapType=#{mapType}&locate dAddress=#{locatedAddress}&locatedAddressPoint=#{locatedAddressPoint}&showInfo=#{showInfo}&language= #{language}&showGoogleBar=#{showGoogleBar}',iframeTemplate:'<iframe id="#{instanceID}-iframe" name="#{instanceID}-iframe" src="#{mapURL}?#{mapRequest}" width="100%" height="100%" scrolling="no" marginheight="0" marginwidth="0" frameborder="0"></iframe>',mapURL:'http://www.me.com/st/1/sharedassets/maps/iweb2/',onload:function() {var mapRequestTemplate=new Template(this.mapRequestTemplate);var mapRequest=mapRequestTemplate.evaluate({center:this.escapedPreferenceForKey("center"),zoomLevel:this .escapedPreferenceForKey("zoomLevel"),showZoom:this.escapedPreferenceForKey("showZoom"),mapType:this .escapedPreferenceForKey("mapType"),locatedAddress:this.escapedPreferenceForKey("locatedAddress"),lo catedAddressPoint:this.escapedPreferenceForKey("locatedAddressPoint"),showInfo:this.escapedPreferenc eForKey("showInfo"),language:this.escapedPreferenceForKey("language"),showGoogleBar:this.escapedPref erenceForKey("showGoogleBar")});var iframeTemplate=new Template(this.iframeTemplate);var iframeText=iframeTemplate.evaluate({instanceID:this.instanceID,mapRequest:mapRequest,mapURL:this.map URL});this.div().innerHTML=iframeText;if(this.preferences&&this.preferences.postNotification) this.preferences.postNotification("BLWidgetIsSafeToDrawNotification",1);},escapedPreferenceForKey:fu nction(key) {var value=this.preferenceForKey(key);if(value!==undefined) value=encodeURIComponent(value);return value;}});</CODE> I have a working script and I want to add a toogleGroup command (which I have) to the end of the working script so that I can toggle map markers with radio buttons. Probably a simple addition. WORKING CODE: Code: //<![CDATA[
var iconPink = new GIcon();
iconPink.image = 'http://www.golfinggreys.com/img/ggmap_icon_attraction.png';
iconPink.shadow = '';
iconPink.iconSize = new GSize(24, 31);
iconPink.shadowSize = new GSize(0, 0);
iconPink.iconAnchor = new GPoint(11, 30);
iconPink.infoWindowAnchor = new GPoint(5, 1);
var iconOrange = new GIcon();
iconOrange.image = 'http://www.golfinggreys.com/img/ggmap_icon_accomm.png';
iconOrange.shadow = '';
iconOrange.iconSize = new GSize(24, 31);
iconOrange.shadowSize = new GSize(0, 0);
iconOrange.iconAnchor = new GPoint(11, 30);
iconOrange.infoWindowAnchor = new GPoint(5, 1);
var iconPurple = new GIcon();
iconPurple.image = 'http://www.golfinggreys.com/img/ggmap_icon_dining.png';
iconPurple.shadow = '';
iconPurple.iconSize = new GSize(24, 31);
iconPurple.shadowSize = new GSize(0, 0);
iconPurple.iconAnchor = new GPoint(11, 30);
iconPurple.infoWindowAnchor = new GPoint(5, 1);
var iconGreen = new GIcon();
iconGreen.image = 'http://www.golfinggreys.com/img/ggmap_icon_golf.png';
iconGreen.shadow = '';
iconGreen.iconSize = new GSize(24, 31);
iconGreen.shadowSize = new GSize(0, 0);
iconGreen.iconAnchor = new GPoint(11, 30);
iconGreen.infoWindowAnchor = new GPoint(5, 1);
var iconRed = new GIcon();
iconRed.image = 'http://www.golfinggreys.com/img/ggmap_icon_golfr.png';
iconRed.shadow = '';
iconRed.iconSize = new GSize(24, 31);
iconRed.shadowSize = new GSize(0, 0);
iconRed.iconAnchor = new GPoint(11, 30);
iconRed.infoWindowAnchor = new GPoint(5, 1);
var iconGrey = new GIcon();
iconGrey.image = 'http://www.golfinggreys.com/img/ggmap_icon_services.png';
iconGrey.shadow = '';
iconGrey.iconSize = new GSize(24, 31);
iconGrey.shadowSize = new GSize(0, 0);
iconGrey.iconAnchor = new GPoint(11, 30);
iconGrey.infoWindowAnchor = new GPoint(5, 1);
var iconBlue = new GIcon();
iconBlue.image = 'http://www.golfinggreys.com/img/ggmap_icon_shopping.png';
iconBlue.shadow = '';
iconBlue.iconSize = new GSize(24, 31);
iconBlue.shadowSize = new GSize(0, 0);
iconBlue.iconAnchor = new GPoint(11, 30);
iconBlue.infoWindowAnchor = new GPoint(5, 1);
var customIcons = [];
customIcons["attraction"] = iconPink;
customIcons["accomm"] = iconOrange;
customIcons["dining"] = iconPurple;
customIcons["golf"] = iconGreen;
customIcons["golfr"] = iconRed;
customIcons["services"] = iconGrey;
customIcons["shopping"] = iconBlue;
var markerGroups = { "attraction": [], "accomm": [], "dining": [], "golf": [], "golfr": [], "services": [], "shopping": []};
function load() {
if (GBrowserIsCompatible()) {
var i = 0;
// Create the map
// Make sure this element has the same ID as your div
map = new GMap2(document.getElementById("googlemap"));
// Add controls for moving and zooming the map. Use GSmallMapControl for small maps
map.addControl(new GSmallMapControl());
// Add controls for switching between regular and satellite views
map.addControl(new GMapTypeControl());
// Set the starting position and zoom level when the map loads
map.setCenter(new GLatLng(51.920556,-103.798828), 7);
// Read the data from XML
var request = GXmlHttp.create();
// Open the XML file
request.open("GET", "east_central.xml", true);
request.onreadystatechange = function() {
if (request.readyState == 4) {
var xmlDoc = request.responseXML;
// Obtain the array of markers and loop through it
var markers = xmlDoc.documentElement.getElementsByTagName("marker");
for (var i = 0; i < markers.length; i++) {
// Obtain the attribues of each marker
var lat = parseFloat(markers[i].getAttribute("lat"));
var lng = parseFloat(markers[i].getAttribute("lng"));
var point = new GLatLng(lat,lng);
var name = markers[i].getAttribute("name");
var phone = markers[i].getAttribute("phone");
var address = markers[i].getAttribute("address");
var city = markers[i].getAttribute("city");
var state = markers[i].getAttribute("state");
var url = markers[i].getAttribute("url");
var type = markers[i].getAttribute("type");
var marker = createMarker(point,name,phone,address,city,state,url,type);
map.addOverlay(marker);
}
}
}
request.send(null);
// Function to create the marker and set up the event window
function createMarker(point,name,phone,address,city,state,url,type) {
var marker = new GMarker(point, customIcons[type]);
markerGroups[type].push(marker);
var markerhtml = "";
if (name != "") markerhtml += "<b>" + name + "</b><br>";
markerhtml += address + ", " + city + ", " + state + "<br>";
if (phone != "") markerhtml += "p:" + phone + "<br>";
if (url != "") markerhtml += "<a href=\"" + url + "\">COURSE DETAILS</a>";
// Add a click event to each marker which will open the HTML window
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowHtml(markerhtml);
});
i++;
return marker;
}
}
// Javascript alert for older browsers where Google Maps isn't supported
else {
alert("Sorry, the Google Maps API is not compatible with this browser");
}
}
//]]>
THE ADDITION Code: function toggleGroup(type) {
for (var i = 0; i < markerGroups[type].length; i++) {
var marker = markerGroups[type][i];
if (marker.isHidden()) {
marker.show();
} else {
marker.hide();
}
Just need to properly add that to the end. I am okay at editing and adapting codes, but I don't know the sytax. Tried JSLINT but still confused. Probably quite simple. Thanks Hi, i have 1 site with three different brands (three ID numbers). I have made a javascript if-statement but it doesnt work. Somebody see some wrong here, I think it should work properly. Thanks in advance $language and $brand is set... <script type="text/javascript"> var accountId; var url; if($language == 'test') { if($brand = '1') { accountId = 'UA-xxxxx-1' url = '1.com' } else if ($brand = '2') { accountId = 'UA-xxxxx-2' url = '2.com' } else if ($brand = '3') { accountId = 'UA-xxxxx-3' url = '3.com' } var _gaq = _gaq || []; _gaq.push(['_setAccount', accountId]); _gaq.push(['_setDomainName', url]); _gaq.push(['_setAllowLinker', true]); _gaq.push(['_trackPageview', '/' + window.location.host + '/' + window.location.pathname]); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> Hi folks, My website is located he http://maps.peachtree-city.org My search functions point to a mysql database and has been working since June 2008. All of sudden, and I credit my boss to this, it has become dysfunctional with a reoccuring error noted by Firefox: Syntax Error: 0Query was empty. I have a php within the server which pulls from my map file to call upon mysql: From the map.html Code: function submitAddress() {
var address = document.getElementById('address').value;
var searchUrl = 'http://maps.peachtree-city.org/google/parcelpin_genxml2.php?address=' + address;
GDownloadUrl(searchUrl, function(data) {
var xml = GXml.parse(data);
var markers = xml.getElementsByTagName('marker');
if (markers.length == 0)
{
alert('Sorry, no Address matches found. Remember to check your spelling and format.');
return;
}
var address1 = markers[0].getAttribute('address')
var point = new GLatLng(parseFloat(markers[0].getAttribute('lat')),
parseFloat(markers[0].getAttribute('lng')));
if (point && ge != null) {
var la = ge.createLookAt('');
la.set(point.y, point.x, 100, ge.ALTITUDE_RELATIVE_TO_GROUND,
0, 0, 500);
placemark.setName(address);
var point1 = ge.createPoint(address1);
point1.setLatitude(point.y);
point1.setLongitude(point.x);
placemark.setGeometry(point1);
ge.getView().setAbstractView(la);
}
});
}
The form from map.html Code: <center><p style="font-family:arial narrow" "color=green" size="1">Search <strong>Address</strong> Example: 1232 S Hwy 74</font></p></center> <form name='searchform2' id='searchform2' action="javascript:void(0);"> <input type=text size=21 id='address' ></input> <input type=submit button style="background-color:orange" value='Search Address' onClick='javascript:submitAddress();'> <input type=reset button style="background-color:orange" value='Clear Form'> </form> <br> The searchURL (parcelpin_genxml2.php) Code: <?php
require ("phpsql_dbinfo.php");
function parseToXML($htmlStr)
{
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
}
// Opens a connection to a mySQL server
$connection=mysql_connect (localhost, $user, $password);
if (!$connection) {
die('Not connected : ' . mysql_error());
}
// Set the active mySQL database
$db_selected = mysql_select_db('geocode', $connection);
if (!$db_selected) {
die ('Can\'t use db : ' . mysql_error());
}
// Select all the rows in the markers table
$query = "";
if ($address != null) {
$tok = strtok($address, " ");
$count = 0;
$query = "SELECT * FROM address WHERE ";
while ($tok !== false) {
if ($count > 0)
{
$query = $query." and ";
}
$query = $query." address like '%$tok%'";
$tok = strtok(" ");
$count = $count + 1;
}
} else if ($parcelpin != null) {
$query = "SELECT * FROM parcel WHERE parcelpin='$parcelpin'";
}
$result = mysql_query($query);
if (!$result) {
die("Invalid query " + $query . mysql_error());
}
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
// ADD TO XML DOCUMENT NODE
echo '<marker ';
if ($address != null) {
echo 'address="' . $row['address'] . '" ';
} else if ($parcelpin != null) {
echo 'parcelpin="' . $row['parcelpin'] . '" ';
}
echo 'lat="' . $row['lat'] . '" ';
echo 'lng="' . $row['lng'] . '" ';
echo '/>';
}
// End XML file
echo '</markers>';
mysql_close();
?>
I am at a complete lost why the error. Boss says he didn't touch anything but I noticed he did add another table to mysql which led me finding out he also tried installing a CMS , SugarCMS. Upon research on this, I found some mentions of SugarCMS contributing to errors on other mysql databases. Hey Guys, I am building an application that uses Google Maps V3 and currently using JavaScript to show and hide markers. I have two check boxes, they have the same location but show if a user has been there or if they are going there. To hide the markers, I am doing the following function: Code: function hideMarker(location) {
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i].currentLocation == location) {
gmarkers[i].setVisible(false);
}
}
infowindow.close();
}
Problem is, because two markers have the same location, it will hide both. I am passing a been and going value to gmarkers array (gmarkers[i].been etc) so wanted to say something like.. If been is unchecked only hide the been marker. Else if going is unchecked only hide the going marker. Else hide both markers. Anyone have any ideas how I can separate the been and going markers? I can't get my head around the logic Cheers. I started using the Google News Web Element on my website. The website for Google News Web Element is: http://www.google.com/webelements/#!/news I want the links to open in a new window, which cannot be done with the iframe version. Their website only allows me to generate an iframe. I was told that this can be done by using the javascript version, but I have not been able to figure it out. This is their link to the documentation: http://code.google.com/apis/newssearch/newsshow/ I know very little about javascript, and have been trying to get it to work but have been unsuccessful. I want to use the Medium Rectangle size and I want the only topic to be "Swainsboro". The only modification that I want to make is for the links to open in a new window. If anyone can help me do this, it would be appreciated. This is the iframe data that was generated by the wizard: Code: <iframe frameborder=0 marginwidth=0 marginheight=0 border=0 style="border:0;margin:0;width:300px;height:250px;" src="http://www.google.com/uds/modules/elements/newsshow/iframe.html?rsz=large&format=300x250&ned=us&hl=en&q=Swainsboro&element=true" scrolling="no" allowtransparency="true"></iframe> Hi, Not sure where to post this. I currently have a web app which utilises Google Maps & Directions, however some of these maps and directions will be used in pdf creation with tcpdf. The problem arises with the fact that tcpdf doesn't read javascript and therefore cant show the map. Any ideas on what I can do to compensate? My javascript knowledge is -10 out of 10. could someone please show me where to insert this javascript command in my header.php file? Code: <script type="text/javascript">
$('#query').autocomplete({
serviceUrl:'service/autocomplete.ashx',
minChars:2,
delimiter: /(,|;)\s*/, // regex or character
maxHeight:400,
width:300,
deferRequestBy: 0, //miliseconds
params: { country:'Yes' }, //aditional parameters
// callback function:
onSelect: function(value, data){ alert('You selected: ' + value + ', ' + data); },
// local autosugest options:
lookup: ['January', 'February', 'March', 'April', 'May'] //local lookup values
});
</script>
HEADER.PHP file Code: <?php
$timing_start = explode(' ', microtime());
if($PMDR->get('header_file')) {
$header = $PMDR->getNew('Template',PMDROOT.TEMPLATE_PATH.'/'.$PMDR->get('header_file'));
} else {
$header = $PMDR->getNew('Template',PMDROOT.TEMPLATE_PATH.'/header.tpl');
}
// Check for maintenance option and show header message bar if necesarry
if($PMDR->getConfig('maintenance') AND in_array('admin_login',$_SESSION['admin_permissions'])) {
$header->set('maintenance',true);
}
if($PMDR->getConfig('usershare') == 'FacebookConnect') {
$header->set('facebook',true);
}
if($PMDR->get('meta_description')) {
$header->set('meta_description',strip_tags($PMDR->get('meta_description')));
} else {
$header->set('meta_description',$PMDR->getConfig('meta_description_default'));
}
if($PMDR->get('meta_keywords')) {
$header->set('meta_keywords',$PMDR->get('meta_keywords'));
} else {
$header->set('meta_keywords',$PMDR->getConfig('meta_keywords_default'));
}
if($PMDR->getConfig('search_display_all') OR on_page('index.php')) {
$header->set('searchform',$searchform);
$header->set('search_display_all',($PMDR->getConfig('search_display_all') OR on_page('index.php')));
}
$PMDR->loadJavascript($PMDR->getConfig('head_javascript'));
$PMDR->loadJavascript('<script type="text/javascript" src="'.BASE_URL.'/includes/javascript_global.js"></script>');
$PMDR->loadJavascript('<script type="text/javascript" src="'.BASE_URL.TEMPLATE_PATH.'jquery.autocomplete.js"></script>');
$PMDR->loadJavascript('<script type="text/javascript" src="'.BASE_URL.TEMPLATE_PATH.'jquery.js"></script>');
$PMDR->loadJavascript('<script type="text/javascript" src="'.BASE_URL.TEMPLATE_PATH.'jquery.jqtransform.js"></script>');
//if(is_object($xajax)) $javascript .= $xajax->getJavascript(BASE_URL.'/includes/xajax/');
$PMDR->setAdd('javascript_onload','
var headID = document.getElementsByTagName("head")[0];
if(headID) {
var newScript = document.createElement(\'script\');
newScript.type = \'text/javascript\';
newScript.src = \''.BASE_URL.'/cron.php?type=javascript\';
headID.appendChild(newScript);
}
');
if($PMDR->get('javascript_onload')) {
$onLoad = '<script language="javascript" type="text/javascript" charset="'.CHARSET.'">';
$onLoad .= "function onLoad() {\n";
$onLoad .= implode("\n",$PMDR->get('javascript_onload'));
$onLoad .= "\n}";
$onLoad .= 'window.onload=onLoad;'."\n";
$onLoad .= '</script>'."\n";
$PMDR->loadJavascript($onLoad);
unset($onLoad);
}
$javascript .= implode("\n",(array) $PMDR->get('load_javascript'));
$header->set('load_javascript',$javascript);
$header->set('load_css',implode("\n",(array) $PMDR->get('load_css')));
$header->set('css_file_path',BASE_URL.TEMPLATE_PATH.'css.css');
// Add title from configuration to end of array and display, seperated by a dash -
//$PMDR->set('page_title',array_merge(array_reverse($PMDR->get('page_title')),array($PMDR->getConfig('title'))));
$header->set('page_title',implode(' - ',array_merge(array_reverse($PMDR->get('page_title')),array($PMDR->getConfig('title')))));
if($PMDR->get('breadcrumb')) {
$header->set('breadcrumb',$PMDR->get('breadcrumb'));
}
?>
Thanks |
|||||||