title: PDO insert parameter key instead parameter value
body: <p>Here I have a form:</p>
  
  <pre><code> &lt;form action="includes/Payment.inc.php" method="get" class="px-4 py-4" &gt;
      &lt;div class="form-group"&gt;
          &lt;div class="d-inline py-1"&gt;&lt;h5&gt;Payment Type&lt;/h5&gt;&lt;/div&gt;
          &lt;select class="bg-white text-dark" name="payment_type"&gt;
              &lt;option value="Type"&gt;Type&lt;/option&gt;
              &lt;option value="Food"&gt;Food&lt;/option&gt;
              &lt;option value="House-Rent"&gt;House-Rent&lt;/option&gt;
              &lt;option value="Other"&gt;Other&lt;/option&gt;
          &lt;/select&gt;
          &lt;h5 class="py-1"&gt;Amount of Money&lt;/h5&gt;
          &lt;div class="input-group"&gt;
              &lt;span class="input-group-addon"&gt;$&lt;/span&gt;
              &lt;input type="text" class="form-control" name="amount" aria-label="Text input with checkbox"&gt;
              &lt;span class="input-group-addon"&gt;JPY&lt;/span&gt;
          &lt;/div&gt;
          &lt;h5 class="py-1"&gt;Detail&lt;/h5&gt;
          &lt;textarea placeholder="Enter The Detail in here" name="detail"&gt;&lt;/textarea&gt;&lt;br&gt;
          &lt;label&gt;&lt;h5 class="py-1"&gt;Date: &lt;/h5&gt;&lt;/label&gt;
          &lt;input type="date" name="date"&gt;&lt;br&gt;
          &lt;button type="submit" name="submit" class="btn btn-primary m-4 border rounded"&gt;Submit&lt;/button&gt;
      &lt;/div&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>When clicked simply put all the information into database with following PHP code:</p>
  
  <pre><code>&lt;?php
  if (isset($_GET['submit'])) {
      include_once  'dbh.inc.php';
      $payment_type = $_GET['payment'];
      $amount_money = filter_input(INPUT_GET,'amount',FILTER_SANITIZE_NUMBER_INT);
      $detail = filter_input(INPUT_GET,'detail',FILTER_SANITIZE_STRING);
      $date = $_GET['date'];
      if (empty($amount_money)) {
          header('Location: ../Data.php?money_empty');
          exit();
      }
      else {
          $sql = "INSERT INTO payment(payment_type,amount,detail,payment_date)
              VALUES (':payment_type',':amount',':detail',':payment_date')";
          $result = $conn-&gt;prepare($sql);
          $result-&gt;bindParam(':payment_type',$payment_type,PDO::PARAM_STR);
          $result-&gt;bindParam(':amount',$amount_money,PDO::PARAM_INT);
          $result-&gt;bindParam(':detail',$detail,PDO::PARAM_STR);
          $result-&gt;bindParam(':payment_date',$date,PDO::PARAM_STR);
          $result-&gt;execute();
  
          header("Location: ../Data.php?payment_success");
          exit();
      }
  }
  </code></pre>
  
  <p>Then when I test the form, the execution is completed but when I checked the "payment" table, here's what i got:</p>
  
  <ul>
  <li>payment_type(varchar) = ":payment_type"</li>
  <li>amount(int) = 0</li>
  <li>detail(varchar) = ":detail"</li>
  <li>payment_date(date) = "0000-00-00".
  What's wrong  with my code ??</li>
  </ul>