PHP $_GET with Ajax/Jquery Request

caetano · May 12, 2012

I am trying to set a variable $id=$_GET["categoryID"]. I cannot get it to work. I believe it has to do with the the Ajax request. But I don't know how I have to format it so that it will work in conjunction with that request. I need the variable for a mysql query. Any help is greatly appreciated. This is over my head and have been struggling with it for days. I have tried both GET and POST. Thanks.I have distilled the page down to this...\[code\]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Test $_GET</title></head><body><?php if(isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') { $id = $_GET["categoryID"]; //$id=3; }?> print_r($_GET) = <?php print_r($_GET); ?> <br /> print_r($id) = <?php print_r($id); ?> </body></html> \[/code\]Here is the resulting page....\[code\]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Test $_GET</title> </head> <body> print_r($_GET) = Array( [categoryID] => 1001) <br /> print_r($id) = </body> </html> \[/code\]Here is the whole page....\[code\]<?phpif (@$_REQUEST['ajax']) { $link = $nm33; if ($link == false) trigger_error('Connect failed - ' . mysql_error(), E_USER_ERROR); $connected = mysql_select_db('nm', $link); if ($connected) { //How do I set $id = $_GET["categoryID"] It fails to set the variable. $id =$_GET["categoryID"]; // $id=1; // It will work as $id=1 $results = mysql_query('select * from selectMenu where categoryID= \'' . $id . '\' AND category="' . strtolower(mysql_real_escape_string(strip_tags($_REQUEST['category']))) . '"'); ////////// $json = array(); while (is_resource($results) && $row = mysql_fetch_object($results)) { //$json[] = '{"id" : "' . $row->id . '", "label" : "' . $row->label . '"}'; $json[] = '"' . $row->label . '"'; } echo '[' . implode(',', $json) . ']'; die(); // filthy exit, but does fine for our example. } else { user_error("Failed to select the database"); }}?><script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script><script src="http://stackoverflow.com/questions/10539042/js/select-chain.js" type="text/javascript" charset="utf-8"></script><script type="text/javascript">  </script><link href="http://stackoverflow.com/questions/10539042/selectMenu.css" rel="stylesheet" type="text/css" /><form action="performance-models.php" method="get"> <select name="category" class="dropdown" id="categorySelect"> <option selected="selected">Select Your Vehicle</option> <?php do { ?> <option> <?php echo $row_rsMake['make']; ?></option> <?php } while ($row_rsMake = mysql_fetch_assoc($rsMake)); ?> </select> <select name="model" class="dropdown" id="elementSelect"> <option selected="selected">Select Model</option> <option>[none selected]</option> </select> <select name="appYear" class="dropdown" id="attributeSelect" > <option selected="selected"> </option> <option>[none selected]</option> </select> <input type="submit" value="http://stackoverflow.com/questions/10539042/Go"></form><p><br /> <br /> print_r($_GET) = <?php print_r($_GET); ?> <br /> print_r($_REQUEST) = <?php print_r($_REQUEST); ?><br /> echo $_REQUEST['categoryID'] <?php echo $_REQUEST['categoryID'];?></p>\[/code\]Here is select-chain.js\[code\](function ($) { $.fn.selectChain = function (options) { var defaults = { key: "id", value: "label" }; var settings = $.extend({}, defaults, options); if (!(settings.target instanceof $)) settings.target = $(settings.target); return this.each(function () { var $$ = $(this); $$.change(function () { var data = http://stackoverflow.com/questions/10539042/null; if (typeof settings.data =='string') { data = http://stackoverflow.com/questions/10539042/settings.data +'&' + this.name + '=' + $$.val(); } else if (typeof settings.data =http://stackoverflow.com/questions/10539042/='object') { data = http://stackoverflow.com/questions/10539042/settings.data; data['category'] = $$.val(); data['model'] = $$.val(); data['year'] = $$.val(); } settings.target.empty(); $.ajax({ url: settings.url, data: data, type: (settings.type || 'get'), dataType: 'json', success: function (j) { var options = [], i = 0, o = null; for (i = 0; i < j.length; i++) { // required to get around IE bug (http://support.microsoft.com/?scid=kb%3Ben-us%3B276228) o = document.createElement("OPTION"); o.value = http://stackoverflow.com/questions/10539042/typeof j =='object' ? j[settings.key] : j; o.text = typeof j == 'object' ? j[settings.value] : j; settings.target.get(0).options = o; } // hand control back to browser for a moment setTimeout(function () { settings.target .find('option:first') .attr('selected', 'selected') .parent('select') .trigger('change'); }, 0); }, error: function (xhr, desc, er) { // add whatever debug you want here. alert("an error occurred here"); } }); }); }); };})(jQuery);\[/code\]

PHP $_GET with Ajax/Jquery Request

caetano

New Member