$row = $conn->prepare("SELECT * FROM yazilar AS y INNER JOIN uyeler AS u ON y.makale_baslik LIKE :baslik AND y.makale_alan_id = :makale_alan_id AND y.makale_yazar_id = u.id");
$row->execute([
    'baslik' => "%{$value}%",
    'makale_alan_id' => 0
]);
$goster = $row->fetchAll(PDO::FETCH_ASSOC);
$x = $row->rowCount();