Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Changing a Google Map script to use MySQLi instead of MySQL

Changing a Google Map script to use MySQLi instead of MySQL

Thread began 9/30/2015 2:29 am by Nathon Jones Web Design | Last modified 10/02/2015 10:12 am by Ray Borduin | 961 views | 2 replies |

9/30/2015 2:29 am | #1 Nathon Jones Web Design

Changing a Google Map script to use MySQLi instead of MySQL

Here is the script that I use for a Google Maps integration but the extension doesn't recognise MySQLi recordsets in its dialog window so you have to create a standard DW MySQL recordset.

<script type="text/javascript">
      // <![CDATA[
     jQuery(document).ready(
       function()
         {
           jQuery("#newvenueMAP").dmxGoogleMaps(
             {"zoom": 15, "markers": [<?php
      do {
    ?> {"address": "<?php echo $row_rsNEWVENUEMAP['tmsavenueaddress']; ?>, <?php echo $row_rsNEWVENUEMAP['tmsavenuetown']; ?>, <?php echo $row_rsNEWVENUEMAP['tmsavenuepostcode']; ?>"}, <?php
        } while ($row_rsNEWVENUEMAP = mysql_fetch_assoc($rsNEWVENUEMAP));
    ?>]}
           );
         }
     );
      // ]]>
    </script>

I understand the recordset fields can be changed as follows:

<script type="text/javascript">
      // <![CDATA[
     jQuery(document).ready(
       function()
         {
           jQuery("#newvenueMAP").dmxGoogleMaps(
             {"zoom": 15, "markers": [<?php
      do {
    ?> {"address": "<?php echo($rsNEWVENUE->getColumnVal("tmsavenueaddress")); ?>, <?php echo($rsNEWVENUE->getColumnVal("tmsavenuetown")); ?>, <?php echo($rsNEWVENUE->getColumnVal("tmsavenuepostcode")); ?>"}, <?php
        } while ($row_rsNEWVENUEMAP = mysql_fetch_assoc($rsNEWVENUEMAP));
    ?>]}
           );
         }
     );
      // ]]>
    </script>

...but how should that last "while" statement read?
Thank you.
NJ

9/30/2015 10:43 am | #2 Ray BorduinWebAssist

php:

<?php

while(!$rsNEWVENUE->atEnd()) {

?> {"address": "<?php echo($rsNEWVENUE->getColumnVal("tmsavenueaddress")); ?>, <?php echo($rsNEWVENUE->getColumnVal("tmsavenuetown")); ?>, <?php echo($rsNEWVENUE->getColumnVal("tmsavenuepostcode")); ?>"}, <?php

  $rsNEWVENUE->moveNext();

}

$rsNEWVENUE->moveFirst();

?>

Did this help? Tips are appreciated...

10/02/2015 2:14 am | #3 Nathon Jones Web Design

This post has been deleted.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.