How can I change the color of some data extracted from my BD, for example if it is on a slope it is yellow and when it is resolved it is green.
<?php
$con=@mysqli_connect('localhost', 'root', '', 'bdpagina');
if(!$con){
die("imposible conectarse: ".mysqli_error($con));
}
if (@mysqli_connect_errno()) {
die("Connect failed: ".mysqli_connect_errno()." : ".
mysqli_connect_error());
}
$action = (isset($_REQUEST['action'])&& $_REQUEST['action'] !=NULL)?
$_REQUEST['action']:'';
if($action == 'ajax'){
include 'pagination.php';
$page = (isset($_REQUEST['page']) && !empty($_REQUEST['page']))?
$_REQUEST['page']:1;
$per_page = 10; //la cantidad de registros que desea mostrar
$adjacents = 4; //brecha entre páginas después de varios adyacentes
$offset = ($page - 1) * $per_page;
//Cuenta el número total de filas de la tabla*/
$count_query = mysqli_query($con,"SELECT count(*) AS numrows FROM contribuyente ");
if ($row= mysqli_fetch_array($count_query)){$numrows = $row['numrows'];}
$total_pages = ceil($numrows/$per_page);
$reload = 'index.php';
$query = mysqli_query($con,"SELECT * FROM contribuyente order by id LIMIT $offset,$per_page");
if ($numrows>0){
?>
<table class="my-table">
<thead>
<tr>
<th>Folio</th>
<th>Nombre</th>
<th>Rut</th>
<th>Correo</th>
<th>Telefono</th>
<th>Direccion</th>
<th>Poste</th>
<th>Solicitud</th>
<th>Fecha</th>
<th>Estado</th>
<th>Borrar</th>
<th>Reporte</th>
</tr>
</thead>
<tbody>
<?php
while($row = $res->fetch_array(MYSQLI_BOTH)){
?>
<tr>
<td><?php echo $row[0];?></td>
<td><?php echo $row[1];?></td>
<td><?php echo $row[2];?></td>
<td><?php echo $row[3];?></td>
<td><?php echo $row[4];?></td>
<td><?php echo $row[5];?></td>
<td><?php echo $row[6];?></td>
<td><?php echo $row[7];?></td>
<td><?php echo $row[8];?></td>
<td><?php echo $row[9];?></td>
<?php echo "<td><a href='admin.php?id=$row[0]&idborrar=2'><img src='./images/eliminar.png' class='img-rounded'/></a></td>";
echo "<td><a href='actualizar.php?id=$row[0]'><img src='./images/editar.png' class='img-rounded'></td>";?>
</tr>
<?php
}
?>