php script sql query parser sql2tree

http://www.phpclasses.org/browse/package/4916.html

Build a tree to represent an SQL query !
Video of a php class that can be used to build a tree to represent an SQL query.

It takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array.

Currently it supports only SELECT, INSERT, UPDATE, DELETE queries.

Category:

Science & Technology

Tags:

• php
• script
• sql
• query
• parser
• database
• analyzer
• tree
• mysql
• postgres
• phpclasses
• package
• select
• insert
• update
• delete
• subquery

[ixabro]

hello,

what is this ? Gedit ? Edyuk ?

What is this text editor ? thank you :)

[kalaspace]

vim

[Mickycond86]

Can't understand your english ... sorry ...

[tharalfie]

thanks

[tiiib83]

mdr ton anglais est vraiment moche

[maigre37]

And where do you expect to find such an hilarious accent ! damn !

[alliax]

Of course they were from France, where else do you expect to find very wise and independant people? France holds the best minds of the world, but we still have to pretend we're modests in order not to upset our inferiors neighbors. :-)

[gatorpower]

alliax,

These judges were all from France. Additionally, they were all French dairy farmers, knowing only two things: how to milk French cows and how to talk to them using the French language.

[zimant78]

HIHI its all got phonetics. you have PHP on a commodore 64? what is this method require string array DOING doing!?

[alliax]

He has the same accent as mine, it is a french accent, and it's the most beautiful accent in the world, so you're wrong. If you can't understand a french speaking english it means you aren't worthy of hearing what this person is saying. French accent has been voted the most understandable foreign accent by a panel of very wise and independant judges.

[nodnotme666]

ARe you trying to be funny? fucker??? fucking speak english!! shit!! i cant understand nothing fuck this tutorial hahahaha it make my thinking worser lol JAJAJAJAJA.

[mbahgat3]

OMG ur accent is terrible! and ur English is terrible!!! holy fuck dude dont ever speak English again... u suck ballz