HTML SQL
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Classes of Jonas J. | > | HTML SQL | > | Download .tar.gz .zip | > |  Support forum (5) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||||
| Author | ||
 |
|
Innovation award Nominee: 1x | |||||||||||||||||||
Browse all classes by 
This class can be used to parse and extract information from HTML documents using a query language similar to SQL to define the information to be extracted.
The class can open HTML documents stored as local files or as remote pages using the Snoopy class.
The class can execute a query with a syntax similar to SQL SELECT statements to search an find certain tags in the opened document with attributes that match query condition.
The occurrences that it find are returned as result set rows that may contain a given list of attributes of the matched tags.
The class can open HTML documents stored as local files or as remote pages using the Snoopy class.
The class can execute a query with a syntax similar to SQL SELECT statements to search an find certain tags in the opened document with attributes that match query condition.
The occurrences that it find are returned as result set rows that may contain a given list of attributes of the matched tags.
| Groups |  Screenshots |
Freshmeat project |  User ratings |
|||||
| Trackback | Applications | Related links |  Files |
|||||
| Groups | ||
 |
HTML | HTML generation and processing | View top rated classes |
|
Text processing | Manipulating and validating text data | View top rated classes |
| Innovation Award | ||
 May 2006 Number 2 Prize: One subscription to the PHP Magazine |
Certain types of applications need to retrieve HTML pages and extract information from them to be processed for specific purposes. Often, parsing HTML pages to extract only the relevant information is not an easy task. On the other hand, most Web developers are very familiar with SQL and can use it to define what information they want from their database tables. This class provides a means to extract data from HTML pages using a query language very similar to SQL. It simplifies greatly the implementation of scripts that need to process data from HTML pages. Manuel Lemos |
| Freshmeat project | ||
| Project record: | htmlsql |
|---|---|
| Popularity score: | 22.02 |
| Vitality score: | 1.0 |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Trackback links | ||
| Link | Description |
|---|---|
| HTML SQL » Burak Kanmaz | 3-4 yildir ben bir web sayfasinin icerigini analiz edecek bir web sayfasi yapmayi hayal etmisimdir hep... |
| Navegar un pagina en HTML con querys en SQL. | HTML_SQL es el nombre de una clase en PHP que nos permite navagar una pagina en HTML, con querys hechos en SQL. La clase ha ganado el segundo lugar de los premios de innovación en PHPClasses. Esto es sin duda, un avance interesante. Se le podran dar habilidades extras a los frameworks MVC. Algunos ejemplos en el enlace. Saludos |
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Related links | ||
| Link | Description |
|---|---|
| A detailed htmlSQL description | A detailed htmlSQL description |
| htmlSQL live demo | Test the htmlSQL class... |
| Files |
||
| File | Role | Description | ||
|---|---|---|---|---|
| examples (15 files) |
||||
| htmlsql.class.php |
Class | Contains the main htmlSQL class | ||
| snoopy.class.php |
Class | The famous snoopy class by Monte Ohrt - v1.01 | ||
| readme.txt |
Doc. | English readme with description and todo list | ||
| readme_german.txt |
Doc. | The same as the readme.txt just in german language | ||
| Files | / | examples |
||
| File | Role | Description |
|---|---|---|
| demo_01.php |
Example | Example 1 - Shows a simple query |
| demo_02.php |
Example | Example 2 - Shows a simple query and the "href as url" usage |
| demo_03.php |
Example | Example 3 - Shows how to connect to a file and a simple query |
| demo_04.php |
Example | Examples 4 - Shows a advanced query with preg_match |
| demo_05.php |
Example | Example 5 - Shows a advanced query (with substr) |
| demo_06.php |
Example | Example 6 - Show how to connect to a string |
| demo_07.php |
Example | Example 7 - Shows a complex query |
| demo_08.php |
Example | Example 8 - Shows how to parse a RSS/XML file with htmlSQL |
| demo_09.php |
Example | Example 9 - Shows how to use the "select" function |
| demo_10.php |
Example | Example 10 - Shows how to use the "isolate_content" function |
| demo_11.php |
Example | Example 11 - Shows how to query a simple XML file |
| demo_12.php |
Example | Example 12 - Shows how to replace the user agent and the referer with custom values |
| demo_data.htm |
Example | Demo HTML data (used for parsing examples) |
| demo_xml.xml |
Example | Example XML file (to test parsing) |
| query_examples.txt |
Doc. | Some query examples for copy and paste |
| Download all files: htmlsql.tar.gz htmlsql.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2012