Exemple #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;
 }
Exemple #2
0
 public static function Setup()
 {
     Debug::Set('Database setup initiated');
     self::SetType('mysql');
     self::SetHostname('localhost');
     self::SetUsername(getenv('TEST_USERNAME'));
     self::SetPassword(getenv('TEST_PASSWORD'));
     self::SetPort('3306');
     self::SetDefaultDatabase('test');
     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');
     }
 }
Exemple #3
0
 public function Setup()
 {
     \Donsapp\Debug::Set('Page setup initiated');
     \Donsapp\Sql::ExecuteSql(' SELECT * FROM don_log ; ');
     //    echo "<br> asd  ROW 0 = " . \Donsapp\Sql::GetField('ip_addr');
 }
Exemple #4
0
 public static function Set($x)
 {
     self::$_results[self::$_name] = $x;
     \Donsapp\Debug::Set('Stored named query: ' . self::$_name);
     self::$_name = '';
 }