Hello guys!, yea I'm back finally bring your guys Part3 of my tour. Today we going to create main script that will aloud you to see your messages that have been send to you.


If you have not view Part1, Part2 here following link below:

Part1
http://dsipaint.com/memberblog.php?blog=84627

Part2
http://dsipaint.com/memberblog.php?blog=84774


Now that clear let get started; if you have not done so you will need a file call Inbox.php(Main file).

First start the php script with following
<?php


Then we need to connect to the database table. If you don't know how to create a connection base file follow the intrusction below.


/* start of the script */
<?php
mysql_connect("Mysql host link","Username","Password");
/* now select table we won't */
Mysql_select_db("table name");
?>
/* end conntection script */


Here the full version
<?php
mysql_connect("Mysql host link","Username","Password");
Mysql_select_db("table name");
?>


Now that you create the script save it as database.php. And finally we can include it and our main script.

Now you should call $_SESSION username or cookie session name you uses in your login script.


<?php
include("database.php");
$To_user = $_SESSION['Username'];
/* Now we need to get info from table */
$info = mysql_query("SELECT * FROM Inbox WHERE To_user='$To_user'");

/* Next we need to display the messages in mysql_num_rows or mysql_fetch_array */

Also be sure to loop it meaning while($row = mysql_fetch_array($info)) this will display each message.

Then we need to print out the messages. To do this just echo print.

While($row = mysql_fetch_array($info)) {
echo"From: ".$row[From_user]."";
echo"<br>";
echo"Subject: <a href=Inbox_msg_view.php?Id=".$row[id].">".$row[Subject]."</a>";
echo"<br>";
}
?>


Lastly we close it off. Good job you have create main inbox file here the full demo


<?php
include("database.php");
$To_user = $_SESSION['Username'];

$info = mysql_query("SELECT * FROM Inbox WHERE To_user='$To_user' ");
While($row = mysql_fetch_array($info)) {
echo"From: ".$row[From_user]."";
echo"<br>";
echo"Subject: <a href=Inbox_msg_view.php?Id=".$row[id].">".$row[Subject]."</a>";
echo"<br>";
}
?>

---

hope you guys like this script next week I show you guys how to create Inbox_msg_view.php that will aloud you to view and read your messages.


If you have any questions please post them below.

Have great MLK weekend!