nej her er hele add.php:
<?php
require('tjeklogin.php');
?>
<html>
<head>
<title>Opdater spillerdata</title>
<style type="text/css">
body {
text-align: center;
background-color: #999999;
}
table {
border: medium solid white;
}
th {
color: #000000;
background-color: #DEDEDE;
padding: 0px 2px 0px 2px;
border: thin red;
}
td {
color: #000000;
background-color: #DEDEDE;
padding: 0px 2px 0px2px;
border: thin blue;
}
</style>
</head>
<body>
<div align="center">
<h1 style=" color: 33aacc;"><php echo $_GET['spiller'];?></h1>
<?php
if($_GET['status'] == 'done') echo"Databasen er opdateret for spilleren: <h2><b>{$_GET['spiller']}</b></h2>";
?>
<?php
include('include.php');
$res = mysql_query("select * from spillere where navn='".$_GET['spiller']."'");
$row = mysql_fetch_assoc($res);
$out = "<table><tr>";
$out .= "<th>Spiller</th><th>kampe_dbu</th><th>maal_dbu</th><th>kampe_friendly</th><th>maal_friendly</th><th>gule</th><th>roede</th><th>stemmer</th><th>kampensspiller</th><th>ol</th></tr><tr>";
$out .= "<td>".$row['navn']."</td><td>".$row['kampe_dbu']."</td><td>".$row['maal_dbu']."</td><td>".$row['kampe_friendly']."</td><td>".$row['maal_friendly']."</td><td>".$row['gule']."</td><td>".$row['roede']."</td><td>".$row['stemmer']."</td><td>".$row['kampensspiller']."</td><td>".$row['ol']."</td>";
$out .= "</tr></table>";
echo $out;
?>
</div>
<br>
<div align="left"><b>Status:</b> <?php echo $_SESSION['Status']; ?><br />
<h4 align="center">Opdater data for seneste kamp</h4>
</div><br />
<br>
<?php
require 'include.php'; // Forbindelse til database
$res = mysql_query("select navn, efternavn from spillere");
$opt = "<select name='navn' size='1'>";
while ($row = mysql_fetch_row($res)) {
$opt .= "<option value='".$row[0]."'>".$row[0]." ".$row[1]."</option>";
}
$opt .= "</select>";
?>
<form method="post" action="
http://super6.kappels.net/kamp/opdater.php"> <div align="center">
<table width="900">
<tr>
<td> </td>
<td>Spiller: <? echo $opt; ?> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Vælg kamp:</td>
<td><div align="right">Kampe_dbu: </div></td>
<td><div align="center">
<input name="kampe_dbu" type="checkbox" value="1" size="2">
</div></td>
<td><div align="right">Kampe_friendly:</div></td>
<td><div align="center">
<input name="kampe_friendly" type="checkbox" value="1" size="2">
</div></td>
<td><div align="right">Kampe_indoors: </div></td>
<td><div align="center">
<input name="kampe_indoors" type="checkbox" value="1" size="2">
</div></td>
<td><div align="right">Kampe_cup:
</div></td>
<td><div align="center">
<input name="kampe_cup" type="checkbox" value="1" size="2">
</div></td>
</tr>
<tr>
<td> </td>
<td><div align="right">Mål_dbu:</div></td>
<td><div align="center">
<input name="maal_dbu" type="text" size="2">
</div></td>
<td><div align="right">Mål_friendly: </div></td>
<td><div align="center">
<input name="maal_friendly" type="text" size="2">
</div></td>
<td><div align="right">Mål_indoors: </div></td>
<td><div align="center">
<input name="maal_indoors" type="text" size="2">
</div></td>
<td><div align="right">Mål_cup: </div></td>
<td><div align="center">
<input name="maal_cup" type="text" size="2">
</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Andet:</td>
<td>Gule: </td>
<td><div align="center">
<input name="gule" type="text" size="2">
</div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Røde:</td>
<td><div align="center">
<input name="roede" type="text" size="2">
</div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Øl:</td>
<td><div align="center">
<input name="ol" type="text" size="2">
</div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Stemmer:</td>
<td><div align="center">
<input name="stemmer" type="text" size="2">
</div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Kampens spiller: </td>
<td><div align="center">
<input name="kampensspiller" type="checkbox" value="1" size="2">
</div></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<input name="send" type="submit" value="Opdater">
</div>
</form>
<br>
<p><a href=../index.php>Tilbage til forsiden</a> | <a href="logud.php" title="Log ud">Log ud</a><br />
</p>
<br>
<br>
<h4>Udsend mail til alle spillere:</h4>
<?php
if (isset($_POST['send']))
{
$besked = $_POST['besked'];
$emne = $_POST['emne'];
$testemail = $_POST['testemail'];
if (isset($testemail) && '' != $testemail)
{
mail($testemail, $emne, $besked);
echo '<p>Der er sendt en e-mail til <b>test</b> adressen</p>';
}
else
{
include('include.php');
mysql_select_db($database);
$sql ='SELECT * FROM spillere';
$resultat = mysql_query($sql);
while ($raekke = mysql_fetch_array($resultat))
{
mail($raekke['email'], $emne, $besked);
}
mysql_close();
echo '<p>Der er sendt en e-mail til <b>hele</b> listen</p>';
}
}
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
Testemail:<br >
<input type="text" name="testemail" /><br />
Emne:<br />
<input type="text" name="emne" value="<?php $_POST['emne']; ?>" /><br />
Besked:<br />
<textarea name="besked" rows="5" cols="30"><?php $_POST['besked']; ?></textarea><br />
<input type="submit" value="Send Mail" name="send" />
<input type="reset" name="Nulstil formular" />
</form>
<br>
<br>
<br>
<br>
<br>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
