API tools faq
paste
Advertisement
Guest User

Codes Nodemcu Web

a guest
Jan 17th, 2019
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 24.31 KB | None | 0 0
raw download clone embed print report
  1. VIEW.PHP
  2. <?php
  3. session_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>
  25. body {background-image:url("image/2.jpg");background-repeat:no-repeat;background-attachment:fixed;
  26.       background-position: top right;
  27.       background-size: cover;}
  28.  
  29. header .head h1 {font-family:aguafina-script;text-align: center;color:#ddd;}
  30. header .head img {float: left;}
  31. header .opt {float: right;margin: -100px 20px 0px 0px}
  32. header .opt a {text-decoration: none;font-family:cursive;text-align: center;font-size:20px;color:red;margin-right: 15px}
  33. header .opt a:hover {opacity: 0.8;cursor: pointer;}
  34. header .opt #inp {padding:3px;margin:0px 0px 0px 33px;background-color:#00A8A9;font-family:cursive;font-size:16px; opacity: 0.6;color:red;}
  35. header .opt #inp:hover {background-color: #00A8A9; opacity: 0.8;}
  36. header .opt input {padding-left:5px;margin:2px 0px 3px 20px;border-radius:7px;border-color: #A40D0F ;background-color:#8E8989; color: white;}
  37. header .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.    
  99. if (!empty($_POST['seldate']))
  100.  {
  101.    $seldate = $_POST['date'];
  102.  }
  103. else
  104.  {
  105.    $seldate = $d;
  106.  }
  107.    
  108. $sql = "SELECT * FROM logs WHERE DateLog='$seldate' ORDER BY id DESC";
  109.  
  110. if ($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.  
  168. POSTDEMO.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.  
  289. EXPORT.PHP
  290.  
  291. <?php
  292. session_start();
  293.    //Connect to database
  294.    require('connectDB.php');
  295.  
  296. $output = '';
  297. $outputdata = $_SESSION['exportdata'];
  298. if(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.  
  344. INSTALL.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.  
  407. CONNECTDB.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.  
  423. ADDCARD.PHP
  424. <?php
  425. session_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">
  585. body {background-image:url("image/2.jpg");background-repeat:no-repeat;background-attachment:fixed;
  586.     background-position: top right;
  587.     background-size: cover;}
  588. header .head h1 {font-family:aguafina-script;text-align: center;color:#ddd;}
  589. header .head img {float: left;}
  590. header a {float: right;text-decoration: none;font-family:cursive;font-size:25px;color:red;margin:-60px 0px 0px 20px;padding-right: 100px}
  591. a: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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!