如何使用数据库将这些值发送到邮件

Question

I am new in php. Not able to send these values to mail. I want to send this form value to mail and my database both. And is 2 mail possible? I use this form as popup on my website all right in form code it is sending values to database.

<?php
$servername = 'localhost';
$username = '********';
$password = '*****';
$dbname = '********';

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (isset($_REQUEST['mailsend']))
{
    $firstname  = $_POST['FirstName'];
    $email      = $_POST['email'];
    $number     = $_POST['number'];
    $query      = $_POST['query'];
    $subject = "A New Query";
    $message = "Name:" .$firstname. "
";
    $message .=" Email:" .$email.  "
" ; 
    $message .= "Mobile Number:" .$number. "
"; 
    $message .= "Query:" .$query. "
"; 
    print_r($message);
    $sql = "INSERT INTO query (name,email,phone,query) VALUES ('$firstname', '$email', '$number', '$query')";

    if ($conn->query($sql) === TRUE) {
        echo "<script>alert('Your Message Sent Sucessfully, We will contact you soon.');</script>";
    }
    else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}
?>

Answer 1

I have made some changes in your php. that will work for you enter your mail id there and you can two email id there put your both email.

 <?php

$servername = 'localhost';
$username = '********';
$password = '*****';
$dbname = '********';

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error){
    trigger_error("Connection failed: " . $conn->connect_error);
} 



if (isset($_REQUEST['mailsend'])){
    $firstname  = $_POST['FirstName'];
    $email      = $_POST['email'];
    $number     = $_POST['number'];
    $query      = $_POST['query'];


    $to = "[e-mail]";  //enter your mail id here
    $tosec = "[e-mail]";  //enter your second mail id here



  $subject = "A New Query";

 $message = "Name:" .$firstname. "
";
 $message .=" Email:" .$email.  "
" ; 
 $message .= "Mobile Number:" .$number. "
"; 
 $message .= "Query:" .$query. "
"; 


 //print_r($message);

    $return = mail($to,$subject,$message);
    $returnsec = mail($tosec,$subject,$message);        


if($retrun && $returnsec){  
    $sql = "INSERT INTO query SET 
      `name` = '{$firstname}',
      `email` = '{$email}',
      `phone` = '{$number}',
      `query` = '{$query}'";

    if ($conn->query($sql) === TRUE) {
        echo "<script>alert('Your Message Sent Sucessfully, We will contact you soon.');</script>";
    }else{
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
  }
 } ?>