6. Spieltag


#echo $_SERVER[‘DOCUMENT_ROOT’];
include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);

$tag1 = 6;
$saison1 = ‘2017-18’;

Try{
$dbh = new PDO($server, $user, $password, $options);
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql=”SELECT
liveticker.spieltag,
liveticker.Datum_start,
liveticker.datum_ende,
liveticker.IDfrauen,
liveticker.IDherren1,
liveticker.IDherren2,
liveticker.IDmixC,
liveticker.IDmixKVA,
liveticker.saison
FROM
liveticker
WHERE
liveticker.spieltag = ‘”. $tag1 .”‘ and
liveticker.saison = ‘”. $saison1 .”‘”;

$result=$dbh->query($sql);

foreach($result as $daten) {
#echo $daten[‘IDmixC’];

#echo “

Regionalliga Frauen

“;
echo “

“;
echo “

“;
}

$dbh = null;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “
“;
die();
}

#

include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);

Try{
$dbh = new PDO($server, $user, $password, $options);
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql=”SELECT
liveticker.spieltag,
liveticker.Datum_start,
liveticker.datum_ende,
liveticker.IDfrauen,
liveticker.IDherren1,
liveticker.IDherren2,
liveticker.IDmixC,
liveticker.IDmixKVA,
liveticker.saison
FROM
liveticker
WHERE
liveticker.spieltag = ‘”. $tag1 .”‘ and
liveticker.saison = ‘”. $saison1 .”‘”;

$result=$dbh->query($sql);

foreach($result as $daten) {
#echo $daten[‘IDmixC’];

echo “

Gruppenliga 1 Männer

“;
echo “

“;
echo “

“;
}

$dbh = null;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “
“;
die();
}

#

include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);

Try{
$dbh = new PDO($server, $user, $password, $options);
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql=”SELECT
liveticker.spieltag,
liveticker.Datum_start,
liveticker.datum_ende,
liveticker.IDfrauen,
liveticker.IDherren1,
liveticker.IDherren2,
liveticker.IDmixC,
liveticker.IDmixKVA,
liveticker.saison
FROM
liveticker
WHERE
liveticker.spieltag = ‘”. $tag1 .”‘ and
liveticker.saison = ‘”. $saison1 .”‘”;

$result=$dbh->query($sql);

foreach($result as $daten) {
#echo $daten[‘IDmixC’];

echo “

B Liga Mix

“;
echo “

“;
echo “

“;
}

$dbh = null;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “
“;
die();
}

#

include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);

Try{
$dbh = new PDO($server, $user, $password, $options);
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql=”SELECT
liveticker.spieltag,
liveticker.Datum_start,
liveticker.datum_ende,
liveticker.IDfrauen,
liveticker.IDherren1,
liveticker.IDherren2,
liveticker.IDmixC,
liveticker.IDmixKVA,
liveticker.saison
FROM
liveticker
WHERE
liveticker.spieltag = ‘”. $tag1 .”‘ and
liveticker.saison = ‘”. $saison1 .”‘”;

$result=$dbh->query($sql);

foreach($result as $daten) {
#echo $daten[‘IDmixC’];

echo “

C Liga 1 Mix

“;
echo “

“;
echo “

“;
}

$dbh = null;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “
“;
die();
}

#

include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);

Try{
$dbh = new PDO($server, $user, $password, $options);
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql=”SELECT
liveticker.spieltag,
liveticker.Datum_start,
liveticker.datum_ende,
liveticker.IDfrauen,
liveticker.IDherren1,
liveticker.IDherren2,
liveticker.IDmixC,
liveticker.IDmixKVA,
liveticker.saison
FROM
liveticker
WHERE
liveticker.spieltag = ‘”. $tag1 .”‘ and
liveticker.saison = ‘”. $saison1 .”‘”;

$result=$dbh->query($sql);

foreach($result as $daten) {

echo “

KVA Liga 2

“;
echo “

“;
echo “

“;
}

$dbh = null;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “
“;
die();
}
?>