prepare("INSERT INTO paste (unique_id, message, visibility, paste_password, paste_expiry, paste_title, paste_by, paste_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); if (!$stmt) { echo "Prepare failed: (" . $conn->errno . ") " . $conn->error; } else { $stmt->bind_param("ssissssi", $uniqueId, $encrypted_message, $visibility, $password, $expiry, $title, $pasteBy, $pasteUserId); if (!$stmt->execute()) { echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } else { header('Location: ' . 'view.php?unique_id=' . $uniqueId); exit; } $stmt->close(); } } ?> Create New Paste

Create New Paste

2 changes: 0 additions & 2 deletions2 server/connect.php @@ -1,13 +1,11 @@ connect_error) { die("Connection failed: " . $conn->connect_error); } ?> 1 change: 0 additions & 1 deletion1 top.php @@ -3,7 +3,6 @@ require 'includes/functions.php'; $pastes = []; // The SQL query now orders the pastes by views in descending order $stmt = $conn->prepare(" SELECT p.unique_id, p.paste_title, p.created_at, p.likes, p.dislikes, p.views, CASE WHEN p.paste_by = 0 THEN 'Anonymous' ELSE u.username END AS username FROM paste p LEFT JOIN users u ON p.paste_by = u.id WHERE p.visibility = 1 ORDER BY p.views DESC, p.created_at DESC LIMIT 10 "); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $pastes[] = $row; } } $stmt->close(); ?> Top Pastes

Top Pastes

Title Pasted By Likes Dislikes Views Created Time