#echo $_SERVER[‘DOCUMENT_ROOT’];
include $_SERVER[‘DOCUMENT_ROOT’].”/wp-content/kcgdb/lib/sql_setting.php”;
#include (“/lib/sql_setting.php”);
$tag1 = 1;
$saison1 = ‘2018-19’;
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[‘IDfrauen’];
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[‘IDherren1’];
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[‘IDherren2’];
echo “
A Liga 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 “
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();
}
?>