问在ajax调用页中显示从ajax操作页到ajax输出表的总量。

EN

$customer=$_POST["from_date"];
  $item=$_POST["to_date"];
  $quantity=$_POST["qty"];
  $ins=mysqli_query($connect,"INSERT INTO sale(pr_id,customer_name,item,quantity,sale_date) VALUES ('$item','$customer','$item','$quantity','$date')");
  $query="SELECT p.pr_name,  p.mrp, s.quantity,s.customer_name FROM sale s JOIN product p ON ( s.pr_id = p.pr_id ) WHERE s.customer_name = '$customer' AND p.pr_id = '$item'";
  $result = mysqli_query($connect, $query);  
  $output = '';  
if(mysqli_num_rows($result) > 0)  
{  $i=0;
  while($row = mysqli_fetch_array($result))  
       { 
            $output .= '  
                 <tr> 
                      <td>'.$i.'</td> 
                      <td>'. $row["pr_name"] .'</td> 
                      <td>'. $row["quantity"] .'</td> 
                      <td>'. $row["mrp"] .'</td>  
                 </tr>  
            ';  
              $output .= '  

            ';  
$i++;
       }  
  }  
  else  
  {  
       $output .= '  
            <tr>  
                 <td colspan="5">No Order Found</td>  
            </tr>  
       ';  
  }  

  $output .= ' <tr> 
  <td><?php echo $i++; ?></td>
  <td>'. $row["pr_name"] .'</td> 
  <td>'. $row["quantity"] .'</td>
  <td>'. $row["mrp"] .'</td> 
  </tr>    
  ';  
  echo $output;  
}  
?>