htmlSQL 0.5

htmlSQL is a PHP class to query the web by an SQL like language

Developer:	Jonas John more software by author →
Price:	0.00
License:	BSD License
File size:	41K
Language:
OS:
Rating:	0 /5 (0 votes)
Your vote:
enlarge screenshot

htmlSQL is a PHP class to query the web by an SQL like language. htmlSQL is a experimental PHP class which allows you to access HTML values by an SQL like syntax.

This means that you don't have to write complex functions (regular expressions) to extract specific values.

How to use

Just include the "snoopy.class.php" and the "htmlsql.class.php" files into your PHP scripts and look at the examples (examples/) to get an idea of how to use the htmlSQL class. 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 to an universal usable class. While drinking a coffee and thinking on that problem, I thought it would be cool to access HTML elements by using SQL. So I started creating this class...

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 user input!
tags

the htmlsql htmlsql class class php access html sql like php class

Download htmlSQL 0.5

http://www.jonasjohn.de/files/download/htmlsql-v0.5.zip

Authors software

htmlSQL 0.5 (by Jonas John)
htmlSQL is a PHP class to query the web by an SQL like language

Similar software

htmlSQL 0.5 (by Jonas John)
htmlSQL is a PHP class to query the web by an SQL like language

PHP Data Grid Class 1.0 Beta (by Stefan Gabos)
PHP Data Grid Class can be used to display MySQL query results in HTML tables

AjaxAC 0.4.1 (by Hendrix)
AjaxAC is an open-source framework written in PHP, used to develop/create/generate AJAX applications.

The fundamental idea behind

Class::DBI::Query 3.0.15 (by Michael G Schwern)
Class::DBI::Query is a Perl module with deprecated SQL manager for Class::DBI.

SYNOPSIS

my $sth = Class::DBI::Query

Validate_fields Class 1.34 (by Olaf Lederer)
Validate_fields Class is an easy-to-use form field validation PHP script

Class::DataStore 0.07 (by Eric Folley)
Class::DataStore is a Perl module for generic OO data storage/retrieval.

SYNOPSIS

my %values = ( one => 1, two => 2 );
my

Access_user Class 1.92 (by FinalWebSites)
Access_user Class is an easy to use system for protecting pages and registering users

Template::Tutorial 2.15 (by Andy Wardley)
Template::Tutorial are template toolkit tutorials.

This section includes tutorials on using the Template Toolkit

CDuce 0.4.1 (by Alain Frisch)
CDuce project is a modern XML-oriented functional language with innovative features

PHP ImageMagick Class 1.0 (by Daniel Eiland)
PHP ImageMagick Class is a class for processing images with ImageMagick

Other software in this category

zlib 1.2.3 (by Jean-loup Gailly)
zlib is designed to be a free, general-purpose, legally unencumbered, lossless data-compression library for use on virtually any comp

libjpeg v6b (by Independent JPEG Group)
libjpeg is a library for handling the JPEG (JFIF) image format

OpenSSL 0.9.7c (by The OpenSSL Project Team)
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implement

libxml2 2.6.27 (by DV)
Libxml2 is the XML C parser and toolkit developed for the Gnome project (but usable outside of the Gnome platform), libxml2 library i

GNU C library 2.4 (by Andreas Jaeger)
GNU C library (glibc) is one of the most important components of GNU Hurd and most modern Linux distributions.

GNU C library is us