| Gast | 
Die Daten in der Datenbank müssen nie verändert werden.
Ich kann natürlich auch ein Formular zu verfügung stellen in dem die Nachbarn das Datum des nächsten Wassertages eingeben, z.B. schon zusammen mit dem Passwort-Formular.(Natürlich erst wenn ich die Daten und das Datum des nächsten Wassertages in die Datenbank eingegeben habe). Aber dann muß ich den Leuten erst mal das Datum bekannt geben denn das weiss nur ich. Dazu muß ich noch sagen das fast alle meine Nachbarn das Internet nur von Ihren Kindern her kennen. Ich meinte, es ist besser wenn ich die Daten ohne Ihr zu tun presentiere kann. Dazu muß ich auf der Auslese-Seite die Scripte mit dem zuständigen datum versehen. Du wirst sehen das ich das auslesen immer an das aktuelle Datum des nächsten Wassertages binde. Es stehen natürlich die Wassertage des letzen Jahres auch in der DB.
Genau diesen String "18.12.2004" möchte ich mit dem nächsten Datum ersetzen.  Es gibt Funktionen bei denen man einen string suchen und ersetzen kann aber das ergebniss muß dan auch in der Datei gespeichert werden.
Hier mal der Script den ich zur Zeit verwende: PHP-Code: <?php
if($usuario == "xxxxxx" and $password == "xxxxxxx")
{
$server = "localhost";
$user = "xxxxxxx";
$pass = "xxxxxx";
$datenbank = "aqua";
$verbindung = mysql_connect($server,$user,$pass) or die ("Keine Verbindung möglich. Prüfen Sie die Zugangsdaten oder wenden Sie sich an den Administrator.");
mysql_select_db($datenbank) or die ("Die Datenbank existiert nicht. Prüfen Sie die Schreibweise oder wenden Sie sich an den Administrator.");
$dbh = mysql_connect($server, $user, $pass);
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '1' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "<p align= \"center\">[b]<font color=\"FF0000\" size=\"3\">Fecha Echada: $row->fecha_echada </font>[/b]</p>";
echo "<hr style=\"background-color: \"#FFFF00\" color=\"#0000FF\" size=\"3\">";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Chichin</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '2' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Ramon</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Horas";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '3' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Vielo</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '4' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Juan</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '5' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Fini</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '6' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Alex</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '7' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Mira</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '8' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Antonio</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo "<hr>";
}
$abfrage = "SELECT fecha_echada, order_echada, hora_echada FROM echada WHERE fecha_echada LIKE '18.12.2004' and socioID LIKE '9' ";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Pepe</font>[/b]</p>";
echo "Pedido: ";
echo $row->order_echada;
echo " Hora";
echo "
";
echo "Hora: ";
echo $row->hora_echada;
echo "
";
echo ":::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::";
}
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '1' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '1' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '1' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "
";
echo "<p align= \"center\">[b]<font color=\"#FF0000\" size=\"4\">Info Deposito</font>[/b]</p>";
echo "<hr style=\"background-color: \"#FFFF00\" color=\"#0000FF\" size=\"3\">";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Chichin</font>[/b]</p>";
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '2' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '2' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '2' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
Echo "</p>
<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Ramon</font>[/b]</p>";
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Vielo</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '3' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '3' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '3' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Juan</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '4' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '4' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '4' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Fini</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '5' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '5' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '5' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Alex</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '6' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '6' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '6' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Mira</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '7' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '7' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '7' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Antonio</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '8' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '8' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '8' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
Echo "<hr>";
echo "
";
echo "<p align= \"left\">[b]<font color=\"#0000FF\" size=\"3\">Pepe</font>[/b]</p>";
$abfrage = "SELECT sum(ing_euro) FROM ingreso WHERE socioID LIKE '9' ";
$ergebnis = mysql_query($abfrage);
$summe_ing_euro = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(valor_order) FROM echada WHERE socioID LIKE '9' ";
$ergebnis = mysql_query($abfrage);
$summe_order_valor = mysql_result($ergebnis, 0);
$abfrage = "SELECT sum(order_echada) FROM echada WHERE socioID LIKE '9' ";
$ergebnis = mysql_query($abfrage);
$summe_order_echada = mysql_result($ergebnis, 0);
$deposito_actual = $summe_ing_euro - $summe_order_valor;
echo "Aqua total consumado: ";
echo $summe_order_echada;
echo " Horas";
echo "
";
echo "Precio total: ";
echo $summe_order_valor;
echo " Euros";
echo "
";
echo "Ingreso total: ";
echo $summe_ing_euro;
echo ",- Euros";
echo "
";
echo "Deposito actual: ";
echo $deposito_actual;
echo " Euros";
echo "
";
echo "<hr>";
}
else
{
echo "mal password or mal usuario";
}
?> |