Send message and email by import excel file PHP
In this example we will discuss Send message and mail by import excel file PHP.
Here Send message and eby import excel file in PHP we using 3 files these are:
- index.php:for getting the values from the user
- message-process.php: Process file for send message
- email-process.php: Process file for send email
index.php
<!DOCTYPE html>
<html>
<body>
<form enctype="multipart/form-data" method="post" action="message-process.php" role="form">
<div class="form-group">
<input type="text" name="message">
<label for="exampleInputFile">File Upload</label>
<input type="file" name="file" id="file" size="150">
<p class="help-block">Only Excel/CSV File Import.</p>
</div>
<button type="submit" class="btn btn-default" name="submit" value="submit">Upload</button>
</form>
</body>
</html>
message-process.php
<?php
if(isset($_POST["submit"]))
{
$message = $_POST['message'];
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$c = 0;
while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
{
$number = $filesop[0];
/* start
Your authentication key */
$authKey = "130491ADE9VcIY7tsB582082d3";
/* retrieve code */
/* Multiple mobiles numbers separated by comma */
$mobileNumber = $number;
/*Sender ID,While using route4 sender id should be 6 characters long. */
$senderId = "STUDEN";
/* Your message to send, Add URL encoding here. */
$message = $message;
/* Define route */
$route = "4";
/* Prepare you post parameters */
$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
'route' => $route
);
/* YOUR API URL */
$url="https://control.msg91.com/api/sendhttp.php";
/* init the resource */
$ch = curl_init();
curl_setopt_array($ch, array(
CURLOPT_URL => $url,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => $postData
/* ,CURLOPT_FOLLOWLOCATION => true */
));
/* Ignore SSL certificate verification */
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
/* get response */
$output = curl_exec($ch);
$success="<h3 align='center'<Birthday Wishes Send Successfully!";
/* Print error if any */
if(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
/* end */
$c = $c + 1;
}
if($fname){
echo "sucess";
}
else
{
echo "Sorry! Unable to message.";
}
}
?>
email-process.php
<?php
if(isset($_POST["submit"]))
{
$message = $_POST['message'];
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$c = 0;
while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
{
$mail_list = $filesop[0];
/* mail start */
$to = $mail_list;
$subject = "My subject";
$txt = $message;
$headers = "From: info@studentstutorial.com" . "\r\n" .
"CC: info@anything.com";
mail($to,$subject,$txt,$headers);
/* mail end */
$c = $c + 1;
}
if($fname){
echo "sucess";
}
else
{
echo "Sorry! Unable to message.";
}
}
?>