Displaying SQL address values onto Google Maps API

Question

Im fairly new to PHP and MySQL and I am attempting to create a master detail page of events. The master page contains all of the events within the database with brief descriptions and the details page gives more information about that specific event based on the EventID.

The PHP code runs fine and displays all the correct information based on that event in the details page. However have added a map link from google and I want to take the values from the address column for that specific event and display the location on a the map.I know where to enter the code into the Iframe but I'm struggling to save any of the address values into a variable.

I'll link the code below. Any advice or help would be greatly appreciated (like I said I am new to all this so please be nice!) :)

Master page

include"connect-mysql.php";

$sql = "SELECT * FROM Events";
$result = mysqli_query($conn,$sql);

?>

<html>
<body>

<?php
while($row=mysqli_fetch_assoc($result))
{
echo "<br><br>Event name: " .$row["EventName"],
    "<br>Second Name: " .$row["EventDate"],
    "<br><a href=googleDetail.php?EventID=" .$row["EventID"]. ">Details</a>";

}

?>

</body>
</html>

Detail page

include"connect-mysql.php";


$ID = $_GET["EventID"];
$Add1 = $_GET["EventAddress1"];
$Add2 = $_GET["EventAddress2"];
$Add3 = $_GET["Postcode"];


$sql = "SELECT * FROM Events WHERE EventID = '$ID' ";
$result = mysqli_query($conn,$sql);

?>

<html>
<body>

<?php
while($row=mysqli_fetch_assoc($result))
{
echo "<br><br>Event Name: " .$row["EventName"],
     "<br>Event Date: " .$row["EventDate"],
     "<br>Address 1: " .$row["EventAddress1"],
     "<br>Address 2: " .$row["EventAddress2"],
     "<br>Postcode: " .$row["EventPostcode"];

     }

?>

<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2393.598194202707!2d-1.2525729846387041!3d53.1353580799353!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x4879967b2e53227b%3A0xf3a89e4d74b3556b!2sADDRESS GOES HERE!5e0!3m2!1sen!2suk!4v1487765096800" width="450" height="450" frameborder="0" style="border:0" allowfullscreen></iframe>

no need to loop just get single row and assign to iframe.

user247217
– user247217

2017-02-22 13:51:22 +00:00
Commented Feb 22, 2017 at 13:51 — user247217
– user247217, Commented Feb 22, 2017 at 13:51

user247217 · Accepted Answer · 2017-02-22 13:48:31Z

1

Try below hope this helps.

<?php
    $sql = "SELECT * FROM Events WHERE EventID = '$ID' ";
    $result = mysqli_query($conn,$sql);
    $row=mysqli_fetch_assoc($result);
    ?>
    <iframe width="640" height="480" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.it/maps?q=<?php echo $row['EventAddress1']; ?>&output=embed"></iframe>

answered Feb 22, 2017 at 13:48

user247217

3941 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Brad Over a year ago

Works perfectly. Thanks.

Collectives™ on Stack Overflow

Displaying SQL address values onto Google Maps API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related