'Invalid parameter number' error using bindParam to create an MySQL query

Question

I have written a function that takes four arguments and passes them to my MySQL database using a PDO.

I am trying to use bindParam so that I can use the variables to construct the query.

I have followed the examples in the PHP documentation, but I am getting the following error:

ERROR:

SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

What am I doing wrong?

function saveAddress($addressLine1, $addressLine2, $town, $county_id) {

    try {
        $conn = new PDO('mysql:host=localhost;dbname=' . DB_DATABASE, DB_USER, DB_PASSWORD);
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $stmt = $conn->prepare('INSERT INTO address (`address_line_1`, `address_line_2`, `town`, `county_id`)
            VALUES (:addressLine1, :addressLine2, :town, :county_id);');
        $stmt->bindParam(':addressLine1', $addressLine1, PDO::PARAM_STR);
        $stmt->bindParam(':addressLine2', $addressLine2, PDO::PARAM_STR);
        $stmt->bindParam(':town', $town, PDO::PARAM_STR);
        $stmt->bindParam(':county_id', $county_id, PDO::PARAM_INT);     
        $success = $stmt->execute(array());
    }
    catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}

Marty · Accepted Answer · 2021-08-17 13:37:03Z

4

$stmt->execute takes an optional array parameter which represents the values to bind in your prepared statement.

Since you are explicitly calling bindParam, you don't need to pass in the array param to execute.

Just as a side note, if you choose to use the array option instead of calling bindParam in the future, be aware that each of the values in that array will be bound using PDO::PARAM_STR.

edited Aug 17, 2021 at 13:37

Marty

3225 silver badges18 bronze badges

answered Dec 28, 2013 at 21:45

keelerm

2,9731 gold badge22 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

'Invalid parameter number' error using bindParam to create an MySQL query

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