Der er lavet en database der hedder member, som har en tabel der hedder t_member med felterne memberid INT(4) UNSIGNED AUTO_INCREMENT PRIMARY KEY og membernavn VARCHAR(255)
mysql databasen er her sat til at køre lokalt
koden her skal gemmes som member.php3
<?
// adgangs koder til databasen
$db_name="member";
$db_user="";
$db_password="";
if (!mysql_pconnect("localhost", "$db_user", "$db_password")) {
print mysql_error()."\n";
die("Kunne ikke få forbindelse til databasen.\n");
}
mysql_select_db("$db_name") or die("Kunne ikke vælge databasen $db_name\n");
?>
<HTML>
<HEAD>
<TITLE>Member</TITLE>
</HEAD>
<?
if($adding_db) {
// Tilføjger nyt member til databasen
$result = mysql_query( "INSERT INTO t_member (membernavn) VALUES ('$membernavn')" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
}
if($delete_db) {
// Sletter member fra databasen
$result = mysql_query( "DELETE FROM t_member WHERE memberid = $memberid" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
$memberid = 1;
}
if($update_db) {
// Ændre member i databasen
$result = mysql_query( "UPDATE t_member SET membernavn = '$membernavn' WHERE memberid = $memberid" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
}
if($adding) {
print "<FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"adding_db\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$memberid\">\n";
print "<TABLE>\n";
print "<TR><TD>Member navn:</TD><TD><INPUT TYPE=Text NAME=\"membernavn\"></TD></TR>\n";
print "<TR><TD></TD><TD><INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Add!\"></TD></TR>\n";
print "</TABLE>\n";
print "</FORM>\n";
}
if($deleting) {
$result = mysql_query( "SELECT membernavn FROM t_member WHERE memberid = $memberid" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
$row = mysql_fetch_array($result);
print "Er du sikker på du vil slette denne post\n";
print "<TABLE>\n";
print "<TR><TD>member id:</TD><TD>memberid</TD></TR>\n";
print "<TR><TD>member navn:</TD><TD>$row[membernavn]</TD></TR>\n";
print "<TR><TD><FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"delete_db\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$memberid\">\n";
print "<INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Ja!\"></TD></FORM>\n";
print "<TD><FORM ACTION=\"member.php3\" METHOD=post>";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$memberid\">\n";
print "<INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Nej!\"></TD></FORM></TR>\n";
print "</TABLE>\n";
}
if($updating) {
$result = mysql_query( "SELECT membernavn FROM t_member WHERE memberid = $memberid" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
$row = mysql_fetch_array($result);
print "<FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"update_db\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$memberid\">\n";
print "<TABLE>\n";
print "<TR><TD>member navn:</TD><TD><INPUT TYPE=Text NAME=\"membernavn\" VALUE=\"$row[membernavn]\"></TD></TR>\n";
print "<TR><TD></TD><TD><INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Update!\"></TD></TR>\n";
print "</TABLE>\n";
print "</FORM>\n";
}
if (!($adding || $deleting || $updating)) {
$result=mysql_query( "SELECT * FROM t_member WHERE memberid = $memberid" ) or die( "Unable to connect to SQL server. Reason: ".mysql_error());
$row = mysql_fetch_array($result);
print "memberid: $row[memberid]<BR>\n";
print "membernavn: $row[membernavn]<BR>\n";
print "<FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"updating\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$row[memberid]\">\n";
print "<INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Update!\">\n";
print "</FORM>\n";
print "<FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"deleting\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$row[memberid]\">\n";
print "<INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Delete!\">\n";
print "</FORM>\n";
print "<FORM ACTION=\"member.php3\" METHOD=post>\n";
print "<INPUT TYPE=Hidden NAME=\"adding\" VALUE=\"yes\">\n";
print "<INPUT TYPE=Hidden NAME=\"memberid\" VALUE=\"$row[memberid]\">\n";
print "<INPUT TYPE=Submit NAME=\"Submit\" VALUE=\"Add!\">\n";
print "</FORM>\n";
mysql_close();
}
?>
</BODY>
</HTML>
Slettet bruger
Ny bruger
Nybegynder
Opret
Preview
