<?php

// +----------------------------------------------------------------------

// | 模拟器数据库采用sqlite3

// +----------------------------------------------------------------------

// | Author: luofei614<www.3g4k.com>

// +----------------------------------------------------------------------

// $Id: ImitSqlite.class.php 2766 2012-02-20 15:58:21Z luofei614@gmail.com $

class ImitSqlite extends SQLite3{

    function __construct()

    {

        $this->open(dirname(__FILE__).'/sae.db');

    }

    //获得数据，返回数组

    public function getData($sql){

        $this->last_sql = $sql;

        $result=$this->query($sql);

        if(!$result){

            return false;

        }

        $data=array();

        while($arr=$result->fetchArray(SQLITE3_ASSOC)){

            $data[]=$arr;

        }

        return $data;

        

    }

    //返回第一条数据

    public function getLine($sql) {

        $data = $this->getData($sql);

        if ($data) {

            return @reset($data);

        } else {

            return false;

        }

    }



    //返回第一条记录的第一个字段值

    public function getVar($sql) {

        $data = $this->getLine($sql);

        if ($data) {

            return $data[@reset(@array_keys($data))];

        } else {

            return false;

        }

    }

    //运行sql语句

    public function runSql($sql) {

        return $this->exec($sql);

    }



}