$stmt->send_long_data(2, mysql_escape_string($_POST['data'])); if ($stmt->execute()) { echo 'true'; } else { die('Error : (' . $mysqli->errno . ') ' . $mysqli->error); } $survey_id = $mysqli->insert_id; $stmt->close(); $es = new email_sender(); $send_data = []; $emailList = str_replace('%2B', '+', htmlspecialchars($_POST['emails'])); $emails = explode(" ", $emailList); $query = "SELECT username, email FROM users WHERE id = ? LIMIT 1"; $statement = $mysqli->prepare($query); $statement->bind_param('s', $ownerID); $statement->execute(); $statement->bind_result($username, $email); $sender = $statement->fetch(); $statement->close(); $query = 'INSERT INTO links (survey_id, email, hash) VALUES (?, ?, ?)'; $stmt = $mysqli->prepare($query); for ($i = count($emails) - 1; $i >= 0; $i--) { $hash = hash('sha256', $emails[$i] . " " . $survey_id); $send_data[$i] = ['email_sender' => $sender[0] . $email, 'name_sender' => $sender[0] . $username, 'name_survey' => $surveyName, 'email_addressee' => $emails[$i], 'link_survey' => $hash]; $stmt->bind_param('iss', $survey_id, $emails[$i], $hash); if (!$stmt->execute()) { echo 'Error : (' . $mysqli->errno . ') ' . $mysqli->error; } } $es->send_email($send_data); $mysqli->close();