PHP - Gmap & Database

hello im having some trouble with my gmap

its just that all my markers are showing all the data from the last child of the xml file
ill explain my code here for beta explanation

first after the form as been submitted, it gets all the posted data from the form, then searches the database and returns all it matches and returns it back to the user, then it writes it all to an xml and then calls the displaymap.php

$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers");
$parnode = $dom->appendChild($node); 
//query for doctor name


//query to search for all doctors that match the selected value of the langspoken dropdown box
$gmapSql = "SELECT * FROM Doctor";

$gmapResult = $mdb2->query($gmapSql);
$rowsFound = ($gmapResult->numRows());

if(PEAR::isError($mdb2))
{
echo $mdb2->getMessage() . "<br/>\n";
echo $mdb2->getUserinfo() . "<br/>\n";
exit;
}

//checks if any exists and displays it or displays none has been found
if(($gmapResult->numRows()) != 0)
{
// Report how many rows were found
$rowsfoundmessage = "{$rowsFound} records of doctors found matching your criteria <br> Address Entered: {$address}
<br> Radius(km): {$KMradius}";
$template->setCurrentBlock("resultsfound");
$template->setVariable("RESULTSFOUND",$rowsfoundmessage);
$template->parseCurrentBlock("resultsfond");

}
else
{
$rowsfoundmessage = 'No records of doctors match your search criteria';
$template->setCurrentBlock("resultsfound");
$template->setVariable("RESULTSFOUND",$rowsfoundmessage);
$template->parseCurrentBlock("resultsfound");
}



if ($rowsFound > 0)
 {
 // Fetch each of the query rows
 while ($row = $gmapResult->fetchRow()) 
 {   
//details it back to the user using the PEAr placeholders
$template->setCurrentBlock("doctorinfo");
$template->setVariable("DOCTORNAME","{$row['Title']} {$row['GivenName']} {$row['Surname']}");
$template->setVariable("DOCTORLANG", $row['LanguageSpoken']);
$template->setVariable("DOCTOROFFICEADD", $row['OfficeAddress']);
$template->setVariable("DOCTOROFFICENUM", $row['OfficeNumber']);
$template->setVariable("DOCTORSPECIAL", $row['Qualifications']);
$template->parseCurrentBlock("doctorinfo");
 
 
 // ADD TO XML DOCUMENT NODE
$node = $dom->createElement("marker");  
$newnode = $parnode->appendChild($node);   

//created attributes for each marker containing doctors details
$newnode->setAttribute("DoctorName","{$row['Title']} {$row['GivenName']} {$row['Surname']}");
$newnode->setAttribute("OfficeAddress", $row['OfficeAddress']);  
$newnode->setAttribute("OfficeNumber", $row['OfficeNumber']);  
$newnode->setAttribute("LanguageSpoken", $row['LanguageSpoken']);  
$newnode->setAttribute("Specialty", $row['LanguageSpoken']); 


} // end while loop body
 } // end if $rowsFound body
 
//save as an xml and overwrite existing one with this data
echo $dom->saveXML();
$dom->save("markers.xml");

//call this script to display the google map
echo "<script type=\"text/javascript\" src=\"displaymap.php?address=".$address."&KMradius=".$KMradius."\"></script>"; 


opens the displaymap.php and starts the map, makes a marker of ur location and draws a radius
it then opens the xml file, searches each child and makes a marker for it and put it on the map
my PROBLEM is the infowindow for each marker on the map  only shows details for the last child on the xml,
at ffirst i was pretty sure it would work fine since its all in for loop so that each marker it makes it shows coresponding details.
Could it be that everytime it goes in the for loop it overrides the marker2 variable with the new details?
is there a solution to this??

//Get the data from the url and store it in a javascript variable
var address = "<?php echo $_GET['address'];?>";
var KMradius = "<?php echo $_GET['KMradius'];?>";


//call the functions with those parameters
showAddress(address,KMradius);return false;

