framework/apps/controllers/Db.php at master · stonegithubs/framework · GitHub

Repository navigation

History

78 lines (68 loc) · 1.64 KB

Raw

<?php

namespace App\Controller;

use Swoole;

class Db extends Swoole\Controller

{

function apt_test()

{

$apt = new Swoole\SelectDB($this->db);

$apt->from('users');

$apt->equal('id', 1);

$res = $apt->getall();

var_dump($res);

}

function tables()

{

/**

* master database

$tables = $this->db->query("show tables")->fetchall();

var_dump($tables);

/**

* other

$tables = $this->db("huya")->query("show tables")->fetchall();

var_dump($tables);

}

function put()

{

$model = Model('User');

$id = $model->put(array('name' => 'swoole', 'level' => 5, 'mobile' => '19999990000'));

echo "insert id = $id\n";

}

function get()

{

$model = Model('User');

$user = $model->get(1);

/**

* 打印数组

var_dump($user->get());

/**

* 修改mobile 为 13800008888

$user->mobile = '13800008888';

$user->save();

//删除此条记录

//$user->delete();

}

function gets()

{

$model = Model('User');

//level = 5

$gets['level'] = 5;

//仅获取数据

//var_dump($model->gets($gets));

//分页

$gets['page'] = empty($_GET['page'])?1:intval($_GET['page']);

$gets['pagesize'] = 5;

$pager = null;

$list = $model->gets($gets, $pager);

foreach($list as $li)

{

echo "{$li['id']}: {$li['name']}<br/>\n";

}

echo $pager->render();

}

framework/apps/controllers/Db.php at master · stonegithubs/framework · GitHub

Repository navigation

Expand file tree

Breadcrumbs

Db.php

Latest commit

History

Breadcrumbs

Db.php

File metadata and controls