CODEWITHSUNDEEP
phphtmlcssmysql
Saranya Thirumeni
Saranya Thirumeni

Reputation: 55

Highlight or color the values of a specific row in table fetched using PHP and Mysql

I am a beginner to PHP. I am looking to highlight or color the values of first and last row in a table fetched using PHP and Mysql. Expected output

Below is the code.

 <?php
  $result_trend = mysql_query("select Week, New_Tickets, Closed_Tickets, 
  Backlogged, Resolution_Rate, Transactions from table");
  while($row = mysql_fetch_array($result_trend))
  {
  echo "<tr>";
  echo "<td>" . $row['Week'] . "</td>";
  echo "<td>" . $row['New_Tickets'] . "</td>";
  echo "<td>" . $row['Closed_Tickets'] . "</td>";
  echo "<td>" . $row['Backlogged'] . "</td>";
  echo "<td>" . $row['Resolution_Rate'] . "</td>";
  echo "<td>" . $row['Transactions'] . "</td>";
  }
  echo "</tr>";
  ?>

I am not really sure how to proceed further. Any suggestion is much appreciated. Thanks in advance.

Upvotes: 0

Views: 1626

Answers (2)

MaxZoom
MaxZoom

Reputation: 7753

You can define a CSS style for the first and last rows as below:

.my-table tbody tr:first-child {
  background-color: yellow;
}
<table class="my-table">
  <thead>
    <tr>
      <td>Col 1</td>
      <td>Col 2</td>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>First</td>
      <td>Row</td>
    </tr>
    <tr>
      <td>Second</td>
      <td>row</td>
    </tr>
    <tr>
      <td>Third</td>
      <td>row</td>
    </tr>
  </tbody>
</table>

Upvotes: 1

Matěj Račinsk&#253;
Matěj Račinsk&#253;

Reputation: 1804

You can simply obtain number of results and then count iterations. And if this is 1. row or last, add the style you need or css class that you'll style in your css file. Like this:

 <?php
  $result_trend = mysql_query("select Week, New_Tickets, Closed_Tickets, 
  Backlogged, Resolution_Rate, Transactions from table");
  $rows_count = mysql_num_rows($result_trend);
  $i = 0;
  while($row = mysql_fetch_array($result_trend))
  {
  $i++;
  $style = "";
  if($i == 1 || $i == $rows_count) {
  //  $style .= "bgcolor=\"#FF0000\""   //for inline style, bad practise
      $style .= "class=\"colorful\""
  }
  echo "<tr " . $style . ">";
  echo "<td>" . $row['Week'] . "</td>";
  echo "<td>" . $row['New_Tickets'] . "</td>";
  echo "<td>" . $row['Closed_Tickets'] . "</td>";
  echo "<td>" . $row['Backlogged'] . "</td>";
  echo "<td>" . $row['Resolution_Rate'] . "</td>";
  echo "<td>" . $row['Transactions'] . "</td>";
  }
  echo "</tr>";
  ?>

Upvotes: 0

Related Questions