API Design

Traffic Elf uses simple PHP-based JSON APIs.

• Simple endpoints
• Readable JSON
• No framework dependency (initially)

Endpoint:

/api/clients.php

<?php
require 'db.php';
 
$stmt = $pdo->query("SELECT * FROM clients ORDER BY name");
echo json_encode($stmt->fetchAll());

Endpoint:

/api/campaigns.php

<?php
require 'db.php';
 
$stmt = $pdo->query("SELECT * FROM campaigns ORDER BY start_date DESC");
echo json_encode($stmt->fetchAll());

fetch('/api/clients.php')
  .then(res => res.json())
  .then(data => renderGrid(data));