jQuery Get Commands

jQuery Get Commands

Hello,

I have just recently started using jQuery. I am trying to create and index form that asks you to select an option from a drop down box. Once that is selected jQuery pulls data from a php page and pastes it into a div. Once that has been done there are more options available in a select list. Once you select one item the select list beside it fills is more data, so on and so forth.

It script will complete the first query but then when i attempt to run the second query it give me a js error and just sits there.

Any help would be greatly appreciated.

Thanks in advance.

Example of my Code: http://www.codernetworks.com/Magellon/index.php

Below are my code snipits.

sqlqueries.js
  1. $(document).ready(function() { 
  2.       $("#Platform").change(function(event){
  3.             $.get("AJAX/query.php", { TestPlatform: document.getElementById("Platform").value},
  4.                   function(data) {
  5.                         alert("Data Loaded: " + data);
  6.                         $('#query').html(data);
  7.                   }
  8.             );
  9.       });
  10.      
  11.       $("#TestTypeSelect").change(function(event){
  12.             alert ("TestTypeSelected");
  13.             $.get("AJAX/query.php", { TestPlatform: document.getElementById("TestPlan").value, TestType: document.getElementById("TestTypeSelect").value }, 
  14.                   function(data) { 
  15.                         alert("Data Loaded: " + data); 
  16.                         $('#query').html(data); 
  17.                   }
  18.             );
  19.        }); 
  20. });


index.php
  1. <?php
  2.       ///////////////////////
  3.       // Connect to DB
  4.       ///////////////////////
  5.       $nDBInfo = array(
  6.       "Server"=> "**********",
  7.       "Database"=> "*********",
  8.       "UserName"=> "********",
  9.       "Password"=> "******");


  11.       $nDBLink = mysql_connect($nDBInfo['Server'], $nDBInfo['UserName'], $nDBInfo['Password']);
  12.       if (!$nDBLink) {
  13.             die('Could not connect: ' . mysql_error());
  14.       }

  16.       //Select the database we want to use
  17.       mysql_select_db($nDBInfo['Database']) or die("Could not select database");
  18.       mysql_query("set names utf8;");

  20.       //Selects All the Test Plans in `Test_Spec` ....     
  21.       $nSQL = "SELECT DISTINCT(TestPlan) AS 'Test Plans' FROM `Test_Spec` ;";
  22.       $result = mysql_query($nSQL);

  24.       while ($row = mysql_fetch_array($result)) {
  25.             $nOptions .= '<option value="'. $row[0] .'">'. $row[0] .'</option>';
  26.       }
  27.       mysql_close($nDBLink);
  28. ?>
  29. <html>
  30.       <head>
  31.             <script type="text/javascript" src="Javascript/jquery.js"></script>
  32.             <script type="text/javascript" src="Javascript/sqlqueries.js"></script>
  33.       </head>
  34.       <body>
  35.             <form>
  36.                   Select a Test Platform:
  37.                   <select id="Platform" name="users">
  38.                         <option value="Select"> Select </option>
  39.                         <?php echo $nOptions; ?>
  40.                   </select>
  41.             </form>
  42.             <br />
  43.             <div id="query"></div>
  44.       </body>
  45. </html>


query.php

  1. <?php
  2.       $nTestPlan = $_REQUEST["TestPlatform"];
  3.       $nTestType = $_REQUEST["TestType"];
  4.       echo $nTestPlan . "<br>";
  5.       echo $nTestType . "<br>";

  7.       ///////////////////////
  8.       // Connect to DB
  9.       ///////////////////////
  10.       $nDBInfo = array(
  11.       "Server"=> "**********",
  12.       "Database"=> "*********",
  13.       "UserName"=> "********",
  14.       "Password"=> "******");


  16.       $nDBLink = mysql_connect($nDBInfo['Server'], $nDBInfo['UserName'], $nDBInfo['Password']);
  17.       if (!$nDBLink) {
  18.             die('Could not connect: ' . mysql_error());
  19.       }


  21.       //Select the database we want to use
  22.       mysql_select_db($nDBInfo['Database']) or die("Could not select database");
  23.       mysql_query("set names utf8;");
  25.       if ($nTestPlan != ""){
  26.             //Selects All the Test Types in `Test_Data` ....
  27.             $nSQL = "SELECT DISTINCT(TestType) AS 'Test Type' FROM `Test_Data` WHERE `TestPlan` = '".$nTestPlan."' ;";
  28.             $result = mysql_query($nSQL);

  30.             while ($row = mysql_fetch_array($result)) {
  31.                   if ($row[0] == $nTestType & $row[0] != ""){
  32.                         $nOptions .= '<option value="'. $row[0] .'" selected="selected">'. $row[0] .'</option>';
  33.                   }else{
  34.                         $nOptions .= '<option value="'. $row[0] .'">'. $row[0] .'</option>';
  35.                   }           
  36.             }
  37.       }

  39.       if ($nTestType != ""){
  40.             //Selects All the Test Types in `Test_Data` ....
  41.             $nSQL = "SELECT DISTINCT(TestName) AS 'Test Name' FROM `Test_Data` WHERE `TestPlan` = '".$nTestPlan."' AND `TestType` = '".$nTestType."' ;";
  42.             $result = mysql_query($nSQL);

  44.             while ($row = mysql_fetch_array($result)) {
  45.                    $nOptions1 .= '<option value="'. $row[0] .'">'. $row[0] .'</option>';
  46.             }
  47.       }     
  48.       mysql_close($nDBLink);
  49. ?>

  51. <input type="hidden" id="TestPlan" value="<?php echo $nTestPlan; ?>">
  52. <input type="hidden" id="TestType" value="<?php echo $nTestType; ?>">
  53. <select id="TestTypeSelect" size="4" multiple="multiple">
  54.       <?php echo $nOptions; ?>
  55. </select>
  56. <select id="TestName" size="4" multiple="multiple">
  57.       <?php echo $nOptions1; ?>
  58. </select>
  59. <select id="TestResult" size="4" multiple="multiple">
  60.       <option value="1">Pass</option>
  61.       <option value="2">Fail</option>
  62. </select>























    • Topic Participants

    • coder