leben-jp

$users = DB::table('users')
            ->where('deleted', '<>', 1)
            ->get();

leben-jp

$sql = DB::table('users')
            ->where('deleted', '<>', 1);

dd($sql->toSql(), $sql->getBindings());

leben-jp

string(43) "select * from `users` where `deleted` <> ?"

leben-jp

DB::enableQueryLog();

//ここで表示したい実行のquery

$queries = DB::getQueryLog();
print_r($queries);

leben-jp

<?php

DB::last_query();

leben-jp

<?php

// DBクラスを使用しSQLを実行
$query = DB::select()->from('user');
$query->where('deleted', 1);
$res = $query->execute()->as_array();
 
// 実行したSQLクエリを表示
var_dump(DB::last_query());

leben-jp

<?php

$query = Doctrine_Query::create()->select('id')->from('MyTable');
$query->where('normalisedname = ? OR name = ?', array($string, $originalString));

echo sprintf(str_replace('?', '%s', $query->getSql()), $query->getParams());

leben-jp

<?php

$query = new Books::find()->where('author=2');

leben-jp

<?php

$query = new Books::find()->where('author=2');
//↓これ
echo $query->createCommand()->sql;

leben-jp

<?php

$query = new Books::find()->where('author=2');
//↓これ
echo $query->createCommand()->getRawSql();