主页 / 问题 / 945171
Accepted
JuniorCoder
Asked:2020-02-15 20:33:26 +0800 CST2020-02-15 20:33:26 +0800 CST

将数据库发送到邮件或以txt格式下载

  • 772

我试图通过单击按钮将数据库发送到邮件，但结果是收到了不正确的信！

$('button').click(function(){
  $.ajax({
            type: "POST",
            url: '../loadtxt.php',
            cache: false,
            success: function () {
                console.log('good');
 
             },
             error:function(respond){
                console.log('bad');
             }
        });
});

//PHP

<?php

 
  $connect_to_db = mysql_connect($db_host, $db_username, $db_password)
  or die("Could not connect: " . mysql_error());
 
  mysql_select_db($db_name, $connect_to_db)
  or die("Could not select DB: " . mysql_error());

$method = $_SERVER['REQUEST_METHOD'];
$c = true;

 $ss = mysql_query("SELECT * FROM commenduser");
 echo json_encode($ss);
while ($d = mysql_fetch_array($ss)){
//гененрируем письмо
$subject = "Коментарии"; 
$from = "xxx@gmail.com";
$to = "xxx@gmail.com";
$message ="Сообщения"; 

$boundary = "--".md5(uniqid(time())); 
$headers = "MIME-Version: 1.0;\r\n"; 
$headers .="Content-Type: multipart/mixed; boundary=\"$boundary\"\r\n"; 
$headers .= "From: info@site.ru ";
$headers .= "Reply-To: " . $from . "\r\n";
$headers .= "Content-type: text/html; charset=\"utf-8\";" . "\r\n";

$arr = mysql_fetch_array($ss);


foreach ( $arr as $key => $value ) {
    if ( $value != "" && $key != "project_name" && $key != "admin_email" && $key != "form_subject" ) {
        $multipart .= "
        " . ( ($c = !$c) ? '<tr>':'<tr style="background-color: #f8f8f8;">' ) . "
            <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>$key</b></td>
            <td style='padding: 10px; border: #e9e9e9 1px solid;'>$value</td>
        </tr>
        ";
    }
}

mail($to,$subject,$multipart,$headers);
 }
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<button>send</button>

结果，我在邮件中收到了这个：

 <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>id</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>5c63eba6bc584</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>1</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>0</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>type</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>0</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>2</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>test</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>name</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>test</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>3</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>test@mail.com</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>mail</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>test@mail.com</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>4</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>28834734</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>phone</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>28834734</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>5</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>5</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>rating</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>5</td>
    </tr>

    <tr>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>6</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>commend</td>
    </tr>

    <tr style="background-color: #f8f8f8;">
        <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>commend</b></td>
        <td style='padding: 10px; border: #e9e9e9 1px solid;'>commend</td>
    </tr>
php

1 个回答

  1. Best Answer

    这是基于您的伪代码，请检查它是否不起作用，因为它应该显示 print_r($arr); 并将代码翻译成mysqli_query（更好的pdo）

    $('button').click(function(){
  $.ajax({
            type: "POST",
            url: '../loadtxt.php',
            cache: false,
            success: function () {
                console.log('good');

             },
             error:function(respond){
                console.log('bad');
             }
        });
});


  $connect_to_db = mysql_connect($db_host, $db_username, $db_password)
  or die("Could not connect: " . mysql_error());

  mysql_select_db($db_name, $connect_to_db)
  or die("Could not select DB: " . mysql_error());

$method = $_SERVER['REQUEST_METHOD'];
$c = true;

 $ss = mysql_query("SELECT * FROM commenduser");
 echo json_encode($ss);

$multipart = '';
foreach ( $arr as $key => $value ) {
    if ( $value != "" && $key != "project_name" && $key != "admin_email" && $key != "form_subject" ) {
        $multipart .= "
        " . ( ($c = !$c) ? '<tr>':'<tr style="background-color: #f8f8f8;">' ) . "
            <td style='padding: 10px; border: #e9e9e9 1px solid;'><b>$key</b></td>
            <td style='padding: 10px; border: #e9e9e9 1px solid;'>$value</td>
        </tr>
        ";
    }
}

unset($key,$value);

//гененрируем письмо
$subject = "Коментарии"; 
$from = "xxx@gmail.com";
$to = "xxx@gmail.com";
$message ="Сообщения"; 

$boundary = "--".md5(uniqid(time())); 
$headers = "MIME-Version: 1.0;\r\n"; 
$headers .="Content-Type: multipart/mixed; boundary=\"$boundary\"\r\n"; 
$headers .= "From: info@site.ru ";
$headers .= "Reply-To: " . $from . "\r\n";
$headers .= "Content-type: text/html; charset=\"utf-8\";" . "\r\n";
//------------------

mail($to,$subject,$multipart,$headers);//тут отправит таблицу
    • 1

相关问题