Skip to content

Instantly share code, notes, and snippets.

@augustohp

augustohp/sql_formater.php

Created April 10, 2012 19:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save augustohp/2353792 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save augustohp/2353792 to your computer and use it in GitHub Desktop.
Download ZIP
SQL formater for PHP by @alganet
Raw
sql_formater.php
function formatSql($sql) {
return preg_replace(
'/(select|from|(left |right |natural |inner |outer |cross |straight_)*join|where|limit|update |set|insert |values)/i',
"\n$1\n ", str_replace("\n", '', $sql)
);
}
@wesleyvicthor
Copy link

wesleyvicthor commented Apr 12, 2012

put it in an utils class.

@alganet
Copy link

alganet commented Apr 13, 2012

Util classes must die. If there's an Util class, everything else is Useless?

@augustohp
Copy link
Author

augustohp commented Apr 14, 2012

LMAO

@wesleyvicthor
Copy link

wesleyvicthor commented Apr 14, 2012

I said that because i know that you do not like. successful troll. (:

@augustohp
Copy link
Author

augustohp commented Apr 16, 2012

Sure, we know... we know...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment