public static function fetchFromDbForCode($paymentGatewayCode) { PaymentGateway::$staticErrors = array(); $sql = "SELECT * FROM bsi_payment_gateway WHERE gateway_code = '" . strtolower(trim(mysql_escape_string($paymentGatewayCode))) . "'"; $query = mysql_query($sql); if (!$query) { global $logger; $logger->LogFatal("Error executing query: {$sql}"); $logger->LogFatal("Database error: " . mysql_errno() . ". Message: " . mysql_error()); die("Database error: " . mysql_errno() . ". Message: " . mysql_error()); } if ($row = mysql_fetch_assoc($query)) { $paymentGateway = PaymentGateway::fetchFromParameters($row); return $paymentGateway; } else { PaymentGateway::setStaticError("Payment gateway does not exist."); return null; } }