29 lines
922 B
PHP
29 lines
922 B
PHP
<?php
|
|
if ("2" == $_POST['step'])
|
|
{
|
|
$sql = "SELECT Betreff, Text1 FROM " . PREFIX . "_Texte WHERE Name = \"Schriftverkehr\";";
|
|
$result = $db->query($sql);
|
|
$nt = $result->fetch_assoc();
|
|
$sql = 'INSERT INTO ' . PREFIX . '_Schrift (Jahr, ID, Kontakt_ID, Admin_ID, Betreff, Text, Datum) VALUES (YEAR(CURDATE()), NULL, "' . $_POST['Kontakt_ID'] . '", "' . $_POST['Admin_ID'] . '", "' . $nt['Betreff'] . '", "' . $nt['Text1'] . '", CURDATE())';
|
|
$stmt = $db->prepare($sql);
|
|
if (!$stmt)
|
|
{
|
|
die ('Datensatz konnte nicht gespeichert werden: ' . $db->error);
|
|
}
|
|
if (!$stmt->execute())
|
|
{
|
|
die ('Datensatz konnte nicht gespeichert werden: ' . $stmt->error);
|
|
}
|
|
$sql = 'SELECT last_insert_id() AS last';
|
|
$result = $db->query($sql);
|
|
$nt = $result->fetch_assoc();
|
|
$date = getdate();
|
|
unset($_POST);
|
|
$Jahr = $date['year'];
|
|
$ID = $nt['last'];
|
|
include __DIR__ . "/schrift_edit.php";
|
|
}
|
|
else
|
|
{
|
|
include __DIR__ . "/add.php";
|
|
} |