Size: a a a
𝕬
𝕬
<?php $db = new PDO("mysql:host=localhost;dbname=users;charset=utf8", "root",""); $name = $db->query("SELECT * FROM users")[0]; echo "<head><style>span {color: red}</style></head><body><span>Hello $name</span><script>alert('hello, $name')</script></body>" ?>BA
𝕬
𝕬
БГ
👑️
SELECT
CASE WHEN m.to_id = ? THEN sender.id ELSE receiver.id END interlocutor,
CASE WHEN m.to_id = ? THEN sender.name ELSE receiver.name END username,
sender.name msg_sender,
m.text msg_text
FROM messages m
JOIN users sender ON
sender.id = m.from_id
JOIN users receiver ON
receiver.id = m.to_id
WHERE m.to_id = ? OR m.from_id = ?
GROUP BY interlocutor
HAVING m.id = max(m.id)
ORDER BY m.id DESC
БГ
R3
БГ
R3
БГ
V
КП
𝕬
𝕬
𝕬
БГ
V
КП
