<?php

require 'config.php';

if(isset($_GET['uid'])) {

    $uid = $_GET['uid'];
    $db = getDB();
    $stmt = $db->prepare("SELECT O.*, U.*  FROM orders_utalas O, users U WHERE O.uid_usr_utal =:uid AND U.uid = O.uid_usr_utal ORDER BY O.create_time DESC");
    $stmt->bindParam("uid", $uid, PDO::PARAM_INT);
    $stmt->execute();
    $stmt->setFetchMode(PDO::FETCH_ASSOC);

}

if(isset($_POST["submit"])) {

$uid = $_GET['uid'];
$orders_utalas = $_POST["utal_stat"];

$stmt = $db->prepare("UPDATE orders_utalas SET tranzakcio_status = :tranzakcio_status WHERE uid_usr_utal = :uid_usr_utal");

$stmt->bindValue(':uid_usr_utal', $uid, PDO::PARAM_INT);
$stmt->bindValue(':tranzakcio_status', $orders_utalas, PDO::PARAM_STR);

$stmt->execute();

}

?>

<form method="post">
<table border="1">
    <tr>
        <td>User ID</td>
        <td>Payment ID</td>
        <td>Username</td>
        <td>Payment status</td>
        <td>Action</td>
    </tr>
    <tr>
        <?php while ($data = $stmt->fetch()) { ?>
        <td><?php echo $data["uid"]; ?></td>
        <td><?php echo $data["oid_utal"]; ?></td>
        <td><?php echo $data["username"]; ?></td>
        <td><?php echo $data["tranzakcio_status"]; ?></td>
        <td>
        <select name="utal_stat">
            <option>Choose</option>
            <option value="nincs fizetve"

            <?php
            if($data["tranzakcio_status"] == 'nincs fizetve') {
                echo "selected";
            }
            ?>

            >Nincs fizetve</option>
            <option value="fizetve"
            <?php
            if($data["tranzakcio_status"] == 'fizetve') {
                echo "selected";
            }
            ?>
            >Fizetve</option>
        </select>
        </td>
    </tr>
    <?php } ?>
    <tr>
        <td><input type="submit" value="submit" name="submit"></td>
    </tr>
</table>
</form>