gum是基于php的开箱即用代码库。
// 链接数据库
$db = new db("table","password","root","127.0.0.1",3306);
// 查询一条记录
$row=$db->row("SELECT * FROM table");
// 查询记录集合
$rows=$db->rows("SELECT * FROM table");
// 查询记录总数
$count=$db->count("SELECT * FROM table");
// 插入
$db->insert("table",[
"title" => "title",
"content" => "content",
]);
// 获取新插入的自动编号id
$db->id();
// 更新
$db->update("table",[
"title" => "title",
"content" => "content",
],"id=1");
// 删除
$db->delete("table",[
"title" => "title",
"content" => "content",
],"id=1");
// 清空表数据
$db->clear(["table1","table2"]);
// 备份数据库导出sql语句
$db->export();
参考demo-model.php
gum::mail([
"to" => "[email protected]",
"subject" => "test",
"body" => "test",
"from" => SMTP_MAIL,
"server" => SMTP_SERVER,
"port" => SMTP_PORT,
"user" => SMTP_USER,
"password" => SMTP_PASSWORD,
]);
gum::json([
"success" => true,
]);
参考demo-validate.php
- 金额
echo format::rmb(12345);
- 容量
echo format::size(1024);
- 时间
echo format::ago($_SERVER['REQUEST_TIME']);
- 拼音
echo format::pinyin('**');