Day 8 Laravel Model

指令 建立一個模組

php artisan make:model User

範例

1. protected $table = "user";//資料表的名稱
2. public $timestamps = false; //可以關閉時間自動建立以及寫入更新的時間欄位
3. $this->where('className' , 'B01' )->count(); //統計數量
4. $this->where('id' , '>' , 0 )->orderBy('created_at' , 'asc');//進行orderby排序
5. 還有許多功能

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use Illuminate\Pagination\Paginator;

use Illuminate\Support\Facades\Request;


class mod_user extends Model
{
   //
   
   protected $table = "user";
   

   public function getByid( $uid ){
       $arrData = [];
       
       
       $arrData = $this->where('id' , '=' , $uid  )->first();
       if( $arrData == null ){
           return false;
       }                 
       return $arrData->toArray();                  
   }
   

   public function countByUser_str( $_user_str ){
       $_user_str = trim($_user_str);
       $iCount = $this->where('user_str' , $_user_str  )->count();
       
       
       return $iCount;
   }
   

   // public function 

   public function updateData( $aData ){
       
       $aUpdateSet = [ 
                       'passwd_md5',
                       'momo' ,
                       'domain_data'
                       ];
       
       $aSave = cxdb_checkArray($aUpdateSet , $aData );
       // dd($aSave);
       $this->where('id' ,  $aData['id']  )
               ->update( $aSave );
       
   }
   
   public function deleteData( $_id ){
       $this->where('id' ,  $_id  )
               ->delete( );
   }
   
   
   
   
}

END

...