使用php-mysql时如何显示带超链接的emaiIds

Question

I am display the contents of mysql table using php. Based on the user inputs, I will do some querying and the results results will be stored in an array and displayed. Now I have emilIds in the output, when I display the table in the webpage, I want to display with hyperlinks. How can I achieve this. Thanks in advance.

if($result2->num_rows > 0){
    echo '<table width="100%" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" border="1" class="db-table" boarder-collapse ="collapse">';
    echo '<tr><th>STUDENT_NAME</th><th>CLASS</th><th>ID_NUMBER</th><th>ADDRESS</th><th>CITY</th><th>STATE</th><th>ZIP</th><th>COUNTRY</th><th>PHONE</th><th>INSURANCE</th>
<th>EMAIL</th><th>MAILING_ADDRESS</th><th>JOINED_ON</th></tr>';

    while($rowz2 = mysqli_fetch_assoc($result2)){
        echo "<tr>";
        foreach($rowz2 as $key=>$value){
            echo '<td>',$value,'</td>';
        }                                                                                                                     
        echo '</tr>';
   }
   echo "</table><br/>";


}

else{
    echo "<h2>No data based on the entered values</h2>";
}

Answer 1

I cannot comment yet so i will post it here. Check if your database column is 'email' or 'EMAIL' because

if ($key == 'EMAIL')

is case sensitive and as such it will never pass the condition if column is 'email'. If for some reason you need a case insensitive string comparison use:

if (strcasecmp($key, 'EMAIL') === 0)