Esempio n. 1
0
 public static function Execute()
 {
     self::SetStatement();
     self::ExecuteStatement();
     Debug::Set('Sql (' . self::GetRowsAffected() . ' rows): ' . self::$_sql);
     if (self::$_name) {
         Data::SetName(self::$_name);
         Data::Set(self::$_statement->fetchAll(PDO::FETCH_ASSOC));
     }
     self::$_name = null;
     self::$_sql = null;
 }
Esempio n. 2
0
 public static function Setup()
 {
     Debug::Set('Database setup initiated');
     self::SetType('mysql');
     self::SetHostname('localhost');
     self::SetUsername(getenv('BALLCALC_USERNAME'));
     self::SetPassword(getenv('BALLCALC_PASSWORD'));
     self::SetPort('3306');
     self::SetDefaultDatabase('steel_bearing');
     Debug::Set('Database type: ' . self::GetType());
     Debug::Set('Database host: ' . self::GetHostname());
     Debug::Set('Database username: ***************');
     Debug::Set('Database password: ***************');
     Debug::Set('Database port: ' . self::GetPort());
     Debug::Set('Database default database: ' . self::GetDefaultDatabase());
     try {
         self::SetConnection(new PDO(self::GetType() . ': host=' . self::GetHostname() . '; port=' . self::GetPort() . '; dbname=' . self::GetDefaultDatabase(), self::GetUsername(), self::GetPassword()));
         self::SetConnectionStatus('ok');
         Debug::Set('Database connection SUCCESS');
     } catch (PDOException $e) {
         self::SetConnectionStatus($e->getMessage());
         Debug::Set('Database connection FAILED');
     }
 }