· 7 years ago · Jan 18, 2019, 01:34 AM
1VIEW.PHP
2<?php
3session_start();
4 //Connect to database
5 require('connectDB.php');
6//**********************************************************************************************
7
8 //Get current date and time
9 date_default_timezone_set('put here your time region');
10 $d = date("Y-m-d");
11
12 $Tarrive = mktime(2,15,00);
13 $TimeArrive = date("H:i:s", $Tarrive);
14//********************************************************************************************
15 $Tleft = mktime(2,30,00);
16 $Timeleft = date("H:i:s", $Tleft);
17
18?>
19<!DOCTYPE html>
20<html>
21<head>
22<meta charset="utf-8">
23<meta name="viewport" content="width=device-width, initial-scale=1.0">
24<style>
25body {background-image:url("image/2.jpg");background-repeat:no-repeat;background-attachment:fixed;
26 background-position: top right;
27 background-size: cover;}
28
29header .head h1 {font-family:aguafina-script;text-align: center;color:#ddd;}
30header .head img {float: left;}
31header .opt {float: right;margin: -100px 20px 0px 0px}
32header .opt a {text-decoration: none;font-family:cursive;text-align: center;font-size:20px;color:red;margin-right: 15px}
33header .opt a:hover {opacity: 0.8;cursor: pointer;}
34header .opt #inp {padding:3px;margin:0px 0px 0px 33px;background-color:#00A8A9;font-family:cursive;font-size:16px; opacity: 0.6;color:red;}
35header .opt #inp:hover {background-color: #00A8A9; opacity: 0.8;}
36header .opt input {padding-left:5px;margin:2px 0px 3px 20px;border-radius:7px;border-color: #A40D0F ;background-color:#8E8989; color: white;}
37header .opt p {font-family:cursive;text-align: left;font-size:19px;color:#f2f2f2;}
38.export {margin: 0px 0px 10px 20px; background-color:#900C3F ;font-family:cursive;border-radius: 7px;width: 145px;height: 28px;color: #FFC300; border-color: #581845;font-size:17px}
39.export:hover {cursor: pointer;background-color:#C70039}
40#table {
41 font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
42 border-collapse: collapse;
43 width: 100%;
44}
45
46#table td, #table th {
47 border: 1px solid #ddd;
48 padding: 8px;
49 opacity: 0.6;
50}
51
52#table tr:nth-child(even){background-color: #f2f2f2;}
53#table tr:nth-child(odd){background-color: #f2f2f2;opacity: 0.9;}
54
55#table tr:hover {background-color: #ddd; opacity: 0.8;}
56
57#table th {
58 opacity: 0.6;
59 padding-top: 12px;
60 padding-bottom: 12px;
61 text-align: left;
62 background-color: #00A8A9;
63 color: white;
64}
65</style>
66</head>
67<body>
68 <header >
69 <div class="head">
70 <img src="image/rfid1.jpg" width="80" height="80">
71 <h1>RFID auto recorder<br>
72 Login System</h1>
73 </div>
74 <div class="opt">
75 <table border="0">
76 <tr>
77 <td><a href="AddCard.php">Add a new User
78 <img src="image/add.png" style="margin:10px 20px -5px 10px" width="30" title="Add"></a></td>
79 <td><p>Select the date log:
80 <form method="POST" action="">
81 <input type="date" name="date"><br>
82 <input type="submit" name="seldate" value="Select Date" id="inp">
83 </form>
84 </p></td>
85 </tr>
86 </table>
87 </div>
88 </header>
89<div id="cards" class="cards">
90<h2 style="margin-left: 15px;">Time to arrive :<?php echo $TimeArrive?><br>
91 Time to leave :<?php echo $Timeleft?></h2>
92
93 <form method="post" action="export.php">
94 <input type="submit" name="export" class="export" value="Export to Excel" />
95 </form>
96
97<?php
98
99if (!empty($_POST['seldate']))
100 {
101 $seldate = $_POST['date'];
102 }
103else
104 {
105 $seldate = $d;
106 }
107
108$sql = "SELECT * FROM logs WHERE DateLog='$seldate' ORDER BY id DESC";
109
110if ($result=mysqli_query($conn,$sql))
111{
112
113 echo "<TABLE id='table'>";
114 echo "<TR>
115 <TH>ID.No</TH>
116 <TH>Name</TH>
117 <TH>CardID</TH>
118 <TH>SerialNumber</TH>
119 <TH>Date</TH>
120 <TH>Time In</TH>
121 <TH>Time Out</TH>
122 <TH>User Status</TH>
123 </TR>";
124 while ($row=$result->fetch_assoc())
125 {
126
127 if (empty($row['TimeOut']))
128 {
129 $sta = "<img src='image/chec.png' style='margin-right: 30px' width='30' title='Not finished yet'>";
130 }
131 else
132 {
133 if ($row['TimeOut'] > $Timeleft )
134 {
135 $sta = "<img src='image/che.png' style='margin-right: 30px' width='30' title='finished'>";
136
137 }
138 elseif ($row['TimeOut'] < $Timeleft )
139 {
140 $sta = "<img src='image/al.png' style='margin-right: 30px' width='30' title='Left early'>";
141 }
142
143 }
144?>
145 <TR>
146 <TD><?php echo $row['id'];?></TD>
147 <TD><?php echo $sta; echo $row['Name'];?></TD>
148 <TD><?php echo $row['CardNumber'];?></TD>
149 <TD><?php echo $row['SerialNumber'];?></TD>
150 <TD><?php echo $row['DateLog'];?></TD>
151 <TD><?php echo $row['TimeIn'];?></TD>
152 <TD><?php echo $row['TimeOut'];?></TD>
153 <TD><?php echo $row['UserStat'];?></TD>
154 </TR>
155<?php
156
157 }
158 echo "</TABLE>";
159}
160
161 $_SESSION['exportdata'] = $seldate;
162
163?>
164</body>
165</html>
166
167
168POSTDEMO.PHP
169
170<?php
171 //Connect to database
172 require('connectDB.php');
173//**********************************************************************************************
174 //Get current date and time
175 date_default_timezone_set('put here your time region');//Europe/London
176 $d = date("Y-m-d");
177 $t = date("H:i:s");
178//**********************************************************************************************
179 $Tarrive = mktime(18,15,00);
180 $TimeArrive = date("H:i:sa", $Tarrive);
181//**********************************************************************************************
182 $Tleft = mktime(20,30,00);
183 $Timeleft = date("H:i:sa", $Tleft);
184//**********************************************************************************************
185
186 if(!empty($_GET['CardID']))
187 {
188 $Card = $_GET['CardID'];
189 $result = $conn->query("SELECT * FROM users WHERE CardID='$Card'");
190
191 if ( $result->num_rows > 0 )
192 {
193
194 $row=$result->fetch_assoc();
195
196 if (!empty($row['username']) && !empty($row['SerialNumber']))
197 {
198
199 $resultl = $conn->query("SELECT * FROM logs WHERE CardNumber='$Card' AND DateLog=CURDATE()");
200 $rowl= $resultl->fetch_assoc();
201
202 if ( $resultl->num_rows > 0 )
203 {
204 if ($t >= $Timeleft && $rowl['TimeIn'] <= $TimeArrive)
205 {
206 $UserStat = "Arrived and Left on time";
207 }
208 elseif ($t < $Timeleft && $rowl['TimeIn'] > $TimeArrive)
209 {
210 $UserStat = "Arrived late and Left early";
211 }
212 elseif ($t < $Timeleft && $rowl['TimeIn'] <= $TimeArrive)
213 {
214 $UserStat = "Arrived on time and Left early";
215 }
216 elseif ($t >= $Timeleft && $rowl['TimeIn'] > $TimeArrive)
217 {
218 $UserStat = "Arrived late and Left on time";
219 }
220
221 $sqlll="UPDATE logs SET TimeOut=CURTIME(), UserStat ='$UserStat' WHERE CardNumber='$Card' AND DateLog=CURDATE()";
222 if ($conn->query($sqlll) === true)
223 {
224 echo "logout";
225 }
226 }
227 //*******************************************************************************
228 else
229 {
230 if ($t <= $TimeArrive)
231 {
232 $UserStat = "Arrived on time";
233 }
234 else
235 {
236 $UserStat = "Arrived late";
237 }
238
239 if ($t <= $Timeleft)
240 {
241 $Uname = $row['username'];
242 $Number = $row['SerialNumber'];
243
244 $sqll = "INSERT INTO
245 logs (CardNumber, Name, SerialNumber, DateLog, TimeIn, UserStat) "
246 . "VALUES ('$Card' ,'$Uname', '$Number', CURDATE(), CURTIME(), '$UserStat')";
247 if ($conn->query($sqll) === true)
248 {
249 echo "login";
250 }
251 }
252 else
253 {
254 $Uname = $row['username'];
255 $Number = $row['SerialNumber'];
256 $UserStat = "Arrived very late";
257
258 $sqll = "INSERT INTO
259 logs (CardNumber, Name, SerialNumber, DateLog, TimeIn, TimeOut, UserStat) "
260 . "VALUES ('$Card' ,'$Uname', '$Number', CURDATE(), CURTIME(), '0', '$UserStat')";
261 if ($conn->query($sqll) === true)
262 {
263 echo "login";
264 }
265 }
266 }
267 }
268 //**********************************************************************************
269 else
270 {
271 echo "Cardavailable";
272 }
273 }
274//**********************************************************************************************
275 else
276 {
277 $sql = "INSERT INTO users (CardID) " . "VALUES ('$Card')";
278
279 if ($conn->query($sql) === true)
280 {
281 echo "succesful";
282 }
283 }
284 }
285
286?>
287
288
289EXPORT.PHP
290
291<?php
292session_start();
293 //Connect to database
294 require('connectDB.php');
295
296$output = '';
297$outputdata = $_SESSION['exportdata'];
298if(isset($_POST["export"]))
299{
300 $query = "SELECT * FROM logs WHERE DateLog='$outputdata' ";
301 $result = mysqli_query($conn, $query);
302 if($result->num_rows > 0)
303 {
304 $output .= '
305 <table class="table" bordered="1">
306 <TR>
307 <TH>ID.No</TH>
308 <TH>Name</TH>
309 <TH>CardID</TH>
310 <TH>SerialNumber</TH>
311 <TH>Date</TH>
312 <TH>Time In</TH>
313 <TH>Time Out</TH>
314 <TH>User Status</TH>
315 </TR>
316 ';
317 while($row=$result->fetch_assoc())
318 {
319 $output .= '
320 <tr>
321 <TD> '.$row['id'].'</TD>
322 <TD> '.$row['Name'].'</TD>
323 <TD> '.$row['CardNumber'].'</TD>
324 <TD> '.$row['SerialNumber'].'</TD>
325 <TD> '.$row['DateLog'].'</TD>
326 <TD> '.$row['TimeIn'].'</TD>
327 <TD> '.$row['TimeOut'].'</TD>
328 <TD> '.$row['UserStat'].'</TD>
329 </tr>
330 ';
331 }
332 $output .= '</table>';
333 header('Content-Type: application/xls');
334 header('Content-Disposition: attachment; filename=UserLog'.$outputdata.'.xls');
335 echo $output;
336 }
337 else
338 {
339 header( "location: view.php" );
340 }
341}
342?>
343
344INSTALL.PHP
345
346<?php
347 //Connect to database
348 $servername = "localhost";
349 $username = "root";
350 $password = "";
351 $dbname = "";
352
353 $conn = new mysqli($servername, $username, $password, $dbname);
354
355 // Create database
356 $sql = "CREATE DATABASE nodemculog";
357 if ($conn->query($sql) === TRUE) {
358 echo "Database created successfully";
359 } else {
360 echo "Error creating database: " . $conn->error;
361 }
362
363 echo "<br>";
364
365 $dbname = "nodemculog";
366
367 $conn = new mysqli($servername, $username, $password, $dbname);
368 //Sr No, Station, Status(OK, NM, WM, ACK) Date, Time
369 //1 A NM 12-5-18 12:15:00 am
370 // sql to create table
371 $sql = "CREATE TABLE IF NOT EXISTS `logs` (
372 `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
373 `CardNumber` double DEFAULT NULL,
374 `Name` varchar(30) DEFAULT NULL,
375 `SerialNumber` double NOT NULL,
376 `DateLog` date DEFAULT NULL,
377 `TimeIn` time DEFAULT NULL,
378 `TimeOut` time DEFAULT NULL,
379 `UserStat` varchar(100) NOT NULL,
380 PRIMARY KEY (`id`)
381 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=264";
382
383 if ($conn->query($sql) === TRUE) {
384 echo "Table logs created successfully";
385 } else {
386 echo "Error creating table: " . $conn->error;
387 }
388
389 $sql = "CREATE TABLE IF NOT EXISTS `users` (
390 `id` int(11) NOT NULL AUTO_INCREMENT,
391 `username` varchar(100) NOT NULL,
392 `SerialNumber` double NOT NULL,
393 `gender` varchar(100) NOT NULL,
394 `CardID` double NOT NULL,
395 PRIMARY KEY (`id`)
396 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58";
397
398 if ($conn->query($sql) === TRUE) {
399 echo "Table users created successfully";
400 } else {
401 echo "Error creating table: " . $conn->error;
402 }
403
404 $conn->close();
405?>
406
407CONNECTDB.PHP
408
409<?php
410/* Database connection settings */
411 $servername = "localhost";
412 $username = "root";
413 $password = "";//if your phpmyadmin has a password put it here.
414 $dbname = "nodemculog";
415
416 $conn = new mysqli($servername, $username, $password, $dbname);
417
418 if ($conn->connect_error) {
419 die("Database Connection failed: " . $conn->connect_error);
420 }
421?>
422
423ADDCARD.PHP
424<?php
425session_start();
426
427 //Connect to database
428 require('connectDB.php');
429//**********************************************************************************************
430//**********************************************************************************************
431 if (empty($Cid))
432 {
433 $result =$conn->query("SELECT CardID FROM users WHERE username='' ");
434 if ( $result->num_rows > 0 )
435 {
436 $row=$result->fetch_assoc();
437 $Cid= $row['CardID'];
438 $_SESSION[ 'card' ] = $row['CardID'];
439 $_SESSION[ 'alert' ] = "<img src='image/al.png' style='margin-right: 20px' width='30'>There's an available cards. ";
440 $_SESSION[ 'message' ] ="";
441 }
442 else{
443 $_SESSION[ 'alert' ] = "<img src='image/al.png' style='margin-right: 20px' width='30'>There's no available cards. ";
444 $Cid= "";
445 $_SESSION[ 'message' ] ="No thing";
446 }
447 }
448//**********************************************************************************************
449//**********************************************************************************************
450 if ($_SERVER["REQUEST_METHOD"] == "POST")
451{
452 if(isset($_POST['login']) && !empty($_SESSION[ 'card' ]) && !empty($Cid))
453 {
454 $CardID = $_SESSION[ 'card' ];
455 //define other variables with submitted values from $_POST
456 $Uname = $conn->escape_string($_POST['Uname']);
457 $Number = $conn->escape_string($_POST['Number']);
458 $gender= $conn->escape_string($_POST['gender']);
459
460 $result = $conn->query("SELECT * FROM users WHERE SerialNumber='$Number' ");
461 if ( $result->num_rows > 0 )
462 {
463 $_SESSION[ 'message' ] = "The Number already taken!";
464 }
465 else
466 {
467
468 $sqll = "UPDATE users SET username='$Uname',SerialNumber='$Number' ,gender='$gender' WHERE CardID='$CardID'";
469
470 if ($conn->query($sqll) === true)
471 {
472 $_SESSION[ 'message' ] = "<img src='image/add.png' style='margin-right: 20px' width='30'>Registration succesful. ";
473 $Cid ="";
474 $_SESSION[ 'card' ] = "";
475 }
476 else
477 {
478 $_SESSION[ 'message' ] = "Registration failed!";
479 }
480 }
481 }
482//**********************************************************************************************
483//**********************************************************************************************
484 if (isset($_POST['update']) && !empty($_SESSION[ 'card' ]))
485 {
486 $CardID = $_SESSION[ 'card' ];
487 //define other variables with submitted values from $_POST
488 $Uname = $conn->escape_string($_POST['Uname']);
489 $Number = $conn->escape_string($_POST['Number']);
490 $gender= $conn->escape_string($_POST['gender']);
491
492 $result = $conn->query("SELECT * FROM users WHERE CardID='$CardID'");
493 if ( $result->num_rows > 0 )
494 {
495
496 $row=$result->fetch_assoc();
497
498 if (empty($row['username']))
499 {
500 $_SESSION[ 'message' ] = "<img src='image/add.png' style='margin-right: 20px' width='30'>Add the card first!";
501 }
502
503 else
504 {
505 $result = $conn->query("SELECT * FROM users WHERE SerialNumber='$Number' And NOT username='$Uname'");
506
507 if ( $result->num_rows > 0 )
508 {
509 $_SESSION[ 'message' ] = "The Number already taken!";
510 }
511 else
512 {
513
514 $sqll = "UPDATE users SET username='$Uname',SerialNumber='$Number' ,gender='$gender' WHERE CardID='$CardID'";
515
516 if ($conn->query($sqll) === true)
517 {
518 $_SESSION[ 'message' ] = "<img src='image/up.png' style='margin-right: 20px' width='25'>Updated succesfully. ";
519 $Cid ="";
520 $_SESSION[ 'card' ] = "";
521 }
522 else
523 {
524 $_SESSION[ 'message' ] = "Updated failed!";
525 }
526 }
527 }
528 }
529 }
530//**********************************************************************************************
531//**********************************************************************************************
532 if(isset($_POST['del']))
533 {
534 $id = $_POST['CardID'];
535
536 $sqll = $conn->query("SELECT * FROM users WHERE CardID='$id'");
537 if ($sqll->num_rows > 0)
538 {
539 $sql ="DELETE FROM users WHERE CardID='$id'";
540
541 if ($conn->query($sql) === true)
542 {
543 $_SESSION[ 'message' ] = "<img src='image/che.png' style='margin-right: 20px' width='30'>The card deleted. ";
544 $Cid ="";
545 }
546 else
547 {
548 $_SESSION[ 'message' ] = "The card didn't delete!";
549 }
550 }
551 else
552 {
553 $_SESSION[ 'message' ] = "Select an existed card to deleted it.";
554 }
555 }
556//**********************************************************************************************
557//**********************************************************************************************
558 if(isset($_POST['set']))
559 {
560 $Cid = $_POST['CardID'];
561
562 $sqll = $conn->query("SELECT CardID FROM users WHERE CardID='$Cid'");
563 if ($sqll->num_rows > 0)
564 {
565 $_SESSION[ 'message' ] = "Set the Card ID to $Cid to Update.";
566 $_SESSION[ 'card' ] = $Cid ;
567 }
568 else
569 {
570 $_SESSION[ 'message' ] = "Select an existed card to modified it.";
571 $Cid = "";
572 }
573 }
574}
575//**********************************************************************************************
576//**********************************************************************************************
577?>
578<!DOCTYPE html>
579<html>
580<head>
581<meta charset="utf-8">
582<meta name="viewport" content="width=device-width, initial-scale=1.0">
583 <title>Add a new User</title>
584<style type="text/css">
585body {background-image:url("image/2.jpg");background-repeat:no-repeat;background-attachment:fixed;
586 background-position: top right;
587 background-size: cover;}
588header .head h1 {font-family:aguafina-script;text-align: center;color:#ddd;}
589header .head img {float: left;}
590header a {float: right;text-decoration: none;font-family:cursive;font-size:25px;color:red;margin:-60px 0px 0px 20px;padding-right: 100px}
591a:hover {opacity: 0.8;cursor: pointer;}
592.bod {background-color:#ddd; opacity: 0.7;border-collapse: collapse;width:100%;height:220px;padding-bottom:20px}
593.opt {float: left;margin: 20px 80px 0px 20px;}
594.opt input {padding:4px 0px 2px 6px;margin:4px;border-radius:10px;background-color:#ddd; color: black;font-size:16px;border-color: black}
595.opt p {font-family:cursive;text-align: left;font-size:19px;color:#f2f2f2;}
596.opt label {color:black;font-size:23px}
597.opt label:hover {color:red;opacity: 0.8;cursor: pointer;}
598.opt table tr td {font-family:cursive;font-size:19px;color:black;}
599.opt #lo {padding:4px 8px;margin-left:28px;background-color:#00A8A9;border-radius:7px;font-size:15px}
600.opt #up {padding:4px 8px;margin-left:28px;background-color:#00A8A9;border-radius:7px;font-size:15px}
601#lo:hover{opacity: 0.8;cursor: pointer;background-color:red}
602#up:hover{opacity: 0.8;cursor: pointer;background-color:green}
603
604.car {font-family:cursive;font-size:19px;padding-top: 45px;margin: 10px}
605
606.op input {border-radius:10px;background-color:#ddd; color: black;font-size:16px;padding-left:5px;margin:18px 0px 0px 10px;border-color: black}
607.op button {margin:7px 0px 5px 82px}
608.op button:hover {cursor: pointer;}
609
610#table {font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;border-collapse: collapse;width: 100%;}
611#table td, #table th {border: 1px solid #ddd;padding: 8px;opacity: 0.6;}
612#table tr:nth-child(even){background-color: #f2f2f2;}
613#table tr:nth-child(odd){background-color: #f2f2f2;opacity: 0.9;}
614#table tr:hover {background-color: #ddd; opacity: 0.8;}
615#table th {opacity: 0.6;padding-top: 12px;padding-bottom: 12px;text-align: left;background-color: #00A8A9;color: white;}
616
617</style>
618</head>
619<body>
620 <header >
621 <div class="head">
622 <img src="image/rfid1.jpg" width="80" height="80">
623 <h1>RFID auto recorder<br>
624 Login System</h1>
625 </div>
626 <a href="view.php">Users Logs</a>
627 </header>
628<form action="" method="POST" >
629 <div class="bod">
630
631 <div class="opt">
632 <table>
633 <tr>
634 <td>Card ID</td>
635 <td><?php echo $Cid ;?></td>
636 </tr>
637 <tr>
638 <td>Name :</td>
639 <td><input type="text" placeholder="User Name" name="Uname" required></td>
640 </tr>
641 <tr>
642 <td>Number :</td>
643 <td><input type="text" placeholder="Serial Number" name="Number" required></td>
644 </tr>
645 <tr>
646 <td>Gender :</td>
647 <td><input type="radio" name="gender" value="Female" required /><label >Female</label >
648 <input type="radio" name="gender" value="Male" required /><label>Male</label ></td>
649 </tr>
650 <tr>
651 <td><input type="submit" value="Add" name="login" id="lo"></td>
652 <td><input type="submit" value="Update" name="update" id="up"></td>
653 </tr>
654 </table>
655 </div>
656</form>
657
658<div class="car">
659 <?php echo '<label style="color:green;"> '.$_SESSION[ "message" ].'</label><br><br>';
660 echo '<label style="color:red"> '.$_SESSION[ "alert" ].'</label>';
661 ?>
662</div>
663<div class="op">
664
665 <form method="POST" action="">
666 <label style="font-size:19px;">Options:</label>
667 <input type="text" name="CardID" placeholder="Card ID"><br>
668 <button type="submit" name="del" style="border:none;background: none;" title="Remove"><img src="image/del.png" width="25" ></button>
669 <button type="submit" name="set" style="border:none;background: none;" title="Select"><img src="image/set.png" width="30" ></button>
670 </form>
671</div>
672<img src="image/wi.png" style="float: right;width:200px;margin:-220px 50px 0px 0px">
673<a href="https://www.youtube.com/ElectronicsTechHaIs"><img src="image/icon.png" style="float: right;margin:-50px 30px 0px 0px"></a>
674</div>
675 <TABLE id="table">
676 <TR><TH>Sr.No.</TH><TH>Name</TH><TH>Number</TH><TH>Gender</TH><TH>CardID</TH></TR>
677<?php
678 $sql =$conn->query("SELECT * FROM users ORDER BY id DESC");
679
680 while ($row=$sql->fetch_assoc())
681 {
682 if (empty($row['username']))
683 {
684 $sta['sta']='<img src="image/sat1.png" width="32" style="margin-right: 25px" title="available Card">';
685 }
686 else
687 {
688 $sta['sta']='<img src="image/sat2.png" width="30" style="margin-right: 25px">';
689 }
690?>
691 <TR>
692 <TD><?php echo $row['id']?></TD>
693 <TD><?php echo $sta['sta']; echo $row['username']?></TD>
694 <TD><?php echo $row['SerialNumber']?></TD>
695 <TD><?php echo $row['gender']?></TD>
696 <TD><?php echo $row['CardID']?></TD>
697 </TR>
698<?php
699 }
700?>
701</TABLE>
702</body>
703</html>