PHP Database::mysql_query Examples

Example #1

File: my.php Project: aydancoskun/octobercms

 public static function get_accountsettings($acno)
 {
     $f3 = \Base::instance();
     $sql = "SELECT * FROM accountsettings WHERE account = {$acno}";
     $result = Database::mysql_query($sql, __LINE__);
     if (count($result) > 1) {
         trigger_error("Account '{$acno}' exist more than once in accountsettings");
     }
     if (count($result) == 1) {
         foreach ($result[0] as $col => $val) {
             self::$as[$col] = $val;
         }
     }
     $sql = "SELECT * FROM accountsettings_2 WHERE account = {$acno}";
     $result = Database::mysql_query($sql, __LINE__);
     if (count($result) > 1) {
         trigger_error("Account '{$acno}' exist more than once in accountsettings_2");
     }
     if (count($result) == 1) {
         foreach ($result[0] as $col => $val) {
             self::$as[$col] = $val;
         }
     }
     if (!self::$as) {
         trigger_error("Account '{$acno}' does not exist in accountsettings & accountsettings_2");
     }
 }