Так пробовал?
$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%");