lib/code.php

   1 <?php
   2
   3         require "persistance.php";
   4
   5         class SqlCode implements sql, persistance
   6         {
   7                 static $db;
   8                 var $id;
   9                 var $code;
  10                 var $date;
  11
  12                 function __construct($code)
  13                 {
  14                         $this->code = $code;
  15                         $this->date = date('c');
  16                         $this->id = 'md5:'. md5($this->code);
  17                 }
  18
  19                 public static function get_table_name()
  20                 {
  21                         return "sql";
  22                 }
  23
  24                 public static function sql_select($options = NULL)
  25                 {
  26                         $table = self::get_table_name();
  27                         $query = "select id, code, date from $table $options";
  28                         return $query;
  29                 }
  30
  31                 function toSQLselect()
  32                 {
  33                         $table = $this->get_table_name();
  34                         $id    = $this->id;
  35                         $query = "select id, code, date from $table where id='$id'";
  36                         return $query;
  37                 }
  38
  39                 function toSQLinsert()
  40                 {
  41                         $table = $this->get_table_name();
  42                         $id    = $this->id;
  43                         $code  = $this->code;
  44                         $date  = $this->date;
  45                         $query = "insert into $table (id, code, date) values ('$id', '$code', '$date')";
  46                         return $query;
  47                 }
  48
  49                 static function set_db($db)
  50                 {
  51                         if ($db instanceof PDO) {
  52                                 self::$db =& $db;
  53                         } else {
  54                                 if (empty($user)) {
  55                                         self::$db =& new PDO($db);
  56                                 } else {
  57                                         self::$db =& new PDO($db, $user, $password);
  58                                 }
  59                         }
  60                         self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  61
  62                         return self::$db;
  63                 }
  64
  65                 static function select($options = NULL, $db = NULL)
  66                 {
  67                         if (!$db) $db =& self::$db;
  68                         $query = self::sql_select($options);
  69                         $result = $db->query($query);
  70                         $scripts = array();
  71                         foreach ($result as $r) {
  72                                 $s       = new SqlCode($r['code']);
  73                                 $s->id   = $r['id'];
  74                                 $s->date = $r['date'];
  75                                 $scripts []= $s;
  76                         }
  77                         return $scripts;
  78                 }
  79
  80                 function save($db = NULL)
  81                 {
  82                         if (!$db) $db =& self::$db;
  83                         $query = $this->toSQLinsert();
  84                         $id = $this->id;
  85                         $table = self::get_table_name();
  86                         try {
  87                                 $db->exec($query);
  88                         } catch (PDOException $e) {
  89                                 if ($db->errorCode() == "23000") { // l'id existe dans la table
  90                                         $db->exec("delete from $table where id='$id'");
  91                                         $db->exec($query);
  92                                 }
  93                         }
  94                         return $this;
  95                 }
  96         }