function showAddress(address,KMradius) 
{
//converts KM radius into Miles 
MIRadius = KMradius * 0.62137119;

if (geocoder) 
{
geocoder.getLatLng(address,function(point) 
{
//checks the address entered is a valid geocode address
if (!point) 
{
alert("Address: "+address + " not found");
} 
else 
{
//if it is set the center of the map of that address 
map.setCenter(point, 10);
var marker = new GMarker(point, {draggable: true});
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowHtml("<p>Address: <b>" + address + "</b><p>Your Are here! </p>");
}); 
//sets the latitude and longtude of the address into variables
var lati=point.lat();
var long=point.lng();
//add the marker of the address onto the map
map.addOverlay(marker);
marker.openInfoWindowHtml("<p>Address: <b>" + address + "</b><p>Your Are here! </p>");


//calls the functions with the latitude,longtude and radius and also the thickness and color of the circle
drawCircle(lati,long,MIRadius, "#000080",1, .5, "#0000FF", .5);

}
}
);
}

//opens the xml with all the markers and parses the data
GDownloadUrl("markers.xml", function(data) 
{
var xml = GXml.parse(data);
//goes into the root element of the xml
var markers = xml.documentElement.getElementsByTagName("marker");
//for each marker element in the xml, create a new marker from the address attribute
for (var i = 0; i < markers.length; i++) 
{
//gets the values of each attribute for each marker element
var GivenName = markers[i].getAttribute("DoctorName");
var OfficeNumber = markers[i].getAttribute("OfficeNumber");
var LanguageSpoken = markers[i].getAttribute("LanguageSpoken");
var addresss = markers[i].getAttribute("OfficeAddress");
var special = markers[i].getAttribute("Specialty");
//alert(GivenName);
//alert(OfficeNumber);
//alert(LanguageSpoken);
//alert(addresss);
//alert(special);

if (geocoder) 
{

geocoder.getLatLng(addresss,function(point) 
{
if (!point) 
{
//if the address in the xml in not a valid geocode address, alert the user
alert("Address: "+addresss+ " not found");
} 
else 
{

//make a variable each for latitude and longatude for the point
var lati2 = point.lat();
var long2 = point.lng();

//make a point containing the latitude and longatude
var point = new GLatLng(lati2,long2);
//created a marker for that point
var marker2 = new GMarker(point,{draggable: false});
GEvent.addListener(marker2, "click", function() {
marker2.openInfoWindowHtml("Office Address:" + addresss + "<br/>Language Spoken: "+ LanguageSpoken + "<br/>Doctor Name:" + GivenName+ "<br/>Office Number: "+ OfficeNumber+ ".");
});

//var marker2 = createMarker(point,);
//add the marker of the address in the xml onto the map
map.addOverlay(marker2);


}
}
);
}





}
});
    }




thanks

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=309753.0

I had bought a script from he php google maps and have been using the attached php script. It was working and than apparently stopped working with this error "602: Unable to Geocode this address"

Can anyone tell me if there is another solution? Or if I can use another method besides $gmap->showLocation($cross,$town,$county$state);
Thanks!
Code: [Select]
<?php
require_once('gmap.php');
        $gmap = new GMap();
$cross = $result['cross_streets'];
$county = $result['county'];
$town = $result['town'];
$state = 'New York';
        $gmap->showLocation($cross,$town,$county$state);

?>

after cloasing connection of database i still got the values form database.

Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
if(!$result){
echo "cont fetch data";

}else{

   $row= mysql_fetch_array($result);
   echo "id".$row[0]."usrname".$row[1]."passwped".$row[2]."date".$row[3]."time".$row[4];
}
//  echo "<html>";
//echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
//      echo "<thead>";
//           echo"<tr>";
//                   echo "<th>";
//                   echo ID;
//                   echo"</th>";
//                   echo" <th>";echo Username; echo"</th>";
//                    echo"<th>";echo Password; echo"</th>";
//                    echo"<th>";echo Last_logged_date; echo "</th>";
//                   echo "<th>";echo Last_logged_time;  echo "</th>";
//               echo" </tr>";
//           echo" </thead>";
//           echo" <tbody>";
//while($row= mysql_fetch_array($result,MYSQL_BOTH)){
//             echo "<tr>";
//              echo "<td>";
//              echo $row[0];
//               echo "</td>";
//                   echo "<td>";
//              echo $row[1];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[2];
//               echo "</td>";
//                   echo "<td>";
//                echo $row[3];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[4];
//               echo "</td>";
//            echo "</tr>";
//     }
//         echo" </tbody>";
//         echo "</table>";
//         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values from doatabase session is destroyed".$_SESSION['admin'];
?>

