PDO execute: Array to String conversion

Question

I am getting an Array to String conversion error

errorCode() --> 00000

errorInfo() --> Array

public function getUserInfoByMail( $userEmail )
{
    if (is_mail($userEmail))
    {
        $sql = $this->db->prepare("SELECT * FROM customer INNER JOIN addresses ON customer.customerid = addresses.customerid WHERE standard='1' AND deleted='0' AND email=:email");
        if ($sql->execute(array(':email' => $userEmail))) 
             return $sql->fetch(PDO::FETCH_ASSOC);
        else 
             throw new Exception("There was a DB-Error!");
    }
    //....
}

Why am I am getting an Array to String conversion error?

Read the php manual for errorInfo. It's an array with SQLState error, errorcode and error message. ch1.php.net/manual/en/pdo.errorinfo.php — Charlotte Dunois
– Charlotte Dunois, Commented Aug 3, 2014 at 12:20
Fatal error: Uncaught exception 'Exception' with message 'There was a DB-Error!' in C:\...\customer.dao.php:107 Stack trace: #0 C:\...\login.php(107): CustomerDAO->getUserInfoByMail('[email protected]') #1 {main} thrown in C:\...\customer.dao.php on line 107 — Sauerbrei
– Sauerbrei, Commented Aug 3, 2014 at 12:25

Community · Accepted Answer · 2017-05-23 10:33:31Z

1

->execute() expects you to send it an array with each element representing each ? in the query.\

The main cause of the problem is by only sending it with 2 elements so it use the array as second...Please see here

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 3, 2014 at 13:32

Avinash Babu

6,2534 gold badges23 silver badges26 bronze badges

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

Comments

robue-a7119895 · Accepted Answer · 2014-08-03 12:14:09Z

0

error code 00000 means, you have no error. Just try to convert the errorCode to int and it will evaluate to false

answered Aug 3, 2014 at 12:14

robue-a7119895

8362 gold badges12 silver badges32 bronze badges

Collectives™ on Stack Overflow

PDO execute: Array to String conversion

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related