 |
|
เนื่องจากต้องการสร้างฟอร์ม ส่งค่าจาก drop down list ไปยัง email แต่ไม่ต้องแสดงผลในฟอร์ม ต้องเขียนอย่างไรครับ พยายามหาแนวทางมาหลายวันยังงงอยู่ โดยขออนุญาตแนบรูปและ code ตามนี้ครับ
DB Code
Code (SQL)
-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 26, 2020 at 08:47 AM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.1.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `autolist2`
--
-- --------------------------------------------------------
--
-- Table structure for table `bu`
--
CREATE TABLE `bu` (
`CustomerID` varchar(20) NOT NULL,
`Email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `bu`
--
INSERT INTO `bu` (`CustomerID`, `Email`) VALUES
('TX01', 'Japan'),
('TX02', 'Chaina'),
('TX03', 'Thailand'),
('TX04', 'Lao'),
('TX05', 'Taiwan');
-- --------------------------------------------------------
--
-- Table structure for table `customer`
--
CREATE TABLE `customer` (
`CustomerID` varchar(25) NOT NULL,
`Email` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` (`CustomerID`, `Email`) VALUES
('C001', '[email protected]'),
('C002', '[email protected]'),
('C003', '[email protected]'),
('C004', '[email protected]');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `bu`
--
ALTER TABLE `bu`
ADD PRIMARY KEY (`CustomerID`);
--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
ADD PRIMARY KEY (`CustomerID`);
COMMIT;
และ Code หน้า ฟอร์มที่ทำการส่ง
Code (PHP)
<html>
<head>
<title>Test list BU send mail</title>
</head>
<?php
$conn=mysqli_connect("localhost","root"," ","autolist2");
?>
<script language="JavaScript">
function resutName(CusID)
{
switch(CusID)
{
<?php
$strSQL = "SELECT * FROM customer ORDER BY CustomerID ASC";
$objQuery = mysqli_query($conn,$strSQL);
while($objResult = mysqli_fetch_array($objQuery))
{
?>
case "<?php echo $objResult["CustomerID"];?>":
frmMain.txtName.value = "<?php echo $objResult["Email"];?>";
break;
<?php
}
?>
default:
frmMain.txtName.value = "";
}
}
function resutbu(CusID)
{
switch(CusID)
{
<?php
$strSQL = "SELECT * FROM bu ORDER BY CustomerID ASC";
$objQuery = mysqli_query($conn,$strSQL);
while($objResult = mysqli_fetch_array($objQuery))
{
?>
case "<?php echo $objResult["CustomerID"];?>":
frmMain.txtName1.value = "<?php echo $objResult["Email"];?>";
break;
<?php
}
?>
default:
frmMain.txtName1.value = "";
}
}
</script>
<body>
<form action="sendex2.php" method="post" name="frmMain">
List Menu
<div class="wrap-input100 input100-select">
<span class="label-input100">Engineer input</span>
<select name="txtUserIDno" OnChange="resutName(this.value);">
<option value=""><-- Engineer inputs --></option>
<?php
$strSQL = "SELECT * FROM customer ORDER BY CustomerID ASC";
$objQuery = mysqli_query($conn,$strSQL);
while($objResult = mysqli_fetch_array($objQuery))
{
?>
<option value="<?php echo $objResult["CustomerID"];?>"><?php echo $objResult["CustomerID"];?></option>
<?php
}
?>
</select>
<!-- <input name="txtName" type="text" value=""> -->
<span class="focus-input100"></span>
</div>
<div class="wrap-input100 input100-select">
<span class="label-input100">BU input</span>
<select name="txtBU" OnChange="resutbu(this.value);">
<option value=""><-- BU input --></option>
<?php
$strSQL = "SELECT * FROM bu ORDER BY CustomerID ASC";
$objQuery = mysqli_query($conn,$strSQL);
while($objResult = mysqli_fetch_array($objQuery))
{
?>
<option value="<?php echo $objResult["CustomerID"];?>"><?php echo $objResult["CustomerID"];?></option>
<?php
}
?>
</select>
<!-- <input name="txtName1" type="text" value=""> -->
<span class="focus-input100"></span>
</div>
<div class="contact100-form-bgbtn"></div>
<button class="contact100-form-btn">
<span>
Submit
<i class="fa fa-long-arrow-right m-l-7" aria-hidden="true"></i>
</span>
</button>
</div>
</form>
</body>
</html>
<?php
mysqli_close($conn);
?>
หน้าฟอร์ม ส่ง email Sendex2.php
Code (PHP)
<html>
<head>
<title>PHP Sending Email</title>
</head>
<body>
<?php
$strTo = "[email protected]";
$strSubject = $_POST["txtName"]; //อยากให้แสดงผล email ของ C001
$strHeader = "Content-type: text/html; charset=UTF-8\r\n"; // or windows-874 //
$strHeader .= "From: ".$_POST["txtUserIDno"]."<".$_POST["txtBU"].">\r\nReply-To: ".$_POST["txtUserIDno"]."";
$strMessage = nl2br($_POST["txtBU"]);
$flgSend = @mail($strTo,$strSubject,$strMessage,$strHeader); // @ = No Show Error //
if($flgSend)
{
echo "Email Send complete.";
}
else
{
echo "Email Can Not Send.";
}
?>
</body>
</html>
รบกวนพี่ ๆ แนะนำด้วยครับ พอมีความรู้งู ๆ ปลา ๆแต่ได้รับมอบหมายงานมาก็ต้องสู้กันนิดหนึ่งครับ
ขอขอบคุณทุกท่านครับ
Tag : PHP, JavaScript
|
|
|
 |
 |
 |
 |
| Date :
2020-01-26 15:04:55 |
By :
djmanny |
View :
780 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
