title: select BLOB type image and insert it to another table
body: <p>I have two table one is storing basic info with image type is blob and
  the other table is for attendance table , Now my problem is when i select all
   the table with basic info with image and insert it to another table the image
  column is only blank the rest has a value , Hope you can help fix it thanks.</p>
  
  <p>here is my php code:</p>
  
  <pre><code>&lt;?php 
  
  include_once('connection.php');
  if(isset($_POST['submit0'])){
  $rfid = $_POST['rfid'];
  
  $sql = mysqli_query($conn,"select * from stud where rfid_num ='$rfid'");
  $count = mysqli_num_rows($sql);
  
  if ($count == 0) {
  header("location:notexist.php");
  
      } else{
  
  while( $row = mysqli_fetch_array($sql)) {
                    $rfid=$row['rfid_num'];
                    $id=$row['id'];
                     $name0 = $row['name'];
                     $course0 = $row['course'];
                    $image = $row['image'];
  
       $InsertSql = "INSERT INTO student_att(rfid_num,id,name,course,image) VALUES ('$rfid','$id','$name0','$course0','$image')";
          $res = mysqli_query($conn, $InsertSql); 
  }
  }
  }
  ?&gt; 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/j40be.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/j40be.png" alt="this is the output of the query"></a></p>