//$stm->bind_param("is",$time,$status);
$response = $stm->execute();
echo $query;
if ($response) {
echo "successfull prepared statement<br>";
} else {
echo "unsuccessful prepared statement<br>";
}
$result = $stm->get_result();
//var_dump($result->fetch_assoc());
$msg = '';
/* now you can fetch the results into an array - NICE */
while ($myrow = $result->fetch_assoc()) {
// use your $myrow array as you would with any other fetch
if ($myrow["email"] != 'a' && $myrow["email"] != 'az') {
$questions = get_questions($myrow["category"]);
$email_html = generate_email($questions, $myrow["category"], $myrow["email"]);
$status = send_questions($myrow["email"], $email_html, "Daily Subliminal Primes");
if ($status) {
//echo "email sent";
$msg .= "\nemail sent successfully to " . $myrow["email"] . " \t for category " . $myrow["category"] . "\t" . strtolower(date("c")) . "\n";
// echo "email sent successfully to ".$myrow["email"]." \t for category ".$myrow["category"]."\n";
} else {
$msg .= "\nemail unsuccessfully to " . $myrow["email"] . " \t for category " . $myrow["category"] . "\n";
}
}
}
echo $msg;
die;
//fwrite($out,$msg);
//fclose($out);
$response = $user->execute();
$result = $user->get_result();
$myrow = $result->fetch_assoc();
if ($response) {
if ($myrow["status"] != "verified") {
$body = generate_email_html($_POST["email"]);
$status = send_questions($_POST["email"], $body, "Subliminal Prime Verification");
if ($status) {
echo 1;
exit;
} else {
echo 0;
exit;
}
} else {
$body = generate_email_preference($_POST["email"]);
$status = send_questions($_POST["email"], $body, "Preference update");
if ($status) {
echo 1;
exit;
} else {
echo 0;
exit;
}
}
} else {
echo 0;
}
} else {
echo "no input found";
}
