How to use a php result set from a query in JavaScript

Question

I am working on a page that displays all state parks. Something like this:

http://www.comehike.com/outdoors/state.php?country_id=1&state_id=6&state_name=California&country_name=

I have the park data, including lat/lng in my database and I already get that data during the request. What I want to avoid is doing an AJAX call which will query the park data again.

Is it possible for me to just send the PHP result set to the JS somehow and to loop through the parks and display them?

I am already doing something like that by sending the map-center lat/lng so I figured it is doable with a result set.

Thanks, Alex

Could you be more clear? What do you mean "avoid doing an Ajax call again"?? When do you do it the first time and what is the flow of messages? That'll help clarify your question better and help others in answering it — PhD
– PhD, Commented Apr 30, 2011 at 16:52

JohnP · Accepted Answer · 2021-09-29 10:24:30Z

2

This depends on how your pages are setup. If you're using some kind of MVC setup, you need to pass the variable to your view first. Or if it's a single page, just retrieve the PHP above and pass it as a variable.

<?php
   $parkData   = $model->getData();  //make sure this returns an array or an object array or something
   $parkDataJson = json_encode($parkData);
?>

//in your view

<script type='text/javascript'>
   let parkData = <?php echo $parkDataJson ?>;
   //now you have a JSON array available for your use
</script>

edited Sep 29, 2021 at 10:24

answered Apr 30, 2011 at 16:51

JohnP

50k13 gold badges112 silver badges142 bronze badges

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

2 Comments

GeekedOut Over a year ago

That idea worked. Sorry can't vote you up because it requires 15 reputation points lol

JohnP Over a year ago

@mickmackusa This answer is from 10 years ago, tbh I don't even remember why I added an unnecessary eval in there. Anyway, I've updated it, thanks.

Collectives™ on Stack Overflow

How to use a php result set from a query in JavaScript

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related