Error "Array to string conversion in" with mysqli bind_param

Question

$searchTerm = isset($_GET['txtSearch']) ? $_GET['txtSearch'] : '';
$searchTerm = strtolower($searchTerm);
$searchTerm = strip_tags($searchTerm);
$searchTerm = trim($searchTerm," "); 

$keywords = explode(" ",$searchTerm); // break down search term into individual keywords

$in = join(',', array_fill(0, count($keywords), '?'));
$select = <<<SQL
    SELECT * 
    FROM m_products
    WHERE product_title IN ($in);
SQL;
$statement = $con->prepare($select);
$statement->bind_param(str_repeat('s', count($$keywords)), ...$keywords); //s = string, d = double, i = integer
$statement->execute();

I'm getting the following error from the above code:

Notice: Array to string conversion in

Notice: Undefined variable: Array in

Warning: mysqli_stmt::bind_param(): Invalid type or no types specified in

How do I solve this error?

$statement->bind_param(str_repeat('s', count($$keywords)), ...$keywords); has a double $$ sign — Deathstorm
– Deathstorm, Commented Jun 9, 2017 at 11:06
Thanks I corrected the double $$ sign and now error is solved. — Gp Master
– Gp Master, Commented Jun 9, 2017 at 11:14

Deathstorm · Accepted Answer · 2017-06-09 11:16:16Z

1

As i've told in the comments above:

$statement->bind_param(str_repeat('s', count($$keywords)), ...$keywords); //s = string, d = double, i = integer

has a double $$ in the count($$keywords)) remove one $ and the error should be resolved.

answered Jun 9, 2017 at 11:16

Deathstorm

86713 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Error "Array to string conversion in" with mysqli bind_param

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