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. http://ch1.php.net/manual/en/pdo.errorinfo.php — Charlotte Dunois, Aug 03 '14 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('test@test.com') #1 {main} thrown in C:\...\customer.dao.php on line 107 — Sauerbrei, Aug 03 '14 at 12:25

score 1 · Accepted Answer · edited May 23 '17 at 10:33

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 '17 at 10:33

Community

1
1

answered Aug 03 '14 at 13:32

Avinash Babu

6,171
3
21
26

score 0 · Answer 2 · answered Aug 03 '14 at 12:14

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 03 '14 at 12:14

robue-a7119895

816
2
11
31

PDO execute: Array to String conversion

2 Answers2