App/HttpController/Index.php
use App\ Model\ Video as VideoModel;
public function getVideoData ( ) {
$params = $this - > request ( ) - > getRequestParam ( ) ;
$page = ! empty ( $params [ 'page' ] ) ? intval ( $params [ 'page' ] ) : 1 ;
$size = ! empty ( $params [ 'size' ] ) ? intval ( $params [ 'size' ] ) : 10 ;
try {
$model = new VideoModel ( ) ;
$res = $model - > getVideoData ( [ ] , $page , $size ) ;
foreach ( $res [ 'list' ] as & $list ) {
$list [ 'create_time' ] = date ( 'Y-m-d H:i:s' , $list [ 'create_time' ] ) ;
$list [ 'update_time' ] = date ( 'Y-m-d H:i:s' , $list [ 'update_time' ] ) ;
$list [ 'video_duration' ] = gmstrftime ( "%H:%M:%S" , $list [ 'video_duration' ] ) ;
}
return $this - > writeJson ( 200 , $res , 'ok' ) ;
} catch ( \Exception $e ) {
throw new \ Exception( $e - > getMessage ( ) ) ;
}
}
<?php
namespace App\ Model ;
class Video extends Base {
public $tableName = 'video' ;
public $db = '' ;
public function __construct ( )
{
$conf = new \ EasySwoole\ Mysqli\ Config( \EasySwoole\ EasySwoole\ Config : : getInstance ( ) - > getConf ( 'MYSQL' ) ) ;
$this - > db = new \ EasySwoole\ Mysqli\ Mysqli( $conf ) ;
}
public function getVideoData ( $condition = [ ] , $page = 1 , $size = 10 ) {
$this - > db - > orderBy ( 'id' , 'desc' ) ;
$res = $this - > db - > where ( 'cat_id' , 1 ) - > get ( $this - > tableName , [ ( $page - 1 ) * $size , $size ] , '*' ) ;
$count = $this - > db - > where ( 'cat_id' , 1 ) - > count ( $this - > tableName ) ;
$data = [
'list' = > $res ,
'count' = > $count ,
'page' = > $page ,
'size' = > $size
] ;
return $data ;
}
}