Daten aus Datenbank einlesen u. bearbeiten

ich weiß, dass ich mittlerweile mit meiner Seite für die Feuerwehr nerve...

Aber jetzt habe ich ein weiteres problem...

Warum funktioniert das hier nicht?

einsatz_editieren.php:

<DIV align="left"><TABLE width=550 bordercolor="#000000" border="0" cellspacing=0 cellpadding=0 align=left>  
<TR>
  <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Userprofil</FONT></b></TD>
</TR>
<TR>
  <TD>
<TABLE width=550 bordercolor="#000000" border="0" align=left>  
<TR>
  <TD width=16></TD>
  <TD width=518><FONT face="Tahoma" size=-1 color=#ffffff>  
  <DIV align="center">  
</DIV>
   <DIV align="left">     



<?php
include('inc_config.php');  
$anfrage='SELECT * FROM einsatz where nummer="'.$row['nummer'].'"'    
$data = mysql_query($anfrage);     
while($row = mysql_fetch_array($data)) 
  { 
  echo '  
  <form method=post action=index.php?section=admin&section=einsatz_editieren>
  <TABLE bordercolor="#000000" border="0">  
<TR>
  <TD valign=top width=105>
      </TD>
  <TD valign=top>
  <TABLE width=100% bordercolor="#000000" border="0">  
<TR>
  <TD><b>Einsatznummer (Bsp.: 001):</TD>
  <TD><DIV align="left"><INPUT type="text" name="nummer" value="'.$row['nummer'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>

</TD>
</TR>
<TR>
  <TD><b>Kurze Beschreibung:</TD>
  <TD><DIV align="left"><INPUT type="text" name="ort" value="'.$row['beschreibung'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD><b>Einsatzkr&auml;fte:</TD>
  <TD><DIV align="left"><INPUT type="text" name="ort" value="'.$row['kraefte'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD><b>Ort:</TD>
  <TD><DIV align="left"><INPUT type="text" name="icq" value="'.$row['ort'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" > ( ohne - )</TD>  
</TR>
<TR>
  <TD><b>Datum des Einsatzes (Bsp.: 01.01.2007):</TD>
  <TD><DIV align="left"><INPUT type="text" name="msn" value="'.$row['datum'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD><b>Zeit der Alamierung:</TD>
  <TD><DIV align="left"><INPUT type="text" name="homepage" value="'.$row['zeit'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD><b>Einsatzende:</TD>
  <TD><DIV align="left"><INPUT type="text" name="email" value="'.$row['ende'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>

<TR>
  <TD><b>Einges&auml;tze Fahrzeuge:</TD>
  <TD><DIV align="left"><INPUT type="text" name="email" value="'.$row['fahrzeuge'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
</TABLE>

  </TD>
</TR>
</TABLE>
<br>
<INPUT type="hidden" name="id" value="'.$row['nummer'].'" size="" maxlength="">  
<INPUT type="submit" name="edit" value="Speichern">  </form>';  

  
  
};?>


  </div></FONT></TD>
  <TD width=16></TD>
</TR>
</TABLE>


  </TD>
</TR>
<TR>
 </TR>
</TABLE>  </div>
<br>

Er macht immer einen Fehler in Line 20 und ich weiß nicht wieso!

Wäre echt genial, wenn ihr euch das einmal anschauen würdet.

Gruß Aleks

Please also mark the comments that contributed to the solution of the article

Content-Key: 59104

Url: https://administrator.de/contentid/59104

Printed on: April 20, 2024 at 00:04 o'clock

1 Comment

Ich hab dir mal das Dokument überarbeitet und einige HTML fehler behoben. Wegen PHP du hast in der einen Zeile nur ein " ; " ohne " vergessen. Achte wenn du ein Tag öffnest das du es auch wieder schließt und natürlich andersrum. Es sind sicher noch fehler drin die ich noch übersehen hab...

<DIV align="left">  
  <TABLE width="550" bordercolor="#000000" border="0" cellspacing="0" cellpadding="0" align="left">  
    <TR>
      <td>Userprofil</TD>
    </TR>
    <TR>
      <TD><TABLE width="550" bordercolor="#000000" border="0" align="left">  
          <TR>
            <TD width="16"></TD>  
            <TD width="518">  
              <DIV align="center"></DIV>  
              <DIV align="left">  
              	<FONT face="Tahoma" size="-1" color="#ffffff">  
                <?php
include('inc_config.php');  
$anfrage='SELECT * FROM einsatz where nummer="'.$row['nummer'].'"';   
$data = mysql_query($anfrage);     
while($row = mysql_fetch_array($data)) 
  { 
  echo '  
  <form method="post" action="index.php?section=admin&amp;section=einsatz_editieren">  
  <TABLE bordercolor="#000000" border="0">  
<TR>
  <TD valign="top" width="105"></TD>  
  <TD valign="top">  
  <TABLE width="100%" bordercolor="#000000" border="0">  
<TR>
  <TD>Einsatznummer (Bsp.: 001):</TD>
  <TD><DIV align="left"><INPUT type="text" name="nummer" value="'.$row['nummer'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD>Kurze Beschreibung:</TD>
  <TD><DIV align="left"><INPUT type="text" name="ort" value="'.$row['beschreibung'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD>Einsatzkr&auml;fte:</TD>
  <TD><DIV align="left"><INPUT type="text" name="ort" value="'.$row['kraefte'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD>Ort:</TD>
  <TD><DIV align="left"><INPUT type="text" name="icq" value="'.$row['ort'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" > ( ohne - )</TD>  
</TR>
<TR>
  <TD>Datum des Einsatzes (Bsp.: 01.01.2007):</TD>
  <TD><DIV align="left"><INPUT type="text" name="msn" value="'.$row['datum'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD>Zeit der Alamierung:</TD>
  <TD><DIV align="left"><INPUT type="text" name="homepage" value="'.$row['zeit'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
<TR>
  <TD>Einsatzende:</TD>
  <TD><DIV align="left"><INPUT type="text" name="email" value="'.$row['ende'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>

<TR>
  <TD>Einges&auml;tze Fahrzeuge:</TD>
  <TD><DIV align="left"><INPUT type="text" name="email" value="'.$row['fahrzeuge'].'" size="" maxlength="" style="background-color:#000000; font-size: 10px; width=100px; color: #ffffff; font-family: verdana,geneva,arial" ></TD>  
</TR>
</TABLE>

  </TD>
</TR>
</TABLE>
<br>
<INPUT type="hidden" name="id" value="'.$row['nummer'].'" size="" maxlength="">  
<INPUT type="submit" name="edit" value="Speichern">  </form>';  

  
  
};?>
              </FONT>
              </div>
              </TD>
            <TD width="16"></TD>  
          </TR>
        </TABLE></TD>
    </TR>
    <TR> </TR>
  </TABLE>
</div>
<br>

German Question PHP Development

Hotly discussed

Check of ZFW Firewallgleixnerd - 3 Comments

How to set up and configure a Linux GRE tunnelAlexWisha - 3 Comments

WIREGUARD VPN ON UDM PRO BEHIND FRITZBOX - HANDSHAKE DID NOT COMPLETEjstricker - 3 Comments

End of Support dates for Office 2016, 2019 Apps und Productivity ServersDani - 1 Comment