Exemplos de Illuminate\Database\Query\Builder::select em PHP

Exemplo n.º 1

Arquivo: testRandomLib.php Projeto: zhangzijun/diandian

$grammar = $conn->getQueryGrammar();
$processor = $conn->getPostProcessor();
$sql = "select column_name from information_schema.columns where table_schema = 'gold_db' and table_name =\r\n't_crm_soa_order'";
$sql = 'desc t_crm_soa_order';
//dd($conn->getColumnListing($table));
//$conn->statement();
$ret = $conn->select($sql);
$queryBuilder = new Illuminate\Database\Query\Builder($conn, $grammar, $processor);
//dd($queryBuilder->getColumnListing($table));
dd($ret);
exit;
$conn->affectingStatement();
$conn->commit();
//dd($conn->getColumnListing($table));
//dd($conn->statement('desc t_crm_soa_order'));
dd($queryBuilder->select('desc t_crm_soa_order'));
dd($conn->statement('desc t_crm_soa_order'));
//$ret =Capsule::connection('seed')->table('t_crm_soa_order')->count();
//use App\Lib\BaseModel;
//$model = new BaseModel();
//$model->setConnection('seed');
//$model->setTable('t_crm_soa_order');
//dd($model->newQueryWithoutScopes()->select('desc ' . $model->getTable()));
//dd($model->count());
exit;
filter();
Capsule::schema()->create('users', function ($table) {
    $table->increments('id');
    $table->string('username', 40);
    $table->string('email')->unique();
    $table->timestamps();