lib/code.php

   1 <?php
   2
   3         require "persistance.php";
   4
   5         class SqlCode implements sql
   6         {
   7                 var $id;
   8                 var $code;
   9                 var $date;
  10
  11                 function __construct($code)
  12                 {
  13                         $this->code = $code;
  14                         $this->date = date('c');
  15                         $this->id = 'md5:'. md5($this->code);
  16                 }
  17
  18                 public static function get_table_name()
  19                 {
  20                         return "sql";
  21                 }
  22
  23                 public static function sql_select($options = NULL)
  24                 {
  25                         $table = self::get_table_name();
  26                         $query = "select id, code, date from $table $options";
  27                         return $query;
  28                 }
  29
  30                 function toSQLselect()
  31                 {
  32                         $table = $this->get_table_name();
  33                         $id    = $this->id;
  34                         $query = "select id, code, date from $table where id='$id'";
  35                         return $query;
  36                 }
  37
  38                 function toSQLinsert()
  39                 {
  40                         $table = $this->get_table_name();
  41                         $id    = $this->id;
  42                         $code  = $this->code;
  43                         $date  = $this->date;
  44                         $query = "insert into $table set id='$id', code='$code', date='$date'";
  45                         return $query;
  46                 }
  47         }