[insert_php] $servername=’localhost’;
$username=’iceeduph10′;
$password=’iceeduph123!@#’;
$dbname = “admin_ice”;
$conn=mysqli_connect($servername,$username,$password,”$dbname”);
if(!$conn){
die(‘Could not Connect My Sql:’ .mysql_error());
}

[/insert_php]





[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GRADE 12 STEM’ order by lastname ASC”;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’

‘;
}

}
[/insert_php]

[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GRADE 12 – ABM’ order by lastname ASC “;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’

‘;
}

}
[/insert_php]

[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GRADE 12 HUMSS’ order by lastname ASC “;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’

‘;
}

}
[/insert_php]

[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GRADE 12 TVL ICT’ order by lastname ASC”;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’

‘;
}

}
[/insert_php]

[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GRADE 12 TVL-HE’ order by lastname ASC”;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’



Avatar

‘;
echo’

“‘.$row[‘myname’].'”


‘;
}

}
[/insert_php]

[insert_php] $sql = “select *,UPPER(concat(lastname)) as myname from tbl_info where grade = ‘GAS’ order by lastname ASC”;
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){

$img = $row[‘image’];
if(empty($img))
{
echo’

‘;
}
else
{
echo’



Avatar

‘;
echo’

“‘.$row[‘myname’].'”


‘;
}

}
[/insert_php]