Ask Question

Menu


Send message and email by import excel file PHP


Mail

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

<!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.";
}
}
?>





Buy Template

Partner Site




Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe