PHP uses smarty to make a simple message system

The message message is an example that was made with php before. Now I use smarty template to make it.

It looks like this

Click to publish Information

Then fill in the content. After sending, it will return form, and the written content will appear in the form

The data in the database is Like this:

Create two files first. php and html

To log in, use the login you made before to log in

In php

first introduce theentry file, then query the database, adjust the sql statement, and then display which page

<?php include("../init.inc.php");
include("../DBDA.php");
$db = new DBDA();
$sql =" select * from xinxi";
$attr = $db->Query($sql);
$smarty->assign("liuyan",$attr);
$smarty->display("liuyan.html");

#write the format of the table in the html Then traverse the data in the database

The code is as follows

nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<title>无标题文档</title>



<h1 id="留言页面">留言页面</h1>
<p><a>发布信息</a><br>
<a>退出系统</a>
</p>

发送人	发送时间	接收人	信息内容	操作
				">删除

When it runs like this, it looks like this

Let’s create the fabu.php page

In the php file

<?php include("../init.inc.php");

$smarty->display("fabu.html");

Because you don’t need to use a database to publish the page, you only need to display the html file, so there are two lines of code

The page

nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<title>无标题文档</title>



<p>

<a>查看信息</a><br>
<a>退出系统</a>

</p>
<h1 id="信息发送">信息发送</h1>

接收人：

信息内容：

in the html file is displayed like this

The next step is to do the release processing page, which is fabuchuli.php

This page is a pure PHP page, and does not need to be seen by users, so here we just make a PHP file

We need to add something to the login page before doing it

is as follows:

This is its processing page, open session, and store the uid in the session

Then leave it to the release processing page and use it again

fabuchuli.php code is as follows

<?php session_start();

$uid = $_SESSION["uid"];
include("../init.inc.php");
include("../DBDA.php");
$db = new DBDA();
$sql= "select * from users where uid=&#39;{$uid}&#39;";
$attr = $db->Query($sql);


?>

<?php $fsr = "{$attr[0][0]}";
$fssj =  date("Y-m-d",time());
$jsr = $_POST["jsr"];
$xxnr = $_POST["xxnr"];
//造连接对象
$db = new MySQLi("localhost","root","726","text11");
//写SQL语句
$sql = "insert into xinxi values(&#39;&#39;,&#39;{$fsr}&#39;,&#39;{$fssj}&#39;,&#39;{$jsr}&#39;,&#39;{$xxnr}&#39;)";
//执行
$r=$db->query($sql);
if($r)
{
    header("location:liuyan.php");
    
}
else
{
    echo "添加失败";
    
}
?>

This is roughly completed, and the deletion in the information system has not been done. , in the previous blogs, you just need to add a processing page

Re-run it and see, start from login, pay attention here, if you don’t start from login, will the final release be completed? Sender

Run it

Enter the user name and password, then click login

## After logging in, all the xinxi data in the database will appear

Click to exit the system and return to the login interface

Click to publish information

Enter the content in the text box

Click send and you will return to the main page

The content just written will appear in the table

Run successfully

The above is the detailed content of PHP uses smarty to make a simple message system. For more information, please follow other related articles on the PHP Chinese website!