<?php
//include "header.php";
include "config.php";
include "opendb.php";
include "functions.php";
function validate($firmaNaam, $firmaPostcode) {
$error = 0;
if($firmaNaam == "") {
echo('<img alt="" src="images/error.gif" width="19" height="19" alt="error" /> Firmanaam is een verplicht veld. <br />');
$error = 1;
}
if($firmaPostcode != "" AND !ctype_digit($firmaPostcode) AND $firmaPostcode != "NULL") {
echo('<img alt="" src="images/error.gif" width="19" height="19" alt="error" /> Postcode mag alleen cijfers bevatten. <br />');
$error = 1;
}
if($error == 1) {
return 0;
}
else {
return 1;
}
}
if(isset($_POST["BtnFirma"])) {
$firmaNaam = cleanstring($_POST["txtFirmaNaam"]);
$firmaStraat = cleanstring($_POST["txtFirmaStraat"]);
$firmaHuisNummer = cleanstring($_POST["txtFirmaHuisnummer"]);
//$firmaPostcode = $_POST["txtFirmaPostcode"];
if($_POST["txtFirmaPostcode"] == "") {
$firmaPostcode = "NULL";
}
else {
$firmaPostcode = $_POST["txtFirmaPostcode"];
}
$firmaGemeente = cleanstring($_POST["txtFirmaGemeente"]);
$firmaTel = cleanstring($_POST["txtFirmaTel"]);
$firmaFax = cleanstring($_POST["txtFirmaFax"]);
$firmaBTW = cleanstring($_POST["txtFirmaBTW"]);
$firmaBIV = cleanstring($_POST["txtFirmaBIV"]);
$firmaEmail = cleanstring($_POST["txtFirmaEmail"]);
$firmaWebsite = cleanstring($_POST["txtFirmaWebsite"]);
$firmaLogo = cleanstring($_POST["txtFirmaLogo"]);
if(validate($firmaNaam, $firmaPostcode)) {
$update = "UPDATE FIRMA SET
FIsOmschr = '$firmaNaam',
FIsStraat = '$firmaStraat',
FIsHuisnummer = '$firmaHuisNummer',
FInPostcode = $firmaPostcode,
FIsGemeente = '$firmaGemeente',
FIsTel = '$firmaTel',
FIsFax = '$firmaFax',
FIsBTW = '$firmaBTW',
FIsBIV = '$firmaBIV',
FIsEmail = '$firmaEmail',
FIsWebsite = '$firmaWebsite',
FIsLogo = '$firmaLogo'
WHERE FInun = " . $_POST["txtFirmaUN"];
$result = mysql_query($update);
if($result) {
/* Redirect browser */
header("Location: firma_overview.php");
//echo('<meta http-equiv="refresh" content="0;url=firma_overview.php" />');
/* Make sure that code below does not get executed when we redirect. */
//exit;
}
else {
echo("Error on update: " . mysql_error());
}
}
}
else {
include "header.php";
$un = $_GET["un"];
$select = mysql_query(
"SELECT FInUN, FIsOmschr, FIsStraat, FIsHuisnummer, FInPostcode, FIsGemeente, FIsTel, FIsFax, FIsBTW, FIsBIV, FIsEmail,
FIsWebsite, FIsLogo
FROM FIRMA
WHERE FInUN=$un");
$row = mysql_fetch_array($select);
//############################################ FORM ###########################################################
echo('<form method="post" action="firma.php">');
echo('<input name="txtFirmaUN" id="txtFirmaUN" type="hidden" value="' . $row["FInUN"] . '" />');
echo('<p>');
echo('<label id="lblFirmaNaam" for="txtFirmaNaam">Naam</label>');
echo('<input name="txtFirmaNaam" id="txtFirmaNaam" type="text" value="' . $row["FIsOmschr"] . '" tabindex="1" size="50" maxlength="100" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaStraat" for="txtFirmaStraat">Straat</label>');
echo('<input name="txtFirmaStraat" id="txtFirmaStraat" type="text" value="' . $row["FIsStraat"] . '" tabindex="2" size="50" maxlength="100" />');
echo('<label id="lblFirmaHuisnummer" for="txtFirmaHuisnummer">Nr</label>');
echo('<input name="txtFirmaHuisnummer" id="txtFirmaHuisnummer" type="text" value="' . $row["FIsHuisnummer"] . '" tabindex="3" size="4" maxlength="20" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaPostcode" for="txtFirmaPostcode">Postcode</label>');
echo('<input name="txtFirmaPostcode" id="txtFirmaPostcode" type="text" value="' . $row["FInPostcode"] . '" tabindex="4" size="8" maxlength="20" />');
echo('<label id="lblFirmaGemeente" for="txtFirmaGemeente">Gemeente</label>');
echo('<input name="txtFirmaGemeente" id="txtFirmaGemeente" type="text" value="' . $row["FIsGemeente"] . '" tabindex="5" size="40" maxlength="100" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaTel" for="txtFirmaTel">Tel</label>');
echo('<input name="txtFirmaTel" id="txtFirmaTel" type="telephone" value="' . $row["FIsTel"] . '" tabindex="6" size="25" maxlength="50"/>');
echo('<label id="lblFirmaFax" for="txtFirmaFax">Fax</label>');
echo('<input name="txtFirmaFax" id="txtFirmaFax" type="telephone" value="' . $row["FIsFax"] . '" tabindex="7" size="25" maxlength="50" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaBTW" for="txtFirmaBTW">BTW</label>');
echo('<input name="txtFirmaBTW" id="txtFirmaBTW" type="text" value="' . $row["FIsBTW"] . '" tabindex="8" size="20" maxlength="30" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaBIV" for="txtFirmaBIV">BIV</label>');
echo('<input name="txtFirmaBIV" id="txtFirmaBIV" type="text" value="' . $row["FIsBIV"] . '" tabindex="9" size="20" maxlength="30" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaEmail" for="txtFirmaEmail">Email</label>');
echo('<input name="txtFirmaEmail" id="txtFirmaEmail" type="email" value="' . $row["FIsEmail"] . '" tabindex="10" size="50" maxlength="100"/>');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaWebsite" for="txtFirmaWebsite">Website</label>');
echo('<input name="txtFirmaWebsite" id="txtFirmaWebsite" type="url" value="' . $row["FIsWebsite"] . '" tabindex="11" size="50" maxlength="100" />');
echo('</p>');
echo('<p>');
echo('<label id="lblFirmaLogo" for="txtFirmaLogo">Logo</label>');
echo('<input name="txtFirmaLogo" id="txtFirmaLogo" type="text" value="' . $row["FIsLogo"] . '" tabindex="12" size="70" maxlength="250" />');
echo('</p>');
echo('<br />');
echo('<p>');
echo('<input name="BtnFirma" type="submit" value="Opslaan" tabindex="13"/>');
echo('</p>');
//########################################## END FORM #########################################################
}
//include "closedb.php";
include "footer.php";
?>