function queue_job_email($conn, $user_email, $email_body)
{
$html_body = sanitize_fieldname($conn, $email_body['html_body']);
$text_body = sanitize_fieldname($conn, $email_body['text_body']);
$subject = sanitize_fieldname($conn, $email_body['subject']);
$sql = "INSERT INTO email_store (email,html_body,text_body,subject) VALUES('{$user_email}','{$html_body}','{$text_body}','{$subject}')";
return mysqli_query($conn, $sql);
}
<?php
ini_set('display_errors', 1);
require_once "job_fun.php";
require_once "email_function.php";
$jobid = $_GET['jobid'];
$key = create_unique_key();
$link = job_edit_link($key);
$email = "*****@*****.**";
//$email_body = edit_job($link);
$conn = connect_db();
if (mysqli_connect_errno($conn)) {
$msg = "database_connect error";
json_print($msg, 'error');
exit;
}
// $email_status = queue_job_email($conn, $email, $email_body);
// if ( ! $email_status ) {
// $msg = "edit_job_error";
// json_print($msg, 'error');
// exit();
// }
$jobid = sanitize_fieldname($conn, $jobid);
$result = job_details($conn, $jobid);
if (count($result) < 1) {
$msg = "job_empty_error";
json_print($msg, 'error');
exit;
}
json_print($result, "success");
