htmlSQL - Version 0.6

htmlSQL is an experimental PHP library that allows you to access HTML values by an SQL like syntax. This means that you don't have to write complex functions or regular expressions to extract specific values.

htmlSQL queries look like this:

SELECT href,title FROM a WHERE $class == "list"
       ^ Attributes    ^       ^ search query (can be empty)
         to return     ^
                       ^ HTML tag to search in
                         "*" is possible = all tags

This query should return an array with all links that contain the attribute class="list".

The project is alive again!

Related projects:

Requirements

Any flavor of PHP5+ should do
Snoopy PHP class - Version 1.2.3 (optional - required for web transfers)
You find all Snoopy related documents (copyright, readme, etc) in the snoopy_data/ subdirectory.

Usage

Just include the "snoopy.php" and the "htmlsql.php" files into your PHP scripts and look at the examples to get an idea of how to use the htmlSQL library. It should be very simple :-)

Background / idea

I had this idea while extracting some data from a website. As I realized that the algorithms and functions to extract links and other tags are often the same - I had the idea to combine all functions into a universal usable library. While drinking a coffee and thinking about that, I thought it would be cool to access HTML elements by using SQL. So I started creating this library...

Warning

The eval() function is used for the WHERE statement. Make sure that all user data is checked and filtered against malicious PHP code. Never trust any user input!

Todo

Enhance the HTML parser
Test htmlSQL with invalid and bad HTML files
Replace the ugly eval() method for the WHERE statement with an own method
Add more error checks
Add unit tests
Add a LIMIT function like in SQL

Author

Jonas John

License

htmlSQL uses a modified BSD license, you find the full license text in the "htmlsql.php".

sepetov/htmlSQL