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