· 8 years ago · Jun 17, 2018, 12:26 PM
1`CREATE TABLE IF NOT EXISTS `attendance` (
2 `aid` int(11) NOT NULL AUTO_INCREMENT,
3 `Name_of_Student` varchar(100) COLLATE latin1_general_ci NOT NULL,
4 `Class` varchar(20) COLLATE latin1_general_ci NOT NULL,
5 `Roll_no` int(11) NOT NULL,
6 `Section` varchar(20) COLLATE latin1_general_ci NOT NULL,
7 `Status` binary(1) NOT NULL,
8 `time` varchar(20) COLLATE latin1_general_ci NOT NULL,
9 `Date` date NOT NULL,
10 PRIMARY KEY (`aid`)
11 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
12
13--
14-- Dumping data for table `attendance`
15--
16
17 INSERT INTO `attendance` (`aid`, `Name_of_Student`, `Class`, `Roll_no`, `Section`, `Status`, `time`, `Date`) VALUES
18 (1, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-01'),
19 (2, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-01'),
20 (3, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-02'),
21 (4, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-02'),
22 (5, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-03'),
23 (6, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-03'),
24 (7, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-04'),
25 (8, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-04'),
26 (9, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-05'),
27 (10, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-05'),
28 (11, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-06'),
29 (12, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-06'),
30 (13, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-07'),
31 (14, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-07'),
32 (15, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Morning', '2013-07-08'),
33 (16, 'Zonundanga', 'X', 5, 'A', 'Y', 'Morning', '2013-07-08'),
34 (17, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-01'),
35 (18, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-01'),
36 (19, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-02'),
37 (20, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-02'),
38 (21, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-03'),
39 (22, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-03'),
40 (23, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-04'),
41 (24, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-04'),
42 (25, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-05'),
43 (26, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-05'),
44 (27, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-06'),
45 (28, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-06'),
46 (29, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-07'),
47 (30, 'Zonundanga', 'X', 5, 'A', 'Y', 'Afternoon', '2013-07-07'),
48 (31, 'Lalchhandami', 'X', 1, 'A', 'Y', 'Afternoon', '2013-07-08'),
49 (32, 'Zonundanga', 'X', 5, 'A', 'N', 'Afternoon', '2013-07-08');`
50
51SELECT * FROM attendance
52
53$query = $dbh->query("SELECT * FROM attendance");
54
55$result = $query->fetchAll(PDO::FETCH_OBJ);
56$column = [];
57foreach($result as $key=>$val){
58 $column[$val->Name_of_Student][$val->Date][$val->time] = $val->Status;
59}
60
61$Status = [];
62$hming = [];
63?>
64<table border="1" align="center" width="100%">
65 <tr>
66 <th>Name</th>
67 <?php foreach($column as $dt=>$vt):
68 $hming[] = $dt;
69 foreach($vt as $k=>$v):
70 $Status[$k] = $v['Morning'];
71 $Status[$k] = $v['Afternoon'];
72 ?>
73 <th colspan="2"><?php echo $k; ?></th>
74 <?php endforeach; endforeach; ?>
75 </tr>
76 <?php foreach($hming as $name): ?>
77 <tr>
78 <td><?php echo $name; ?></td>
79 <?php foreach($Status as $time): ?>
80 <td><?php echo $time; ?></td>
81 <?php endforeach;?>
82 </tr>
83 <?php endforeach;?>
84</table>
85
86$query = $dbh->query("SELECT * FROM attendance");
87$result = $query->fetchAll(PDO::FETCH_OBJ);
88$column = [];
89foreach($result as $key=>$val){
90 $column[$val->Name_of_Student][$val->Date][$val->time] = $val->Status;
91}
92$dateat = [];
93foreach($column as $studentname=>$hming){
94 foreach($hming as $dt=>$nihming){
95 $dateat[$studentname][] = $dt;
96 }
97}
98$prevDate = [];
99?>
100<table border="1" align="center" width="80%" cellpadding="10" cellspacing="4">
101 <?php
102 echo "<tr>";
103 echo "<td>Name</td>";
104 foreach($dateat as $nk=>$nithar):
105 foreach($nithar as $atdate):
106 if (!in_array($atdate, $prevDate)) {
107 $prevDate[] = $atdate;
108 echo '<td colspan="2">'.$atdate."</td>n";
109 }
110 endforeach;
111 endforeach;
112 echo "</tr>";
113 foreach($column as $stname=>$stval):
114 echo "<tr>";
115 echo "<td>".$stname."</td>n";
116 foreach($stval as $sk=>$sv){
117 foreach($sv as $stt){
118 echo "<td>".$stt."</td>n";
119 }
120 }
121 echo "</tr>";
122 endforeach; ?>
123</table>
124
125<table>
126<tr><th>Sr no</th><th > .....//all of your table heads </th> </tr>
127<?php
128
129 $query = "select * from `attendance`";
130 $result = mysql_query($query);
131 $result = mysql_fetch_row($result);
132 foreach($result as $result)
133 {
134 echo "<tr><td>".$result['aid']."</td><td>all of id with index</td></tr>"
135 }
136 ?> </table>