<?php
$host="127.0.0.1";
$port=3306;
$socket="";
$user="root";
$password="";
$dbname="dragrace";
$con = new mysqli($host, $user, $password, $dbname, $port, $socket)
or die ('Could not connect to the database server' . mysqli_connect_error());
//a.l. : Probleme mit Dragrace Anmelungen Namen
$con->set_charset("utf8");
//$con->close();
/*
SELECT Resultate Tabelle mit Namen
*/
$query = "SELECT r.Start_Nr as 'Start-<br>Nummer',
r.id as ID,
u.`name` as Name,
u.angemeldet as Angemeldet
FROM resultate r
LEFT JOIN user u
ON u.start_nr=r.Start_Nr
WHERE u.`angemeldet` > '2014-01-01 23:00:52.000000'
OR u.`angemeldet` is null
ORDER BY r.start_nr, r.id";
$stmt = $con->prepare($query) or die ("error");
$stmt->execute();
$result = $stmt->get_result();
$field_info = $result->fetch_fields();
$stmt->close();
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<table border="1">
<!--Spalten Titel-->
<tr>
<?php foreach ($field_info as $spalte){ ?>
<td><?php echo $spalte->name ?></td>
<?php } ?>
</tr>
<!--Daten Zeilen-->
<?php while ($row = $result->fetch_row()){ ?>
<tr>
<!--Daten Spalten-->
<?php foreach ($row as $val){ ?>
<td><?php echo $val?></td>
<?php } ?>
</tr>
<?php } ?>
</table>
</body>
</html>
Keine Kommentare:
Kommentar veröffentlichen