各位大大請教一個問題:
目前我有做一個客戶資料管理程式,而在這支程式的資料表中我有規劃了用戶的信箱(email)租書到期日(booklimdate)與租片到期日(videolimdate),我想要讓租書到期日與租片到期日前30/15/7/3/1天寄出一封到期通知信給用戶的信箱,【
內容比如說:敬愛的顧客xx您好!您向本店租賃的書籍將於$booklimdate到期,敬請注意還書日期,謝謝!! 】請問我該怎麼做呢?
以下是我目前寫的程式:敬請大大不吝惠予協助~感激不盡
//************************************************* bookstore_edit *********************************************************
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "bookstore_edit")) {
$updateSQL = sprintf("UPDATE bookstore SET name=%s, tel=%s, fax=%s, city=%s, adr=%s, email=%s, mobile=%s, bookdate=%s, booklimdate=%s, videodate=%s,videolimdate=%s, flag=%s WHERE id=%s",
GetSQLValueString($_POST['company'], "text"),
GetSQLValueString($_POST['tel'], "text"),
GetSQLValueString($_POST['fax'], "text"),
GetSQLValueString($_POST['city'], "text"),
GetSQLValueString($_POST['adr'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['mobile'], "text"),
GetSQLValueString($_POST['bookdate'], "text"),
GetSQLValueString($_POST['booklimdate'], "text"),
GetSQLValueString($_POST['videodate'], "text"),
GetSQLValueString($_POST['videolimdate'], "text"),
GetSQLValueString($_POST['flag'], "int"),
GetSQLValueString($_POST['id'], "int"));
mysql_select_db($database_connect, $connect);
$Result1 = mysql_query($updateSQL, $connect) or die(mysql_error());
echo "<script>";
echo "alert(\"資料更新成功!!\");";
echo "location.href='bookstore_list.php'";
echo "</script>";
}
