0

I have an HTML/PHP page (sucessful.php) that gets a variable job_id from another page.

I am trying to send two variables and their data from this page to a page called interview.php but job_id is not getting passed to the other page.

Where is the problem?

successful.php

    <?php $getid =$_GET['jobid'];?>
    <html>
    <head>
        <link href="css/bootstrap.min.css" rel="stylesheet">

    <script>
    function showSuccess (str,$getid) {
      var job_id= $getid;

    var resp;
     if (window.XMLHttpRequest) {
        resp = new XMLHttpRequest();
        xmlhttp = new XMLHttpRequest();
    } else if (window.ActiveXObject) { 
        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
    var data = "q="+str+"job_id="+job_id

         xmlhttp.open("POST", 
          "interview.php"); 
         xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");                  
         xmlhttp.send(data);
       xmlhttp.onreadystatechange =
      function display_data() {
       if (xmlhttp.readyState == 4 && xmlhttp.status==200) {

            document.getElementById("txtHint").innerHTML=xmlhttp.responseText;


         } 
         }
      }


    </script>
    </head>
    <body>


    <div class="col-md-4 col-md-offset-4">
    <form>

        <?php 
    echo '<select name="number" onchange="showSuccess(this.value)" class="form-control">
      <option value="">Select a person:</option>
      <option value="1">1</option>

      <option value="5">5</option>
      <option value="0">0</option>
      <option value="10">10</option>
      <option value="15">15</option>
      <option value="20">20</option>
      <option value="25">25</option>
      <option value="30">30</option>
      <option value="35">35</option>
      <option value="40">40</option>
      <option value="45">45</option>
      <option value="50">50</option>
      <option value="55">55</option>
      <option value="60">60</option>
      <option value="65">65</option>
      <option value="70">70</option>
      <option value="75">75</option>
      <option value="80">80</option>
      <option value="85">85</option>
      <option value="90">90</option>
      <option value="95">95</option>
      <option value="100">100</option>
      </select>';
      ?>

    </form>
    </div>
    <br>
    <div id="txtHint" class="col-md-4 col-md-offset-4"><b>The candidates</b></div>
    </body>
    </html>

interview.php
<?php 
$q = intval($_POST['q']);
?>

    <?php 
    $getid = $_REQUEST['job_id'];?>

    <?php
    include('includes/conn.php');
    $row="SELECT  DISTINCT id,name,idNo,jobTitle,job,SUM(points) AS total FROM shortlist WHERE job='$getid' 
    GROUP BY idNo ORDER BY total DESC LIMIT $q";
    $query=mysqli_query($conn,$row) or die(mysqli_error($conn));

    while($row=mysqli_fetch_array($query))
    {
      echo "<p>".$row['name'].$row['total']."</p>";

    }

    mysqli_close($conn);
    ?>
Improve this question
0

2 Answers 2

Reset to default
1

You are using POST so it should be:

var data = {q:str,job_id:job_id};

If you want get , change the method to GET then append the data as a query string:

var data = "?q="+str+"&job_id="+job_id;

And pass the job id to the function:

echo '<select name="number" onchange="showSuccess(this.value,'.$_GET['jobid'].')" class="form-control">

AJAX

<html>
<head>
    <link href="css/bootstrap.min.css" rel="stylesheet">
<script>
window.onload = function() {
    function showSuccess (){
        var success = document.getElementById("success");
        //parameters
        var e = document.getElementByName("number");
        var selectedNumber = e.options[e.selectedIndex].value;
        var jobId = document.getElementById("jobId").value;
        //data to send
        var params = {q:selectedNumber,job_id:jobId};

        var xmlhttp = new XMLHttpRequest();
        xmlhttp.open("POST", "interview.php", true);
        xmlhttp.setRequestHeader("Content-type", "application/json");
        xmlhttp.onreadystatechange = function() {
            if(xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                var data = JSON.parse(xmlhttp.responseText);
                var html='';
                for (var i in data) {
                    html +=  "<p>" + data.name + data.total + "</p>";
                }
                //print success to the div
                success.innerHTML=html; 
            }
        }
        xmlhttp.send(null);
    }
}
</script>
</head>
<body>
<div class="col-md-4 col-md-offset-4">
<form>
<select name="number" onchange="showSuccess()" class="form-control">
  <option value="">Select a person:</option>
  <option value="1">1</option>
  <option value="5">5</option>
  <option value="0">0</option>
  <option value="10">10</option>
  <option value="15">15</option>
  <option value="20">20</option>
  <option value="25">25</option>
  <option value="30">30</option>
  <option value="35">35</option>
  <option value="40">40</option>
  <option value="45">45</option>
  <option value="50">50</option>
  <option value="55">55</option>
  <option value="60">60</option>
  <option value="65">65</option>
  <option value="70">70</option>
  <option value="75">75</option>
  <option value="80">80</option>
  <option value="85">85</option>
  <option value="90">90</option>
  <option value="95">95</option>
  <option value="100">100</option>
  </select>
</form>
</div>
<br>
<div id="txtHint" class="col-md-4 col-md-offset-4"><b>The candidates</b></div>
<div id="success"></div>
<input id="jobId" value="<?php echo $_GET['job_id'] ?>" />
</body>
</html>

PHP

<?php 
$q = intval($_POST['q']);
$job_id = $_POST['job_id'];
include('includes/conn.php');
$row="SELECT  DISTINCT id,name,idNo,jobTitle,job,SUM(points) AS total FROM shortlist WHERE job='$job_id' 
GROUP BY idNo ORDER BY total DESC LIMIT $q";
$query=mysqli_query($conn,$row) or die(mysqli_error($conn));
$data = array();
while($row=mysqli_fetch_array($query)){
 $data[]=$row;
}
mysqli_close($conn);
echo json_encode($data);
?>
Improve this answer
Sign up to request clarification or add additional context in comments.

6 Comments

I have edited and I get this error from firebug."ReferenceError: NCAGR002 is not defined".But am wondering why because the job_id passed is NCAGR002/5/2015.where is the bug?...When I use var data = {q:str,job_id:job_id}; with POST i get an error that both q and job_id are unknown index
@user3752159 see my edit , you have multiple problems
thanks.Let me try it out.
so what happened @user3752159
i had to use var data = "q="+str+"&job_id="+(job_id); and it worked @meda.
|
0

You need to build this string like this, using &:

var data = "q="+str+"&job_id="+encodeURIComponent(job_id);

You also need to access $getid PHP variable this way:

var job_id='<?php echo $getid ?>';

in your showSuccess function, as you combine PHP with javascript - you can remove second parameter then.

Improve this answer

10 Comments

,It has worked but not displaying any value.The firebug gives the following error "ReferenceError: NCAGR002 is not defined".But am wondering why because the job_id passed is NCAGR002/5/2015.where is the bug?
oops, it tried to divide it by 5 and by 2015 - I updated it, adding quotes around echoed variable $getid. To be sure there are no forbidden characters, use encodeURIComponent building query string.
I have used it but the error still pops out.
the same error? Have you cleared the cache with Ctrl+F5?
When i put the quotes both q and job_id becomes undefined @n-dru
|

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.