Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

Sending HTML Form data to a MYSQL and a Webhook with PHP

0 votes
183 views
in Technique[技术] by (71.8m points)

Sending HTML Form data to a MYSQL and a Webhook with PHP

I have a form that collects lead data and on submit I want that info to go to MYSQL and a Webhook.

I've got to pieces of PHP code (MYSQL-WEBHOOK.PHP AND WEBHOOK.PHP) that I've created for testing in the <The form action="">

Here is the HTML for the form

<form action="/Lead/leadprocess.php">
      <div class="row">
        <div class="col-25">
          <label for="VehVin">Vehicle VIN Number - Please Verify</label>
        </div>
        <div class="col-75">
          <input type="text" id="VehVin" name="VehVin" placeholder="Vehicle Vin Number">
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="Own1st">Applicants First Name</label>
        </div>
        <div class="col-75">
          <input type="text" id="Own1st" name="Own1st" placeholder="Your First Name..">
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="OwnLst">Applicants Last Name</label>
        </div>
        <div class="col-75">
          <input type="text" id="OwnLst" name="OwnLst" placeholder="Your Last Name..">
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="OwnPh">Applicants Mobile Number</label>
        </div>
        <div class="col-75">
          <input type="text" id="OwnPh" name="OwnPh" placeholder="Your Mobile Number..">
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="OwnEml">Applicants Email Address</label>
        </div>
        <div class="col-75">
          <input type="text" id="OwnEml" name="OwnEml" placeholder="Your Email Address..">
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="OwnSt">State Of Residence</label>
        </div>
        <div class="col-75">
          <select id="OwnSt" name="OwnSt">
            <option value="AL">Alabama</option>
        <option value="AK">Alaska</option>
        <option value="AZ">Arizona</option>
        <option value="AR">Arkansas</option>
        <option value="CA">California</option>
        <option value="CO">Colorado</option>
        <option value="CT">Connecticut</option>
        <option value="DE">Delaware</option>
        <option value="DC">District Of Columbia</option>
        <option value="FL">Florida</option>
        <option value="GA">Georgia</option>
        <option value="HI">Hawaii</option>
        <option value="ID">Idaho</option>
        <option value="IL">Illinois</option>
        <option value="IN">Indiana</option>
        <option value="IA">Iowa</option>
        <option value="KS">Kansas</option>
        <option value="KY">Kentucky</option>
        <option value="LA">Louisiana</option>
        <option value="ME">Maine</option>
        <option value="MD">Maryland</option>
        <option value="MA">Massachusetts</option>
        <option value="MI">Michigan</option>
        <option value="MN">Minnesota</option>
        <option value="MS">Mississippi</option>
        <option value="MO">Missouri</option>
        <option value="MT">Montana</option>
        <option value="NE">Nebraska</option>
        <option value="NV">Nevada</option>
        <option value="NH">New Hampshire</option>
        <option value="NJ">New Jersey</option>
        <option value="NM">New Mexico</option>
        <option value="NY">New York</option>
        <option value="NC">North Carolina</option>
        <option value="ND">North Dakota</option>
        <option value="OH">Ohio</option>
        <option value="OK">Oklahoma</option>
        <option value="OR">Oregon</option>
        <option value="PA">Pennsylvania</option>
        <option value="RI">Rhode Island</option>
        <option value="SC">South Carolina</option>
        <option value="SD">South Dakota</option>
        <option value="TN">Tennessee</option>
        <option value="TX">Texas</option>
        <option value="UT">Utah</option>
        <option value="VT">Vermont</option>
        <option value="VA">Virginia</option>
        <option value="WA">Washington</option>
        <option value="WV">West Virginia</option>
        <option value="WI">Wisconsin</option>
        <option value="WY">Wyoming</option>
          </select>
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="Serv">State Of Residence</label>
        </div>
        <div class="col-75">
          <select id="Serv" name="Serv">
            <option value="Title Transfer">Title Transfer</option>
        <option value="Title Replacement">Title Replacement</option>
        <option value="Bonded Title">Bonded Title</option>
        
          </select>
        </div>
      </div>
      <div class="row">
        <div class="col-25">
          <label for="Coments">Comments</label>
        </div>
        <div class="col-75">
          <textarea id="Coments" name="Coments" placeholder="Tell Us A Bit About Your Issue.." style="height:200px"></textarea>
        </div>
      </div>
      <div class="row">
        <input type="submit" value="Submit">
      </div>
      </form>

I trying to use this code to pass info from the URL as variables, convert it to json and send it to the webhook and then redirect to a thankyou page. Hoping to use this code to test the webhook for a successful trigger catch. FILE NAME: WEBHOOK.PHP

<?php
  

