Any idea's?
messageboard.php (the page with the textbox and where I want messages to appear
Code: Select all
<?php
;
session_start();
//this checks to see if the $_SESSION variable has been not set
//or if the $_SESSION variable has been not set to true
//and if one or the other is not set then the user gets
//sent to the login page
if (!isset($_SESSION['username'])) {
header('Location: http://*******.*********/login.php');
}
?>
<HTML>
<head><title>Message Board - Logged In</title>
<link rel='stylesheet' href='layout.css'>
</head>
<body bgcolor="#fd8ecf">
<center><img src="headerpage.jpg"></center>
<div class="navbar">
<div class="button"><a href="index.html">Home</a></div>
<div class="button"><a href="news.html">News</a></div>
<div class="button"><a href="gallery.html">Gallery</a></div>
<div class="button"><a href="videos.html">Videos</a></div>
<div class="button"><a href="contact.html">Contact</a></div>
<div class="button"><a href="links.html">Links</a></div>
<div class="button"><a href="msg.html">Message Kaaleigh</a></div>
</div>
<div class="frame">
<frameset cols="25%,75%" noresize="noresize">
<?php
session_start();
$username = $_SESSION['username'];
$password = $_SESSION['password'];
if(isset($_SESSION['username']) && isset($_SESSION['password'])) {
echo " <b>Welcome ".$username." <br><br></b> Please not only messages with the username Kaaleigh are posted by Kaaleigh herself";
}
else {
echo "Welcome Guest! <br> <a href=login.php>Login</a> | <a href=register.php>Register</a>";
}
?>
<?php
mysql_connect("**********.com", "************", "**********");
mysql_select_db("*************");
?>
<form action="message.php" method="POST">
Your Name: <input type="text" name="author"><br>
Message:<br><textarea cols="60" rows="5" name="message"></textarea><br>
<input type="submit" value="Post Message">
</form>
<hr>
<?php
// I am selecting everything from the messages section in the database and ordering them newest to oldest.
$sql = mysql_query("SELECT * FROM messages ORDER BY posted DESC");
// Now I am getting my results and making them an array
while($r = mysql_fetch_array($sql)) {
$posted = date("jS M Y h:i",$r[posted]);
// End of Array
}
echo "$r[message]<h4>Posted by $r[author] on $posted</h4><hr>";
?>
</body>
</html>
Code: Select all
<?php
mysql_connect("**********.com", "************", "**********");
mysql_select_db("*************");
$time = time();
$query = "INSERT INTO messages VALUES( NULL, '{$_POST['message']}', '{$_POST['author']}', '$time' )";
if( $result = mysql_query($query) ) {
if(mysql_affected_rows() > 0 ) {
echo "Message Posted.<br><a href='messageboard.php'>Return</a>";
} else {
echo 'There was an error posting your message. Please try again later.';
}
} else {
echo "There was a database error.";
// comment out next line for live site.
echo "<br>Query string: $query<br>Returned error: " . mysql_error() . '<br>';
}
;msg.php
Code: Select all
<?php
mysql_connect("**********.com", "************", "**********");
mysql_select_db("*************"););
echo "<a href='messageboard.php'>Go Back...</a>";
$sql = mysql_query("SELECT * FROM messages WHERE id = '$_GET[id]'");
// Now we are getting our results and making them an array
while($r = mysql_fetch_array($sql)) {
// Everything within the two curly brackets can read from the database using $r[]
// We need to convert the UNIX Timestamp entered into the database for when a thread...
// ... is posted into a readable date, using date().
$posted = date("jS M Y h:i",$r[posted]);
// Now this shows the thread with a horizontal rule after it.
echo "$r[message]<h4>Posted by $r[author] on $posted</h4><hr>";
// End of Array
}As you can see on the messageboard.php page a user is logged in and the username is stored in a session. I would like the user to not have to enter anything in the author box and the username appears after "posted by (name) on (date)". Tjis however isn;t the priotory roght now. My main concern is making the messages appear on the messageboard.php Any feedback is appreciated. People pointing out the code that is missing is appreciated more.