CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

15 October, 2018

How to show contact form 7 Wordpress data in PHP admin panel

 Programing Coderfunda     October 15, 2018     Wordpress     1 comment   

Show contact form 7 Wordpress data in PHP admin panel is very easy.
When a user fill up form through contact form 7 it store in wp_cf7_vdata_entry. But the data store process is little bit different than we store normally.
It store the data vertically. So we need to convert it horizontal to show in our php admin panel.
Let’s see how to change vertical table record into horizontal in PHP.
Wordpress

View.php

<?php
include_once 'database.php';
$result = mysqli_query($conn,"SELECT data_id, 
     MAX( CASE WHEN name =  'your-name' THEN value END) AS Name, 
     MAX( CASE WHEN name =  'your-email' THEN value END) AS Email,
MAX( CASE WHEN name =  ‘tel-780‘ THEN value END) AS Phone,
MAX( CASE WHEN name =  ‘your-address‘ THEN value END) AS Address
FROM wp_cf7_vdata_entry where cf7_id = 8100
GROUP BY data_id
;"
);
?>
 <!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet"href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container"> 
<table class="table table-bordered">
<thead>
<tr>
<th>Sl no</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Address</th>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_array($result)) {
?>

<tr>
<td><?php echo $row[“date_id”]; ?></td>
<td><?php echo $row[“Name”]; ?></td>
<td><?php echo $row[“Email”]; ?></td>
<td><?php echo $row[“Phone”]; ?></td>
<td><?php echo $row[“Address”]; ?></td>
</tr>
<?php
}
?>

</tbody>
</table>
</div>
</body>
</html>
Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

How to show contact form 7 Wordpress data in PHP admin panel

 Programing Coderfunda     October 15, 2018     Wordpress     No comments   

Show contact form 7 Wordpress data in PHP admin panel is very easy.
When a user fill up form through contact form 7 it store in wp_cf7_vdata_entry. But the data store process is little bit different than we store normally.
It store the data vertically. So we need to convert it horizontal to show in our php admin panel.
Let’s see how to change vertical table record into horizontal in PHP.
Wordpress

View.php

<?php
include_once 'database.php';
$result = mysqli_query($conn,"SELECT data_id, 
     MAX( CASE WHEN name =  'your-name' THEN value END) AS Name, 
     MAX( CASE WHEN name =  'your-email' THEN value END) AS Email,
MAX( CASE WHEN name =  ‘tel-780‘ THEN value END) AS Phone,
MAX( CASE WHEN name =  ‘your-address‘ THEN value END) AS Address
FROM wp_cf7_vdata_entry where cf7_id = 8100
GROUP BY data_id
;"
);
?>
 <!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet"href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container"> 
<table class="table table-bordered">
<thead>
<tr>
<th>Sl no</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Address</th>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_array($result)) {
?>

<tr>
<td><?php echo $row[“date_id”]; ?></td>
<td><?php echo $row[“Name”]; ?></td>
<td><?php echo $row[“Email”]; ?></td>
<td><?php echo $row[“Phone”]; ?></td>
<td><?php echo $row[“Address”]; ?></td>
</tr>
<?php
}
?>

</tbody>
</table>
</div>
</body>
</html>
Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

How to integrate OTP in Wordpress form with resend option

 Programing Coderfunda     October 15, 2018     Wordpress     No comments   

Integrate OTP in Wordpress form is very easy. Please follow the below step to integrate OTP in your Wordpress form.
Step 1- Edit the page with Visual composer and add create a form using raw html option of Visual composer.
Or
If you don’t have visual composer then try another editor or create a custom html form.
Step 2-In the form action link the process file.
Example :

Raw HTML File

<form method="post" action=" process/contact-process.php">
<input type="text" name="name" placeholder="name"><br><br>
<input type="text" name="email" placeholder="email"><br><br>
<input type="text" name="phone" placeholder="phone"><br><br>
<input type="text" name="message" placeholder="message"><br><br>
<button type="submit" value="submit" name="save">Submit</button>
</form>
Step 3- Create a folder process in public_html and upload the below file list.
  1. contact-process.php
  2. otp.php
  3. database.php

contact-process.php

<?php
session_start();
//Your authentication key$authKey = "abc13VcIY7WyB582082d3";
//Multiple mobiles numbers separated by comma$mobileNumber = $_POST["phone"];
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$rndno=rand(100000, 999999);
$message = urlencode("otp number.".$rndno);
//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
'route' => $route
);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
if(isset($_POST['save']))
{
$_SESSION['name']=$_POST['name'];
$_SESSION['email']=$_POST['email'];
$_SESSION['phone']=$_POST['phone'];
$_SESSION['message']=$_POST['message'];
$_SESSION['otp']=$rndno;
//echo "success";header( "Location: otp.php" );
} 
?>

otp.php

otp.php

