[RESOLVED] Display Blog Entry

tone72

Hi. I'm trying to get the following code to display the most recent full blog entry on the index page. It currently displays the Archive page and Add Entry page fine, but not the index page. I've tried several different things, but just can't work out how to do it. Anybody have any suggestions. Thanks!

require ("db.php"); // establish a connection to the database
include ("tpl/header.html"); // include header template
$content = ""; // start empty
@$page = strip_tags($_GET['p']); // sanitize data.
// set it so that if page is empty (IE, home page) show archive posts.
//if (empty($page)) {
    //$page = "archive";
//}
if ($page == 'add') {
    // display the add form..
    if (empty($_POST['addblog'])) {
        $content .= "
        <form action=\"{$_SERVER['PHP_SELF']}?p=add\" method=\"post\">
        <label for=\"title\">Entry Title:</label> <input type=\"text\" name=\"title\" id=\"title\" /><br />
        <label for=\"content\">Blog Entry:</label><br /><textarea name=\"content\" id=\"content\" rows=\"15\"></textarea><br />
        <input type=\"submit\" name=\"addblog\" id=\"addblog\" value=\"Add Entry\" />
        </form>
        ";
    } else {
        // sanitization is important. You could catch some nasty bug.
        $title = mysql_real_escape_string(htmlspecialchars($_POST['title'], ENT_QUOTES));
        $entry = mysql_real_escape_string(htmlspecialchars($_POST['content'], ENT_QUOTES));
        // re enable line breaks.
        $entry = str_replace(array("\\r\\n", "\\r", "\\n"), "<br />", $entry);
        // if the title or content is empty, tell the user it's empty!!
        if ((!empty($title)) && (!empty($entry))) {
		mysql_query("INSERT INTO `tt_blog` (`id` ,`title` ,`content` ,`datetime` ,`userip`)VALUES (NULL ,  '{$title}',  '{$entry}',  NOW(),  '{$_SERVER['REMOTE_ADDR']}');");
		$content .= "Entry Added!";
        } else {
			$content .= "Error. Please fill out all fields.";
        }
    }
} else
    if ($page == 'archive') {
        // Loop through the archive
        $getpostsq = mysql_query("SELECT * FROM `tt_blog` ORDER BY `tt_blog`.`datetime` DESC LIMIT 5"); //lists 5 most recent entries
        while ($getposts = mysql_fetch_assoc($getpostsq)) {
        $content .= "<div class=\"archive\">
		<p><em>{$getposts['datetime']}</em> &raquo; <a href=\"index.php?p={$getposts['id']}\"><strong>{$getposts['title']}</strong></a></p></div>";
        }
    } else
        if ((int)$page) {
			$getpostq = mysql_query("SELECT * FROM `tt_blog` WHERE `id` = '$page'"); // select current ID from database
			$getpost = mysql_fetch_assoc($getpostq); // put the data from the previous query into an array which we can pull from
			$content .= "<h1>{$getpost['title']}</h1>
			<em>{$getpost['datetime']}</em>
			<blockquote>{$getpost['content']}</blockquote>";
        } else {
            $content .= "Error, unknown action.";
        }
        echo $content; // echo out the pre filled content variable.
include ("tpl/footer.html"); // include footer template

	<header>
		<nav>
			<a href="index.php">Home</a>
            <a href="index.php?p=add">Add Entry</a>
			<a href="index.php?p=archive">Archive</a>
		</nav>
	</header>

Damian_

instead of this

 <form action=\"{$_SERVER['PHP_SELF']}?p=add\" method=\"post\">

have you tried without the p=add, and just try posting a hidden field!!

such as doing this:

 

$hidden = $_POST["hidden "]



<html>
<body>

//check to see if it is empty!
if($hidden== ""){

execute code here
}else{
execute code here

}


</body>
</html>

I normally have another file for inserting statements and then use php header to redirect back to a specific page.

Hope it makes sense.. makes sense in my head lol

Weedpacket

Let's walk through and see just what you've written does.

When the index page is asked for, $p isn't set. So $page ends up being NULL (and a Notice about an uninitialised variable is suppressed).
NULL != "add", so the Add Entry page isn't shown.
NULL != "archive", so the Archive page isn't shown.
NULL, when cast to an integer, gives 0. When that's cast to a boolean by the if() statement, it becomes false. So that page isn't shown.
Leaving the Error page.

tone72

