query('SELECT * ' . "\r\n\t\t\t\t" . ' FROM ibo ' . "\r\n\t\t\t\t" . ' WHERE id=\'' . $_GET['update'] . '\''); $row = $res->fetchArray(); $id = $row['id']; $mac_address = $row['mac_address']; $expire_date = $row['expire_date']; $username = $row['username']; $password = $row['password']; if (isset($_POST['submit'])) { $we = strtotime($_POST['expire_date']); $ne = date('Y-m-d', $we); $start = date('Y-m-d'); $end = date('h:m:s'); $full = $start . 'T' . $end . '.000000Z'; $created_at = date('yyyy-MM-dd\'T\'hh:mm:ss.SSSSSS\'Z\''); $db->exec('UPDATE ibo SET mac_address=\'' . $_POST['mac_address'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'expire_date=\'' . $ne . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'username=\'' . $_POST['username'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'url=\'' . $_POST['url'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'title=\'' . $_POST['title'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'password=\'' . $_POST['password'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'created_at=\'' . $full . '\'' . "\r\n\t\t\t\t\t\t" . ' WHERE ' . "\r\n\t\t\t\t\t\t\t" . ' id=\'' . $_POST['id'] . '\''); $db->close(); header('Location: users.php'); } include 'includes/header.php'; $userupdate_id = $row['id']; $userupdate_mac_address = $row['mac_address']; $userupdate_expire_date = $row['expire_date']; $userupdate_username = $row['username']; $userupdate_password = $row['password']; $userupdate_url = $row['url']; $userupdate_title = $row['title']; echo '

' . "\n"; echo '

Update User

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

Edit User

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Mac Address ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Username' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Password' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Expiration' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' DNS' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Server Name' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; include 'includes/footer.php'; echo '' . "\n"; echo "\n"; echo ''; ?>