Solved

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

Posted on 2014-09-09
3
251 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
  • 2
3 Comments
 
LVL 58

Expert Comment

by:Gary
Comment Utility
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
Comment Utility
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
Comment Utility
Firgured out the answer myself
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
advertisement module in core php 4 81
Re-imbursement Claim System 3 21
PHP string issue 5 17
Jquery autocomplete 10 21
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now