import prohtml.*;
import java.util.regex.*; 
import de.bezier.data.sql.*;

HtmlList htmlList;
MySQL msql;

void setup(){
  size(100,100);
  //enter your url here
  htmlList = new HtmlList("http://www.hello.com");
  String s_list = "";
  String user     = "bob";
  String pass     = "password";
  String database = "test";
  String table    = "htmlparse";

  for (int i = 0;i<htmlList.pageList.size();i++){
    String s = htmlList.pageList.get(i).toString();
    Pattern p = Pattern.compile("<");
    Matcher m = p.matcher(s);
    boolean found = m.find();
    if (found == false){
      s_list = s_list.concat(s + " ");   
    }    
  }
  println(s_list);
  Pattern q = Pattern.compile("[H|h]ello\\s[A-Za-z]+\\s[A-Za-z]+");
  Matcher n = q.matcher(s_list);
  int numMatches = 0;
  msql = new MySQL( this, "localhost", database, user, pass );
  if ( msql.connect() ){
    msql.execute( "CREATE TABLE IF NOT EXISTS " + table + " ("+
                          "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"+
                          "word VARCHAR( 255 )"+")");}
  else{
        println("connection failed!");
    }
  while(n.find() == true){
    String h = n.group();
    msql.execute( "INSERT INTO " + table + " (word) VALUES (\""+ h + "\")" );
    numMatches++;
  }

  println("results: " + str(numMatches));
  
  String word_list[] = split(s_list, ' ');
  saveStrings("html_input.txt", word_list);
}