摘要：入口文件 require './config/config.php'; require './db/contact.php'; require './db/add.php'; require './db/update.php'; require './db/delete.php
入口文件
require './config/config.php';
require './db/contact.php';
require './db/add.php';
require './db/update.php';
require './db/delete.php';
require './db/select.php';
$smarty->assign('rows',$rows);
$smarty->display('demo1.html');smarty配置文件 require __DIR__.'/../vendor/autoload.php'; $smarty=new Smarty(); $smarty->setTemplateDir(__DIR__.'/../temp'); $smarty->setCompileDir(__DIR__.'/../comp'); $smarty->setCacheDir(__DIR__.'/../cache'); $smarty->setConfigDir(__DIR__.'/../config'); $smarty->setCaching(false); $smarty->setCacheLifetime(60*60*24*7);
连接数据库文件 require __DIR__ . './../vendor/autoload.php'; use Medoo\Medoo; $db = new Medoo([ // required 'database_type' => 'mysql', 'database_name' => 'phpstudy', 'server' => '127.0.0.1', 'username' => 'root', 'password' => '', // [optional] 'charset' => 'utf8', 'port' => 3306 ]); $table='user';
增加
$name=isset($_GET['name'])?$_GET['name']:null;
$password=isset($_GET['password'])?$_GET['password']:null;
if($name && $password){
$arr['name']=$name;
$arr['password']=sha1($password);
$arr['token']=sha1($name.time());
$stmt=$db->insert($table,$arr);
}删除
$delete_id=isset($_GET['delete_id'])?$_GET['delete_id']:null;
if($delete_id){
$where['id']=$delete_id;
$db->delete($table,$where);
}查找 $fileds=['id','name','password','token']; $where=[]; $rows=$db->select($table,$fileds,$where);
修改
$update_id=isset($_GET['update_id'])?$_GET['update_id']:null;
$update_name=isset($_GET['update_name'])?$_GET['update_name']:null;
$update_password=isset($_GET['update_password'])?$_GET['update_password']:null;
if($update_id){
$arr['password']=sha1($update_password);
$arr['name']=$update_name;
$where['id']=$update_id;
$db->update($table,$arr,$where);
}html文件
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>medoo增删改查</title>
</head>
<body>
<form action="">
<table>
<caption>添加数据</caption>
<tr>
<td>姓名</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="text" name="password"></td>
</tr>
<tr>
<td></td>
<td><button>注册</button></td>
</tr>
</table>
</form>
<hr>
<table border="1">
<caption>用户信息</caption>
<tr>
<th>id</th>
<th>姓名</th>
<th>密码</th>
<th>token</th>
<th>操作</th>
</tr>
{foreach $rows as $row}
<tr>
<td>{$row.id}</td>
<td>{$row.name}</td>
<td>{$row.password}</td>
<td>{$row.token}</td>
<td>
<button onclick="update(event)">修改</button>
<a href="?delete_id={$row.id}">删除</a>
</td>
</tr>
{foreachelse}
<tr>
<td colspan="5">暂无数据</td>
</tr>
{/foreach}
</table>
<hr>
<form action="">
<table>
<caption>修改信息</caption>
<tr>
<td>姓名</td>
<td>
<input type="hidden" name="update_id">
<input type="text" name="update_name" value="321654">
</td>
</tr>
<tr>
<td>密码</td>
<td><input type="text" name="update_password"></td>
</tr>
<tr>
<td></td>
<td><button>提交</button></td>
</tr>
</table>
</form>
<script>
function update(e){
//找到按钮所在tr
var btn=e.target;
var tr=btn.parentNode.parentNode;
//获取所有子元素
var trs=tr.children;
//获取修改信息的输入框
var update_id=document.getElementsByName('update_id')[0];
var update_name=document.getElementsByName('update_name')[0];
//设置值
update_id.value=trs[0].innerHTML;
update_name.value=trs[1].innerHTML;
}
</script>
</body>
</html>
批改老师：韦小宝批改时间：2019-01-23 16:08:36
老师总结：写的很不错 很有想法 编程就是要这样大胆的去尝试 继续加油吧
