Vytváranie InfoPanelu v PHP #3_1

// addticket
if(isset($_POST["submit"])){
    $title = $_POST["title"];
    $msg = $_POST["msg"];
    $admin = $_POST["admin"];
    $author = $_SESSION['username'];
    $date = time();

    $idget = insertDB("tickets", "title,status,admin,time,creator", "'".$title."', 1, '".$admin."', '".$date."', '".$author."'");
    $msgi = insertDB("ticketr", "msg,user,time,tID,type", "'".$msg."', '".$author."', '".$date."', '".$idget."', 0");


    header("Location: tickets?action=ticketcreated");
  }

// funkcie

function getfromDBw($data, $table, $where, $what) {
    global $db;

    $stmt = $db->prepare('SELECT '.$data.' FROM '.$table.' WHERE '.$where.'='.$what.'');
    $stmt->execute(array());
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

    if (!$stmt->execute()) {
        print_r($stmt->errorInfo());
    }

    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        return $row;
    }

    // $row = getfromDBw("pageID, pageTitle", "pages", "pageID", $id);

}

function getperm($perm) {
    global $db;
    global $usergroupID;

    $stmtg = $db->prepare('SELECT '.$perm.' FROM groups WHERE id="'.$usergroupID.'"');
    $stmtg->execute(array());
    $rowg = $stmtg->fetch(PDO::FETCH_ASSOC);

    if (!$stmtg->execute()) {
        print_r($stmtg->errorInfo());
    }

    while ($rowg = $stmtg->fetch(PDO::FETCH_ASSOC)) {
        return $rowg;
    }

    // $row = getfromDBw("pageID, pageTitle", "pages", "pageID", $id);

}

function insertDB($table, $data, $values2) {
    global $db;

    $stmt = $db->prepare('INSERT INTO '.$table.' ('.$data.') VALUES ('.$values2.')');
    $stmt->execute(array());
    $idget = $db->lastInsertId();
    return $idget;

}

function updateDB($table, $values, $where) {
    global $db;

    $stmt = $db->prepare('UPDATE '.$table.' SET '.$values.' WHERE '.$where.'');
    $stmt->execute(array());

    // $row = getfromDBw("pageID, pageTitle", "pages", "pageID", $id);

}

// atickets.php

    $stmt = $db->prepare('SELECT * FROM tickets ORDER BY time DESC');
    $stmt->execute(array());
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

    if (!$stmt->execute()) {
        print_r($stmt->errorInfo());
    }

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

                        $date = date("d.m.Y H:i", $row["time"]);

                        if ($row["status"] == '1'){
                          $status = '<a href="editticket?id='.$row["id"].'"><button type="button" class="btn btn-block btn-success btn-xs">Otvorený</button></a>';
                        }
                        else if ($row["status"]== '2'){
                          $status = '<a href="editticket?id='.$row["id"].'"><button type="button" class="btn btn-block btn-default btn-xs">Rieši sa...</button></a>';
                        }
                        else if ($row["status"] == '3'){
                          $status = '<a href="editticket?id='.$row["id"].'"><button type="button" class="btn btn-block btn-danger btn-xs">Uzavretý</button></a>';
                        }
                        else if ($row["status"] == '4'){
                          $status = '<a href="editticket?id='.$row["id"].'"><button type="button" class="btn btn-block btn-warning btn-xs">Odložený</button></a>';
                        }
                        else {
                          $status = '<span class="label label-danger">Chyba!</span>';
                        }

                        echo '
                          <tr>
                            <td>'.$row["id"].'</td>
                            <td>'.$row["title"].'</td>
                            <td>'.$status.'</td>
                            <td>'.$row["admin"].'</td>
                            <td>'.$row["creator"].'</td>
                            <td>'.$date.'</td>
                          </tr>
                          ';
                      }
                      ?>

// SQL

CREATE TABLE `ticketr` (
  `id` int(11) NOT NULL,
  `msg` text,
  `user` text,
  `time` int(11) DEFAULT NULL,
  `tID` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `admin` text,
  `time` int(11) DEFAULT NULL,
  `creator` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;