PHP Classes

File: examples/demo_01.php

Recommend this page to a friend!
  Classes of J.   HTML SQL   examples/demo_01.php   Download  
File: examples/demo_01.php
Role: Example script
Content type: text/plain
Description: Example 1 - Shows a simple query
Class: HTML SQL
Parse and extract information from HTML using SQL
Author: By
Last change:
Date: 17 years ago
Size: 1,012 bytes
 

Contents

Class file image Download
<?php

   
/*
    ** htmlSQL - Example 1
    **
    ** Shows a simple query
    */
   
   
include_once("../snoopy.class.php");
    include_once(
"../htmlsql.class.php");
   
   
$wsql = new htmlsql();
   
   
// connect to a URL
   
if (!$wsql->connect('url', 'http://codedump.jonasjohn.de/')){
        print
'Error while connecting: ' . $wsql->error;
        exit;
    }
   
   
/* execute a query:
       
       This query extracts all links with the classname = nav_item
    */
   
if (!$wsql->query('SELECT * FROM a WHERE $class == "nav_item"')){
        print
"Query error: " . $wsql->error;
        exit;
    }

   
// show results:
   
foreach($wsql->fetch_array() as $row){
   
       
print_r($row);
       
       
/*
        $row is an array and looks like this:
        Array (
            [href] => /feedback.htm
            [class] => nav_item
            [tagname] => a
            [text] => Feedback
        )
        */
       
   
}
   
?>