<?php
$pdo = new PDO('mysql:host=xxx;dbname=xxxx', 'xxx', 'xxx');
$parameter = $_GET["parameter"];
$sql = "SELECT * FROM bw WHERE bw_code = $parameter";
foreach ($pdo->query($sql) as $row) {
}
$sql = "update bw set fa_vorname = fa_vorname, fa_nachame = fa_nachname where bw_code = :parameter";
$sth = $pdo->prepare($sql);
$sth->bindParam('parameter', $parameter, PDO::PARAM_INT);
$sth->execute();
$sql = "SELECT DISTINCT vorname FROM bw ORDER BY id";
$anrede = $row["fa_anrede"]; // Sollte Werte zwischen 0-2 annhemen => 0 = Frau, 1 = Mann, 3 = Generelle Ansprache
$arrP = Array(
Array(
'sex' => 'Frau',
'anrede' => 'Frau',
'grammer' => Array('',''),
'name' => ' '. $_POST["fa_vorname"] . ' ' . $_POST["fa_nachname"]
),
Array(
'sex' => 'Mann',
'anrede' => 'Herr',
'grammer' => Array('r','n'),
'name' => ' '. $_POST["fa_vorname"] . ' ' . $_POST["fa_nachname"]
),
Array(
'sex' => '',
'anrede' => 'Damen und Herren',
'grammer' => Array('',''),
'name' => ''
)
);
$ausgabe = $arrP[$anrede];
echo '
<div class="container">
<h3 class="seitentitel">Bewerbung ändern</h3>
<span style="float:right; margin-right:50px; margin-top:-30px;">
<a href="neue_mail.php" target="_self">
<button type="button" class="btn btn-primary btn-sm">Neue Bewerbung erfassen</button>
</a>
<a href="ausgabe.php" target="_self">
<button type="button" class="btn btn-success btn-sm">Alle Bewerbungen sehen</button>
</a>
</span>
<hr />
<form action="#" method="post">
<div class="row">
<div class="col-lg-6 col-xs-12">
<div class="form-group">
<label for="bw_als">Bewerbung als..:</label>
<select class="form-control" id="bw_als" name="bw_als">
<option value="'.$row["bw_als"].'">'.$row["bw_als"].'</option>
<option value="Webdesigner">Webdesigner</option>
<option value="Küchenplaner">Küchenplaner</option>
</select>
</div>
</div>
<div class="col-lg-6 col-xs-12">
<div class="form-group">
<label for="bw_referenz_nr">Referenz-Nr.:</label>
<input type="text" class="form-control" id="bw_referenz_nr" name="bw_referenz_nr" value="'.$row["bw_referenz_nr"].'">
</div>
</div>
<div class="col-lg-12 col-xs-12">
<div class="form-group">
<label for="bw_anschreiben">Anschreiben:</label>
<textarea class="form-control" rows="10" id="bw_anschreiben" name="bw_anschreiben" value="'.$row["bw_anschreiben"].'">'.$row["bw_anschreiben"].'</textarea>
</div>
</div>
<h3 class="seitentitel">Adresse ändern..</h3>
<hr />
<div class="col-lg-12 col-xs-12">
<div class="form-group">
<label for="fa_firmen_name">Firma:</label>
<input type="text" class="form-control" id="fa_firmen_name" name="fa_firmen_name" value="'.$row["fa_firmen_name"].'">
</div>
</div>
<div class="col-lg-4 col-xs-4">
<div class="form-group">
<label for="fa_anrede">Anrede:</label>
<select class="form-control" id="fa_anrede" name="fa_anrede">
<option value="'.$row["fa_anrede"].'">'.$ausgabe["anrede"].$ausgabe["grammer"][2].'</option>
<option value="0">Frau</option>
<option value="1">Herr</option>
<option value="2">Damen und Herren</option>
</select>
</div>
</div>
<div class="col-lg-6 col-xs-12">
</div>
</div>
<div class="row">
<div class="col-lg-6 col-xs-12">
<div class="form-group">
<label for="fa_vorname">Vorname:</label>
<input type="text" class="form-control" id="fa_vorname" name="fa_vorname" value="'.$row["fa_vorname"].'">
</div>
</div>
<div class="col-lg-6 col-xs-12">
<div class="form-group">
<label for="fa_nachname">Nachname:</label>
<input type="text" class="form-control" id="fa_nachname" name="fa_nachname" value="'.$row["fa_nachname"].'">
</div>
</div>
<div class="col-lg-10 col-xs-10">
<div class="form-group">
<label for="fa_strasse">Strasse:</label>
<input type="text" class="form-control" id="fa_strasse" name="fa_strasse" value="'.$row["fa_strasse"].'">
</div>
</div>
<div class="col-lg-2 col-xs-2">
<div class="form-group">
<label for="fa_hausnummer">Nr:</label>
<input type="text" class="form-control" id="fa_hausnummer" name="fa_hausnummer" value="'.$row["fa_hausnummer"].'">
</div>
</div>
<div class="col-lg-2 col-xs-2">
<div class="form-group">
<label for="fa_plz">PLZ:</label>
<input type="text" class="form-control" id="fa_plz" name="fa_plz" value="'.$row["fa_plz"].'">
</div>
</div>
<div class="col-lg-10 col-xs-10">
<div class="form-group">
<label for="fa_ort">Ort:</label>
<input type="text" class="form-control" id="fa_ort" name="fa_ort" value="'.$row["fa_ort"].'">
</div>
</div>
<div class="col-lg-10 col-xs-10">
<div class="form-group">
<label for="fa_telefon">Telefon:</label>
<input type="text" class="form-control" id="fa_telefon" name="fa_telefon" value="'.$row["fa_telefon"].'">
</div>
</div>
<div class="col-lg-10 col-xs-10">
<div class="form-group">
<label for="fa_email">E-Mail:</label>
<input type="text" class="form-control" id="fa_email" name="fa_email" value="'.$row["fa_email"].'">
</div>
</div>
<div class="col-lg-10 col-xs-10">
<div class="form-group">
<label for="fa_web">Webseite:</label>
<input type="text" class="form-control" id="fa_web" name="fa_web" value="'.$row["fa_web"].'">
</div>
</div>
</div>
<hr />
<input type="hidden" class="form-control" id="bw_code" name="bw_code" value="'.$row["bw_code"].'">
<button type="submit" class="btn btn-success btn-sm">Bewerbung ändern</button>
</form>
</div>';
$pdo = null;
?>