Her er et ekssempel på hvordan det kan gøres fx fra xplayn.com
<?php
class getNews {
/*
CREATE TABLE nyheder (
id int(11) NOT NULL auto_increment,
nyhed varchar(255) NOT NULL default '',
site varchar(100) NOT NULL default '',
dato varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
*/
var $usr = "usr";
var $pwd = "pwd";
var $host = "localhost";
var $db = "nyheder";
function connectDB() {
mysql_connect($this->host, $this->usr, $this->pwd);
mysql_select_db($this->db);
}
function checkIfExist($string) {
$tjek = mysql_query("SELECT nyhed FROM nyheder WHERE nyhed = '".$string."'") or die(mysql_error());
if(mysql_num_rows($tjek) == 0) {
return 0;
} else {
return 1;
}
}
function fetch_site($site) {
$data = implode("",file($site));
return $data;
}
function parse_dataXplayn() {
$input = $this->fetch_site("
http://xplayn.com");
$pos1 = strpos($input, "Scenen");
$pos2 = strpos($input, "<a href=\"?id=5256\">");
$striped= strip_tags(substr($input, $pos1, ($pos2-$pos1)),"<td><a>");
$new = str_replace("<td colspan=\"2\"></td>", "", $striped);
return str_replace("Scenen", "", $new);
}
function newsXplayn() {
$data = explode("</td><td>", $this->parse_dataXplayn());
$url = "
http://xplayn.com"; for($i=0;$i<=19;$i++) {
$n = explode("</a>", strip_tags(ereg_replace("\(.*\)", "", $data[$i]),"<a>"));
$nyhed = str_replace("href=\"?id", " target=\"_blank\" href=\"".$url."?id", $n[0]);
$dato = $n[1];
if($this->checkIfExist($nyhed) == 0) {
mysql_query("INSERT INTO nyheder (nyhed,dato,site) VALUES ('".$nyhed."', '".$dato."', 'Xplayn.com')") or die (mysql_error());
echo "Følgende blev tilføjet: ".strip_tags($nyhed)."<br>";
}
}
}
}
$test = new getNews();
$test->connectDB();
$test->newsXplayn();
?>