Laravel框架—模型操作数据库

最新推荐文章于 2025-04-04 16:14:46 发布

砚子丫

最新推荐文章于 2025-04-04 16:14:46 发布

阅读量540

点赞数 1

分类专栏： laravel

本文链接：https://blog.youkuaiyun.com/weixin_45080962/article/details/104562676

版权

laravel 专栏收录该内容

7 篇文章

订阅专栏

1.创建模型UserModel

例：app\models\UserModel.php

<?php
namespace app\models;
use Illuminate\Database\Eloquent\Model;
class UserModel extends Model{
	//数据库表名
	protected $table = 'user';
	//主键
	protected $primaryKey = 'id';
	//是否开启时间戳  true时系统会自动管理CREATED_AT  UPDATE_AT 二个时间字段
	public $timestamps = false;
	//时间格式 'U' 是指UNIX时间戳格式
	//protected $dateFormat = 'U';
	//定义创建时间的字段名
	//const CREATED_AT = 'create_time';
	//定义修改时间的字段名
	//const UPDATE_AT = 'update_time';
}
?>

2.创建控制器UserController

模型的查询方法(后者为查询构造器方法):
1.获取多条 all()
User::select()->where()->get()
2.获取单条 find()
User::select()->where()->first()
3.模型的插入 save()
User::insert()
4.模型的更新 save()
User::where()->update
5.模型的删除 destory ()
User::where()->delete

例：app\Http\home\UserController.php

<?php
namespace App\Http\Controllers\home;
use App\models\UserModel;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
class UserController extends Controller{
	public function select(){
	     //1.获取全部数据
		 //模型方法all():（括号内可以限制字段）
		 $res = UserModel::all(['username','phone']);
		 //查询构造器方法
		 $res = UserModel::select(['username','phone'])->get();
		 $res = UserModel::get(['username','phone']);
	     //2.获取单条数据
	     //模型方法find():
	     $res = UserModel::find('3');
	     $res = UserModel::first();
	     //3.获取所有数据渲染到视图页面
	     $res = UserModel::all();
	     return view('home.index')->with('user',$res);
		 //dump($res);
	}

	public function insert(){
		$user = new UserModel();
		/*
		$user->username = 'zs';
		$user->password = '4444';
		$user->phone = '110';
		$user->email = '14478225';
		$user->save();
		*/
	//查询构造器
	$user->insert([
		'username' => 'ls',
		'password' => 1,
		'phone' => 12,
		'email' => '5555']
	);
	dump('success');
	}
	public function update(Request $request){
		$id = $request->route('id');
		/*
		$users = UserModel::find($id);
		$users->username = 'new';
		$users->save();
		*/
	    //查询构造器
		UserModel::where('id',$id)->update(['username'=>'tt']);
		dump('success');
	}
	public function delete(Request $request){
		$id = $request->route('id');
		UserModel::destroy($id);
		//查询构造器
		//UserModel::where('id',$id)->delete();
		dump('delete');
	}
}
?>

3.创建视图文件Index

例：resources\views\home\index.blade.php

<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body> 
<table>
	<caption>用户表</caption>
	<tr>
		<th>ID</th>
		<th>姓名</th>
		<th>手机号</th>
		<th>邮件</th>
	</tr>
	<?php foreach ($user as $u): ?>
	<tr>
     <td><?php echo $u->id; ?></td>
     //简便写法输出
     <td><?=$u->username?></td>
     <td><?=$u->phone?></td>
     <td><?=$u->email?></td>
	</tr>
<?php endforeach; ?>
</table>