Connection failed: " . mysqli_connect_error() . "");
}
// Prepare SQL query using prepared statements to prevent SQL injection
$query = "INSERT INTO $table (exec,name,mail,st,pr,fo,pe,re,org)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = mysqli_prepare($conn, $query);
if ($stmt) {
// Bind parameters
mysqli_stmt_bind_param($stmt, 'sssssssss', $date, $uname, $umail, $ut1, $ut2, $ut3, $ut4, $ut5, $ut6);
// Execute statement
if (mysqli_stmt_execute($stmt)) {
echo "Data inserted successfully
";
$url = "http://www.selfmiracle.com/downloadysm6aiy40p6.html";
header ("Location: $url");
$message="$uname the link to download session 6 of Your Self Miracle and complete the actions to receive session 7 is:\n\nhttp://www.selfmiracle.com/downloadysm6aiy40p6.html\n\n\nRegards\n\n\n\nSledge\nhttp://www.selfmiracle.com";
if(mail($umail,"Your Self Miracle Session 6",$message,"From: ysm@selfmiracle.com")) {
echo "Thanks for your comments.";
}else{
echo "There was a problem sending the mail. Please check that you filled in the form correctly.";
}
} else {
echo "Error inserting data: " . mysqli_stmt_error($stmt) . "
";
}
// Close statement
mysqli_stmt_close($stmt);
} else {
echo "Failed to prepare statement: " . mysqli_error($conn) . "
";
}
// Close connection
mysqli_close($conn);
?>