Det er ikke svært at lave PHP. Hvis du laver følgende filer og indtaster dine indstillinger i filen: inc_settings.php så har du en side der kan vise listen med resultaterne. Det er nok nemmere bare at lave det i Excel.
settings.php:
<?php
$set_table_prefix = "";
$db_host = "";
$db_user = "";
$db_pass = "";
$check_database_name = "";
?>
create_tables.php:
<?php include 'inc_settings.php'; ?>
<?php
$con = mysql_connect("$db_host","$db_user","$db_pass");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("$check_database_name", $con);
//### TABLE
$sql = "CREATE TABLE $set_table_prefix" . "_table
(
ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
fullname varchar(50),
score INT,
spare INT,
strike INT,
vartime varchar(50)
)";
mysql_query($sql,$con);
mysql_close($con);
?>
Udført... Tabellerne er oprettet.<br><br>
vis.php:
<?php include 'inc_settings.php'; ?>
$con = mysql_connect("$db_host","$db_user","$db_pass");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("$check_database_name", $con);
$result = mysql_query("SELECT * FROM $set_table_prefix" . "_table ORDER by strike desc, score desc");
echo "<table width=100% border=1 cellpadding=10 cellspacing=5>";
$total = array();
while($row = mysql_fetch_array($result)) {
if (!seset($total[$row['fullname']])
$total[$row['fullname']] = 0;
$total[$row['fullname']] = $row['score'];
echo "<tr>";
echo "<td>" . $row['vartime'] . "</td>";
echo "<td>" . $row['fullname'] . "</td>";
echo "<td>" . $row['score'] . "</td>";
echo "<td>" . $row['spare'] . "</td>";
echo "<td>" . $row['strike'] . "</td>";
echo "</tr>";
}
echo "</table><br>";
foreach($total AS $each)
echo $each . "<br>";
mysql_close($con);
?>
Du kan lige se om det virker og om det er noget du vil arbejde videre med.
