Releases Datenbank

Releases Commands prepare("SELECT * FROM users WHERE username=?"); $stmt->execute([$_POST['user']]); $u = $stmt->fetch(); if ($u && password_verify($_POST['pass'], $u['password'])) { $_SESSION['role'] = $u['role']; header("Location: admin.php"); exit; } } $sql = "SELECT * FROM releases ORDER BY rls_date DESC LIMIT 25;"; $query = mysql_query($sql) or die(mysql_error()); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; while($fetch = mysql_fetch_assoc($query)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Releas-Name	Section	Infos	Releas-Zeit
' . $fetch['rls_name'] . '	' . $fetch['rls_section'] . '	' . $fetch['rls_infos'] . '	' . $fetch['rls_date'] . '

'; ?> ################################

---

"; WHILE($row = mysql_fetch_assoc($query)) { $releas = $row ['rls_name']; $section = $row ['rls_section']; $infos = $row ['rls_infos']; $date = $row ['rls_date']; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; while($fetch = mysql_fetch_assoc($query)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Releas-Name	Section	Infos	Releas-Zeit
' . $fetch['rls_name'] . '	' . $fetch['rls_section'] . '	' . $fetch['rls_infos'] . '	' . $fetch['rls_date'] . '

'; } echo "

"; ?>

Releases Commands