SQL Injection Safe Paste Search

Text Views: 125 • Feb 08, 2026 • Never expires
24. SQL Injection Safe Paste Search
=================================

-- PasteText Search Query (PREPARED STATEMENT)
SELECT p.public_id, p.title, p.created_at, m.username
FROM pastes p
LEFT JOIN members m ON p.member_id = m.id
WHERE p.visible = 1
  AND (p.title LIKE ? OR p.content LIKE ?)
  AND (p.expires_at IS NULL OR p.expires_at > NOW())
ORDER BY p.created_at DESC
LIMIT 20 OFFSET ?;

-- Usage: ['%' . $search . '%', '%' . $search . '%', $offset]
🛡️

Ad Blocker Detected

PasteBin.site is free to use thanks to our sponsors. Please consider disabling your ad blocker or whitelisting our site to support our servers.

Learn More