if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $search_term = isset($_POST['search_term']) ? $_POST['search_term'] : '';

    $query = "
    SELECT bilet_satis.*, satis_turleri.tur_adi AS satis_turu_adi, otobus_hareketleri.gidilecek_yer AS sefer_gidilecek_yer, otobus_hareketleri.hareket_saati
    FROM bilet_satis
    JOIN satis_turleri ON bilet_satis.satis_turu_id = satis_turleri.id
    JOIN otobus_hareketleri ON bilet_satis.sefer_id = otobus_hareketleri.id
    WHERE bilet_satis.id LIKE :search_term1
    OR satis_turleri.tur_adi LIKE :search_term2
    OR otobus_hareketleri.gidilecek_yer LIKE :search_term3
    OR bilet_satis.inilecek_yer LIKE :search_term4
    OR bilet_satis.tarih LIKE :search_term5
    OR bilet_satis.aciklama LIKE :search_term6
    OR bilet_satis.tutar LIKE :search_term7
    OR bilet_satis.odenen_tutar LIKE :search_term8
    OR bilet_satis.odeme_tipi LIKE :search_term9
    OR bilet_satis.pos_adi LIKE :search_term10
    ";

    $stmt = $pdo->prepare($query);
    $stmt->execute([
        'search_term1' => '%' . $search_term . '%',
        'search_term2' => '%' . $search_term . '%',
        'search_term3' => '%' . $search_term . '%',
        'search_term4' => '%' . $search_term . '%',
        'search_term5' => '%' . $search_term . '%',
        'search_term6' => '%' . $search_term . '%',
        'search_term7' => '%' . $search_term . '%',
        'search_term8' => '%' . $search_term . '%',
        'search_term9' => '%' . $search_term . '%',
        'search_term10' => '%' . $search_term . '%'
    ]);
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}