get_data.php

<?php
 $connect = mysqli_connect("localhost", "root", "", "db_fmea");
 $output = '';
 $status = '';
 if(isset($_POST["idWorksheet"]))
 {
      if($_POST["idWorksheet"] != '')
      {
           $sql = "SELECT *
  FROM `data_fmea` AS df
  LEFT JOIN approve_q AS aq ON(aq.id_approve_q = df.id_approve_q)
  WHERE df.id_worksheet = '".$_POST["idWorksheet"]."'";
      }
      else
      {
           $sql = "SELECT *
  FROM `data_fmea` AS df
  LEFT JOIN approve_q AS aq ON(aq.id_approve_q = df.id_approve_q)";
      }
      $result = mysqli_query($connect, $sql);
      while($data = mysqli_fetch_array($result))
      {
    //Logic Status
        if ($data['status_aq'] == "Approved"){
            $status = '<font color=blue>'.$data['status_aq'].'</font>';
        }else if ($data['status_aq'] == "Cancel"){
            $status = '<font color=red>'.$data['status_aq'].'</font>';
    }else if ($data['status_aq'] == "On Progress"){
      $status = '<font color=#737373>'.$data['status_aq'].'</font>';
    }else {
          $status = '';
    }
          $output .= '
  <tr>
        <th>
<a class="btn btn-link btn-primary btn-md info_modal" data-toggle="tooltip" data-original-title="Information" id="'.$data ['id_fmea'].'"><span class="fa fa-eye" style="color: black;"></span></a>

<a href="modifydata.php"  class="btn btn-link btn-primary btn-md open_delete" data-toggle="tooltip" data-original-title="Modify" id="'.$data ['id_fmea'].'"><span class="fa fa-edit" style="color: #31e437"></span></a>


<a href="history_pre-treatment.php"  class="btn btn-link btn-primary btn-md" data-toggle="tooltip" data-original-title="History" id="'.$data['id_fmea'].'"><span class="fa fa-history" style="color: #d82c2c;"></span></a>

<a  class="btn btn-link btn-primary btn-md open_approve" data-toggle="tooltip" data-original-title="Approve" id="'.$data ['id_fmea'].'"><span class="fa fa-check" style="color: #3190d6"></span></a>
    </th>
    <td>'.$data['requirement'].'</td>
    <td>'.$data['process_name'].'</td>
    <td>'.$data['p_failuremode'].'</td>
    <td>'.$data['p_effectfail'].'</td>
    <td>'.$data['s_severity'].'</td>
    <td>'.$data['cause_a_mechanism'].'</td>
    <td>'.$data['o_occurrence'].'</td>
    <td>'.$data['cpcs_prevent'].'</td>
    <td>'.$data['cpcs_detec'].'</td>
    <td>'.$data['d_detection'].'</td>
    <td>'.$data['rpn1'].'</td>
    <td>'.$data['improv_item_est'].'</td>
    <td>'.$data['improv_pic'].'</td>
    <td>'.$data['completion_date'].'</td>
    <td>'.$data['improv_res_cont'].'</td>
    <td>'.$data['improv_res_stan'].'</td>
    <td>'.$data['improv_s'].'</td>
    <td>'.$data['improv_o'].'</td>
    <td>'.$data['improv_d'].'</td>
    <td>'.$data['rpn2'].'</td>
    <td align="center">'.$status.'</td>
  </tr>';
      }
      echo $output;
 }
 ?>