close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Converting an older WA Google Maps Pro file to be MySqli and PHP 7 compatible.

Thread began 6/05/2018 9:47 am by administration282761 | Last modified 6/11/2018 3:31 pm by Ray Borduin | 124 views | 7 replies |

administration282761

Converting an older WA Google Maps Pro file to be MySqli and PHP 7 compatible.

Converting the Recordset to MySqli does not seem to be a problem.

However, the "wagmp_map_1.php" file I am using which retrieves location info from a database and insets it into a dynamically generated Google Map needs to be updated.

Basically, to make this work I need to update code such as:

<?php echo str_replace("'", "\'", "".$row_rsAgenda['address_street'] .""); ?>

Is there a MySQli equivalent to the above?

And, would the Google Maps Pro extension in Design Extender generate PHP 7 compatible code?

Thanks for any advice.

Sign in to reply to this post

Ray BorduinWebAssist

$row_rsAgenda['address_street']

is:
$rsAgenda->getColumnVal('address_street')

Sign in to reply to this post

administration282761

Thanks Ray

I thought the "echo str_replace" part may have also changed. I still have some other issues in order to make this work which I am trying to sort out.

However, while testing I got a notice from Google informing me that on June 16, 2018 they will start charging for using the Google Map API. Do you know anything about this and how it may affect the Google Map app?

More info: https://cloud.google.com/maps-platform/

Pricing: https://cloud.google.com/maps-platform/pricing/

Sign in to reply to this post

Ray BorduinWebAssist

The API key will be required and you will have to have a credit card associated with your account. Other than that there shouldn't be any effect.

Sign in to reply to this post

administration282761

Hi Ray - I am still having trouble converting my Google Map to MySqli. I have added my code in a PM.
And yes, I have a new API. Thanks for having a look.

Sign in to reply to this post

Ray BorduinWebAssist

This looks correct to me. Do you have a url where I can see it broken?

Sign in to reply to this post

administration282761

Old code working here:
http://www.swissart.ch/en/agenda_aargau_solothurn_region.php
(Section Museums - Google Map)

New code not working here:
http://www.swissart.ch/fr/agenda_aargau_solothurn_region.php
(Section Museums - Google Map)

Attached is my new intermediate page "google_agenda_map_2.php " that calls the file:

Sign in to reply to this post

Ray BorduinWebAssist

The issue appears to be the map function name being out of sync with the code.

function wagmp_map_1() {

should be:
function wagmp_map_2() {

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...