Location: PHPKode > scripts > htmlSQL > htmlsql/examples/demo_02.php
<?php

    /*
    ** htmlSQL - Example 2
    **
    ** Shows a simple query and the "href as url" usage
    */
    
    include_once("../snoopy.class.php");
    include_once("../htmlsql.class.php");
    
    $wsql = new htmlsql();
    
    // connect to a file
    if (!$wsql->connect('file', 'demo_data.htm')){
        print 'Error while connecting: ' . $wsql->error;
        exit;
    }
    
    /* execute a query:
       
       This query extracts all links from the document
       and just returns href (as url) and text
    */
    if (!$wsql->query('SELECT href as url, text FROM a')){
        print "Query error: " . $wsql->error; 
        exit;
    }

    // show results:
    foreach($wsql->fetch_array() as $row){
    
        print "Link-URL: " . $row['url'] . "\n";
        print "Link-Text: " . trim($row['text']) . "\n\n";
        
    }
    
?>
Return current item: htmlSQL