PHP Developer's Network : Network Member Forums

Class: HTML SQL


  Search   All class groups   Latest entries   Top 10 charts   Newsletter   Blog   Forums   Help FAQ  
  Login   Register  
Recommend this page to a friend! Trackback URL: http://www.phpclasses.org/trackback/browse/package/3086.html
      Classes of Jonas John  > 
HTML SQL
  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Screenshots Screenshots   Supplied by   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Trackback   Applications   Related links   Files Files  

  • Screenshots:

    • htmlSQL syntax example
    File Role Description
    Accessible without login Image file htmlsql_syntax_example.png Screen
    htmlSQL syntax example

  • Supplied by:

    • Picture of Jonas John
    Name: Jonas John <e-mail contact>
    Published packages: 1
    Country: Germany Germany - PHP jobs in Germany
    Home page: http://www.jonasjohn.de/
    Age: 22
    All time rank: 432
    Week rank: 374

    Browse this author's classes

  • Innovation Award:

    • PHP Programming Innovation award nominee
    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:

    • Group folder image
    HTML generation and processing
    		 View top rated classes
    Group folder image
    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: 114.53 (0.19%)
    Popularity rank: 25,340 (PHP Classes: 191)
    Vitality score: 1.00 (0.00%)
    Rating: Not yet rated Please rate this class in Freshmeat

  • User ratings:

    • Ratings
    Utility
    Consistency
    Documentation
    Examples
    Tests
    Videos
    Overall
    Rank
    All time:
    Good (98.1%)
    Good (92.3%)
    Good (88.5%)
    Good (90.4%)
    -
    -
    Sufficient (76.2%)
    22
    Month:
    There are not enough user ratings to display for this class.

  • 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 Latest blog trackback links

  • Applications that use this class:

    • No application links were specified for this class.
    Add link image 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
    Plain text file htmlsql.class.php Class
    Contains the main htmlSQL class
    Plain text file snoopy.class.php Class
    The famous snoopy class by Monte Ohrt - v1.01
    Plain text file readme.txt Doc.
    English readme with description and todo list
    Plain text file readme_german.txt Doc.
    The same as the readme.txt just in german language
    Files folder image examples
      Plain text file demo_01.php Example
    Example 1 - Shows a simple query
      Plain text file demo_02.php Example
    Example 2 - Shows a simple query and the "href as url" usage
      Plain text file demo_03.php Example
    Example 3 - Shows how to connect to a file and a simple query
      Plain text file demo_04.php Example
    Examples 4 - Shows a advanced query with preg_match
      Plain text file demo_05.php Example
    Example 5 - Shows a advanced query (with substr)
      Plain text file demo_06.php Example
    Example 6 - Show how to connect to a string
      Plain text file demo_07.php Example
    Example 7 - Shows a complex query
      Plain text file demo_08.php Example
    Example 8 - Shows how to parse a RSS/XML file with htmlSQL
      Plain text file demo_09.php Example
    Example 9 - Shows how to use the "select" function
      Plain text file demo_10.php Example
    Example 10 - Shows how to use the "isolate_content" function
      Plain text file demo_11.php Example
    Example 11 - Shows how to query a simple XML file
      Plain text file demo_12.php Example
    Example 12 - Shows how to replace the user agent and the referer with custom values
      Plain text file demo_data.htm Example
    Demo HTML data (used for parsing examples)
      Plain text file demo_xml.xml Example
    Example XML file (to test parsing)
      Plain text file 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.

 
  Advertise on this site   Site map   Statistics   Site tips   Privacy policy   Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products