Hallo Experten,
ich versuche hier gerade einen Datensatz aus einem Formular auszulesen, um ihn später dann per AJAX weiter zu verarbeiten.
Einschlägige Seiten schlagen hier vor, alle Formulardaten mit der Funktion
oder
in eine Variable zu schreiben und diese dann im AJAX zu übergeben.
Bei mir bleibt die Variable aber leer, der Befehl liefert keine Inhalte.
Hier mein Formular:
PHP
<div class="container">
<form id="singleSQLedit" method="post" style="text-align:right;">
<div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_bez" class="col-sm-2 col-form-label">Bezeichnung: </label>
<div class="col-sm-4">
<input type="text" class="form-control" id="fz_bez" value="<?php echo $row['Bezeichnung']; ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_ruf" class="col-sm-2 col-form-label">Funkrufname: </label>
<div class="col-sm-4">
<input type="text" class="form-control" id="fz_ruf" value="<?php echo $row['Funkrufname']; ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_ruf" class="col-sm-2 col-form-label">Anhänger: </label>
<div class="col-sm-4">
<input type="text" class="form-control" id="fz_anh" value="<?php echo $row['Anhaenger']; ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_ruf" class="col-sm-2 col-form-label">Abrollbehälter: </label>
<div class="col-sm-4">
<input type="text" class="form-control" id="fz_arb" value="<?php echo $row['Abrollbehaelter']; ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_ort" class="col-sm-2 col-form-label">Herkunft: </label>
<div class="col-sm-4">
<input type="text" class="form-control" id="fz_ort" value="<?php echo $row['Standort']; ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_anz" class="col-sm-2 col-form-label">Ankunftzeit: </label>
<div class="col-sm-4">
<input type="time" class="form-control" id="fz_anz" value="<?php echo substr($row['Ankunftzeit'],0,5); ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_block" class="col-sm-2 col-form-label">Position (Block):</label>
<div class="col-sm-4">
<select id="fz_block" class="form-control">
<?php
echo " <option" . ((!isset($row['Block'])) ? " selected" : "") . "> </option>\n";
for($i=0; $i <= 20; $i++) {
echo " <option" . (($row['Block'] == $BlockBS[$i]) ? " selected" : "") . ">$BlockBS[$i]</option>\n";
}
?>
</select>
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_row" class="col-sm-2 col-form-label">Position (Reihe): </label>
<div class="col-sm-4">
<select id="fz_row" class="form-control">
<?php
echo " <option" . ((!isset($row['Reihe'])) ? " selected" : "") . "> </option>";
echo " <option" . (($row['Reihe'] == "Links") ? " selected" : "") . ">Links</option>";
echo " <option" . (($row['Reihe'] == "Mitte")? " selected" : "") . ">Mitte</option>";
echo " <option" . (($row['Reihe'] == "Rechts") ? " selected" : "") . ">Rechts</option>";
?>
</select>
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<label for="fz_pos" class="col-sm-2 col-form-label">Position (Folge): </label>
<div class="col-sm-4">
<input type="number" min="1" step="1" class="form-control" id="fz_anz" value="<?php echo substr($row['Position'],0,5); ?>">
</div>
</div><div class="row">
<div class="col-sm-3 col-xs-hidden"></div>
<div class="col-sm-2"><a tabindex="0" class="btn btn-secondary sqlKnopf" data-action="edit">Daten ändern</a></div>
<div class="col-sm-2"><a tabindex="0" class="btn btn-secondary sqlKnopf" data-action="new">als neues Fahrzeug speichern</a></div>
</div>
</form>
</div>
Alles anzeigen
...und hier das Script zum Auslesen der Formularinhalte:
Code
<script>
$(document).ready(function() {
$(".sqlKnopf").click(function() {
var daten = $("#singleSQLedit").serialize();
$("#message").text(daten);
$("#message").css('display', 'block');
setTimeout(function() {
$("#message").css('display', 'none');
}, 5000);
$.ajax({
type: 'POST',
url: "./lib/sql_helper.php",
data : daten,
success: function(response) {
$("#message").text(response);
$("#message").css('display', 'block');
setTimeout(function() {
$("#message").css('display', 'none');
}, 5000);
}
});
});
});
</script>
Alles anzeigen
Kann mir jemand erklären, was ich falsch mache?