Online PHP editor | refs for lh8io

<?php if (isset($_POST['submit']) && isset($_POST['titel']) && isset($_POST['trainer']) && isset($_POST['dauer']) && $_POST['titel'] != '' && $_POST['trainer'] != '' && (int)$_POST['dauer'] > 0) { try { $db = new MySQLi('localhost', 'root', '', 'php'); echo 'Verbindung offen.<br />'; $sql = 'INSERT INTO trainings (titel, trainer, dauer) VALUES (?, ?, ?)'; $kommando = $db->prepare($sql); $kommando->bind_param('ssi', $_POST['titel'], $_POST['trainer'], $dauer); $dauer = (int)$_POST['dauer']; $kommando->execute(); echo 'SQL geschickt. <br />'; echo $kommando->affected_rows . ' Zeilen betroffen. <br />'; $db->close(); echo 'Verbindung zu.<br />'; } catch (Exception $e) { echo 'Fehler: ' . htmlspecialchars($e->getMessage()); } } ?>