public function GetItemById($id)
{
$result = null;
$conn = new Connection();
$cmd = $conn->stmt_init();
$query = '
SELECT
id,author_id,content,meme_id
FROM comments
WHERE id = ?
';
if ($cmd->prepare($query)) {
$cmd->bind_param('i', $id);
$cmd->execute();
$reader = $cmd->get_result();
if ($row = $reader->fetch_assoc()) {
$result = $row;
}
$reader->close();
$cmd->close();
}
$conn->close();
return $result;
}
private function UpdateItem($item)
{
$result = null;
$conn = new Connection();
$cmd = $conn->stmt_init();
$query = '
UPDATE users SET
username = ?,
password = ?,
firstname = ?,
lastname = ?,
email = ?
WHERE
id = ?
';
if ($cmd->prepare($query)) {
$cmd->bind_param('sssssi', $item['username'], $item['password'], $item['firstname'], $item['lastname'], $item['email'], $item['id']);
$cmd->execute();
$cmd->close();
}
$conn->close();
}
public function AuthLike($meme_id, $author_id)
{
$result = false;
$conn = new Connection();
$cmd = $conn->stmt_init();
$query = '
SELECT
id
FROM
LIKES
WHERE
meme_id = ? AND author_id = ?
';
if ($cmd->prepare($query)) {
$cmd->bind_param('ii', $meme_id, $author_id);
$cmd->execute();
$reader = $cmd->get_result();
if ($reader->fetch_array()) {
$result = true;
}
$reader->close();
$cmd->close();
}
$conn->close();
return $result;
}
