Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <meta http-equiv="content-type" content="text/html; charset=UTF-8">
- <title>Zugangssystem</title>
- <script src="http://code.jquery.com/jquery-latest.js"></script>
- <script>
- $(document).ready(function(){
- setInterval(function() {
- $(".latestData").load("reload.php");
- //var result = .load("reload.php");
- //alert(".latestData");
- <?php
- $mysql = mysqli_connect("localhost","phpmyadmin","chris","phpmyadmin");
- $ergebnis = mysqli_query($mysql, "SELECT * FROM rfid");
- while($row = mysqli_fetch_object($ergebnis))
- {
- echo '$(\'.'.$row->kartennummer.'\').load("reload.php"); // .text("'.$row->anzahl_zugang.'");';
- }
- ?>
- }, 2500);
- });
- </script>
- <div class="latestData">s</div>
- <style>
- body {
- font-size: 18px;
- background-image: linear-gradient(to right, turquoise, pink);
- }
- td { padding: 3px; }
- input { font-size: 18px;width: 95%; }
- </style>
- <?php
- $pruefen = shell_exec("pgrep -f Read.py");
- $pruefen2 = explode(" ", $pruefen);
- print_r($pruefen2);
- if (!empty($_POST['save_id']))
- {
- mysqli_query($mysql, "UPDATE rfid SET name = '".$_POST['save_name']."', anzahl_zugang = '".$_POST['save_anzahl']."' WHERE kartennummer = '".$_POST['save_id']."'");
- }
- echo '
- <div style="padding: auto; margin: auto; width: 75%;">
- <br /><br />
- <table style="width:100%;" border="1">
- <thead>
- <tr>
- <th>ID</th>
- <th>Name</th>
- <th>Mediennummer</th>
- <th style="width: 50px;">Verbleibende<br />Zugänge</th>
- <th>Zahnrad</th>
- </tr>
- </thead>
- <tbody>';
- $ergebnis = mysqli_query($mysql, "SELECT * FROM rfid");
- while($row = mysqli_fetch_object($ergebnis))
- {
- echo '
- <form action="index.php" method="post">
- <tr>
- <td style="text-align:center;">'.$row->id.'</td>
- <td>'.$row->name.'</td>
- <td>'.$row->kartennummer.'</td>
- <td><div class="'.$row->kartennummer.'"></div>'.$row->anzahl_zugang.'</td>
- <td style="text-align:right;">
- <button>edit</button>
- delete
- <input type="hidden" name="edit_id" value="'.$row->kartennummer.'" />
- </td>
- </tr>
- </form>';
- if (!empty($_POST['edit_id']) AND $row->kartennummer == $_POST['edit_id'])
- {
- echo '
- <form action="index.php" method="post">
- <tr style="background-color: #ff0000;height:50px;">
- <td style="text-align:center;">'.$row->id.'</td>
- <td><input type="text" name="save_name" value="'.$row->name.'" /></td>
- <td>'.$row->kartennummer.'</td>
- <td><input type="text" name="save_anzahl" value="'.$row->anzahl_zugang.'" /></td>
- <td style="text-align:right;">
- <button>speichern</button>
- <input type="hidden" name="save_id" value="'.$row->kartennummer.'" />
- </td>
- </tr>
- </form>';
- }
- }
- echo '</tbody></table>';
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement