function get_sub_info($id) { $sql = <<<EOD SELECT email_id, email_address, email_status, email_created, email_candles_zipcode, email_candles_city, email_candles_geonameid, email_candles_havdalah, email_optin_announce FROM hebcal_shabbat_email WHERE hebcal_shabbat_email.email_id = '{$id}' EOD; $mysqli = hebcal_open_mysqli_db(); $result = mysqli_query($mysqli, $sql) or die("Invalid query 1: " . mysqli_error($mysqli)); if (mysqli_num_rows($result) != 1) { return array(); } list($id, $address, $status, $created, $zip, $city, $geonameid, $havdalah, $optin_announce) = mysqli_fetch_row($result); $val = array("id" => $id, "status" => $status, "em" => $address, "m" => $havdalah, "upd" => $optin_announce, "zip" => $zip, "city" => $city, "geonameid" => $geonameid, "t" => $created); mysqli_free_result($result); return $val; }
function sql_unsub($em) { global $remoteAddr; $sql = <<<EOD UPDATE hebcal_shabbat_email SET email_status='unsubscribed',email_ip='{$remoteAddr}' WHERE email_address = '{$em}' EOD; $mysqli = hebcal_open_mysqli_db(); return mysqli_query($mysqli, $sql); }