SQL数据库中的PHP数组 [英] PHP Array from SQL Database
问题描述
我试图做的是从已经建立的数据库中提取电子邮件地址,我需要能够根据给出的日期选择电子邮件地址。
然后我需要能够破坏电子邮件地址列表,这样我就可以一次向多个客户发送多封电子邮件。这就是我到目前为止。
******************申请表格****** **********
< select name =" emailto"大小= QUOT; 15" multiple id =" emailto" style =" color:#000000; font-size:8pt; font-family:Verdana" tabindex ="">
<?php
$ users_sql =" SELECT * FROM ******* WHERE site_tag = ''*****''和date_received BETWEEN''" 。 $ _POST [" startDate"]。 "''''''' 。 $ _POST [" endDate"]。 "'''";
$ users_result = @mysql_query($ users_sql);
while($ users = @mysql_fetch_array($ users_result))
{
echo"< option" ;;
echo">" 。 $ users [" email"];
echo",< / option> \ n";
}
?>
< / select>
**************************
************************** php code ************** *******
if($ _ POST [''email_now''])
{
$ to = $ _POST [''emailto''];
$ from =" ***************" ;;
$ subject =" *******************" ;;
$ headers。=''''***************"。$ eol;
$ headers。=''**************''。$ eol;
$ headers。=''Return-Path:''。$ eol; //这两个设置回复地址
$ headers。="消息ID:<"。$ subject。">"。$ eol;
// $ headers。="消息ID:<"。$ now。 TheSystem @" $ _ SERVER [ SERVER_NAME]"。>" $ EOL;
$ headers。=" X-Mailer:PHP v" .phpversion()。$ eol; //这两个有助于避免垃圾邮件过滤器
#Bounding用于标记拆分&多字节标题
$ mime_boundary = md5(time());
$ headers。=''MIME-Version:1.0''。$ eol;
$ headers。=''Content-Type:text / html; 。字符集= ISO-8859-1’ $ EOL;
$ body = $ _POST ['''编辑''];
// EOF;
$ success = mail($ to,$ subject,$ body,$ headers);
if($ success)
{
$ msg ="" ;;
mass_email($ msg);
}
else
{
$ msg ="。" ;;
mass_email($ msg);
}
}
但是什么我需要它做的是当我选择或从该表单中选择的任何人并单击电子邮件时,它会通过电子邮件发送所有这些表单。并且我无法弄清楚我的生活是做错了什么。
What im attempting to do is pull email address from a database already built, i need to be able to select the email address depending on the date they are given.
Then i need to be able to Implode the list of email address so i can send out multiple emails to multiple Clients at one time. This is what i have so far.
******************Form Application****************
<select name="emailto" size="15" multiple id="emailto" style="color: #000000; font-size: 8pt; font-family: Verdana" tabindex="">
<?php
$users_sql = "SELECT * FROM ******* WHERE site_tag = ''*****'' AND date_received BETWEEN ''" . $_POST["startDate"] . "'' AND ''" . $_POST["endDate"] . "''";
$users_result = @mysql_query($users_sql);
while($users = @mysql_fetch_array($users_result))
{
echo "<option";
echo">" . $users["email"] ;
echo",</option>\n";
}
?>
</select>
**************************
**************************php code*********************
if($_POST[''email_now''])
{
$to = $_POST[''emailto''];
$from = "***************";
$subject = "*******************";
$headers .= ''''***************".$eol;
$headers .= ''**************''.$eol;
$headers .= ''Return-Path: ''.$eol; // these two to set reply address
$headers .= "Message-ID: <".$subject.">".$eol;
//$headers .= "Message-ID: <".$now." TheSystem@".$_SERVER[''SERVER_NAME''].">".$eol;
$headers .= "X-Mailer: PHP v".phpversion().$eol; // These two to help avoid spam-filters
# Boundry for marking the split & Multitype Headers
$mime_boundary=md5(time());
$headers .= ''MIME-Version: 1.0''.$eol;
$headers .= ''Content-Type: text/html; charset=iso-8859-1''.$eol;
$body= $_POST[''edited''];
//EOF;
$success = mail($to, $subject, $body, $headers);
if ($success)
{
$msg="";
mass_email($msg);
}
else
{
$msg=".";
mass_email($msg);
}
}
But what i need it to do is when i select or whoever i select from that form and click Email, it emails all of them. and i cant figure out for the life of me what im doing wrong.
推荐答案
users_sql =" SELECT * FROM ******* WHERE site_tag =' '*****''和date_received BETWEEN''" 。
users_sql = "SELECT * FROM ******* WHERE site_tag = ''*****'' AND date_received BETWEEN ''" .
_POST [" startDate"]。 "''''''' 。
_POST["startDate"] . "'' AND ''" .
_POST [" endDate"]。 "''" ;;
_POST["endDate"] . "''";
这篇关于SQL数据库中的PHP数组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!