邮件功能不起作用 [英] Mail function not working

问题描述

我需要更新我的桌子并将邮件发送到更新的行。

表格已成功更新但无法发送邮件。



我尝试了什么：

 <？php  
 session_start（）; 
 
 if（isset（$ _ GET ['  PID']））{ 
 $ id = $ _ GET ['  PID']; 
 
  / *  创建sql连接* /  
  $ link  = mysqli_connect（  localhost，  root，  mysql，  mydb）; 
 
  $ query  =   UPDATE分配t2，
（SELECT PID，pname，pemail，ph_no，体验
 FROM addpandit 
）t1 
 SET t2.PID = t1.PID，t2.pname = t1。 pname，t2.pemail = t1.pemail，t2.ph_no = 
 t1.ph_no，t2.experience = t1.experience 
 WHERE t2.PID =''AND t1.PID = $ id;< /跨度>;  / *  第一个查询：注意最后的2个分号！ * /  
  $ query 。=   SELECT * FROM assign WHERE PID = $ id;  / *  最后一次查询：注意结尾前的点数！ * /  
 
  if （mysqli_multi_query（$ link，$ query））{
 do {
  / *  存储第一个结果集* /  
  if （$ result = mysqli_store_result（$ link））{
  while （$ row = mysqli_fetch_array（$ result））{
 $ from = '  [e-mail]'; 
 $ subject =  已接受; 
 
 $ first_name = $ row ['  firstname']; 
 $ address = $ row ['  address1']; 
 $ email = $ row ['  email']; 
 $ phone = $ row ['  phone']; 
 $ puja = $ row ['  productinfo']; 
 $ date1 = $ row ['  date']; 
 $ time1 = $ row ['  time']; 
 $ amount = $ row ['  amount']; 
 $ pname = $ row ['  pname']; 
 $ pemail = $ row ['  pemail']; 
 $ ph_no = $ row ['  ph_no']; 
 $ exp = $ row ['  experience']; 
 
 $ msg =  亲爱的$ first_name您的订单已被接受。\ n请检查详细信息并付款\ n 
姓名：$ first_name \ n 
电子邮件：$ email \ n 
手机号码：$ phone \ n 
精选Puja：$ puja \ n 
日期：$ date1 \ n 
时间：$ time1 \ n 
金额：$ amount \感谢你; 
 
 $ sendmail = mail（$ email，$ subject，$ msg，'  From：' 。$ from）; 
 
 if（$ sendmail）{
  echo  ' 发送电子邮件至：'。 $电子邮件。 ' < br>'; 
} 
 其他 {
  echo  ' 电子邮件未发送'; 
} 
} 
 mysqli_free_result（$ result）; 
} 
}  while （mysqli_next_result（$ link））; 
} 
} 
 ？>  

解决方案

_GET [' PID']））{

id =

_GET [' PID'] ;

/ * 创建sql连接* /

I need to update my table and send mail to an updated row.
Table is updating successfully but cannot send mail.

What I have tried:

<?php 
session_start();

if(isset($_GET['PID'])) {
  $id=$_GET['PID'];

  /* create sql connection*/
  $link = mysqli_connect("localhost", "root", "mysql", "mydb");

  $query = "UPDATE assign t2,
  (   SELECT PID,pname,pemail,ph_no,experience 
      FROM addpandit 
  ) t1
  SET t2.PID = t1.PID,t2.pname = t1.pname,t2.pemail = t1.pemail,t2.ph_no = 
  t1.ph_no,t2.experience = t1.experience
  WHERE t2.PID='' AND t1.PID=$id;"; /*  first query : Notice the 2 semicolons at the end ! */
  $query .= "SELECT *FROM assign WHERE PID=$id"; /* last query : Notice the dot before = at the end ! */

  if (mysqli_multi_query($link, $query)) {
    do {
      /* store first result set */
      if ($result = mysqli_store_result($link)) {
        while ($row = mysqli_fetch_array($result)) {
          $from= '[e-mail]';
          $subject= "Accepted ";
  
          $first_name= $row['firstname'];
          $address= $row['address1'];
          $email= $row['email'];
          $phone= $row['phone'];
          $puja= $row['productinfo'];
          $date1= $row['date'];
          $time1= $row['time'];
          $amount= $row['amount'];
          $pname=$row['pname'];
          $pemail=$row['pemail'];
          $ph_no=$row['ph_no'];
          $exp=$row['experience'];	
	
          $msg= "Dear $first_name Your order has been accepted.\nPlease check the details and do payment\n 
            Name:$first_name\n
            Email:$email\n
            Mobile No:$phone\n
            Selected Puja:$puja\n
            Date:$date1\n
            Time:$time1\n
            Amount:$amount\nThank You";

          $sendmail=mail($email, $subject, $msg, 'From:' . $from);

          if($sendmail) {
            echo 'Email sent to: ' . $email. '<br>';
          }
          else {
            echo 'email not sent';
          }
        }
        mysqli_free_result($result);
      }   
    } while (mysqli_next_result($link));
  }
}
?>

解决方案

_GET['PID'])) {

id=

_GET['PID']; /* create sql connection*/

这篇关于邮件功能不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！