HTML SQL (snoopy, extract, referer)

Name:	HTML SQL Support forum
Base name:	`htmlsql`
Description:	Parse and extract information from HTML using SQL
Related top rated classes:	snoopy, extract, referer
Version:	`-`
Required PHP version:	`-`
License:	BSD License
All time users:	4433 users
All time rank:	366
Week users:	13 users
Week rank:	502

	Screenshots		Author		Groups		Detailed description		Freshmeat project

	User ratings		Trackback		Applications		Related links		Files

Screenshots

File	Role	Description
`htmlsql_syntax_example.png`	Screen	htmlSQL syntax example

Author

Name:	Jonas John `<e-mail contact>`
Published packages:	1 Browse this author's classes
Country:	Germany - PHP jobs in Germany
Home page:	`http://www.jonasjohn.de/`
Age:	24
All time rank:	415
Week rank:	537

Innovation Award

May 2006
Number 2

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

Groups

	HTML	HTML generation and processing	View top rated classes
	Text processing	Manipulating and validating text data	View top rated classes

Detailed description

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.

Freshmeat project

Project record:	`htmlsql`
Popularity score:	32.4
Vitality score:	1.0

User ratings

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (98.2%)`	`Good (92.9%)`	`Good (89.3%)`	`Good (91.1%)`	`-`	`-`	`Sufficient (76.4%)`	29
Month:	Not yet rated by the users

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

Latest blog trackback links

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.

Files

File	Role	Description
`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
`examples`
`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
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: HTML SQL

Innovation Award