Почему запрос prepare не работает с like?

Question

[Tema Ovchinnikov]

Выдаёт ошибку Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in

$search_articles = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_title LIKE '%?%'");

		mysqli_stmt_bind_param($search_articles, 's', $search);

пробовал %?% выдаёт Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in

этот работает как не странно

$post_old = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_link = ? LIMIT 1");

		mysqli_stmt_bind_param($post_old, "s", $param_name_article);

Answer 1

[Олег]

Так пробовал?

$search_articles = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_title LIKE ?");

    mysqli_stmt_bind_param($search_articles, 's', "%$search%");

Comments

[Tema Ovchinnikov]

Спасибо огромное вам. Но это наверное в mysql дело или может на хостинге заработает

apache 2-4, php 5.6 mysql 5.7 open server

object(mysqli_stmt)#2 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(1) ["field_count"]=> int(9) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(1) } Ошибка запроса!

mysql воспринимает запрос почему-то только '%$search%' так у меня работало без prepare

$search_articles = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_title LIKE ?");

		mysqli_stmt_bind_param($search_articles, '%s%', $search);

Warning: mysqli_stmt_bind_param(): Number of elements in type definition string doesn't match number of bind variables in

Answer 2

[romy4]

а почему бы там не оставить просто ?, а в параметр добавить % %

Comments

[Tema Ovchinnikov]

Parse error: syntax error, unexpected '%' in

LIKE ?");

		mysqli_stmt_bind_param($search_articles, 's', %$search%);

%{$search}%

'%'.$search.'%'

Only variables can be passed by reference in

LIKE ?");

		mysqli_stmt_bind_param($search_articles, 's', $search);

работает но не ищет вообще по запросу

[romy4]

Tema Ovchinnikov: так в чём проблема с ошибкой?
Only variables can be passed by reference in