Explore our sites

Stack Exchange
tour help careers 2.0
Take the tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite
1

How do you call a PHP function that is in a different file from a JavaScript function?

I have a JavaScript function that recieves a variable from an onclick function. The variable is an id that I will use to retrieve data from a MySQL database. The variable is then passed on to a PHP function that will access the database to get the data and return back to my JavaScript function for display, but it does not seem to be working. How can I get it to work? I am using CodeIgniter PHP.

Here is the code.

The JavaScript code is in a different file called divUpdate.php.

<script type="text/javascript">
    function changeDiv(venueID){
        //retrieveData(venueID) is a PHP function from venue_model.php
        var dest = retrieveData(venueID);
        document.getElementById('venue_description').innerHTML=dest;
    }
</script>

---Where the onclick function calls the JavaScript code above. ----

<li><a href="#self" class="menulink" class=&{ns4class};
                    onClick="changeDiv(\''.
                    $venue_details->VenueID.
                   '\')">;

--- Function retrieveData is called from the JavaScript code above. This is in the model (CodeIgniter). --

function retrieveData($venueID){
    $query = $this->db->query("SELECT * FROM venue WHERE VenueID = '$venueID' ");
    echo $query;
}
share|improve this question
2  
search for "ajax tutorial with php" –  h3xStream Oct 29 '10 at 1:27
1  
When you said that it doesn't work, what is actually not working? –  Victor Oct 29 '10 at 1:54
 
I hope you escape $venueID somewhere. –  Ivo Wetzel Oct 29 '10 at 1:59
 
Some google search results on stackoverflow: bit.ly/dh8Uxj –  subhaze Oct 29 '10 at 2:31
 
In the divUpdater.php the call to the method retrieveData($venueID) doesnt work –  user455699 Oct 31 '10 at 23:00
add comment

2 Answers

up vote 2 down vote

Use Ajax as already suggested. Using jQuery you will get this fixed with ease.

You will need to create a controller to access your Ajax calls. I, simply enough, created the Ajax controller like this:

<?php
    class Ajax extends Controller
    {
        public function index()
        {
            $this->output->set_output("This is the AJAX Controller");
        }

        public function get_venue_description( $venueId )
        {
            $this->load->model('yourmodel');
            $data = $this->yourmodel->retrieveData($venueId);
            $this->output->set_output($data);
        }
    }
?>

Then your JavaScript code, after implementing jQuery, should look something like this:

<script type="text/javascript">
    function changeDiv(venueID)
    {
        $.get('/ajax/get_venue_description/' + venueId, function(data) {
            $('#venue_description').html(data);
        });
    }
</script>

I haven't tested it, but I hope you get the idea.

share|improve this answer
add comment
up vote 0 down vote

What you are looking for is "AJAX" - try searching for a tutorial on google. Also, you'll find it a lot easier to perform AJAX requests by using a JavaScript library like jQuery.

Here's jQuery AJAX function: http://api.jquery.com/jQuery.ajax/

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.