Tweet
Attempting to create report using HTML TABLE, and propogating with MYSQL data.
CODE:
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2
3 <html xmlns="http://www.w3.org/1999/xhtml">
4 <head>
5 <title>DEPARTMENT REPORT</title>
6 </head>
7 <body>
8 <h1>DEPARTMENT REPORT</h1>
9 <?php
10
11 // Connect to the database
12 include_once('connectvars.php');
13 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
14 or die('Error connecting to MySQL server.');
15
16 $query = "SELECT cr_id, cr_empl_num, cr_ci_num, cr_cert_exp_dte, cr_flag, ci_num, ci_desc, ci_authority, ce_dpt,
17 ce_name, ce_email, ce_phone_ext, ce_empl_num, cd_email, cd_num
18 FROM certification_record, certification_info, certification_employee, cert_department
19 WHERE cr_empl_num = ce_empl_num
20 AND ce_dpt = cd_num
21 AND cr_ci_num = ci_num
22 AND cr_flag > '00'";
23
24 $result = mysqli_query($dbc, $query)
25 or die('ERROR querying database');
26 ?>
27
28 <table border=1 style="background-color:#F0F8FF;">
29 <caption><EM>Nurse Certification Report</EM></caption>
30 <tr>
31 <th>Department Number</th>
32 <th>Employeer Number</th>
33 <th>Employee Name</th>
34 <th>Employeer Email</th>
35 <th>Employeer Phone Extention</th>
36
37 </tr>
38
39 <?php
40
41 WHILE ($row = mysqli_fetch_assoc($result)) {
42 echo "</td><td>";
43 echo $row['ce_dpt'];
44 echo "</td><td>";
45 echo $row['ce_empl_num'];
46 echo "</td><td>";
47 echo $row['ce_name'];
48 echo "</td></tr>";
49 echo $row['ce_email'];
50 echo "</td><td>";
51 echo $row['ce_phone_ext'];
52 echo "</td><td>";
53 }
54 echo "</table>";
55
56
57 ?>
58
59 </body>
60 </html>
CODE:
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2
3 <html xmlns="http://www.w3.org/1999/xhtml">
4 <head>
5 <title>DEPARTMENT REPORT</title>
6 </head>
7 <body>
8 <h1>DEPARTMENT REPORT</h1>
9 <?php
10
11 // Connect to the database
12 include_once('connectvars.php');
13 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
14 or die('Error connecting to MySQL server.');
15
16 $query = "SELECT cr_id, cr_empl_num, cr_ci_num, cr_cert_exp_dte, cr_flag, ci_num, ci_desc, ci_authority, ce_dpt,
17 ce_name, ce_email, ce_phone_ext, ce_empl_num, cd_email, cd_num
18 FROM certification_record, certification_info, certification_employee, cert_department
19 WHERE cr_empl_num = ce_empl_num
20 AND ce_dpt = cd_num
21 AND cr_ci_num = ci_num
22 AND cr_flag > '00'";
23
24 $result = mysqli_query($dbc, $query)
25 or die('ERROR querying database');
26 ?>
27
28 <table border=1 style="background-color:#F0F8FF;">
29 <caption><EM>Nurse Certification Report</EM></caption>
30 <tr>
31 <th>Department Number</th>
32 <th>Employeer Number</th>
33 <th>Employee Name</th>
34 <th>Employeer Email</th>
35 <th>Employeer Phone Extention</th>
36
37 </tr>
38
39 <?php
40
41 WHILE ($row = mysqli_fetch_assoc($result)) {
42 echo "</td><td>";
43 echo $row['ce_dpt'];
44 echo "</td><td>";
45 echo $row['ce_empl_num'];
46 echo "</td><td>";
47 echo $row['ce_name'];
48 echo "</td></tr>";
49 echo $row['ce_email'];
50 echo "</td><td>";
51 echo $row['ce_phone_ext'];
52 echo "</td><td>";
53 }
54 echo "</table>";
55
56
57 ?>
58
59 </body>
60 </html>