EINFÜHRENDE DATENBANKBEISPIELE  MIT  PHP+MYSQL
Anzeige einer Tabelle, Version 1
Anzeige einer Tabelle, Version 2
Teilnehmerliste

 

Anzeige einer Tabelle 1

<? /* Anzeige */ ?>
<?
      /*if ($gebiete=="" or $name=="") {
             header("Location: $HTTP_REFERER");
             exit;
       }
      */
$host = "localhost";
$dbase = "ecdl";
$user = "root";
$pass = "";
$db = mysql_connect($host, $user, $pass) or die("beim Verbinden Datenbankfehler");
?>


<HTML>
<HEAD><TITLE>Auswertung</TITLE>
</HEAD>
<BODY bgcolor="CCCCFF">
<P><center><FONT face=Arial size=4>Bisherige Anmeldungen zu den ECDL-Prüfungen</FONT></center></P><br>
<table align="center" border=1 cellspacing=1>
<?
       $query = "SELECT name, schule, email, orttermin, gebiete FROM anmeldung"; 
       $rs = mysql_db_query("ecdl", $query, $db);
       $flag=0;
       echo("<TR bgcolor=\"AAAAAA\">");
       echo("<TD><b>"."NAME"."</TD>");
       echo("<TD><b>"."SCHULE"."</TD>");
       echo("<TD><b>"."E-MAIL"."</TD>");
       echo("<TD><b>"."ORT/DATUM"."</TD>");
       echo("<TD><b>"."MODULE"."</TD>");
       while ($row = mysql_fetch_row($rs)) {
              if ($flag==0): 
                   echo("<TR bgcolor=\"CCCCCC\">");
                   echo("<TD>".$row[0]."</TD>");
                   echo("<TD>".($row[1]=='' ? ' --- ' : $row[1])."</TD>");
                   echo("<TD>".$row[2]."</TD>");
                   echo("<TD>".$row[3]."</TD>");
                   echo("<TD>".$row[4]."</TD>");
                   $flag=1;
                   echo("</TR>"); 
             else:
                   echo("<TR bgcolor=\"FFFFFF\">");
                   echo("<TD>".$row[0]."</TD>");
                   echo("<TD>".($row[1]=='' ? ' --- ' : $row[1])."</TD>");
                   echo("<TD>".$row[2]."</TD>");
                   echo("<TD>".$row[3]."</TD>");
                   echo("<TD>".$row[4]."</TD>");
                   $flag=0;
                   echo("</TR>"); 
             endif;
       } 
?>
</table>
<? mysql_close(); ?>
<br><br><center><a href="index.htm">ZURÜCK</a><center>
</BODY>
</HTML>

 

Anzeige einer Tabelle 2

<html> <head><title>Tabellen anzeigen</title></head>
<body>
<? 
     $dbhost="localhost"; 
     $dbuser="root"; 
     $dbpass=""; 
     $dbname="ecdl"; 
     $table="anmeldung"; 
     mysql_connect( "$dbhost", "$dbuser", "$dbpass") or die( "Unable to connect to SQL server");
     mysql_select_db( "$dbname") or die( "Unable to select database"); 
     if(!IsSet($sort)) $result = mysql_query( "select * from $table"); 
                else $result = mysql_query( "select * from $table order by $sort"); 
?> 

<table border="1"> 
<tr> 
       <? 
           while ($field=mysql_fetch_field($result)) { 
                echo "<th><A HREF=\"showtable.php3?sort=$field->name\">$field->name</A></th>"; 
           } 
           echo "</tr>"; 
           while($row = mysql_fetch_row($result)) { 
                   echo "<tr>"; 
                   for($i=0; $i < mysql_num_fields($result); $i++) { 
                              echo "<td>$row[$i]</td>"; 
                    } 
                   echo "</tr>\n"; 
           } 
?>
</table>
</body>
</html>

 

Teilnehmerliste eingeben und anzeigen

Das Eingabeformular

