?
Solved

Reload a php query that is included in html page when select option is pressed.

Posted on 2014-09-09
3
Medium Priority
?
272 Views
Last Modified: 2014-09-20
I have a index.php page that that uses this in the body.
<div id="live-area">
                            <?php include ('assets/php/multibox.php');?>
                                </div>

Open in new window


In that multibox.php i have a div id container that loads my highcharts.
On that same multibox.php i have a query to load the table data.

I have a select option box that is filled by a mysql query on same page.

here is what the options look like
echo "<option value=index.php?id=$row[activity]/$row[app_name]>$row[app_name]</option>";

Open in new window


So when they are clicked they reload the index.php (same page they are included on) and pass id.

I then have this on the multibox.php to check the id
if ($_GET['id'] == '')

So i can change the query based on that id so when the page loads it shows the chart with data for the selected.

SO... my question.

How can i just refresh that php with data for graph?

I did the following but it reloads the entire page into the live-area div.

echo "<select name=category value='' onchange=\"runthis(this)\"></option>";

Open in new window


 <script type="text/javascript">

        function runthis(sel) {
            var page = sel.value;
        $.ajax({
            url: page,
            success: function (response) {
                $('#live-area').html(response);
            }
        });
        }
    </script>

Open in new window

0
Comment
Question by:bignadad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 40313439
You need to create a page that is called by the ajax function that only contains the data (HTML) for the graph and nothing else
0
 
LVL 2

Accepted Solution

by:
bignadad earned 0 total points
ID: 40313449
i figured it out.

function runthis(sel) {
        var page = sel.value;
        $('#live-area').load('assets/php/multibox.php?id=' + page);
    }

Open in new window

0
 
LVL 2

Author Closing Comment

by:bignadad
ID: 40334220
Firgured out the answer myself
0

Featured Post

WordPress Tutorial 3: Plugins, Themes, and Widgets

The three most common changes you will make to your website involve the look (themes), the functionality (plugins), and modular elements (widgets).

In this article we will briefly define each again, and give you directions on how to install them.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question