Quote:
it show me table
Are you sure ?
After cleaning:
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$crime_type = $_POST['search'];
$sql = "select * from criminal_tbl where crime_type=:crime_type order by case_no DESC";
$stmt = $con->prepare($sql);
$stmt->bindParam('crime_type',$crime_type);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
while ($row = $stmt->fetch()){
echo"
<table border="3" style="width: 100%; height: 100%">
<tbody>
<tr align="center">
<td> </td>
<td> Information</td>
<td>Identity </td>
<td> Date of Birth </td>
<td> <span class="fa fa-eye"></span> </td>
</tr>
</tbody>
</table>
";
}
?>
This code produce 1
table per record with a
body meant to be a
header and missing the real body meant to contain the data.
Are you sire the question is about this code ?