Array has more params than PDO prepared statement causes error?
No, that's not supported BTW, when it comes to maintaining I always felt using the bindParam method results in much more readable code. Like this $STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )"); $STH->bindParam(':a', 'a'); $STH->bindParam(':b', 'b'); $STH->bindParam(':e', 'e'); $STH->execute().
No, that's not supported. BTW, when it comes to maintaining I always felt using the bindParam method results in much more readable code. Like this... $STH = $this->PDO->prepare("INSERT INTO table1 ( fieldA, fieldB, fieldE ) VALUES (:a, :b, :e )"); $STH->bindParam(':a', 'a'); $STH->bindParam(':b', 'b'); $STH->bindParam(':e', 'e'); $STH->execute().
Nit-picking: a: should be :a, same for b: and c: ... – VolkerK Aug 25 '10 at 21:52 thank you - corrected. – Oliver Aug 26 '10 at 4:55.
I wanted to create one array containing the data for all the params for all the queries. Is there a way to allow this? Or do have to create a different array each time?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
How do I set ORDER BY params using prepared PDO statement?
Trying to figure out PHP PDO prepared statements and placeholders. Placeholder in “IN” clause of MySQL statement?
PHP PDO Prepared statement query not updating record?
How can I return a pdo prepared statement to check if user exists, and then return there id from the database?
Pdo prepared statement doesn't update?
Mysql PDO Prepared statement efficiency?