jQuery的AJAX传递SQL查询

Question

I'm using an ajax call to query a database. I'd like to pass a complex sql query as part of the ajax data. Is this the way I should be doing it?

var myQuery = 'select * from table....';        

$.ajax({
    type: "GET",
    url: 'jsonQuery.php',
    dataType: 'json',
    data: {keyvalue: 2416, q: myQuery},
    success: function(pieData) {
        //do something with the response        
    }

});

Answer 1

Yes, there is a better way. Keep the query on the .php page and send a post type which tells you which one to use.

Example:

data: {keyvalue: 2416, q: 2},

Then you take your query that corresponds to number 2 and use that! No need to pass the SQL along!