function lotSearch ($connect, $search) {

    $sql = "SELECT lots.id, lots.title, categories.title AS cats_title, price, description, open_date, close_date, image_path, is_open FROM lots " .
           "JOIN categories ON lots.category_id = categories.id " .
           "WHERE is_open = 1 AND lots.title LIKE %?% OR description LIKE %?% ORDER BY open_date DESC";

    $stmt = mysqli_prepare($connect, $sql);

    mysqli_stmt_bind_param($stmt, "ss", $search, $search);

    mysqli_stmt_execute($stmt);

    mysqli_stmt_bind_result($stmt, $lots_id, $lots_title, $cats_title, $price, $description, $open_date, $close_date, $image_path, $is_open);

    $lots_search = [];

    while (mysqli_stmt_fetch($stmt)) {

        $lots_search[] = [

            'id' => $lots_id,
            'title' => $lots_title,
            'cats_title' => $cats_title,
            'price' => $price,
            'description' => $description,
            'open_date' => $open_date,
            'close_date' => $close_date,
            'image_path' => $image_path,
            'is_open' => $is_open,

        ];

    };

    return $lots_search;

};