FM / libs

/var/www/allseasontrans.com/www/libs

Name	Size	Mode	Actions
class.ajax.php	794	0755	edit dl rm
class.bootstrap.php	4279	0755	edit dl rm
class.controller.php	904	0755	edit dl rm
class.database.php	2003	0755	edit dl rm
class.form.php	3090	0755	edit dl rm
class.gd.php	8982	0755	edit dl rm
class.hash.php	210	0755	edit dl rm
class.model.php	1734	0755	edit dl rm
class.num_to_string.php	4016	0755	edit dl rm
class.session.php	1178	0755	edit dl rm
class.transfer_scales.php	10626	0755	edit dl rm
class.validate.php	2584	0755	edit dl rm
class.view.php	901	0755	edit dl rm

Edit: /var/www/allseasontrans.com/www/libs/class.database.php (2003B)

<?php
class database extends PDO
{
    function __construct($DB_TYPE, $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS,$ENCODE)
    {
        try{
            parent::__construct($DB_TYPE . ':host=' . $DB_HOST . ';dbname=' . $DB_NAME . '', '' . $DB_USER . '', '' . $DB_PASS);
            $this->query("set names $ENCODE");
            $this->query("SET lc_time_names = 'ru_RU'");
            $this -> setAttribute ( PDO :: ATTR_ERRMODE , PDO :: ERRMODE_EXCEPTION );
            $this -> setAttribute ( PDO :: ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC );
        }catch (Exception $e){
             echo  $e->getMessage();
        }
    }
    public function insert($table, $data)
        {
                ksort($data);
                $fieldsNames = implode('`,`', array_keys($data));
                $fieldsValues = ':' . implode(',:', array_keys($data));
                $sth = $this->prepare("INSERT INTO `$table` (`$fieldsNames`)VALUES ($fieldsValues);");
            foreach ($data as $key => $value) {
                $sth->bindValue(":$key", $value);
            }
                $sth->execute();
        }
    public function log ($msg,$parent_class=''){
         $this->insert('logs',array(
                       'action'      =>$msg,
                       'users_login' =>session::get('login'),
                       'ip'          =>$_SERVER["REMOTE_ADDR"],
                       'func'        =>$parent_class 
                      ));
    }
    public function update($table, $data, $where)
        {
                $fieldDetails = null;
            foreach ($data as $key => $value) {
               
                    $fieldDetails .= "`$key`=:$key,";
                 
            }
                $fieldDetails = rtrim($fieldDetails, ',');
                $sth = $this->prepare("UPDATE `$table` SET $fieldDetails  WHERE $where ;");
            foreach ($data as $key => $value) {
                $sth->bindValue(":$key", $value);
            }
            $sth->execute();
        }
}
?>

query("set names $ENCODE"); $this->query("SET lc_time_names = 'ru_RU'"); $this -> setAttribute ( PDO :: ATTR_ERRMODE , PDO :: ERRMODE_EXCEPTION ); $this -> setAttribute ( PDO :: ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC ); }catch (Exception $e){ echo $e->getMessage(); } } public function insert($table, $data) { ksort($data); $fieldsNames = implode('`,`', array_keys($data)); $fieldsValues = ':' . implode(',:', array_keys($data)); $sth = $this->prepare("INSERT INTO `$table` (`$fieldsNames`)VALUES ($fieldsValues);"); foreach ($data as $key => $value) { $sth->bindValue(":$key", $value); } $sth->execute(); } public function log ($msg,$parent_class=''){ $this->insert('logs',array( 'action' =>$msg, 'users_login' =>session::get('login'), 'ip' =>$_SERVER["REMOTE_ADDR"], 'func' =>$parent_class )); } public function update($table, $data, $where) { $fieldDetails = null; foreach ($data as $key => $value) { $fieldDetails .= "`$key`=:$key,"; } $fieldDetails = rtrim($fieldDetails, ','); $sth = $this->prepare("UPDATE `$table` SET $fieldDetails WHERE $where ;"); foreach ($data as $key => $value) { $sth->bindValue(":$key", $value); } $sth->execute(); } } ?>