0

I have a little problem with my SQL query:

I have a variable ($arraySearch) with a string:

$arraySearch = "'Bob', 'Ross'";

My PHP query:

$stmt = $this->pdo->prepare("SELECT * FROM `kunden` WHERE `FAMNAME` IN (arraySearch =:arraySearch) AND `VORNAME` IN (arraySearch = :arraySearch)");

$stmt->execute(['arraySearch' => $arraySearch]);

$all = $stmt->fetchAll(PDO::FETCH_CLASS, $model);

Error Code:

Fatal error: Uncaught Error: Call to a member function execute() on boolean

I've been searching for the error for hours but I can't find it.

What am I missing?

Does somebody have any idea?

best regards

bitcodr
  • 1,395
  • 5
  • 21
  • 44
Pesi
  • 81
  • 1
  • 6
  • $stmt->execute([$arraySearch]); or $stmt->execute(array('arraySearch' => $arraySearch)); –  Jan 02 '20 at 14:54
  • you have a syntax error to start with ... `(arraySearch =:arraySearch)` – treyBake Jan 02 '20 at 14:55
  • Since the array search is `'Bob', 'Ross'` ... is this really an error rather than a *happy little accident*? – CD001 Jan 02 '20 at 14:58

0 Answers0