<?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 
        )
 
        */
 
        
 
    }
 
    
 
?>
 
 |