diff options
| author | Florin Patan <florinpatan@gmail.com> | 2012-09-10 22:33:39 +0300 |
|---|---|---|
| committer | Florin Patan <florinpatan@gmail.com> | 2012-09-10 22:33:39 +0300 |
| commit | 997cc0e0dde3efa8e588eed419385ad8bd3b0556 (patch) | |
| tree | 8263e3cf0627462fc617a70d7e1606c68c90f58d /examples/examples.php | |
| parent | 94c7e4e67a5fcc989deb42e958114d829073f17b (diff) | |
| download | sql-formatter-997cc0e0dde3efa8e588eed419385ad8bd3b0556.zip sql-formatter-997cc0e0dde3efa8e588eed419385ad8bd3b0556.tar.gz sql-formatter-997cc0e0dde3efa8e588eed419385ad8bd3b0556.tar.bz2 | |
Formatted source code according to PSR-1 and PSR-2. Added composer support
Diffstat (limited to 'examples/examples.php')
| -rw-r--r-- | examples/examples.php | 286 |
1 files changed, 152 insertions, 134 deletions
diff --git a/examples/examples.php b/examples/examples.php index 2760a11..5c0c52e 100644 --- a/examples/examples.php +++ b/examples/examples.php @@ -1,177 +1,195 @@ <!DOCTYPE html> <html> - <head> - <title>SqlFormatter Examples</title> - <style> - body { - font-family: arial; - } - table, td, th { - border: 1px solid #aaa; - } - table { - border-width: 1px 1px 0 0; - border-spacing: 0; - } - td, th { - border-width: 0 0 1px 1px; - padding: 5px 10px; - vertical-align:top; - } - pre { - padding:0; - margin: 0; - } - </style> - </head> - <body> +<head> + <title>SqlFormatter Examples</title> + <style> + body { + font-family: arial; + } + + table, td, th { + border: 1px solid #aaa; + } + + table { + border-width: 1px 1px 0 0; + border-spacing: 0; + } + + td, th { + border-width: 0 0 1px 1px; + padding: 5px 10px; + vertical-align: top; + } + + pre { + padding: 0; + margin: 0; + } + </style> +</head> +<body> <?php -require_once('../SqlFormatter.php'); -//example statements for formatting and highlighting +require_once('../lib/SqlFormatter.php'); + +// Example statements for formatting and highlighting $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)", - - "-- This is a comment - SELECT - /* This is another comment - On more than one line */ - Id #This is one final comment - as temp, DateCreated as Created FROM MyTable;", + "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)", + + "-- This is a comment + SELECT + /* This is another comment + On more than one line */ + Id #This is one final comment + as temp, DateCreated as Created FROM MyTable;", ); -//example statements for splitting SQL strings into individual queries +// Example statements for splitting SQL strings into individual queries $split_statements = array( - "DROP TABLE IF EXISTS MyTable; - CREATE TABLE MyTable ( id int ); - INSERT INTO MyTable (id) - VALUES - (1),(2),(3),(4); - SELECT * FROM MyTable;", - - "SELECT \";\"; SELECT \";\\\"; a;\"; - SELECT \"; - abc\"; - SELECT a,b #comment; - FROM test;", + "DROP TABLE IF EXISTS MyTable; + CREATE TABLE MyTable ( id int ); + INSERT INTO MyTable (id) + VALUES + (1),(2),(3),(4); + SELECT * FROM MyTable;", + + "SELECT \";\"; SELECT \";\\\"; a;\"; + SELECT \"; + abc\"; + SELECT a,b #comment; + FROM test;", ); -//example statements for removing comments +// Example statements for removing comments $comment_statements = array( - "-- This is a comment - SELECT - /* This is another comment - On more than one line */ - Id #This is one final comment - as temp, DateCreated as Created FROM MyTable;", + "-- This is a comment + SELECT + /* This is another comment + On more than one line */ + Id #This is one final comment + as temp, DateCreated as Created FROM MyTable;", ); ?> <h1>Formatting</h1> + <div> - Usage: - <pre> - <?php highlight_string('<?php'."\n".'$formatted = SqlFormatter::format($sql);'."\n".'?>'); ?> - </pre> + Usage: + <pre> + <?php highlight_string('<?php' . "\n" . '$formatted = SqlFormatter::format($sql);' . "\n" . '?>'); ?> + </pre> </div> <table> - <tr> - <th>Original</th> - <th>Formatted</th> - </tr> - <?php foreach($statements as $sql) { ?> - <tr> - <td><pre><?php echo $sql; ?></pre></td> - <td><?php echo SqlFormatter::format($sql); ?></td> - </tr> - <?php } ?> + <tr> + <th>Original</th> + <th>Formatted</th> + </tr> + <?php foreach ($statements as $sql) { ?> + <tr> + <td> + <pre><?php echo $sql; ?></pre> + </td> + <td><?php echo SqlFormatter::format($sql); ?></td> + </tr> + <?php } ?> </table> <h1>Syntax Highlighting Only</h1> + <div> - Usage: - <pre> - <?php highlight_string('<?php'."\n".'$highlighted = SqlFormatter::highlight($sql);'."\n".'?>'); ?> - </pre> + Usage: + <pre> + <?php highlight_string('<?php' . "\n" . '$highlighted = SqlFormatter::highlight($sql);' . "\n" . '?>'); ?> + </pre> </div> <table> - <tr> - <th>Original</th> - <th>Highlighted</th> - </tr> - <?php foreach($statements as $sql) { ?> - <tr> - <td><pre><?php echo $sql; ?></pre></td> - <td><?php echo SqlFormatter::highlight($sql); ?></td> - </tr> - <?php } ?> + <tr> + <th>Original</th> + <th>Highlighted</th> + </tr> + <?php foreach ($statements as $sql) { ?> + <tr> + <td> + <pre><?php echo $sql; ?></pre> + </td> + <td><?php echo SqlFormatter::highlight($sql); ?></td> + </tr> + <?php } ?> </table> <h1>Splitting SQL Strings Into Individual Queries</h1> + <div> - Usage: - <pre> - <?php highlight_string('<?php'."\n".'$queries = SqlFormatter::splitQuery($sql);'."\n".'?>'); ?> - </pre> + Usage: + <pre> + <?php highlight_string('<?php' . "\n" . '$queries = SqlFormatter::splitQuery($sql);' . "\n" . '?>'); ?> + </pre> </div> <table> - <tr> - <th>Original</th> - <th>Split</th> - </tr> - <?php foreach($split_statements as $sql) { ?> - <tr> - <td><pre><?php echo SqlFormatter::highlight($sql); ?></pre></td> - <td><?php - $queries = SqlFormatter::splitQuery($sql); - echo "<ol>"; - foreach($queries as $query) { - echo "<li><pre>".SqlFormatter::highlight($query)."</pre></li>"; - } - echo "</ol>"; - ?></td> - </tr> - <?php } ?> + <tr> + <th>Original</th> + <th>Split</th> + </tr> + <?php foreach ($split_statements as $sql) { ?> + <tr> + <td> + <pre><?php echo SqlFormatter::highlight($sql); ?></pre> + </td> + <td><?php + $queries = SqlFormatter::splitQuery($sql); + echo "<ol>"; + foreach ($queries as $query) { + echo "<li><pre>" . SqlFormatter::highlight($query) . "</pre></li>"; + } + echo "</ol>"; + ?></td> + </tr> + <?php } ?> </table> - <h1>Removing Comments</h1> + <div> - Usage: - <pre> - <?php highlight_string('<?php'."\n".'$nocomments = SqlFormatter::removeComments($sql);'."\n".'?>'); ?> - </pre> + Usage: + <pre> + <?php highlight_string('<?php' . "\n" . '$nocomments = SqlFormatter::removeComments($sql);' . "\n" . '?>'); ?> + </pre> </div> <table> - <tr> - <th>Original</th> - <th>Comments Removed</th> - </tr> - <?php foreach($comment_statements as $sql) { ?> - <tr> - <td><pre><?php echo SqlFormatter::highlight($sql); ?></pre></td> - <td><pre><?php echo SqlFormatter::highlight(SqlFormatter::removeComments($sql)) ?></pre></td> - </tr> - <?php } ?> + <tr> + <th>Original</th> + <th>Comments Removed</th> + </tr> + <?php foreach ($comment_statements as $sql) { ?> + <tr> + <td> + <pre><?php echo SqlFormatter::highlight($sql); ?></pre> + </td> + <td> + <pre><?php echo SqlFormatter::highlight(SqlFormatter::removeComments($sql)) ?></pre> + </td> + </tr> + <?php } ?> </table> </body> |