SQL Injection Safe Paste Search
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]
Featured
Advertisement
Category
Action