kkeith29
Nearly a Posting Virtuoso
1,357 posts since Jun 2007
Reputation Points: 235
Solved Threads: 194
<?php
//name this page inbox.php
?>
<?php
// get the messages from the table.
$get_messages = mysql_query("SELECT message_id FROM messages WHERE to_user='$userfinal' ORDER BY message_id DESC") or die(mysql_error());
$get_messages2 = mysql_query("SELECT * FROM messages WHERE to_user='$userfinal' ORDER BY message_id DESC") or die(mysql_error());
$num_messages = mysql_num_rows($get_messages);
// display each message title, with a link to their content
for($count = 1; $count <= $num_messages; $count++)
{
$row = mysql_fetch_array($get_messages2);
//if the message is not read, show "(new)" after the title, else, just show the title.
if($row['message_read'] == 0)
{
echo '<a href="read_message.php?messageid=' . $row['message_id'] . '">' . $row['message_title'] . '</a>(New)<br><br>';
}else{
echo '<a href="read_message.php?messageid=' . $row['message_id'] . '">' . $row['message_title'] . '</a><br>';
}}
echo '<form name="newmsgfrm" method="post" action="new_message.php">';
echo '<br><input type="submit" value="Send a New Message"><br>';
echo '</form>';
echo '<form name="backfrm" method="post" action="members.php">';
echo '<input type="submit" value="Back to Home"><br>';
echo '</form>';
?>
<?php
//Name this page messageck.php
//(yes like that)
?>
<?php
$title=$_POST['message_title'];
$to=$_POST['message_to'];
$content=$_POST['message_content'];
$from=$_POST['message_from'];
$ck_reciever = "SELECT username FROM users WHERE username = '".$to."'";
if(mysql_num_rows( mysql_query($ck_reciever))==0){
die("The user you are trying to contact don't excist. Please go back and try again.<br>
<form name=\"back\" action=\"new_message.php\"
method=\"post\">
<input type=\"submit\" value=\"Try Again\">
</form>
");
}
elseif(strlen($content) < 1){
die("Your can't send an empty message!<br>
<form name=\"back\" action=\"new_message.php\"
method=\"post\">
<input type=\"submit\" value=\"Try Again\">
</form>
");
}
elseif(strlen($title) < 1){
die("You must have a Title!<br>
<form name=\"back\" action=\"new_message.php\"
method=\"post\">
<input type=\"submit\" value=\"Try Again\">
</form>
");
}else{
mysql_query("INSERT INTO messages (from_user, to_user, message_title, message_contents) VALUES ('$from','$to','$title','$content')") OR die("Could not send the message: <br>".mysql_error());
echo "The Message Was Successfully Sent!";
?>
<form name="back" action="inbox.php"
method="post">
<input type="submit" value="Back to The Inbox">
</form>
<?php
}
?>
<?php
//Name this one new_message.php
?>
<form name="message" action="messageck.php"
method="post">
Title: <input type="text" name="message_title" value="<?php if($use){echo 'This Is A Message'; }?>"><br>
To: <input type="text" name="message_to" value="<?php if($use){echo $use; }?>"><br>
Message: <br>
<textarea rows="20" cols="50" name="message_content">
</textarea>
<?php
echo '<input type="hidden" name="message_from" value="'.$user.'"><br>';
?>
<input type="submit" value="Send">
</form>
<?php
//Name this page read_message.php
?>
<?php
$messageid = $_GET['messageid'];
$message = mysql_query("SELECT * FROM messages WHERE message_id = '$messageid' AND to_user = '$userfinal'");
$message=mysql_fetch_assoc($message);
mysql_query("UPDATE messages SET message_read = '1' WHERE message_id = '$messageid' AND to_user = '$userfinal'");
echo "<p>Title: ".$message['message_title']."</p>";
echo "<p>From: ".$message['from_user']."</p>";
echo "<p>Message: <br>".$message['message_contents']."<br></p>";
echo '<form name="backfrm" method="post" action="inbox.php">';
echo '<input type="submit" value="Back to Inbox">';
echo '</form>';
?>
<?php
//And finally import this sql into your database
?>
CREATE TABLE IF NOT EXISTS `messages` (
`message_id` int(11) NOT NULL AUTO_INCREMENT,
`from_user` varchar(65) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`to_user` varchar(65) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`message_title` varchar(65) NOT NULL,
`message_contents` longtext NOT NULL,
`message_read` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;You
© 2012 DaniWeb® LLC
