diff options
author | Shadi Akiki <shadiakiki1986@gmail.com> | 2016-08-18 09:58:43 +0300 |
---|---|---|
committer | Shadi Akiki <shadiakiki1986@gmail.com> | 2016-08-18 10:15:22 +0300 |
commit | 784940e10f9b29ce72b98770885524a276593135 (patch) | |
tree | ed5c4919a9e542ad259f88537bab07003289425f | |
parent | f8b2937a174603222941edc2cab5b27a54310698 (diff) | |
download | sql-parser-784940e10f9b29ce72b98770885524a276593135.zip sql-parser-784940e10f9b29ce72b98770885524a276593135.tar.gz sql-parser-784940e10f9b29ce72b98770885524a276593135.tar.bz2 |
fixup of example in documentation
-rw-r--r-- | README.md | 18 |
1 files changed, 13 insertions, 5 deletions
@@ -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 |