PHPize Online / SQLize Online  /  SQLtest Online

<?php require_once 'login.php'; mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); // Create connection $conn = new mysqli($servername, $username, $password, $dbname); mysqli_autocommit($conn, false); $sql = $conn->prepare("INSERT IGNORE INTO user (`firstName`, `lastName`, `age`, `email`) VALUES (?, ?, ?, ?)"); $sql->bind_param("ssis", $firstname, $lastname, $age, $email); $firstname = $_GET['firstName']; $lastname = $_GET['lastName']; $age = !isset($_GET['age']) ? '0' : $_GET['age']; $email = $_GET['emailAddress']; $sql->execute(); echo 'SQL ran successfully'; $feedbackTypeID = $_GET['feedbackTypeID']; $userResponse = $_GET['userResponse']; $sql2 = $conn->prepare("INSERT INTO feedback (`userID`, `feedbackTypeID`, `userResponse`) VALUES (?, ?, ?)"); $sql2->bind_param("iis", $userID, $feedbackTypeID, $userResponse); $sql2->execute(); mysqli_commit($conn);