logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 06-15-2012, 03:07 AM   #1
sturekdrf
 
Join Date: Jun 2012
Posts: 2
Default $end error.

I keep getting this error

Parse error: syntax error, unexpected $end in /inc/posts.inc.php on line 87
but line 87 is ?> so not sure what the deal is with this. but its driving me nuts. Script below.

Code:
<?php
//check if there is a post
function valid_pid($pid) {
	$pid = (int)$pid;
	
	$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;
}
 ?>
 <?php
//Fetches a summery of all blog posts
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){
		$row[] = 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;
}
?>

<?php
//gets a single post from the table.
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;
}
?>
//adds new blog entry
<?php
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())");
}

?>
sturekdrf is offline   Reply With Quote
Old 06-15-2012, 08:13 AM   #2
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

valid_pid function is missing a closing brace
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:54 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com