php与smarty相互结合的插入例子

来源:互联网 发布:金蝶eas7.5数据字典 编辑:程序博客网 时间:2024/05/21 15:05

<?php
require_once("conn_inc.php");
require_once("smarty_inc.php");
if ($_POST["submit"]) {
$name= $_POST['name'];
$pass=  $_POST['pass'];
$mail=  $_POST['mail'];
$content=$_POST['content'];
$sql="insert into  `news_list` (name,pass,`mail`,`content`) values ('$name','$pass','$mail','$content')";
$query=mysql_query($sql);
if ($query) {
 echo "<script>alert('用户添加 成功,请返回!')</script>";
 echo "<script>location.href='login.php'</script>";
}else {
 echo "<script>alert('用户添加失败')</script>";
}
}
$smarty->display("login.tpl.html");
?>

模板部分内容:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<form action="" method="POST">
<table border="1" align="center" width="50%">
<tr>
<td>用户名:</td>
<td><input type="text" name="name" size="30"></td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="pass" size="30"></td>
</tr>
<tr>
<td>注册邮箱:</td>
<td><input name="mail" type="text" size="30"></td>
</tr>
<tr>
<td>详细介绍</td>
<td><textarea rows="10" cols="40" name="content"></textarea></td>
</tr>
<tr><td colspan="2"><center><input type="submit" value="提交" name="submit"></center></td></tr>
</table>
</form>
</body>
</html>