Hello Friends, In this blog post(How can I delete all my Gmail contacts at once) I am going to let you know how to build an email verification functionality based on the domain address inside your email CSV file.
I make it more simple, suppose you have an email CSV file that has bulk email addresses and multiple domain addresses for email|How can I delete all my Gmail contacts at once|
Now the problem is that you have email addresses with domain extensions say ABC.com, and you don’t want to keep any email address with this particular domain name and want to delete all of them|How can I delete all my Gmail contacts at once|
so now the question is how would you delete them for email verification?| How can I delete all my Gmail contacts at once?
Though there could be some other way to remove such a domain from your Excel file for email verification, in case you don’t know the way or you are not familiar with the more technical thing then you would need to have a tool that can do this work for you|How can I delete all my Gmail contacts at once|
You can use this tool below for the email verification process where you just need to upload your list and select the domain that you want to remove or keep if the domain you want to delete is not in the drop-down list then you can also manually add or delete the domain the below-given option.
*Note – Domain add and delete functionality is disabled in the live demo. If you have any queries related to the live demo then please contact us here.
So using this tool email verification can happen both ways, you can remove the domain you want and you can also keep the domain you want, which means you can select the emails with a specific domain name and also can delete the email with a specific name.
What is the process to make this email verification tool?
This is a very simple process to build this email verification tool, you just need to follow the procedure.
1. Install all the applications to develop this functionality.
Software required to develop this functionality are :
NetBeans IDE
Xampp Server
2. Now create a project name as excel_cleaner, though you can create with any name and then create the below-given file structure.
Once the project creation is done with all files and folders then just copy and paste the below-given code for the email verification tool.
index.php
[php]
<?php
session_start();
ini_set("display_errors", 0);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<link href="style.css" rel="stylesheet" type="text/css"/>
<link href="bootstrap/css/bootstrap.css" rel="stylesheet" type="text/css"/>
<link href="bootstrap/css/bootstrap-theme.min.css" rel="stylesheet" type="text/css"/>
<title>Remove Email With Domain From Excel</title>
</head>
<body>
<div class="container">
<div class="row">
<h1 class="main_heading">Remove Email With Domain From Excel</h1>
<div id="main">
<div id="login">
<h2>Email Domain Remover</h2>
<hr>
<div id="right">
<div id ="form1" >
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post" enctype="multipart/form-data">
<?php
$server = "localhost";
$username = "root";
$password = "";
$link = @mysql_connect($server, $username, $password) or die("Cannot connect to mysql server: " . @mysql_error());
$dbname = 'test';
@mysql_select_db($dbname, $link) or die("Cannot connect to database: " . @mysql_error());
$query = "SELECT id,domainname from domain";
$result = @mysql_query($query);
echo "<select name='dname' value='domain'>";
while ($drop = @mysql_fetch_array($result)) {
echo "<option value=$drop[domainname]>$drop[domainname]</option>";
}
echo "</select>";
?>
<label><b>Upload CSV :</b></label>
<label><input type="file" name="file" id="file" /></label>
<input type="submit" name="csubmit" id="csubmit" value="submit"/>
</form>
<form action="#" method="get" id="registerform">
<input type="text" name="username" placeholder="Domainname"></input><br/>
<input type="submit" name="submit" value="Add"></input>
<input type="submit" name="deletercd" value="Delete"></input>
</form>
</div>
<div style="text-align: center;"><a href="">For exporting more email please click here..</a> </div>
</div>
</div>
</div>
<div id="csvmailcontent">
<?php
try {
if (isset($_POST['csubmit'])) {
$sample3 = $_POST['dname'];
$sample1 = 'abc';
$sample2 = '@';
$input = $sample1 . $sample2 . $sample3;
// echo $input;
if (isset($_FILES["file"])) {
//if there was an error uploading the file
if ($_FILES["file"] ["error"] > 0) {
echo "<script type='text/javascript'>alert('Please choose File for upload')</script>";
} else {
$storagename = $_FILES["file"]["name"];
$_SESSION['file_name'] = $storagename;
$id = $_SESSION['file_name'];
$row = 1;
move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $storagename);
$file = new SplFileObject("upload/" . $storagename);
$file->setFlags(SplFileObject::READ_CSV);
$file->setCsvControl(',', '"', '\\'); // this is the default anyway though
foreach ($file as $value) {
foreach ($value as $row) {
$arcsv[] = $row;
}
}
$arcsv = array_unique($arcsv);
$_SESSION['csv_value'] = $arcsv;
if (empty($arcsv)) {
$arcsv = $_SESSION['csv_value'];
}
$countarcsv = count($arcsv);
if($countarcsv >20){
echo ("<script LANGUAGE='JavaScript'>
window.alert('You exceed the one time limit of 20 emails');
window.location.href='http://localhost/excel_cleaner/index.php';
</script>");
}
/*This will remove all the Gmail.com address*/
if (preg_match('/\w+([-+.]\w+)*@(gmail\.com)$/i', $input)) {
$matches = preg_grep('/\w+([-+.]\w+)*@(gmail\.com)$/i', $arcsv,PREG_GREP_INVERT);
/*This will select all the yahoo addresses*/
// print_r($matches);
} elseif (preg_match('/\w+([-+.]\w+)*@(yahoo\.com)$/i', $input)) {
$matches = preg_grep('/\w+([-+.]\w+)*@(yahoo\.com)$/i', $arcsv);
//print_r($matches);
}
echo"<table id ='tid'>";
echo"<th>";
echo"<b>";
echo"Result Emails";
echo"</b>";
echo"</th>";
foreach ($matches as $key) {
echo"<tr>";
echo"<td>";
echo $key . "<br/>";
echo"</td>";
echo"</tr>";
}
echo"</table>";
$arcsv1[] = $matches;
$lists1 = json_encode($arcsv1);
}
}
if (!empty($file)) {
echo"<form action='csvdown.php' method='post' >
<input type='hidden' name='lists1' value='$lists1' />
<button type='submit' value='Export CSV' id ='csvsubmit'><u>Export CSV<u></button>
</form>";
}
}
} catch (MyException $e) {
echo "Something went wrong";
}
?>
<?php
if (isset($_GET['submit'])) {
$con = mysql_connect("localhost", "root", "");
//Selecting Database
$db = mysql_select_db("test", $con);
$username = $_GET['username'];
if($username=="")
{
echo"Please fill all the fields";
}
else{
$query=mysql_query("insert into domain (domainname) values ('$username')");
if($query){
echo ("<script LANGUAGE='JavaScript'>
window.alert('Your domain has been added successfully');
window.location.href='http://localhost/excel_cleaner/index.php';
</script>");}
mysql_close($con); // Closing the connection
}
}
if (isset($_GET['deletercd'])) {
$con = mysql_connect("localhost", "root", "");
//Selecting Database
$db = mysql_select_db("test", $con);
$username = $_GET['username'];
if($username=="")
{
echo"Please fill all the fields";
}
else{
$query=mysql_query("DELETE from domain where domainname = '$username'");
if($query){
echo ("<script LANGUAGE='JavaScript'>
window.alert('Your domain has been deleted successfully');
window.location.href='http://localhost/excel_cleaner/index.php';
</script>");
}
mysql_close($con); // Closing the connection
}
}
?>
</div>
</div>
</div>
</body>
</html>
[/php]
csvdown.php
[php]
<?php
ini_set("display_errors", 0);
?>
<?php
try {
$array2 = json_decode($_POST['lists1']);
foreach ($array2 as $key) {
foreach ($key as $key1) {
$array3[][] = $key1;
}
}
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=file.csv");
header("Pragma: no-cache");
header("Expires: 0");
$data = $array3;
$file = fopen('php://output', 'w');
fputcsv($file, array('Emails '));
foreach ($data as $row) {
fputcsv($file, $row);
}
exit();
} catch (MyException $e) {
echo "Something went wrong";
}
?>
[/php]
Style.css
[css]
@import url(http://fonts.googleapis.com/css?family=Raleway);
#main{
min-width: 350px;
margin: 44px auto;
font-family:raleway;
}
span{
color:red;
}
h1.main_heading {
text-align: center;
}
h2{
background-color: #FEFFED;
text-align:center;
border-radius: 10px 10px 0 0;
margin: -10px -40px;
padding: 15px;
}
hr{
border:0;
border-bottom:1px solid #ccc;
margin: 10px -40px;
margin-bottom: 30px;
}
#login{
border-radius: 10px;
font-family:raleway;
border: 2px solid #ccc;
padding: 10px 40px 33px;
margin-top: 23px;
}
input[type=text],input[type=email]{
width:99.5%;
padding: 10px;
border: 1px solid #ccc;
padding-left: 5px;
font-size: 16px;
font-family:raleway;
}
input[type=submit]{
width: 37%;
background-color:#FFBC00;
color: white;
border: 2px solid #FFCB00;
padding: 4px;
font-size:20px;
cursor:pointer;
border-radius: 5px;
}
#right{
overflow: hidden;
overflow-wrap: break-word;
width: 104%;
border: 1px dashed rgb(215, 215, 215);
box-shadow: 0px 5px 17px 1px #99A3AD, 0px 0px 40px #EEEEEE;
margin-left: -10%;
padding: 20px;
}
#right p{
padding: 20px;
}
form1 {
padding-top: 27px;
width: 248px;
margin: auto;
}
#right h3 {
margin-top: -8px;
text-align: center;
}
#csvmailcontent{
width:60%px;
font-family:raleway;
margin-top: -4%;
}
#mailsubmit{
background:none!important;
border:none;
padding:0!important;
font: inherit;
border-bottom:1px solid #444;
cursor: pointer;
font-size: 150%;
margin-left: 45%;
}
#csvsubmit{
background: none! important;
border:none;
padding:0!important;
font: inherit;
border-bottom:1px solid #444;
cursor: pointer;
font-size: 150%;
margin-left: 45%;
}
#uploadcsv
{
margin-bottom: 5%;
}
#text1{
margin-top: 1%;
margin-bottom: 11px;
}
input#text1 {}
#or{
margin-left: 45%;
font-size: 20px;
font-family:raleway;
margin-top: -50px;
}
#or:hover{
color: #204d74;
z-index: 8;
}
#file{
color:lightblue;
margin-top: 3px;
margin-bottom: 4px;
}
table {
font-family: 'Raleway', sans-serif;
color:#666;
font-size:12px;
text-shadow: 1px 1px 0px #fff;
background:#eaebec;
margin:20px;
border:#ccc 1px solid;
font-size: 16px;
-moz-border-radius:3px;
-webkit-border-radius:3px;
border-radius:3px;
-moz-box-shadow: 0 1px 2px #d1d1d1;
-webkit-box-shadow: 0 1px 2px #d1d1d1;
box-shadow: 0 1px 2px #d1d1d1;
margin: 0 auto;
}
table th {
text-align: center;
padding:21px 25px 22px 25px;
border-top:1px solid #fafafa;
border-bottom:1px solid #e0e0e0;
background: #ededed;
background: -webkit-gradient(linear, left top, left bottom, from(#ededed), to(#ebebeb));
background: -moz-linear-gradient(top, #ededed, #ebebeb);
}
table th:first-child {
text-indent: center;
padding-left:20px;
}
table tr:first-child th:first-child {
-moz-border-radius-topleft:3px;
-webkit-border-top-left-radius:3px;
border-top-left-radius:3px;
}
table tr:first-child th:last-child {
-moz-border-radius-topright:3px;
-webkit-border-top-right-radius:3px;
border-top-right-radius:3px;
}
table tr {
text-indent: center;
padding-left:20px;
}
table td:first-child {
text-align: center;
padding-left:20px;
border-left: 0;
}
table td {
padding:18px;
border-top: 1px solid #ffffff;
border-bottom:1px solid #e0e0e0;
border-left: 1px solid #e0e0e0;
background: #fafafa;
background: -webkit-gradient(linear, left top, left bottom, from(#fbfbfb), to(#fafafa));
background: -moz-linear-gradient(top, #fbfbfb, #fafafa);
}
table tr. even td {
background: #f6f6f6;
background: -webkit-gradient(linear, left top, left bottom, from(#f8f8f8), to(#f6f6f6));
background: -moz-linear-gradient(top, #f8f8f8, #f6f6f6);
}
table tr:last-child td:first-child {
-moz-border-radius-bottomleft:3px;
-webkit-border-bottom-left-radius:3px;
border-bottom-left-radius:3px;
}
table tr:last-child td:last-child {
-moz-border-radius-bottomright:3px;
-webkit-border-bottom-right-radius:3px;
border-bottom-right-radius:3px;
}
table tr: hover td {
background: #f2f2f2;
background: -webkit-gradient(linear, left top, left bottom, from(#f2f2f2), to(#f0f0f0));
background: -moz-linear-gradient(top, #f2f2f2, #f0f0f0);
}
@media only screen and (min-width:768px){
#main {
max-width: 370px;
}
}
[/css]
Once you are done with this process to complete all the files and pages then you can run your project for email verification and test the result|How can I delete all my Gmail contacts at once|
You can also go through a few important blog links related to email marketing below:
How to stop email from falling into the user’s spam folder.
See a few best tips for effective email marketing.
Learn Email marketing in Hindi.
30+ Best Email marketing service providers study and reviews.
8 Best Tips for sending a successful email campaign.
Domain Registration vs Domain Hosting In Hindi…
Email को Spam folder में जाने से कैसे रोके?…
Which domain is best for effective email marketing…
What does it mean if your account is suspended?…
How badly do emails impact your email campaign…
SPF और DKIM रिकार्ड्स क्या होते है, कहा पर मिलते है और कहा पर उन्हें रखना होता है ?…
Email marketing क्या है और इसका उपयोग कैसे करते है ?…
How do I check if a sent email ended up in the receiver’s spam box automatically…
हम Email में कितनी बड़ी file attachment भेज सकते है …
Can Yahoo Send Scheduled Emails…
SMTP क्या है और कैसे काम करता है…
Most Common Email Marketing Mistakes In Hindi…
Email Scraping In Hindi…
Email marketing क्या है और इसका उपयोग कैसे करते है…
SPF and DKIM records in Hindi…
5 Free Email Marketing Software…
In the case of any queries, you can write to us at a5theorys@gmail.com we will get back to you ASAP|How can I delete all my Gmail contacts at once|
Hope! you would have enjoyed this post on How can I delete all my Gmail contacts at once.
Please feel free to give your important feedback in the comment section below|How can I delete all my Gmail contacts at once|
Have a great time! Sayonara!