|
Server IP : 172.16.15.8 / Your IP : 13.58.38.184 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/asbright/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$ID = "Male";
$host = "localhost";
$user = "asbright";
$pass = "Diablo2986!";
$database = "asbright";
$connect = mysql_connect($host, $user, $pass);
$query = "select * from STUDENT where GENDER = 'Male'";
print "The query is <i> $query </i>";
mysql_select_db($database);
$result_id = mysql_query($query, $connect);
if($result_id)
{
print "<table border = 1>";
print "<th> First Name <th> Last Name";
while($row = mysql_fetch_row($result_id))
{ print "<tr>";
foreach ($row as $field)
print "<td> $field </td> ";
print "</tr>";
}
}
else
print "fail";
mysql_close($connect);
?>