Added more example SQL statements.

Moved all syntax highlighting styles to static properties that can be overwritten.
Simplified and rewrote the newline/indent logic (still needs to be improved for subselects)

1 files changed, 20 insertions, 4 deletions

diff --git a/examples.php b/examples.php
index 4051d60..970db0a 100644
--- a/examples.php
+++ b/examples.php
@@ -1,9 +1,25 @@
 <?php
 require_once('SqlFormatter.php');
 
-$sql = "SELECT count(*),`Column1`,`Testing`, `Testing Three` FROM `Table1`
-WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= NOW()) )
-ORDER BY Column3 DESC GROUP BY Column1 LIMIT 5,10";
+$statements = array(
+	"SELECT * FROM MyTable WHERE id = 46",
+	
+	"SELECT count(*),`Column1`,`Testing`, `Testing Three` FROM `Table1`
+	WHERE Column1 = 'testing' AND ( (`Column2` = `Column3` OR Column4 >= NOW()) )
+	GROUP BY Column1 ORDER BY Column3 DESC LIMIT 5,10",
+	
+	"select * from `Table`, (SELECT group_concat(column1) as col FROM Table2 GROUP BY category) 
+	Table2, Table3 where Table2.col = (Table3.col2 - `Table`.id)",
+	
+	"insert ignore into Table3 (column1, column2) VALUES ('test1','test2'), ('test3','test4');",
+	
+	"UPDATE MyTable SET name='sql', category='databases' WHERE id > '65'",
+	
+	"delete from MyTable WHERE name LIKE \"test%\"",
+);
 
-echo SqlFormatter::format($sql);
+foreach($statements as $sql) {
+	echo "<hr />";
+	echo SqlFormatter::format($sql);
+}
 ?>