session is destroyed but database connection is not closed.

thanks

I have a very tricky php problem here. At least for me.
On a page that is editing a job entry. I have a database generated group of checkboxes some of which have been checked when the job was entered.

So the script has to do two things generate the complete list of checkboxes and check the ones that have already been selected in the job request. The below script is what I've done trying to figure it out.

Description of what I'm trying to do:
I'm generating the the boxes with a call to my database for the list of checkboxes.
Then I'm building an array with all the possible items that could be checked to compare against.
 
Ok here is where I think my first problem is. I need to make a second query to another table "worklog" in the same database. This is where the list of checked items are stored. What is the best way to do this? A second query seems wrong "or at least not efficient"

       Code: [Select]
<div class="text">Job Type&nbsp;(<a class="editlist" href="javascript:editlist('listedit.php?edit=typelist',700,400);">edit list</a>):</div>
<div class="field">

    <?PHP

    $connection=mysql_connect ("localhost", "user", "password") or die ("I cannot connect to the database.");
    $db=mysql_select_db ("database", $connection) or die (mysql_error());
    $query = "SELECT type FROM typelist ORDER BY type ASC";
    $sql_result = mysql_query($query, $connection) or die (mysql_error());
    $i=1;
    echo '<table valign="top"><tr><td>';
    while ($row = mysql_fetch_array($sql_result)) {
    $type = $row["type"];
        if ($i > 1 && $i % 26 == 0)
        echo '</td><td>';
        else if ($i)
        echo '';
        ++$i;
       
        $aTypes = array ("Spec Ad Campaign", "100 x 100 Logo", "100 x 35 (Featured Developer/Broker)", "100 x 40 (Featured Lender)", "120 x 180 (Home Page Auto)", "120 x 45 (Half Tile - Jobs)", "120x60 (Section Sponsor)", "125 x 40 (Profile Page logo)", "135 x 31 (Autos)", "135 x 60 (Autos)", "135 x 60 (Logotile - Jobs)", "150 x 40 (Auto Logo)", "160 x 240 (monster tile)", "160 x 400 (Skyscraper)", "160 x 600 (Tower)", "170x30 (Section Sponsor)", "240 x 180 JPG/GIF Auto Video", "240 x 180 size FLV video ", "300 x 250 (Story Ad)", "300 x 600 (Halfpage)", "468 x 60 (Banner Jpg/Gif)", "728 x 90 (Leaderboard)", "95 x 75 (Sweeps Logo) ", "Agent Profile Page", "Contest", "Creative Change", "Employer Profile", "Holiday Shop", "Home of the Week", "HP Half Banner (234 x 60 Static)", "Mobile Ads (320x53 *300x50*216x36*168x28)", "Newsletter", "Peelback", "Pencil Ad", "Print", "Real Deals", "Resize ad campaign", "Roll-Over Skyscraper", "Site Sponsor logo (170x30)", "Splash Page Production", "Travel Deals Update", "Video Ad", "Web Development", "Web Maintenance", "Web Quote (or Design)");
       
        $dbTypes = explode(',',$row['type']);
       
        foreach ($aTypes as $type){
       
        if(in_array($aType,$dbTypes)){
       
      echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type' CHECKED><span style='color:#000;'>$type</span></input><br/>";
       
        }else
       
        {
       
            echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type'><span style='color:#000;'>$type</span></input><br/>";  
       
               
        }

        }

    }
      echo '</td></tr></table>';
   
    ?>

</div>