FluentUtils::formatQuery PHP Méthode

formatQuery() public static méthode

public static formatQuery ( string $query ) : string
$query string
Résultat string
    public static function formatQuery($query)
    {
        $query = preg_replace('/WHERE|FROM|GROUP BY|HAVING|ORDER BY|LIMIT|OFFSET|UNION|ON DUPLICATE KEY UPDATE|VALUES/', "\n\$0", $query);
        $query = preg_replace('/INNER|LEFT|RIGHT|CASE|WHEN|END|ELSE|AND/', "\n    \$0", $query);
        // remove trailing spaces
        $query = preg_replace("/\\s+\n/", "\n", $query);
        return $query;
    }

Usage Example

Exemple #1
0
 /**
  * Get query string
  *
  * @param bool $formatted - Return formatted query
  *
  * @return string
  */
 public function getQuery($formatted = true)
 {
     $query = $this->buildQuery();
     if ($formatted) {
         $query = FluentUtils::formatQuery($query);
     }
     return $query;
 }