有问题显示使用$ .post（）jquery和php从数据库返回图像

Question

I'm retrieving a table from database as result of a search action, but when I try to display the result I see the table and the data, but the image returned in each row is not render, I think my problem is in the $('#search').html(data), I'm not sure please someone knows what is the problem?

this is the result

http://s9.postimg.org/mro5qn46n/search_result.jpg

****This is the search page, where result table is displayed****

<table align="center">
  <tr>
     <td>
     <label for="criteria">Select Criteria</label>
     </td>
    <td>
       <select name="select" id="criteria">
           <option selected="true" style="display:none;"></option>              
           <option value="value1">name</option> 
           <option value="value2">apartment</option>
      </select>
  </td>
  <td>
      <input type="text" name="value" size="40" maxlength="60" id="value"\>
  </td>
  </tr>
  <tr>
  <td>
      <input name="name-submit" type="button" id="submit" value="Search"\>

  </td>
  </tr> 
  <tr>
  <td >
  <div id="search"></div>
  </td>
  </tr> 
</table> 

<script type="text/javascript" src="../js/jquery-1.11.1.min.js"></script>

<script type="text/javascript">
$('#submit').click(function(){

    var criteria = $("#criteria option:selected").text();
    var    value = $("#value").val();

    $.post("search_r.php",{criteria:criteria,value:value},function(data){

        $('#search').html(data);

          });

    });

</script> 

****This is the Page that calls $.post() in the main seach page ****

<?php
$criteria = $_POST['criteria'];
  $value = $_POST['value'];

      $con = mysqli_connect("localhost","root","");
            mysqli_select_db($con,"gables");

   $query = "SELECT * FROM residents WHERE $criteria = '$value'";       
  $result = mysqli_query($con,$query);

    echo "<table border='1'>
<tr>
<th>Id</th>
<th>Name</th>
<th>Last Name</th>
<th>Apartment</th>
<th>Parking</th>
<th>Phone1</th>
<th>Phone2</th>
<th>image</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
  echo "<tr>";
  echo "<td>" . $row['0'] . "</td>";
  echo "<td>" . $row['1'] . "</td>";
  echo "<td>" . $row['2'] . "</td>";
  echo "<td>" . $row['3'] . "</td>";
  echo "<td>" . $row['4'] . "</td>";
  echo "<td>" . $row['5'] . "</td>";
  echo "<td>" . $row['6'] . "</td>";

  echo "<td><img src=get_image.php?id=".$row['0']." width=160 height=120/></td>";   
  echo "</tr>";
}
echo "</table>";


?>

***Here the get_image.php****

<?php
$con = mysqli_connect("localhost","root","");
       mysqli_select_db($con,"gables");

$id = $_GET['id'];

$query = "SELECT * FROM residents WHERE id='$id'";
$result = mysqli_query($con,$query);

if($result)
$picture = mysqli_fetch_array($result);
header('Content-Type: image/jpg');

echo $picture['11'];

?>

Answer 1

You can chage the get_image.php file as this. Then this work will work.

<?php
function get_image($id){
$con = mysqli_connect("localhost","root","");
       mysqli_select_db($con,"gables");

$query = "SELECT * FROM residents WHERE id='$id'";
$result = mysqli_query($con,$query);

if($result)
$picture = mysqli_fetch_array($result);
return $picture['11'];
}
?>

Then use require_once(); function and in image src like this.echo "<td><img src='".get_image($row['0'])."' width=160 height=120/></td>";. In your code check how the src path will print and it will be print like as echo string, not as a execute the file.

echo 

    "<table border='1'>
    <tr>
    <th>Id</th>
    <th>Name</th>
    <th>Last Name</th>
    <th>Apartment</th>
    <th>Parking</th>
    <th>Phone1</th>
    <th>Phone2</th>
    <th>image</th>
    </tr>";
    require_once('search_r.php');
    while($row = mysqli_fetch_array($result))
    {
      echo "<tr>";
      echo "<td>" . $row['0'] . "</td>";
      echo "<td>" . $row['1'] . "</td>";
      echo "<td>" . $row['2'] . "</td>";
      echo "<td>" . $row['3'] . "</td>";
      echo "<td>" . $row['4'] . "</td>";
      echo "<td>" . $row['5'] . "</td>";
      echo "<td>" . $row['6'] . "</td>";

      echo "<td><img src='".get_image($row['0'])."' width=160 height=120/></td>";   
      echo "</tr>";
    }
    echo "</table>";