Added example output screenshot. Created examples directory.

1 files changed, 27 insertions, 0 deletions

diff --git a/examples/examples.php b/examples/examples.php
new file mode 100644
index 0000000..3478e5d
--- /dev/null
+++ b/examples/examples.php
@@ -0,0 +1,27 @@
+<?php
+require_once('SqlFormatter.php');
+
+$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%\"",
+	
+	"SELECT * FROM UnmatchedParens WHERE ( A = B)) AND (((Test=1)"
+);
+
+foreach($statements as $sql) {
+	echo "<hr />";
+	echo SqlFormatter::format($sql);
+}
+?>