我的框架:模型

末蓝、 2022-09-19 10:52 150阅读 0赞

<?php 
final class MBizLog extends SModel \{ 
    protected static $handle; //单例句柄 
 
 
    protected $table; 
 
    protected function \_\_construct() \{ 
        $this->table = $this->\_table('biz\_log'); 
    \} 
 
    /\*\* 
     \* 获取本类单例的方法,公开 
     \* 
     \* @return MBizLog 
     \*/ 
    public static function instance() \{ 
        if(self::$handle)\{ 
            return self::$handle; 
        \} 
 
        $class = \_\_CLASS\_\_; 
        self::$handle = new $class(); 
        return self::$handle; 
    \} 
 
    /\*\* 
     \* 商家管理时调用的日志插入 
     \* 
     \*/ 
    static public function addLog($msg) \{

所有模型都继承SModel类

模型类名以M开头

前两个属性与前两个方法是固定写法  , 请修改其中与具体表相关的词(包括注释中)

之后是各种模型方法

注意,模型是单例的,调用时需要 MProduct::instance()->xxx()

* 基类已经实现的模型方法
 
 <table style="direction:ltr;
 border-collapse:collapse;border-style:solid;border-color:#A3A3A3;border-width:
 1pt"> 
 <tbody> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 1 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> get </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 获取单值 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 2 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> row </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 获取一条记录 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 3 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> col </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 获取一列 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 4 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> select </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 获取多条记录 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 5 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> update </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 6 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> insert </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 7 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> delete </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 8 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> exist </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 判断是否存在满足条件的记录 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 9 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> immit </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 处理字符串,防注入 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 10 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> count </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt"> 计数 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt"> &nbsp; </td> 
 </tr> 
 </tbody> 
 </table>
 
  
 
  
 
 table属性的常用方法
 
 <table style="direction:ltr;
 border-collapse:collapse;border-style:solid;border-color:#A3A3A3;border-width:
 1pt"> 
 <tbody> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 1 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6881in;padding:4pt 4pt 4pt 4pt"> query </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:1.4847in;padding:4pt 4pt 4pt 4pt"> 复杂SQL语句的查询 </td> 
 </tr> 
 <tr> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt"> 2 </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:.6881in;padding:4pt 4pt 4pt 4pt"> execute </td> 
 <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
 vertical-align:top;width:1.4847in;padding:4pt 4pt 4pt 4pt"> 复杂SQL语句的执行 </td> 
 </tr> 
 </tbody> 
 </table>

阅读(166) | 评论(0) | 转发(0) |

上一篇：我的框架:模板

下一篇：我的框架:表单验证