$VehVin = $_GET['VehVin'];
$Own1st = $_GET['Own1st'];
$OwnLst = $_GET['OwnLst'];
$OwnPh = $_GET['OwnPh'];
$OwnEml = $_GET['OwnEml'];
$OwnSt = $_GET['OwnSt'];
$S3rv = $_GET['S3rv'];
$C0m3nts = $_GET['Coments'];



function generateKey() {
   global $conn;
   $keyLength = 9;
   $str = "1234567890ABCDEFGHJKLMNPQRSTUVWXYZ";
   $checkKey=true;
   while ($checkKey == true)  {
      $randstr = substr(str_shuffle($str),0,$keyLength);
      
      return $randstr;
   }
   
}
$RefCod = generateKey();
 

$curl = curl_init();
$url = 'https://hooks.zapier.com/hooks/catch/9259009/o0txxca/';

curl_setopt_array($curl, [
    CURLOPT_URL => $url,
    CURLOPT_HEADER => false,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_POST => [ 
      'Contact._VehicleID' => '$VehVin',
      'contact.first_name' => '$Own1St',
      'contact.last_name' => '$OwnLst',
      'Contact.Phone1' => '$OwnPh',
      'Contact.Email' => '$OwnEml', 
      'Contact._IDStateofOrigin' => '$OwnSt',
      'Contact._Service' => '$S3rv',
      'Contact._Comments' => '$Com3nt',
      '~Contact._RefCod~' => '$RefCod',
    ],
]);

$response = curl_exec($curl);

if ($error = curl_error($curl)) {
  throw new Exception($error);
}

curl_close($curl);
$response = json_decode($response, true);

var_dump('Response:', $response);

/* Redirect browser */
header("Location: /Lead/shrtthks.html"); 
exit();

?>

I'm trying to use this code to send data to the MYSQL, then the Webhook, and then redirect to the thankyou page. File name MYSQL-WEBHOOK.PHP

<?php
        
        require_once('dogs.php');
        
     

$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
    
if (!$conn){
    echo 'Not Connected to Server';
}

if(!mysqli_select_db($conn, 'thetitl1_losttitl'))
{
    echo 'Database Not Selected';
}
$VehVin = $_GET['VehVin'];
$Own1st = $_GET['Own1st'];
$OwnLst = $_GET['OwnLst'];
$OwnPh = $_GET['OwnPh'];
$OwnEml = $_GET['OwnEml'];
$OwnSt = $_GET['OwnSt'];
$S3rv = $_GET['S3rv'];
$C0m3nts = $_GET['Coments'];



function generateKey() {
   global $conn;
   $keyLength = 9;
   $str = "1234567890ABCDEFGHJKLMNPQRSTUVWXYZ";
   $checkKey=true;
   while ($checkKey == true)  {
      $randstr = substr(str_shuffle($str),0,$keyLength);
      //  New random key is created, verify it is unique
      $sql = "SELECT * FROM leadform WHERE refcod=" . $randstr;
      $result = mysqli_query($conn,$sql);
      if (mysqli_num_rows($conn,$result)==0) {
         $checkKey=true;
      } else {
         $checkKey=false;
      }
      return $randstr;
   }
   
}
$RefCod = generateKey();
$stmt = mysqli_prepare($conn, "INSERT INTO leadform VALUES (?,?,?,?,?,?,?,?,?)");
mysqli_stmt_bind_param($stmt, 'sssssssss', $VehVin,$Own1st,$OwnLst,$OwnPh,$OwnEml,$OwnSt,$S3rv,$C0m3nts,$RefCod);

/* execute prepared statement */
mysqli_stmt_execute($stmt);

/* Send form data to webhook using cURL and JSON*/
$curl = curl_init();
$url = 'https://hooks.zapier.com/hooks/catch/9259009/o0txxca/';

curl_setopt_array($curl, [
    CURLOPT_URL => $url,
    CURLOPT_HEADER => false,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_POST => [ 
      'Contact._VehicleID' => '$VehVin',
      'contact.first_name' => '$Own1St',
      'contact.last_name' => '$OwnLst',
      'Contact.Phone1' => '$OwnPh',
      'Contact.Email' => '$OwnEml', 
      'Contact._IDStateofOrigin' => '$OwnSt',
      'Contact._Service' => '$S3rv',
      'Contact._Comments' => '$Com3nt',
      '~Contact._RefCod~' => '$RefCod',
    ],
]);

$response = curl_exec($curl);

if ($error = curl_error($curl)) {
  throw new Exception($error);
}

curl_close($curl);
$response = json_decode($response, true);

var_dump('Response:', $response);


/* close statement and connection */
mysqli_stmt_close($stmt);

/* close connection */
mysqli_close($conn);

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

Just Browsing Browsing

2.1m questions

2.1m answers

60 comments

57.0k users

Most popular tags

Powered by Question2Answer
Donate
Theme by Q2A Market&&OStack.cn
...