<FORM   action="_auswertung.php3"  method="post">
        <TABLE bgColor=#faebd7 border=0 cellPadding=1 cellSpacing=2 width=100% borderColor=lightseagreen>
             <TR>
                 <TD bgColor=lightgrey colSpan=1><STRONG>Name </STRONG></TD>
                 <TD><INPUT name=name style="HEIGHT: 22px; WIDTH: 246px"></TD>
           </TR>
            <TR>
                 <TD bgColor=lightgrey colSpan=1><STRONG>Schule </STRONG></TD>
                 <TD><INPUT name=schule style="HEIGHT: 22px; WIDTH: 246px"></TD>
           </TR>
           <TR>
                 <TD bgColor=lightgrey colSpan=1><STRONG>E-Mail </STRONG></TD>
                 <TD><INPUT name=email style="HEIGHT: 22px; WIDTH: 246px"></TD>
          </TR>
          <TR>
                 <TD bgColor=#D3D3D3><b>Prüfungsort/Termin</b></TD>
                 <TD>
                 <SELECT id="" name=orttermin style="HEIGHT: 22px; WIDTH: 246px">
                           <OPTION >Villach, Do, 30.Nov.
                           <OPTION >Villach, Do, 7.Dez.
                           <OPTION >Völkermarkt, Sa, 11.Nov.
                           <OPTION >Völkermarkt, Do, 23.Nov.
                           <OPTION >Wolfsberg, Sa, 18. Nov.
                           <OPTION >Wolfsberg, Mi, 22. Nov.
                  </SELECT>
                 <TD></TD>
            </TR>
            <TR>
                  <TD bgColor=lightgrey colSpan=2><font size="1">Übersicht&nbsp;
                    Module:&nbsp;&nbsp;<font face="Arial"> 1: Grundlagen, 2:Betriebssystem, 3:Text,
                    4:Kalkulation, 5: Datenbank, 6:Präsentation, 7:Internet</font></font></TD>
            </TR>
            <TR>
                    <TD bgColor=lightgrey colSpan=1><STRONG>Module&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; z.B. (1,3,4,6) </STRONG></TD>
                    <TD><INPUT name=gebiete style="HEIGHT: 22px; WIDTH: 246px"></TD>
              </TR>
         </TABLE>
         <P><INPUT id=submit1 name=submit1 type=submit value="Absenden und Ergebnisse ansehen ">&nbsp;&nbsp;&nbsp; 
                <INPUT id=reset1 name=reset1 type=reset value=Neueingabe></P>
</FORM>

Speicherung(Anfügen) in der Datenbank und Anzeige (_auswertung.php3) 

<? /* Auswertung der Umfrage und Abspeicherung        */  ?>
       <?
             if ($gebiete=="" or $name=="") {
                           header("Location: $HTTP_REFERER");
                           exit;
              }
       $host = "localhost";
       $dbase = "ecdl";
       $user = "root";
       $pass = "";
       $db = mysql_connect($host, $user, $pass) or die("beim Connecten Datenbankfehler");
       $query = "INSERT INTO anmeldung (name, schule, email, orttermin, gebiete)";
       $query .= "VALUES (";
       $query .= "'".$name."',";
       $query .= "'".$schule."',";
       $query .= "'".$email."',";
       $query .= "'".$orttermin."',";
       $query .= "'".$gebiete."'".")";
       mysql_db_query("ecdl", $query, $db) or die("bei sql Datenbankfehler");
       ?>        

         <HTML>
         <HEAD><TITLE>Auswertung</TITLE></HEAD>
         <BODY>
         <P><FONT face=Arial size=4>Bisherige Anmeldungen zu den ECDL-Prüfungen</FONT></P><br>
         
         <table border=1 cellspacing=1>
         <?
         $query = "SELECT name, schule, email, orttermin, gebiete FROM anmeldung"; 
         $rs = mysql_db_query("ecdl", $query, $db);
         while ($row = mysql_fetch_row($rs)) {
                 ?>
                     <TR>
                                   <TD><? echo $row[0] ?></TD>
                                   <TD><? echo $row[1] ?></TD>
                                   <TD><? echo $row[2] ?></TD>
                                   <TD><? echo $row[3] ?></TD>
                                   <TD><? echo $row[4] ?></TD>
                     </TR> 
              <? 
               } 
             ?>
         </table>
         
         <? mysql_close(); ?>
         <br><br>
         <a href="index.htm">ZURÜCK</a>
         </BODY>
</HTML>