Dieser Artikel stellt hauptsächlich das TP5-Singleton-Modus-Betriebsmodell vor, das einen gewissen Referenzwert hat. Jetzt kann ich es mit allen teilen, die es brauchen.
1. Erstellen Sie eine Datenbank und eine Datenbankkonfiguration
1. Das Datenbankdesign ist wie folgtSET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `u_id` int(255) NOT NULL AUTO_INCREMENT, `u_name` varchar(50) NOT NULL, `u_age` int(3) DEFAULT NULL, `u_sex` tinyint(1) DEFAULT NULL, PRIMARY KEY (`u_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
<?php
// +----------------------------------------------------------------------
// | ThinkPHP [ WE CAN DO IT JUST THINK ]
// +----------------------------------------------------------------------
// | Copyright (c) 2006~2018 http://thinkphp.cn All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: liu21st <liu21st@gmail.com>
// +----------------------------------------------------------------------
return [
// 数据库类型
'type' => 'mysql',
// 服务器地址
'hostname' => '127.0.0.1',
// 数据库名
'database' => 'singletons',
// 用户名
'username' => 'root',
// 密码
'password' => '123456',
// 端口
'hostport' => '3306',
// 连接dsn
'dsn' => '',
// 数据库连接参数
'params' => [],
// 数据库编码默认采用utf8
'charset' => 'utf8',
// 数据库表前缀
'prefix' => 'u_',
// 数据库调试模式
'debug' => true,
// 数据库部署方式:0 集中式(单一服务器),1 分布式(主从服务器)
'deploy' => 0,
// 数据库读写是否分离 主从式有效
'rw_separate' => false,
// 读写分离后 主服务器数量
'master_num' => 1,
// 指定从服务器序号
'slave_no' => '',
// 是否严格检查字段是否存在
'fields_strict' => true,
// 数据集返回类型
'resultset_type' => 'array',
// 自动写入时间戳字段
'auto_timestamp' => false,
// 时间字段取出后的默认时间格式
'datetime_format' => 'Y-m-d H:i:s',
// 是否需要进行SQL性能分析
'sql_explain' => false,
];<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>TP5.0单例模式</title>
<link rel="stylesheet" href="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="http://cdn.static.runoob.com/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<p style="margin-top:20%;">
<form class="form-horizontal" role="form" method="POST" action="{:url('users/add')}">
<p class="form-group">
<label for="firstname" class="col-sm-2 control-label">Id</label>
<p class="col-sm-6">
<input type="text" class="form-control" name="id" id="id"
placeholder="id">
</p>
</p>
<p class="form-group">
<label for="lastname" class="col-sm-2 control-label">Name</label>
<p class="col-sm-6">
<input type="text" class="form-control" name="name" id="name"
placeholder="Name">
</p>
</p>
<p class="form-group">
<p class="col-sm-offset-2 col-sm-10">
<p class="checkbox">
<label>
<input type="checkbox"> Remember me
</label>
</p>
</p>
</p>
<p class="form-group">
<p class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-default">Go</button>
</p>
</p>
</form>
</p>
</body>
</html><?php // +---------------------------------------------------------------------- // | ThinkPHP [ WE CAN DO IT JUST THINK ] // +---------------------------------------------------------------------- // | Copyright (c) 2006~2018 http://thinkphp.cn All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- // | Author: liu21st <liu21st@gmail.com> // +---------------------------------------------------------------------- Route::rule('add','users/add','GET'); // 添加 Route::rule('del','users/del','GET'); // 删除 Route::rule('update','users/update','GET'); // 更新 Route::rule('query','users/query','GET');// 查询 Route::rule('batchupdate','users/batchupdate','GET'); // 更新多个
<?php
namespace app\index\controller;
use app\index\model\Users as UsersModel;
use think\Controller;
use think\Db;
class Users extends Controller
{
/**
* 模板渲染
*/
public function index()
{
return view('index');
}
/**
* 添加一条数据
*/
public function add()
{
$u_id = intval(input('id'));
$u_name = input('name');
$u_age = 18;
$u_sex = 0;
$insertOne = UsersModel::insertOne($u_id,$u_name,$u_age,$u_sex);
if($insertOne)
{
$this->success("插入".$u_name."成功");
}
else{
$this->error("插入".$u_name."失败");
}
}
/**
* 删除一条数据(硬删除)
*/
public function del()
{
$u_id = intval(input('id'));
$delOne = UsersModel::deleteOne($u_id);
if($delOne)
{
$this->success("删除".$u_id."成功");
}
else{
$this->error("删除".$u_id."失败");
}
}
/**
* 更新
*/
public function update()
{
$u_id = intval(input('id'));
$u_age = 18;
$updateOne = UsersModel::updateOne($u_id,$u_age);
if($updateOne)
{
$this->success("更新".$u_id."的年龄为".$u_age."成功");
}
else{
$this->error("更新".$u_id."的年龄为".$u_age."失败");
}
}
/**
* 查询
*/
public function query()
{
$filed = "u_id,u_age"; //多个字段以逗号隔开
$u_id = "";
$query = UsersModel::query($filed,$u_id);
dump($query);
}
/**
* 批量修改
*/
public function batchupdate()
{
$array = array(array('u_id'=>1,'u_name'=>'deng','u_age'=>18,'u_sex'=>1),array('u_id'=>2,'u_name'=>'yuan','u_age'=>19,'u_sex'=>2));
$updateall = UsersModel::batchUpdate($arr);
if($updateall)
{
$this->success("success");
}
else{
$this->error("error");
}
}
}<?php
namespace app\index\model;
use think\Model;
use think\Db;
/**
* 使用静态方法 static 而不是 public 在controller里面不用new 直接用 会方便很多
*/
class Users extends Model
{
private static $instance;
protected $defaultField = 'danli';
private function __clone(){} //禁止被克隆
/**
* 单例
*/
public static function getInstance()
{
if(!(self::$instance instanceof self)){
self::$instance = new static();
}
return self::$instance;
}
/**
* 添加一条数据
*/
public static function insertOne($uid,$uname,$uage,$usex)
{
$inserttheone = self::getInstance()->execute("insert into users(u_id,u_name,u_age,u_sex) value(".$uid.",'".$uname."',".$uage.",".$usex.")");
if($inserttheone)
{
return true;
}
else{
return false;
}
}
/**
* 删除一条数据
*/
public static function deleteOne($uid)
{
$delone = self::getInstance()->execute("delete from users where u_id = ".$uid."");
if($delone)
{
return true;
}
else{
return false;
}
}
/**
* 修改一条数据
*/
public static function updateOne($uid,$age)
{
$updateone = self::getInstance()->execute("update users set u_age = ".$age." where u_uid = ".$uid."");
if($updateone)
{
return true;
}
else{
return false;
}
}
/**
* 查询
*/
public static function query($defaultField,$uid)
{
if($defaultField == '' || empty($defaultField) || is_null($defaultField)){
$defaultField = '*';
}
if($uid == '' || empty($uid) || is_null($uid)){
$uid = '';
}
else{
$uid = "where u_id = $uid";
}
return self::getInstance()->query("select $defaultField from users $uid");
}
/**
* 批量修改
*/
public static function batchUpdate($arr)
{
foreach ($arr as $key => $value) {
$updatearr = self::getInstance()->execute("update users set u_name = '".$value['u_name']."',u_age = ".$value['u_age'].",u_sex = ".$value['u_sex']." where u_uid = ".$uid."");
if($updatearr)
{
return true;
}
else{
return false;
}
}
}
}Tp5-Projektänderungsdatenbank
Das obige ist der detaillierte Inhalt vonTP5-Singleton-Modus-Betriebsmodell. Für weitere Informationen folgen Sie bitte anderen verwandten Artikeln auf der PHP chinesischen Website!
