To view/preview the executing query or last executed Query Log in Laravel 5 (including Laravel 4.2, Laravel 5.0, Laravel 5.2), please add the below code and run it.
Please comment me if you have any queries
// This is the Sample Controller
class SampleController extends Controller
{
public function sampleControllerFunction()
{
$this->owner_id = 5;
// Enable the Laravel Database Query Log
DB::enableQueryLog();
// Run your Query here
$item = SampleModel::where('owner_id', $this->owner_id)->first();
SampleModel::where('owner_id', $owner_id)->forceDelete();
// Fetch and Print the Last Database Query Log
print_r( DB::getQueryLog() );
}
}
// This is the Sample Model
class SampleModel extends Model
{
/**
* The database table used by the model (mysql).
*
* @var string
*/
protected $table = 'owner_list';
/**
* The attributes that are mass assignable..
*
* @var string
*/
protected $fillable = ['id', 'owner_id'];
public function getItemsList()
{
// Enable the Laravel Database Query Log
DB::enableQueryLog();
// Run your Query here
$item = static::where('owner_id', $this->owner_id)->first();
// Fetch and Print the Last Database Query Log
print_r( DB::getQueryLog() );
}
}
Please comment me if you have any queries
No comments:
Post a Comment
Please post any queries and comments here.