SQL数据库中的PHP数组

本文介绍了SQL数据库中的PHP数组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我试图做的是从已经建立的数据库中提取电子邮件地址，我需要能够根据给出的日期选择电子邮件地址。 然后我需要能够破坏电子邮件地址列表，这样我就可以一次向多个客户发送多封电子邮件。这就是我到目前为止。 ******************申请表格****** ********** < 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"] . "''";