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
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 |
|
|
|
|
|
|