title: How can i add one more filed for image upload and show?
body: <p>can add one more field for image that saved in mysql i am unable to add by js </p>
  
  <p>this is my index.php script how can i add image field in this script just want to show image from mysql </p>
  
  <p><strong>index.php</strong></p>
  
  <pre><code>&lt;body&gt;  
          &lt;div class="container"&gt;  
     &lt;br /&gt;
     &lt;div class="table-responsive"&gt;  
  
      &lt;div id="grid_table"&gt;&lt;/div&gt;
     &lt;/div&gt;  
    &lt;/div&gt;
      &lt;/body&gt;  
  &lt;/html&gt;  
  &lt;script&gt;
  
      $('#grid_table').jsGrid({
  
       width: "100%",
       height: "600px",
  
       filtering: true,
       inserting:true,
       editing: true,
       sorting: true,
       paging: true,
       autoload: true,
       pageSize: 10,
       pageButtonCount: 5,
       deleteConfirm: "Do you really want to delete data?",
  
       controller: {
        loadData: function(filter){
         return $.ajax({
          type: "GET",
          url: "fetch_data.php",
          data: filter
         });
        },
        insertItem: function(item){
         return $.ajax({
          type: "POST",
          url: "fetch_data.php",
          data:item
         });
        },
        updateItem: function(item){
         return $.ajax({
          type: "PUT",
          url: "fetch_data.php",
          data: item
         });
        },
        deleteItem: function(item){
         return $.ajax({
          type: "DELETE",
          url: "fetch_data.php",
          data: item
         });
        },
       },
  
       fields: [
        {
         name: "id",
      type: "hidden",
      css: 'hide'
        },
        {
         name: "first_name", 
      type: "text", 
      width: 150, 
      validate: "required"
        },
        {
         name: "last_name", 
      type: "text", 
      width: 150, 
      validate: "required"
        },
        {
         name: "age", 
      type: "text", 
      width: 50, 
      validate: function(value)
      {
       if(value &gt; 0)
       {
        return true;
       }
      }
        },
        {
         name: "gender", 
      type: "select", 
      items: [
       { Name: "", Id: '' },
       { Name: "Male", Id: 'male' },
       { Name: "Female", Id: 'female' }
      ], 
      valueField: "Id", 
      textField: "Name", 
      validate: "required"
        },
        {
         type: "control"
        }
       ]
  
      });
  
  &lt;/script&gt;
  </code></pre>
  
  <p>this my fetch_data.php file how can i add image field in this script just want to show image from mysql </p>
  
  <p><strong>fetch_data.php</strong></p>
  
  <pre><code>&lt;?php
  
  $connect = new PDO("mysql:host=localhost;dbname=testing", "root", "");
  
  $method = $_SERVER['REQUEST_METHOD'];
  
  if($method == 'GET')
  {
   $data = array(
    ':first_name'   =&gt; "%" . $_GET['first_name'] . "%",
    ':last_name'   =&gt; "%" . $_GET['last_name'] . "%",
    ':age'     =&gt; "%" . $_GET['age'] . "%",
    ':gender'    =&gt; "%" . $_GET['gender'] . "%"
   );
   $query = "SELECT * FROM sample_data WHERE first_name LIKE :first_name AND last_name LIKE :last_name AND age LIKE :age AND gender LIKE :gender ORDER BY id DESC";
  
   $statement = $connect-&gt;prepare($query);
   $statement-&gt;execute($data);
   $result = $statement-&gt;fetchAll();
   foreach($result as $row)
   {
    $output[] = array(
     'id'    =&gt; $row['id'],   
     'first_name'  =&gt; $row['first_name'],
     'last_name'   =&gt; $row['last_name'],
     'age'    =&gt; $row['age'],
     'gender'   =&gt; $row['gender']
    );
   }
   header("Content-Type: application/json");
   echo json_encode($output);
  }
  
  if($method == "POST")
  {
   $data = array(
    ':first_name'  =&gt; $_POST['first_name'],
    ':last_name'  =&gt; $_POST["last_name"],
    ':age'    =&gt; $_POST["age"],
    ':gender'   =&gt; $_POST["gender"]
   );
  
   $query = "INSERT INTO sample_data (first_name, last_name, age, gender) VALUES (:first_name, :last_name, :age, :gender)";
   $statement = $connect-&gt;prepare($query);
   $statement-&gt;execute($data);
  }
  
  if($method == 'PUT')
  {
   parse_str(file_get_contents("php://input"), $_PUT);
   $data = array(
    ':id'   =&gt; $_PUT['id'],
    ':first_name' =&gt; $_PUT['first_name'],
    ':last_name' =&gt; $_PUT['last_name'],
    ':age'   =&gt; $_PUT['age'],
    ':gender'  =&gt; $_PUT['gender']
   );
   $query = "
   UPDATE sample_data 
   SET first_name = :first_name, 
   last_name = :last_name, 
   age = :age, 
   gender = :gender 
   WHERE id = :id
   ";
   $statement = $connect-&gt;prepare($query);
   $statement-&gt;execute($data);
  }
  
  if($method == "DELETE")
  {
   parse_str(file_get_contents("php://input"), $_DELETE);
   $query = "DELETE FROM sample_data WHERE id = '".$_DELETE["id"]."'";
   $statement = $connect-&gt;prepare($query);
   $statement-&gt;execute();
  }
  
  ?&gt;
  </code></pre>