如何将参数传递给Laravel DB :: transaction()

问题描述

限时删除！！

从laravel文档中:数据库事务.它说:

From the laravel documentation: Database Transaction.It says that:

DB::transaction(function() {
    DB::table('users')->update(array('votes' => 1));
    DB::table('posts')->delete();
});

在这里，显式输入1以更新用户...我用一个变量试过了

Here, 1 is explicitly entered to update the users...I tried this using a variable,

$id = 3;
DB::transaction(function() {
    DB::table('users')->where('id','=',$id)->get();
});

它抛出一个错误:

Undefined variable: id

我还尝试将$ id放置为这样的参数:

I also tried to place to $id as a parameter like this:

$id = 3;
DB::transaction(function($id) {
    DB::table('users')->where('id', '=', $id)->get();
});

还是一个错误:

我做错了什么吗?请指教.谢谢...

Have I done anything wrong? Please advise. Thanks...

推荐答案

您需要的是use关键字:

$id = 3;
DB::transaction(function($id) use ($id) {
    DB::table('users')->where('id', '=', $id)->get();
});

对于PHP 7(未经测试，根据以下答案的要求进行编辑):

For PHP 7 (untested, edited as requested by the answer below):

$id = 3;
DB::transaction(function() use ($id) {
    DB::table('users')->where('id', '=', $id)->get();
});

这篇关于如何将参数传递给Laravel DB :: transaction()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1403页，肝出来的..