<?php
$config = require __DIR__ . '/../config.php';
$pdo = new PDO(
    "mysql:host={$config['host']};dbname={$config['name']};charset=utf8mb4",
    $config['user'],
    $config['pass'],
    [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);

$stmt = $pdo->query(
    "SELECT * FROM relationships
     WHERE you_followed_at IS NOT NULL
     AND they_followed_at IS NULL
     ORDER BY you_followed_at DESC"
);

header('Content-Type: application/json');
echo json_encode($stmt->fetchAll());