AJAX: Can't pass javascript variable to SQL query in PHP script

Question

I have a PHP page with 2 sections side by side. The left pane has a MySQL query that runs and produces a list of categories as links. The right pane should have subcategories that appear when links in the left pane are clicked.

I have some AJAX in an attached JS file that should pass the ID in the links from the left pane, into a query in the right pane. The query should run. It runs if I take out a variable.

The PHP/SQL Queries work fine. JS does not.

I think this is the appropriate way of doing this.

ajax.js

$( document ).ready(function() {
$( 'a' ).on( 'click', function() {
    var a = $( this ).attr( 'id' );

    $.ajax({
        type: "POST",
        url: "categories.php",
        data: "ajax="+a,
        success: function(response){
            alert( a );
        },
        error: function() {
            alert('Error');
        }
    })
});

});

I am being told everything works, but I cannot call $_POST['ajax'] in PHP. Perhaps my page is not being refreshed. There is no form on the page.

Lastly, my file hierarchy has categories.php comprised of a list of includes, which are in a folder that is not public.

Try logging the response in your console. What do you see? And you should probably format your output form categories.php with JSON for better interoperability. — Terry
– Terry, Commented Oct 14, 2013 at 18:33
Perhaps I'm doing something incorrectly, but I only need the ajax call to get an attribute from a link, nothing directly from PHP. Only need it to run a dynamic query on a click even. — nobrandheroes
– nobrandheroes, Commented Oct 14, 2013 at 20:04

mavrosxristoforos · Accepted Answer · 2013-10-14 18:55:00Z

1

I think your ajax syntax is wrong. Try this if your argument is a and your post identifier is ajax:

$( document ).ready(function() {
    $( 'a' ).on( 'click', function() {
        var a = $( this ).attr( 'id' );

        $.ajax({
            type: "POST",
            url: "categories.php",
            data: {ajax : a},
            success: function(response){
                alert( a );
            },
            error: function() {
                alert('Error');
            }
        });
    });
});

edited Oct 14, 2013 at 18:55

mavrosxristoforos

3,6833 gold badges27 silver badges44 bronze badges

answered Oct 14, 2013 at 18:46

user2877011

1105 bronze badges

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

Comments

T0w3ntuM · Accepted Answer · 2013-10-14 18:45:52Z

0

Try setting async: false on your $.ajax call. Also, how is the data being return from php? Are you using JSON_ENCODE for the data?

answered Oct 14, 2013 at 18:45

T0w3ntuM

3322 gold badges3 silver badges12 bronze badges

1 Comment

nobrandheroes Over a year ago

My script generates a list of links to a page. JQuery pulls the id from the links and hopefully sends it to the page which will run an SQL query.

Collectives™ on Stack Overflow

AJAX: Can't pass javascript variable to SQL query in PHP script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related