piler/webui/system/database/sqlite.php

<?php


class SQLite {
   private $link;
   private $affected;

   public function __construct($hostname, $username, $password, $database, $prefix = NULL) {
      $fixperm = 0;

      if(!file_exists($database)) { $fixperm = 1; }

      try {
         $this->link = new PDO("sqlite:$database", 'OPEN_CREATE');
      }
      catch(PDOException $exception) {
         exit('Error: ' . $exception->getMessage() . " on $database<br />");
      }

      if($fixperm == 1) { chmod($database, 0660); }

      $this->affected = 0;
   }


   public function select_db($database) { }


   public function query($sql) {
      $query = new stdClass();

      $query->error = 1;
      $query->errmsg = "Error";
      $query->query = $sql;

      $time_start = microtime(true);

      $i = 0;
      $data = array();

      $s = $this->link->prepare($sql);
      if(!$s) { return $query; }

      $s->execute();

      $this->affected = $s->rowCount();

      $R = $s->fetchAll();

      foreach($R as $k => $v) {
         $data[$i] = $v;
         $i++;
      }

      $query->row      = isset($data[0]) ? $data[0] : array();
      $query->rows     = $data;
      $query->num_rows = $i;

      $query->error = 0;
      $query->errmsg = "";

      unset($data);

      $time_end = microtime(true);

      $query->exec_time = $time_end - $time_start;

      return $query;
   }


   public function escape($value) {
      //return $this->link->quote($value);
      return $value;
   }


   public function countAffected() {
      return $this->affected;
   }


   public function getLastId() {
      return $this->link->lastInsertId();
   }


   public function __destruct() { }

}


?>