<?php
  $hostname='ljtfrdb.cvrsft0i6bfz.us-east-1.rds.amazonaws.com';
  $username='masteruser';
  $password='**********';

  try {
    $dbh = new PDO("mysql:host=$hostname;dbname=riderdb",$username,$password);

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO riderInfo(partyNM, numParty, numCooler, phoneNum,pickUp)
    VALUES ('".$_POST["partyName"]."','".$_POST["numParty"]."','".$_POST["numCooler"]."','".$_POST["phoneNum"]". ','".$_POST["pickUP"].''")";
  if ($dbh->query($sql)) {
    echo "<script type= 'text/javascript'>alert('New Record Inserted Successfully');</script>";
  }
  else{
    echo "<script type= 'text/javascript'>alert('Data not successfully Inserted.');</script>";
  }

  $dbh = null;
  }
    catch(PDOException $e)
  {
    echo $e->getMessage();
  }
?>