Ejemplo n.º 1
0
<?php

if ($argv[0] == 'Bill.php') {
    $b = new Bill("", "");
    $b->id = "PRC_A1J5J1E1N1K0Q1O4A4V8L1H4C2Q4C9";
    // open DB
    $db = new mysqli("p:localhost", "trend", "", "assembly");
    // Check connection
    if ($db->connect_error) {
        die("Connection failed: " . $db->connect_error);
    }
    $b->insertHTML($db);
}
/*
assembly_id int,
id  int NOT NULL UNIQUE,
link_id varchar(255) NOT NULL UNIQUE,
title varchar(255),

summary TEXT,

proposed_date DATE,
decision_date DATE,
collected_date DATE,

represent_actor int,

withdrawer_count int,
actor_count int,

proposer_type varchar(255),