cannot be null - PhP PDO Function

Question

I have a problem with one function, function should be sent a text to base (phpmyadmin), or menu displays error..

Error code:

Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Code' cannot be null

My function:

public function UploadInvoice($CONN)
{
  $SubmitOK = '1';
  $Core = new Core();
  $Core->CheckForEmpty(array('Code'), 'finances.php');

  if($SubmitOK == '1') {
    try {
      $SQL = 'INSERT INTO Invoices (UserID, Code) VALUES (:UserID, :Code)';
      $SQL = $CONN->prepare($SQL);
      $SQL->execute(array('UserID' => $_SESSION['UserLogin']['ID'], 'Code' => $Code));
      $_SESSION['Success'] = 'Successfully submitted your code, Wait for checking multiple payments, your money will be soon on the bill';
      header('location: finances');
      exit();
    } catch(PDOException $e) {
       echo "Error: " . $e->getMessage();
    }
  } else {
      $_SESSION['Error'] = 'An error has occurred. Try again!';
      header('location: finances');
      exit();
  }
}

My form code:

<form action="" method="POST">
    <input type="text" class="form-control" required="true" minlength="4" name="Code" placeholder="Your ID">
    <button type="submit">SEND</button>
</form>

The error clearly states that $Code have no value

Death-is-the-real-truth
– Death-is-the-real-truth

2016-04-30 07:50:44 +00:00
Commented Apr 30, 2016 at 7:50 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Apr 30, 2016 at 7:50
HI @CyberFX: You Didn't Respond To The Answer Given Below.

Nana Partykar
– Nana Partykar

2016-05-05 09:43:01 +00:00
Commented May 5, 2016 at 9:43 — Nana Partykar
– Nana Partykar, Commented May 5, 2016 at 9:43

Nana Partykar · Accepted Answer · 2016-04-30 07:55:05Z

1

You Missed ":" in $SQL->execute.... Append it with UserID & Code.

Change

$SQL->execute(array('UserID' => $_SESSION['UserLogin']['ID'], 'Code' => $Code));

To

$SQL->execute(array(':UserID' => $_SESSION['UserLogin']['ID'], ':Code' => $Code));

For More info, Please click PDO Statement Execute

answered Apr 30, 2016 at 7:55

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cannot be null - PhP PDO Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related