Live Voetbal
$query = "SELECT id, competition, stage, date, DATE_FORMAT(datetime, '%W %e %M') AS datum, TIME_FORMAT(datetime, '%H:%i') AS tijd, home, away "; $query .= "FROM $competition "; switch($competition){ case('europaleague'): $query .= "WHERE (date = CURDATE() || date = CURDATE() + INTERVAL 1 DAY) AND datetime > (NOW() - INTERVAL 2 HOUR) "; break; case('championsleague'): $query .= "WHERE (date = CURDATE() || date = CURDATE() + INTERVAL 1 DAY) AND datetime > (NOW() - INTERVAL 2 HOUR) "; break; case('knvbbeker'): $query .= "WHERE stage = (SELECT stage FROM knvbbeker WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND datetime > (NOW() - INTERVAL 2 HOUR) "; break; case('nederlandselftal'): $query .= "WHERE (date = CURDATE() || date = CURDATE() + INTERVAL 1 DAY) AND datetime > (NOW() - INTERVAL 2 HOUR) "; break; case('eredivisie'): $query .= "WHERE stage = (SELECT stage FROM eredivisie WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND datetime > (NOW() - INTERVAL 2 HOUR) "; break; default: $query .= "WHERE stage = (SELECT stage FROM eredivisie WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND datetime > (NOW() - INTERVAL 2 HOUR) "; } $query .= "ORDER BY datetime ASC, id ASC"; $result = mysql_query($query); if(mysql_num_rows($result) != 0){ while(list($id, $competition, $stage, $date, $datum, $time, $home, $away) = mysql_fetch_row($result)){ // namen omzetten $query_comp = "SELECT name FROM competities WHERE url = '$competition'"; $result_comp = mysql_query($query_comp); list($compname) = mysql_fetch_row($result_comp); if(!isset($class)){ echo "Live streams $compname
"; } $query_h = "SELECT name, url FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename, $homeurl) = mysql_fetch_array($result_h); $query_a = "SELECT name, url FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname, $awayurl) = mysql_fetch_array($result_a); // - // flag $flag = "/img/icons/competities/$competition" . "24.gif"; if(file_exists($_SERVER{'DOCUMENT_ROOT'} . $flag)){ $flag = ""; } else{ $flag = ""; } // // homeflag $homeflag = "/img/icons/clubs/$homeurl" . "24.gif"; if(file_exists($_SERVER{'DOCUMENT_ROOT'} . $homeflag)){ $homeflag = ""; } else{ $homeflag = $flag; } // // awayflag $awayflag = "/img/icons/clubs/$awayurl" . "24.gif"; if(file_exists($_SERVER{'DOCUMENT_ROOT'} . $awayflag)){ $awayflag = ""; } else{ $awayflag = $flag; } // // weekday 2 $query_w2 = "SELECT DATE_FORMAT(date, '%j') AS wday FROM $competition WHERE $competition.id = '$id'"; $result_w2 = mysql_query($query_w2); list($wday2) = mysql_fetch_array($result_w2); // - if(isset($laststage)){ if($wday1 != $wday2){ echo ""; echo ""; $class = ""; } } // vs if(date('Y-m-d') == $date){ $vs = ""; } else{ $vs = "–"; } // echo " "; if($class != "b"){ $class = "b"; } else{ $class = ""; } // weekday 1 $query_w1 = "SELECT DATE_FORMAT(date, '%j') AS wday FROM $competition WHERE $competition.id = '$id'"; $result_w1 = mysql_query($query_w1); list($wday1) = mysql_fetch_array($result_w1); // - $laststage = $stage; } echo " "; } ?>
Live voetbal op internet
Eredivisie Live is veranderd in FOX Sports Eredivisie en FOX Sports International. Je kan live voetbal op internet kijken via streams op je computer, tablet en smartphone. Er zijn live streams op internet beschikbaar van Nederlands, Europees en buitenlands voetbal zoals de Eredivisie, Jupiler League, KNVB Beker, Premier League, Primera Division, Bundesliga, Serie A, Ligue 1, Primeira Liga, Jupiler Pro League, Champions League, UEFA Europa League en het Nederlands Elftal $query = " SELECT date, DATE_FORMAT(datetime, '%W %e %M') AS datum, home, away FROM nederlandselftal WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1 "; $result = mysql_query($query); list($date, $datum, $home, $away) = mysql_fetch_row($result); // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if(date('W', strtotime($date)) == date('W') || $date == date('Y-m-d', strtotime('+1 day')) || $date == date('Y-m-d', strtotime('+2 day'))){ echo ": live "; if($homename == 'Nederland'){ echo $homename . " - " . $awayname; } else{ echo $awayname . " - " . $homename; } } ?>. De mogelijkheden om voetbal live op internet of TV te kijken worden steeds uitgebreider en er zijn zelfs gratis streams beschikbaar. Aanbieders van live voetbal op internet zijn FOX Sports Eredivisie GO, FOX Sports International GO, Unibet en Bwin.
FOX Sports GO bestaat uit twee varianten: Eredivisie GO en International GO. Je kunt met FOX Sports GO Eredivisie live Eredivisie streams op internet kijken. Naast de Eredivisie zijn ook voetbal wedstrijden uit de Jupiler League, KNVB Beker en UEFA Europa League te kijken op je PC, Mac, laptop, tablet of smartphone. Met FOX Sports International GO kun je live buitenlands voetbal kijken via streams op internet: Premier League, Serie A, FA Cup, Coppa Italia, DFB-pokal en meer. Unibet en Bwin bieden gratis live streams op internet: live Eredivisie (buiten NL), Primera Division (Spanje), Serie A (Italië), Bundesliga (Duitsland), Ligue 1 (Frankrijk), Primeira Liga (Portugal), Jupiler Pro League (België), Nederlands Elftal en andere grote Europese competities. Bij Unibet en Bwin kan je naast live voetbal op internet kijken ook wedden op voetbal wedstrijden.
include "ad/468x60/default.php"; ?>Voetbal kijken op TV
Naast internet streams kan je ook live voetbal kijken op TV via digitale televisie. De belangrijkste aanbieders zijn UPC, Tele2, Ziggo en KPN. Om live voetbal op TV te kunnen kijken heb je digitale TV nodig. Je kunt dit via onze website bestellen. Heb je al digitale televisie, dan hoef je alleen FOX Sports en/of Sport1 te bestellen bovenop je huidige pakket. Aanbieders van live voetbal op tv zijn FOX Sports Eredivisie, FOX Sports International en Sport1. Van FOX Sports zijn twee varianten: FOX Sports Eredivisie voor Nederlands voetbal op TV, waaronder de Eredivisie, en FOX Sports International voor buitenlands voetbal op TV. Je kunt ook een combi-pakket nemen met FOX Sports Eredivisie én FOX Sport International.
Met FOX Sports Eredivisie kun je live Eredivisie wedstrijden kijken op TV if(mysql_num_rows(mysql_query("SELECT id FROM eredivisie WHERE date >= CURDATE()")) != 0){ echo ": "; $query = " SELECT date, home, away FROM eredivisie WHERE stage = (SELECT stage FROM eredivisie WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND date >= CURDATE() ORDER BY datetime ASC "; $result = mysql_query($query); $nr = 0; while(list($date, $home, $away) = mysql_fetch_row($result)){ if($nr != 0){ echo ", "; } if($date == date('Y-m-d') || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if( ($awayname == 'Ajax' || $awayname == 'PSV' || $awayname == 'Feyenoord' || $awayname == 'FC Twente' || $awayname == 'AZ') && ($homename != 'Ajax' && $homename != 'PSV' && $homename != 'Feyenoord' && $homename != 'FC Twente' && $homename != 'AZ') ){ echo $awayname . " - " . $homename; } else{ echo $homename . " - " . $awayname; } $nr++; } echo " en alle andere Eredivisie streams."; } else{ echo " van "; $query = " SELECT name FROM clubs WHERE competition = 'eredivisie' ORDER BY id ASC "; $result = mysql_query($query); $nr = 0; while(list($name) = mysql_fetch_row($result)){ if($nr != 0){ echo ", "; } echo $name; $nr++; } echo " en andere Eredivisie clubs."; } ?> Naast live Eredivisie wedstrijden op TV kijk je met FOX Sports Eredivisie live naar de Jupiler League, KNVB Beker en UEFA Europa League (NL). if(mysql_num_rows(mysql_query("SELECT id FROM knvbbeker WHERE date >= CURDATE()")) != 0){ $query = " SELECT stage, date, home, away FROM knvbbeker WHERE stage = (SELECT stage FROM knvbbeker WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND date >= CURDATE() ORDER BY datetime ASC "; // AND (home = 'ajax' || home = 'feyenoord' || home = 'psv' || home = 'twente' || home = 'az' || away = 'ajax' || away = 'feyenoord' || away = 'psv' || away = 'twente' || away = 'az') $result = mysql_query($query); $nr = 0; while(list($stage, $date, $home, $away) = mysql_fetch_row($result)){ if($nr == 0){ echo "Dit betekent dus ook in de $stage van de KNVB Beker "; } else{ echo ", "; } if($date == date('Y-m-d') || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if( ($awayname == 'Ajax' || $awayname == 'PSV' || $awayname == 'Feyenoord' || $awayname == 'FC Twente') && ($homename != 'Ajax' && $homename != 'PSV' && $homename != 'Feyenoord' && $homename != 'FC Twente') ){ echo $awayname . " - " . $homename; } else{ echo $homename . " - " . $awayname; } $nr++; } echo "."; } else{ echo "Zo heb je alle wedstrijden van het Nederlands voetbal bij elkaar, waaronder de KNVB Beker."; } ?> if(mysql_num_rows(mysql_query("SELECT id FROM europaleague WHERE WEEKOFYEAR(date) = WEEKOFYEAR(NOW()) AND date >= CURDATE()")) != 0){ $query = " SELECT stage, date, home, away FROM europaleague WHERE stage = (SELECT stage FROM europaleague WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1) AND date >= CURDATE() ORDER BY datetime ASC "; $result = mysql_query($query); $nr = 0; while(list($stage, $date, $home, $away) = mysql_fetch_row($result)){ if($nr == 0){ echo "Daarnaast in de UEFA Europa League "; } else{ echo ", "; } if($date == date('Y-m-d') || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if( ($awayname == 'Ajax' || $awayname == 'PSV' || $awayname == 'Feyenoord' || $awayname == 'FC Twente' || $awayname == 'AZ') && ($homename != 'Ajax' && $homename != 'PSV' && $homename != 'Feyenoord' && $homename != 'FC Twente' && $homename != 'AZ') ){ echo $awayname . " - " . $homename; } else{ echo $homename . " - " . $awayname; } $nr++; } } else{ echo "Daarnaast kun je live Europa League wedstrijden kijken"; } echo " via FOX Sports Eredivisie."; ?>
Voor wedstrijden uit de Champions League en buitenlands voetbal kan je FOX Sports International en Sport1 bestellen. Met FOX Sports International kun je live buitenlands voetbal kijken uit de Premier League, Serie A, Europa League (exclusief de wedstrijden van de Nederlandse clubs), FA Cup, DFB-Pokal, Coppa Italia, League Cup en meer. Live voetbal op TV voor buitenlands voetbal is ook beschikbaar via Sport1: de Spaanse Primera Division, Duitse Bundesliga, Franse Ligue 1, Portugese Primeira Liga, Belgische Jupiler Pro League en de UEFA Champions League. if(mysql_num_rows(mysql_query("SELECT id FROM championsleague WHERE WEEKOFYEAR(date) = WEEKOFYEAR(NOW()) AND date >= CURDATE()")) != 0){ $query = " SELECT stage, date, home, away FROM championsleague WHERE WEEKOFYEAR(date) = WEEKOFYEAR(NOW()) AND date >= CURDATE() ORDER BY datetime ASC "; $result = mysql_query($query); $nr = 0; while(list($stage, $date, $home, $away) = mysql_fetch_row($result)){ if($nr == 0){ echo "Binnenkort op Sport1 wedstrijden uit de $stage van de Champions League: "; } else{ echo ", "; } if($date == date('Y-m-d') || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - echo $homename . " - " . $awayname; $nr++; } echo "."; } ?>
include "ad/468x60/default.php"; ?>Live streams op internet
In de afgelopen seizoenen werd voetbal kijken op internet via live streams op Chinese zenders steeds populairder en verschillende websites gaven hier informatie over. P2P programma's als SopCast, TVAnts, StreamTorrent en TVUPlayer maken het mogelijk gratis Eredivisie wedstrijden te kijken van uw favoriete voetbalclub, zoals if(mysql_num_rows(mysql_query("SELECT id FROM eredivisie WHERE WEEKOFYEAR(date) = WEEKOFYEAR(NOW()) AND date >= CURDATE()")) != 0){ $query = " SELECT date, home, away FROM eredivisie WHERE WEEKOFYEAR(date) = WEEKOFYEAR(NOW()) AND date >= CURDATE() ORDER BY datetime ASC "; $result = mysql_query($query); $nr = 0; while(list($date, $home, $away) = mysql_fetch_row($result)){ if($nr != 0){ echo ", "; } if($date == date('Y-m-d') || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if($awayname == 'Ajax' || $awayname == 'PSV' || $awayname == 'Feyenoord' || $awayname == 'FC Twente'){ echo $awayname . " - " . $homename; } else{ echo $homename . " - " . $awayname; } $nr++; } echo " en andere Eredivisie wedstrijden."; } else{ $query = " SELECT name FROM clubs WHERE competition = 'eredivisie' ORDER BY short ASC "; $result = mysql_query($query); $nr = 0; while(list($name) = mysql_fetch_row($result)){ if($nr != 0){ echo ", "; } if($name == "Ajax" || $name == "Feyenoord" || $name == "PSV"){ echo ''; } echo $name; if($name == "Ajax" || $name == "Feyenoord" || $name == "PSV"){ echo ''; } $nr++; } echo "."; } ?>
Ook populair zijn streams van Oranje: $query = " SELECT date, DATE_FORMAT(datetime, '%W %e %M') AS datum, home, away FROM nederlandselftal WHERE date >= CURDATE() ORDER BY datetime ASC LIMIT 1 "; $result = mysql_query($query); list($date, $datum, $home, $away) = mysql_fetch_row($result); if(date('W', strtotime($date)) == date('W') || $date == date('Y-m-d', strtotime('+2 day')) || $date == date('Y-m-d', strtotime('+1 day'))){ echo "live "; } // clubnamen omzetten $query_h = "SELECT name FROM clubs WHERE short = '$home'"; $result_h = mysql_query($query_h); list($homename) = mysql_fetch_array($result_h); $query_a = "SELECT name FROM clubs WHERE short = '$away'"; $result_a = mysql_query($query_a); list($awayname) = mysql_fetch_array($result_a); // - if($homename == 'Nederland'){ echo $homename . " - " . $awayname; } else{ echo $awayname . " - " . $homename; } echo " op $datum."; ?> De wedstrijden worden uitgezonden via internet streams die meestal afkomstig zijn uit China, of de zender Eredivisie Live werd gestreamd. Ook in Nederland zijn diverse streamers actief die een live stream gratis verspreiden via internet. Voor Eredivisie live streams via P2P televisie zijn er op dit moment de goede alternatieven Unibet, Bwin en FOX Sports GO Eredivisie live op internet. De tussenstand van Eredivisie streams en wedstrijden uit andere competities vind je op tussenstanden Eredivisie.