Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/blog/core/inc/comments.inc.php on line 17
<?php
//puščaš vse objave ki so dane v blogu.
function get_comments($pid) {
$pid = (int)$pid;
$sql = "SELECT
`comment_body` AS `body`,
`comment_user` AS `user`,
DATE_FORMAT(`comment_date`, '%d/%m/%Y %H:%i:%s') AS `date`
FROM `comments`
WHERE `post_id` = {pid}";
$comments = mysql_query($sql);
$return = array();
while (($row =mysql_fetch_assoc($comments)) !== false) {
$return[] = $row;
}
return $return;
}
//dodaj komentar
function add_comments($pid, $user, $body) {
if (valid_pid($pid) === fales) {
return false;
}
$pid = (int)$pid;
$user = mysql_real_escape_string(htmlentites($user));
$body = mysql_real_escape_string(nl2br(htmlentites($body)));
mysql_query("INSERT INTO `comments` (`post_id`, `comment_user`, `comment_body`, `comment_date`) VALUES ({$pid}, '{$user}', '{$body}', NOW())");
return true;
}
?>