Børsen Crawler

<?php

require_once 'simple_html_dom.php';

function getStock($borsen_url){

$html = file_get_html($borsen_url);

$tmp = array();
$result = array();
$row = array();
$i = 0;


foreach ($html->find("div.stock-table") as $div){
    foreach($div->find("tr") as $tr){
        $i++;
        foreach($tr->find("td") as $td){
            $val = trim($td->plaintext);
            $tmp[($i == 1 ? "keys" : "values")][] = $val;
        }
        if($i != 1){
            $result[] = $tmp;
            $tmp = array();
        }
    }
}
return $result;

}

$borsone = getStock("http://borsen.dk/kurslister/danske_aktier/alle_danske_aktier.html?tabId_48097=1&page_48097=1&orderBy_48097=OFFICIAL_NAME_SECURITY&orderType_48097=asc&filter_48097=&activeLink_48097=%22");

var_dump($borsone);

if ($stmt = $mysqli->prepare("INSERT INTO `aktier` (`aktienavn` ,`%` ,`+/-` ,`senest` ,`bud` ,`udbud` ,`høj` ,`lav` ,`åbning` ,`omsætning` ,`senesthandlet`)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {

$stmt->bind_param('sddddddddds', $aktienavn, $procent, $plus_minus, $senest, $bud, $udbud, $hoj, $lav, $aabning, $omsatning, $senest_handlet);

    foreach ($borsone as $aktie) {
        $aktienavn = $aktie["values"][0];
        $procent = str_replace(",", ".", str_replace(".", "", $aktie["values"][1]));
        $plus_minus = str_replace(",", ".", str_replace(".", "", $aktie["values"][2]));
        $senest = str_replace(",", ".", str_replace(".", "", $aktie["values"][3]));
        $bud = str_replace(",", ".", str_replace(".", "", $aktie["values"][4]));
        $udbud = str_replace(",", ".", str_replace(".", "", $aktie["values"][5]));
        $hoj = str_replace(",", ".", str_replace(".", "", $aktie["values"][6]));
        $lav = str_replace(",", ".", str_replace(".", "", $aktie["values"][7]));
        $aabning = str_replace(",", ".", str_replace(".", "", $aktie["values"][8]));
        $omsatning = str_replace(",", ".", str_replace(".", "", $aktie["values"][9]));
        $senest_handlet = $aktie["values"][10];


        $stmt->execute();
    }
    print "Inserted data";
    $stmt->close();
}else {
    /* Error */
    printf("Prepared Statement Error: %s\n", $mysqli->error);
}
?>