Home > Article > Backend Development > 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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <h1>留言页面</h1> <p><a href="fabu.php">发布信息</a><br /> <a href="login.php" onclick=" return confirm('确定退出么?')">退出系统</a> </p> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td>发送人</td> <td>发送时间</td> <td>接收人</td> <td>信息内容</td> <td>操作</td> </tr> <{foreach $liuyan as $v}> <tr> <td><{$v[1]}></td> <td><{$v[2]}></td> <td><{$v[3]}></td> <td><{$v[4]}></td> <td><a href="shanchu.php?code=<{$v[0]}>">删除</a> </td> </tr> <{/foreach}> </table> </body> </html>
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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <p> <a href="liuyan.php">查看信息</a><br /> <a href="denglu.php" onclick=" return confirm('确定退出么?')">退出系统</a> </p> <h1>信息发送</h1> <form action="fabuchuli.php" method="post"> <input type="hidden" name="fsr" /> <p>接收人:<input type="text" name="jsr"/></p> <input type="hidden" name="fssj" /> <br /> <p>信息内容:<input type="text" name="xxnr" /></p> <br /> <p><input type="submit" value="发送" /><input type="reset" value="复位" /></p> </form> </body> </html>
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='{$uid}'"; $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('','{$fsr}','{$fssj}','{$jsr}','{$xxnr}')"; //执行 $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 appearClick to exit the system and return to the login interfaceClick to publish informationEnter the content in the text box Click send and you will return to the main page The content just written will appear in the tableRun 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!