Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta http-equiv="X-UA-Compatible" content="ie=edge">
- <title>Document</title>
- </head>
- <body>
- <form method="POST">
- <label><input type="float" name="money"></label>
- <button type="submit">Wrzuć</button>
- <button name="green">zielony - drukuj</button>
- <button name="red">czerwony - anuluj</button>
- </form>
- <?php
- $green = $_POST['green'] ?? 'true';
- $red = $_POST['red'] ?? 'true';
- function pushCoin($connection, $result){
- $coin = $_POST['money'] ?? "-1";
- $valid = false;
- while ($row = mysqli_fetch_assoc($result)) {
- if ($row['value']==$coin) {
- $valid = true;
- }
- }
- if($valid){
- $pushQuery = "INSERT INTO `puttedcoins` (`id`, `coin`) VALUES (NULL, '".$coin."');";
- mysqli_query($connection, $pushQuery);
- }
- }
- function checkHowLong($resultPut){
- $sum = 0;
- $howlong = 0;
- while ($row = mysqli_fetch_assoc($resultPut)) {
- $sum += $row['coin'];
- }
- if ($sum >= 12) {
- for (; $sum >= 12; $sum-=12) {
- $howlong += 24*60*60;
- } //cały dzień
- }elseif ($sum >= 7.5) {
- $howlong = 3*60*60;
- $sum -= 6;
- for (; $sum >= 1.5; $sum-=1.5) {
- $howlong += 60*60;
- }
- for (; $sum > 0; $sum-=0.5) {
- $howlong += 15*60;
- }
- //4h w góre
- }else{
- if($sum==0){
- $howlong = 15*60; //darmowe 15min
- }else {
- $howlong = ($sum/0.5)*15*60; //długosc postuju w sekundach
- $sum = 0;
- }
- }
- echo "<br>".$sum."<br>".$howlong."<br>".($howlong/(60*60));
- return $howlong;
- }
- $connection = @mysqli_connect('localhost', 'root', '', 'park');
- if($connection){
- mysqli_set_charset($connection, "utf8mb4");
- $query = "SELECT * FROM denominations";
- $queryPut = "SELECT * FROM puttedcoins";
- $deleteQuery = "DELETE FROM puttedcoins WHERE 1";
- $result = mysqli_query($connection, $query);
- $resultPut = mysqli_query($connection, $queryPut);
- if($result){
- if (!$green) {
- checkHowLong($resultPut);
- }elseif (!$red) {
- while ($row = mysqli_fetch_assoc($resultPut)) {
- echo $row['coin']."<br>";
- }
- mysqli_query($connection, $deleteQuery);
- }else {
- pushCoin($connection, $result);
- }
- }else{
- echo "wrong query";
- }
- }else{
- echo "unable to connect";
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement