summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorShadi Akiki <shadiakiki1986@gmail.com>2016-08-18 09:58:43 +0300
committerShadi Akiki <shadiakiki1986@gmail.com>2016-08-18 10:15:22 +0300
commit784940e10f9b29ce72b98770885524a276593135 (patch)
treeed5c4919a9e542ad259f88537bab07003289425f
parentf8b2937a174603222941edc2cab5b27a54310698 (diff)
downloadsql-parser-784940e10f9b29ce72b98770885524a276593135.zip
sql-parser-784940e10f9b29ce72b98770885524a276593135.tar.gz
sql-parser-784940e10f9b29ce72b98770885524a276593135.tar.bz2
fixup of example in documentation
-rw-r--r--README.md18
1 files changed, 13 insertions, 5 deletions
diff --git a/README.md b/README.md
index 29975bb..9c390d5 100644
--- a/README.md
+++ b/README.md
@@ -42,14 +42,22 @@ echo SqlParser\Utils\Formatter::format($query, array('type' => 'html'));
### Parsing and building SQL query
```php
-$parsed = new SqlParser\Parser($query);
+require __DIR__."/vendor/autoload.php";
-// you can now inspect or change query
-var_dump($parser->statements[0]);
+$query1 = "select * from a";
+$parser = new SqlParser\Parser($query1);
-// and build it again
+// inspect query
+var_dump($parser->statements[0]); // outputs object(SqlParser\Statements\SelectStatement)
+
+// modify query by replacing table a with table b
+$table2 = new \SqlParser\Components\Expression("", "b", "", "");
+$parser->statements[0]->from[0] = $table2;
+
+// build query again from an array of object(SqlParser\Statements\SelectStatement) to a string
$statement = $parser->statements[0];
-$statement->build()
+$query2 = $statement->build();
+var_dump($query2); // outputs string(19) "SELECT * FROM `b` "
```
## More information