如何在动态while循环中使用活动的锚标记颜色？使用php和mysql

Question

Here is my Table

Here is my php code:

<?php
$sql=mysql_query("select * from parent_cat order by pid ");
while($row=mysql_fetch_array($sql))
{
$pid=$row['pid'];
?>
<div class="overallcopt"><a href="index.php?master=<?php echo $row['pid']; ?>"><?php echo $row['p_cat'];?></a></div>
<?php
}
?> 

1.If user click school ,school should be in active, I want to highlight school in red color and rest college and corporate should in black color, 2.If user click college ,college should be in active, I want to highlight college in red color and rest school and corporate should in black color, 3. Like wise for corporate,

Answer 1

In PHP, you can add active class on anchar as:

while($row=mysql_fetch_array($sql))
{
    $active = (intval($_GET['master']) == $row['pid'] ? 'class="active"' : '');
    ..........

Use this variable in your HTML:

<a <?=$active?> href="index.php?master=<?php echo $row['pid']; ?>"><?php echo $row['p_cat'];?></a>

Side Note:

Please use mysqli_* or PDO instead of mysql_* its deprecated and not available in PHP 7.