Thank you Ralph !
Where do I put it?
On Sep 9, 2:35 pm, Ralph <ralph.a...@gmail.com> wrote:
> Maybe this might work
>
> $occ->setAttribute('name', utf8_encode($row['name']));
>
> Ralph
>
> On Sep 9, 2:13 pm, DaveGivesPHPaShot <tolman.da...@gmail.com> wrote:
>
>
>
> > Hello, I am trying to duplicate this google code tutorial on using
> > MySql and PHP with Google Maps V3.
>
> >http://code.google.com/intl/fr/apis/maps/articles/phpsqlajax_v3.html
>
> > I have foreign characters (well they aren't "foreign" for everyone,
> > but you know what I mean, right?) in my MySql database.
>
> > When I call this php page
>
> >http://www.oukwakan.org/phpsqlajax_genxml_jdm2.php
>
> > My code breaks after <markers><marker nom="Halle de la Martini
> > because it's "Halle de la Martinière." (accent on the E right after
> > "Martini")
>
> > I think I have to correctly specify the formatting of the XML output
> > file in the PHP genxml and I am not yet doing it correctly. Right ?
> > This problem is mentioned in the above tutorial, but my syntax must be
> > wrong.
>
> > Here is my code: forhttp://www.oukwakan.org/phpsqlajax_genxml_jdm2.php
> > <?php
>
> > require("phpsqlajax_dbinfo.php");
>
> > // Start XML file, create parent node
>
> > $dom = new DOMDocument("1.0");
> > $node = $dom->createElement("markers");
> > $parnode = $dom->appendChild($node);
>
> > // Opens a connection to a MySQL server
>
> > $connection=mysql_connect (localhost, $username, $password);
> > if (!$connection) { die('Not connected : ' . mysql_error());}
>
> > // Set the active MySQL database
>
> > $db_selected = mysql_select_db($database, $connection);
> > if (!$db_selected) {
> > die ('Can\'t use db : ' . mysql_error());}
>
> > // Retrieve data from Query String
> > $nom = $_GET['nom'];
> > $jour = $_GET['jour'];
> > $horaires = $_GET['horaires'];
> > $remarques = $_GET['remarques'];
> > $lat = $_GET['lat'];
> > $lng = $_GET['lng'];
> > $educatif = $_GET['educatif'];
> > // Update later - Escape User Input to help prevent SQL Injection
> > $age = mysql_real_escape_string($age);
> > $sex = mysql_real_escape_string($sex);
> > $wpm = mysql_real_escape_string($wpm);
> > //SECURITY ABOVE NEEDS TO BE UPDATED AS WE GO
> > //build query
> > $query = "SELECT * FROM jourdemarche WHERE 1";
>
> > //Execute query
> > $result = mysql_query($query);
> > if (!$result) {
> > die('Invalid query: ' . mysql_error());}
>
> > header('Content-type: text/xml; charset=UTF-8');
>
> > // Iterate through the rows, adding XML nodes for each
>
> > while ($row = @mysql_fetch_assoc($result)){
> > // ADD TO XML DOCUMENT NODE
> > $node = $dom->createElement("marker");
> > $newnode = $parnode->appendChild($node);
> > $newnode->setAttribute("nom",$row['nom']);
> > $newnode->setAttribute("descriptif", $row['descriptif']);
> > $newnode->setAttribute("lat", $row['lat']);
> > $newnode->setAttribute("lng", $row['lng']);
> > $newnode->setAttribute("entreprise", $row['entreprise']);
>
> > }
>
> > echo $dom->saveXML();
>
> > ?>
>
> > Thanks for your help !
--
You received this message because you are subscribed to the Google Groups
"Google Maps JavaScript API v3" group.
To post to this group, send email to google-maps-js-api...@googlegroups.com.
To unsubscribe from this group, send email to
google-maps-js-api-v3+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-maps-js-api-v3?hl=en.
