Trådstart 7 sep. 2003 23:05 #1 Tjenare..http://schema.hj.se/visa.asp?from=2003-09-08&tom=&prog=Dm3+++&kurs=&lokal=&larare=&visap=Nej&bolag=ING för att senare kunna använda det i exempelvis Outlook/PDA.
<?php
$datum = date("Y-m-d");
$url = "http://schema.hj.se/visa.asp?from=$datum&tom=&prog=Dm3+++&kurs=&lokal=&larare=&visap=Nej&bolag=ING";
function getPageCode($url){
$data=0;
if(!($fp = fopen ($url, "r")))
{
die("Cannot connect to: $url");
}
while ($in = fread($fp, 4096))
{
$data .= $in;
}
return $data;
}
$host = "localhost";
$user = "Andreas";
$password = "";
$dbname = "schema";
$link = mysql_connect ($host, $user, $password);
$sql2="DELETE FROM `schema` " or die(mysql_error());
mysql_db_query ($dbname, $sql2, $link);
mysql_close ($link);
$link2 = mysql_connect ($host, $user, $password);
$code = getPageCode($url);
preg_match_all("/(<form>\s*.*<+form>\s)/mis", $code, $matches);
$nystrang = $matches[1][0];
preg_match_all("/\s*<TD VALIGN=\"TOP\" ALIGN=\"LEFT\" class=\"brodtext\">(\d*-\d*-\d*) \s(\w*) <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">(\d+:\d+)-(\d+:\d+) <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">(\w*)\s* <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">(\w*)\s* <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">([A-Za-z\s]*) <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">(\w\d\d\d)\s*[A-Za-z-]*\s* <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">(\w*) <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">([\w\s\/]*) <\/TD>\s*<TD VALIGN=\"TOP\" class=\"brodtext\">\s(\w*) \s*<\/TD>/mis", $nystrang, $matches2);
for ($i=0; $i< count($matches2[1]); $i++) {
$sql="INSERT INTO schema(datum, dag, start, slut, program, kurs, grupp, sal, sign, moment) VALUES ('".$matches2[1][$i]."','".$matches2[2][$i]."','".$matches2[3][$i]."','".$matches2[4][$i]."','".$matches2[5][$i]."','".$matches2[6][$i]."','".$matches2[7][$i]."','".$matches2[8][$i]."','".$matches2[9][$i]."','".$matches2[10][$i]."')" or die(mysql_error());
mysql_db_query($dbname, $sql, $link2) or die(mysql_error());
}
//}
mysql_close($link2);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
informationen har sparats...
</body>
</html>
Koden från schema sidan är strukturerat uppbyggd:
<form>
<TD VALIGN="TOP" ALIGN="LEFT" class="brodtext">2003-09-10 Ons </TD>
<TD VALIGN="TOP" class="brodtext">13:00-16:45 </TD>
<TD VALIGN="TOP" class="brodtext">Dm3 </TD>
<TD VALIGN="TOP" class="brodtext">Datgraf </TD>
<TD VALIGN="TOP" class="brodtext">1 </TD>
<TD VALIGN="TOP" class="brodtext">E440
</TD>
<TD VALIGN="TOP" class="brodtext">RuAn </TD>
<TD VALIGN="TOP" class="brodtext">Laboration
</TD>
<TD VALIGN="TOP" class="brodtext">
</TD>
</form>
Snälla kan någon hjälpa mig?