Thanks for the help. I'm slowly getting there. I have now added code for the (empty($page)) and it is displaying on the index page like I want. However, I can't figure out how to initialise the $page variable. Every time I try to use isset it stops working. What code would you suggest in this instance so I can get rid of the suppression? Sorry maybe should have posted in the New Coders section. Updated code below.

require ("db.php"); // establish a connection to the database
include ("tpl/header.html"); // include header template
$content = ""; // start empty
@$page = strip_tags($_GET['p']); // sanitize data.
// set it so that if page is empty (IE, home page) show archive posts.
if (empty($page)) {
	    $getpostsq = mysql_query("SELECT * FROM `tt_blog` ORDER BY `tt_blog`.`datetime` DESC LIMIT 2"); //lists 2 most recent entries
        while ($getposts = mysql_fetch_assoc($getpostsq)) {
		$content .= "<h1>{$getposts['title']}</h1>
		<em>{$getposts['datetime']}</em>
		<blockquote>{$getposts['content']}</blockquote>";
}
} else
if ($page == 'add') {
    // display the add form..
    if (empty($_POST['addblog'])) {
        $content .= "
        <form action=\"{$_SERVER['PHP_SELF']}?p=add\" method=\"post\">
        <label for=\"title\">Entry Title:</label> <input type=\"text\" name=\"title\" id=\"title\" /><br />
        <label for=\"content\">Blog Entry:</label><br /><textarea name=\"content\" id=\"content\" rows=\"15\"></textarea><br />
        <input type=\"submit\" name=\"addblog\" id=\"addblog\" value=\"Add Entry\" />
        </form>
        ";
    } else {
        // sanitization is important. You could catch some nasty bug.
        $title = mysql_real_escape_string(htmlspecialchars($_POST['title'], ENT_QUOTES));
        $entry = mysql_real_escape_string(htmlspecialchars($_POST['content'], ENT_QUOTES));
        // re enable line breaks.
        $entry = str_replace(array("\\r\\n", "\\r", "\\n"), "<br />", $entry);
        // if the title or content is empty, tell the user it's empty!!
        if ((!empty($title)) && (!empty($entry))) {
		mysql_query("INSERT INTO `tt_blog` (`id` ,`title` ,`content` ,`datetime` ,`userip`)VALUES (NULL ,  '{$title}',  '{$entry}',  NOW(),  '{$_SERVER['REMOTE_ADDR']}');");
		$content .= "Entry Added!";
        } else {
			$content .= "Error. Please fill out all fields.";
        }
    }
} else
    if ($page == 'archive') {
        // Loop through the archive
        $getpostsq = mysql_query("SELECT * FROM `tt_blog` ORDER BY `tt_blog`.`datetime` DESC LIMIT 5"); //lists 5 most recent entries
        while ($getposts = mysql_fetch_assoc($getpostsq)) {
        $content .= "<div class=\"archive\">
		<p><em>{$getposts['datetime']}</em> &raquo; <a href=\"index.php?p={$getposts['id']}\"><strong>{$getposts['title']}</strong></a></p></div>";
        }
    } else
        if ((int)$page) {
			$getpostq = mysql_query("SELECT * FROM `tt_blog` WHERE `id` = '$page'"); // select current ID from database
			$getpost = mysql_fetch_assoc($getpostq); // put the data from the previous query into an array which we can pull from
			$content .= "<h1>{$getpost['title']}</h1>
			<em>{$getpost['datetime']}</em>
			<blockquote>{$getpost['content']}</blockquote>";
        }
		else {
            $content .= "Error, unknown action.";
        }
        echo $content; // echo out the pre filled content variable.
include ("tpl/footer.html"); // include footer template
[code=php]

tone72

By every time I try to use isset it stops working I mean if I add:

if(isset($page)){
$page = strip_tags($_GET['p']); // sanitize data.
}

Then only the contents of (empty($page)) are displayed no matter what link I use (i.e., Home, Add Entry, Archive).

Damian_

Firstly have you tried to echo $page to see what it is returning?

and then try this controlling the value maybe something like this

$page = isset($_GET["p"])?trim($_GET["p"]):"";


if($page == "");

...

tone72

Thanks so much for your help. I have it working exactly as I wanted now. Could you please explain the line of code you suggested in more detail so I can understand exactly what it is doing. Also can you please explain why you used trim instead of strip_tags. Thanks so much!

$page = isset($_GET["p"])?trim($_GET["p"]):"";

Damian_

haha dam, you beat me to it, i was on my way to work...

exactly what "bradgrafelman" said is what i would have said, but i think he explains it better...

😃

tone72

Thank you for help all. Much appreciated. Understanding it all much better now. 🙂