<?php
session_start();
include_once 'database.php';
if(isset($_POST['save']))
{
$rno=$_SESSION['otp'];
$urno=$_POST['otpvalue'];
if(!strcmp($rno,$urno))
{
$name=$_SESSION['name'];
$phone=$_SESSION['phone'];
$email=$_SESSION['email'];
$message=$_SESSION['message'];
date_default_timezone_set("Asia/Calcutta");
$date_time= date("Y-m-d H:i:s");
// Create connection$sql = "INSERT INTO contact (name,email,phone,message,date_time)
VALUES ('$name','$email','$phone','$message','$date_time')"
;
if (mysqli_query($conn, $sql)) {
$authKey = "abc431ADE9VcIY7WyB582082d3";
$mobileNumber = $phone;
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$message = urlencode("Thank you for contacting us.We will get back to you shortly.");
//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
'route' => $route
);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
header( "Location: https://www.nayadarshan.com/success/" );
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
return true;
}
else
{
echo "Invalid OTP please try again.";
return false;
}
}
if(isset($_POST['resend_otp']))
{
$authKey = "abc13491ADE9VcIY7WyB582082d3";
//Multiple mobiles numbers separated by comma$mobileNumber = $_SESSION['phone'];
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$rno=$_SESSION['otp'];
$message = urlencode("OTP number.".$rno);
//echo $rno;//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
//'route' => $route);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
}
?>

<!DOCTYPE html>
<html>
<title>Form</title>
<body>
<form action="" method="post">
<input type="text" name="otpvalue"/>
<input type="submit" value="submit" name="save"/>
<input type="submit" value="Resend OTP" name="resend_otp"/>
</form>
</body>
</html>
Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg

How to integrate OTP in Wordpress form with resend option

 Programing Coderfunda     October 15, 2018     Wordpress     No comments   

Integrate OTP in Wordpress form is very easy. Please follow the below step to integrate OTP in your Wordpress form.
Step 1- Edit the page with Visual composer and add create a form using raw html option of Visual composer.
Or
If you don’t have visual composer then try another editor or create a custom html form.
Step 2-In the form action link the process file.
Example :

Raw HTML File

<form method="post" action=" process/contact-process.php">
<input type="text" name="name" placeholder="name"><br><br>
<input type="text" name="email" placeholder="email"><br><br>
<input type="text" name="phone" placeholder="phone"><br><br>
<input type="text" name="message" placeholder="message"><br><br>
<button type="submit" value="submit" name="save">Submit</button>
</form>
Step 3- Create a folder process in public_html and upload the below file list.
  1. contact-process.php
  2. otp.php
  3. database.php

contact-process.php

<?php
session_start();
//Your authentication key$authKey = "abc13VcIY7WyB582082d3";
//Multiple mobiles numbers separated by comma$mobileNumber = $_POST["phone"];
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$rndno=rand(100000, 999999);
$message = urlencode("otp number.".$rndno);
//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
'route' => $route
);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
if(isset($_POST['save']))
{
$_SESSION['name']=$_POST['name'];
$_SESSION['email']=$_POST['email'];
$_SESSION['phone']=$_POST['phone'];
$_SESSION['message']=$_POST['message'];
$_SESSION['otp']=$rndno;
//echo "success";header( "Location: otp.php" );
} 
?>

otp.php

otp.php

<?php
session_start();
include_once 'database.php';
if(isset($_POST['save']))
{
$rno=$_SESSION['otp'];
$urno=$_POST['otpvalue'];
if(!strcmp($rno,$urno))
{
$name=$_SESSION['name'];
$phone=$_SESSION['phone'];
$email=$_SESSION['email'];
$message=$_SESSION['message'];
date_default_timezone_set("Asia/Calcutta");
$date_time= date("Y-m-d H:i:s");
// Create connection$sql = "INSERT INTO contact (name,email,phone,message,date_time)
VALUES ('$name','$email','$phone','$message','$date_time')"
;
if (mysqli_query($conn, $sql)) {
$authKey = "abc431ADE9VcIY7WyB582082d3";
$mobileNumber = $phone;
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$message = urlencode("Thank you for contacting us.We will get back to you shortly.");
//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
'route' => $route
);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
header( "Location: https://www.nayadarshan.com/success/" );
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
return true;
}
else
{
echo "Invalid OTP please try again.";
return false;
}
}
if(isset($_POST['resend_otp']))
{
$authKey = "abc13491ADE9VcIY7WyB582082d3";
//Multiple mobiles numbers separated by comma$mobileNumber = $_SESSION['phone'];
//Sender ID,While using route4 sender id should be 6 characters long.$senderId = "NAYADS";
//Your message to send, Add URL encoding here.$rno=$_SESSION['otp'];
$message = urlencode("OTP number.".$rno);
//echo $rno;//Define route $route = "route=4";
//Prepare you post parameters$postData = array(
'authkey' => $authKey,
'mobiles' => $mobileNumber,
'message' => $message,
'sender' => $senderId,
//'route' => $route);
//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 verificationcurl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
//get response$output = curl_exec($ch);
//Print error if anyif(curl_errno($ch))
{
echo 'error:' . curl_error($ch);
}
curl_close($ch);
}
?>

<!DOCTYPE html>
<html>
<title>Form</title>
<body>
<form action="" method="post">
<input type="text" name="otpvalue"/>
<input type="submit" value="submit" name="save"/>
<input type="submit" value="Resend OTP" name="resend_otp"/>
</form>
</body>
</html>
Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Newer Posts Older Posts Home

Meta

Popular Posts

  • Credit card validation in laravel
      Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...
  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • iOS 17 Force Screen Rotation not working on iPAD only
    I have followed all the links on Google and StackOverFlow, unfortunately, I could not find any reliable solution Specifically for iPad devic...
  • C++ in Hindi Introduction
    C ++ का परिचय C ++ एक ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग लैंग्वेज है। C ++ को Bjarne Stroustrup द्वारा विकसित किया गया था। C ++ में आने से पह...
  • Python AttributeError: 'str' has no attribute glob
    I am trying to look for a folder in a directory but I am getting the error.AttributeError: 'str' has no attribute glob Here's ...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (2)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda