The Sent, Trash and Drafts Folders - PHP

In this article, the fourth and final one of our series covering the creation of a PHP email application, we are going to look at the code for some of the remaining pages of the mail application. Chief among these is the NewMsg.php page, which is where items, to be more precise, new messages, are either saved as drafts or saved as sent messages.

TABLE OF CONTENTS:

By: Leidago

Poor Best

Rating:

/ 8

November 15, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

The above folders have similar code, so I'm not going to list the code of each of them here. Let me explain what happens when you want to view the items inside a folder. A query string variable called userID is received, which is used to retrieve messages related to that user. Then a query is run on the table of the related folder (can be the sent, trash or drafts table). Based on the results of that query, a dynamic table is created and all the messages are listed. Here's the code for the Sent folder:

include "connect.php";

//get all msgs

$query_msgs = "select * from sent WHERE userid =
'".$_SESSION['userid']."'";

$re = mysql_query($query_msgs);

$n = mysql_num_rows($re);

if($n > 0){

while($r = mysql_fetch_array($re))

{

<a href="NewMsg.php?sid=<?=$r
['sent_id'];?>" class="email"><?=$r['to'];?></a>

</td>

</tr>

}

Conclusion

That's it! You should now have a fully functional PHP email client. I've used very general code to make it easy for you to adapt it to your liking. The basics are covered, so any changes you make to this will just make your client more useful. In the NewMsgs page I've used a text editor called fckEditor because it makes it possible to format the text, and in so doing enables you to sent HTML email messages. You can download this editor from the Internet, it is entirely free. Also, if you do not want to use this editor, you can use the normal textarea form element instead.