Blog Tutorial Add a Comment to Posts

Post here is you are having problems with any of the tutorials.
Post Reply
slimsik007
Posts: 1
Joined: Sun May 06, 2012 8:03 am

Blog Tutorial Add a Comment to Posts

Post by slimsik007 »

posts.inc.php

Below is my code. When i make a comment it doesnt show up or either not going to the DB.

Please help me
<?php
function  valid_pid($pid){
	//echo mysql_error();
	$pid = (int)$pid;
	//echo mysql_error();
	$total = mysql_query("SELECT COUNT('post_id') FROM `posts` WHERE `post_id`={$pid}");
	$total = mysql_result($total, 0);
	
	if ($total !=1){
		return false;
	}else{
		return true;
	}
}

function get_posts(){
	$sql = "SELECT
		`posts`.`post_id` AS `id`,
		`posts`.`post_title` AS `title`,
		LEFT(`posts`.`post_body`, 512) AS `preview`,
		`posts`.`post_user` AS `user`,
		DATE_FORMAT (`posts`.`post_date`, '%d/%m/%y %H:%i:%s') AS `date`,
		`comments`.`total_comments`,
		DATE_FORMAT(`comments`.`last_comment`, '%d/%m/%y %H:%i:%s') AS `last_comment`
	FROM `posts`
	LEFT JOIN (
		SELECT
		`post_id`,
		COUNT(`comment_id`) AS `total_comments`,
		MAX(`comment_date`) AS `last_comment`
	FROM `comments`
	GROUP BY `post_id`
	) AS `comments`
	ON `posts`.`post_id` = `comments`.`post_id`
	ORDER BY `posts`.`post_date` DESC";
	$posts = mysql_query($sql); 
	$rows = array();
	while (($row = mysql_fetch_assoc($posts)) !== false){
		$rows[] = array(
		'id' 				=> $row['id'],
		'title' 			=> $row['title'],
		'preview' 			=> $row['preview'],
		'user' 				=> $row['user'],
		'date' 				=> $row['date'],
		'total_comments' 	=> ($row['total_comments'] === null) ? 0: $row['total_comments'],
		'last_comment' 		=> ($row['last_comment'] === null) ? 'never' : $row['last_comment']
		);
	}
	return $rows;
}

function get_post($pid){
	$pid = (int)$pid;
	$sql = "SELECT 
			`post_title` AS `title`,
			`post_body` AS `body`,
			`post_user` AS `user`,
			`post_date` AS `date`
			FROM `posts` WHERE `post_id` = {$pid}";
			
			$post = mysql_query($sql);
			$post = mysql_fetch_assoc($post);
			$post['comments'] = get_comments($pid);
			
			return $post;
}

function add_post($name, $title, $body){
	$name = mysql_real_escape_string(htmlentities($name));
	$title = mysql_real_escape_string(htmlentities($title));
	$body = mysql_real_escape_string(nl2br(htmlentities($body)));
	
	mysql_query("INSERT INTO `posts` (`post_user`, `post_title`,`post_body`,`post_date`) VALUES ('{$name}', '{$title}','{$body}', NOW()) ");
}


?>

Last edited by jacek on Mon May 07, 2012 3:39 pm, edited 1 time in total.
Reason: removed all caps
User avatar
jacek
Site Admin
Posts: 3262
Joined: Thu May 05, 2011 1:45 pm
Location: UK
Contact:

Re: Blog Tutorial Add a Comment to Posts

Post by jacek »

It looks basically right. Try adding
echo mysql_error();
after the INSERT and see if it tells you why it's not inserting.
Image
Post Reply