og addinfo filen
<?php
if (($_POST[op] != "add") || ($_GET[id] != "")) {
//har ikke set formular - så vis den
$display_block = "<h1>Tilføj data til eksisterende kunde </h1>
<form method=\"post\" action=\"$_SERVER[PHP_SELF]\">";
if ($_GET[id] != "") {
// etabler forbindelse til databasen
$conn = mysql_connect("localhost", "xxxx", "xxxxx") or die(mysql_error());
mysql_select_db("xxxxxxx",$conn) or die(mysql_error());
//hent for- og efternavn
$get_names = "select concat_ws(', ', f_name, l_name) as
display_name from master_name where id = $_GET[id]";
$get_names_res = mysql_query($get_names)
or die(mysql_error());
$get_names_res = mysql_query($get_names) or die(mysql_error()."<br>SELECT f_name, l_names from master_name: ".$get_names);
if(mysql_num_rows($get_names_res) == 1) {
$display_name = mysql_result($get_names_res,0, 'display_name');
}
}
if ($display_name != "") {
$display_block .= "<h2>Tilføjelse til
<strong>$display_name</strong>:</h2>";
} else {
$display_block .= "<h2>
<p><strong>For-/efternavn:</strong><br>
<input type=\"test\" name=\"f_name\" size=30 maxlength=75>
<input type=\"test\" name=\"l_name\" size=30 maxlength=75></h2>";
}
$display_block .= "<h2><strong>Adresse:</strong></h2>
<h2><input type=\"text\" name=\"address\" size=30 maxlength=63></h2>
<h2><strong>Postnr. og by:</strong></h2>
<h2><input type=\"text\" name=\"postnr\" size=4 maxlength=6>
<input type=\"text\" name=\"postby\" size=30 maxlength=25></h2>
<h2><strong>Telefonnr.:</strong><br>
<input type=\"text\" name=\"tel_number\" size=8
maxlenght=25>
<h2><strong>Faxnr.:</strong><br>
<input type=\"text\" name=\"fax_number\" size=8
maxlenght=25>
<h2><strong>Email-adresse:</strong><br>
<input type=\"text\" name=\"email\" size=30
maxlenght=150>
<h2><strong>CVRnr.:</strong><br>
<input type=\"text\" name=\"cvr_number\" size=8
maxlenght=25></h2>
<input type=\"hidden\" name=\"op\" value=\"add\">
<input type=\"hidden\" name=\"id\" value=\"$_GET[id]\">
<p><input type=\"submit\" name=\"submit\"
value=\"Tilføj kunde\"></p>
</form>";
} else if ($_POST[op] == "add") {
//føj til tabeller - tjek krævede felter
if ((($_POST[f_name] == "") || ($_POST[l_name] == "")) &&
($_POST[id] == "")) {
header("Location: addentry.php");
exit;
}
// etabler forbindelse til databasen
$conn = mysql_connect("localhost", "xxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("xxxxxx",$conn) or die(mysql_error());
if ($_POST[id] == "") {
// føj til master_name-tabellen
$add_master = "insert into master_name values ('', '$_POST[f_name]', '$_POST[l_name]')";
mysql_query($add_master) or die(mysql_error());
// hent master_id til brug i andre tabeller
$id = mysql_insert_id();
} else {
$id = $_POST[id];
}
if (($_POST[address]) || ($_POST[postnr])) {
//evt. føj til address-tabellen
$add_address = "insert into address values ('', $id, '$_POST[address]', '$_POST[postnr]', '$_POST[postby]') ";
mysql_query($add_address) or die(mysql_error());
}
if ($_POST[tel_number]) {
//evt. føj til telephone-tabellen
$add_tel = "insert into tel_number values ('', $id, '$_POST[tel_number]')";
mysql_query($add_tel) or die(mysql_error());
}
if ($_POST[fax_number]) {
//evt. føj til fax-tabellen
$add_fax = "insert into fax_number values ('', $id, '$_POST[fax_number]')";
mysql_query($add_fax) or die(mysql_error());
}
if ($_POST[email]) {
//evt. føj til email-tabellen
$add_email = "insert into email values ('', $id, '$_POST[email]')";
mysql_query($add_email) or die(mysql_error());
}
if ($_POST[cvr_number]) {
//evt. føj til cvr-tabellen
$add_cvr = "insert into cvr values ('', $id, '$_POST[cvr_number]')";
mysql_query($add_cvr) or die(mysql_error());
}
$display_block = "<h1>Statusmelding for tilføjning af data ved eksisterende kunde</h1>
<h2>Der er tilføjet data vedr. <strong>$get_names</strong></h2>
<h2><a href=\"addinfo.php?master_id=$_POST[sel_id]\">tilføj flere data til samme kunde</a></h2>
<h2><a href=\"adressemenu.htm\">tilbage til menu</a></h2>
<h2><a href=\"selentry.php\">få vist kundens data fra kundedatabasen</a></h2>";
}
?>
<html>
<head>
<title>Add an entry</title>
<link href="ve style.css" rel="stylesheet">
</head>
<body>
<? print $display_block; ?>
</body></html>
Ny bruger
Nybegynder
Opret
Preview
