Fri 07 Nov 2025 12:21:10 EET


```php
// ai_002.php
// Single-file SQLite3 HTML5 dashboard for managing 55 free-tier AI offers
// Features: Auto-creates DB/table, populates with 55 entries if empty, add/edit/delete, search, sortable columns, clickable hyperlinks
// Everything self-contained - no external dependencies

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

$db_file = 'ai_free_tiers.db';
$db = new SQLite3($db_file);

$db->exec('CREATE TABLE IF NOT EXISTS offers (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    url TEXT NOT NULL
)');

// Populate with 55 free-tier AI offers if table is empty
$res = $db->querySingle('SELECT COUNT(*) AS c FROM offers');
if ($res == 0) {
    $stmt = $db->prepare('INSERT INTO offers (name, url) VALUES (:name, :url)');
    $offers = [
        ['ChatGPT', 'https://chatgpt.com'],
        ['Google Gemini', 'https://gemini.google.com'],
        ['Anthropic Claude', 'https://claude.ai'],
        ['xAI Grok', 'https://grok.x.ai'],
        ['Perplexity AI', 'https://www.perplexity.ai'],
        ['Microsoft Copilot', 'https://copilot.microsoft.com'],
        ['Meta AI', 'https://www.meta.ai'],
        ['Mistral Le Chat', 'https://chat.mistral.ai'],
        ['Hugging Face Chat', 'https://huggingface.co/chat'],
        ['Poe', 'https://poe.com'],
        ['You.com', 'https://you.com'],
        ['Phind', 'https://www.phind.com'],
        ['Groq Chat', 'https://groq.com'],
        ['DeepSeek', 'https://platform.deepseek.com'],
        ['Google AI Studio', 'https://aistudio.google.com'],
        ['AIMLAPI', 'https://aimlapi.com'],
        ['Fal.ai', 'https://fal.ai'],
        ['Replicate', 'https://replicate.com'],
        ['Together AI', 'https://together.ai'],
        ['Blackbox AI', 'https://www.blackbox.ai'],
        ['Codeium', 'https://codeium.com'],
        ['Tabnine', 'https://www.tabnine.com'],
        ['Amazon CodeWhisperer', 'https://aws.amazon.com/codewhisperer/'],
        ['Grammarly', 'https://app.grammarly.com'],
        ['QuillBot', 'https://quillbot.com'],
        ['Wordtune', 'https://www.wordtune.com'],
        ['Canva Magic Studio', 'https://www.canva.com/ai-image-generator/'],
        ['Adobe Firefly', 'https://firefly.adobe.com'],
        ['ElevenLabs', 'https://elevenlabs.io'],
        ['Suno', 'https://suno.com'],
        ['Udio', 'https://www.udio.com'],
        ['Otter.ai', 'https://otter.ai'],
        ['Fireflies.ai', 'https://fireflies.ai'],
        ['Notion AI', 'https://www.notion.so/product/ai'],
        ['Mem.ai', 'https://get.mem.ai'],
        ['Gamma', 'https://gamma.app'],
        ['Tome', 'https://tome.app'],
        ['Beautiful.ai', 'https://www.beautiful.ai'],
        ['Pi.ai', 'https://pi.ai'],
        ['Runway', 'https://runwayml.com'],
        ['Pika', 'https://pika.art'],
        ['Luma Dream Machine', 'https://lumalabs.ai/dream-machine'],
        ['Kling AI', 'https://www.klingai.com'],
        ['Google Cloud Translation', 'https://cloud.google.com/translate'],
        ['Google Speech-to-Text', 'https://cloud.google.com/speech-to-text'],
        ['AWS AI Services', 'https://aws.amazon.com/free/ai/'],
        ['Azure AI', 'https://azure.microsoft.com/en-us/free/ai-services'],
        ['Oracle Cloud AI', 'https://www.oracle.com/cloud/free/'],
        ['IBM Watsonx', 'https://www.ibm.com/watsonx'],
        ['Eden AI', 'https://www.edenai.co'],
        ['Clarifai Community', 'https://clarifai.com'],
        ['Vercel AI Playground', 'https://play.vercel.ai'],
        ['Snowflake Cortex', 'https://www.snowflake.com/en/data-cloud/cortex/'],
        ['Databricks Mosaic AI', 'https://www.databricks.com/product/machine-learning'],
        ['Google Cloud Vertex AI', 'https://cloud.google.com/vertex-ai']
    ];
    foreach ($offers as $o) {
        $stmt->bindValue(':name', $o[0], SQLITE3_TEXT);
        $stmt->bindValue(':url', $o[1], SQLITE3_TEXT);
        $stmt->execute();
    }
    $stmt->close();
}

// Handle delete
if (isset($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    $db->exec("DELETE FROM offers WHERE id = $id");
    header('Location: ai_002.php' . (isset($_GET['search']) ? '?search=' . urlencode($_GET['search']) : ''));
    exit;
}

// Handle add
if (isset($_POST['action']) && $_POST['action'] === 'add') {
    $name = trim($_POST['name']);
    $url  = trim($_POST['url']);
    if ($name && $url) {
        $stmt = $db->prepare('INSERT INTO offers (name, url) VALUES (:name, :url)');
        $stmt->bindValue(':name', $name, SQLITE3_TEXT);
        $stmt->bindValue(':url', $url, SQLITE3_TEXT);
        $stmt->execute();
    }
    header('Location: ai_002.php' . (isset($_GET['search']) ? '?search=' . urlencode($_GET['search']) : ''));
    exit;
}

// Handle update
if (isset($_POST['action']) && $_POST['action'] === 'update') {
    $id   = (int)$_POST['id'];
    $name = trim($_POST['name']);
    $url  = trim($_POST['url']);
    if ($id && $name && $url) {
        $stmt = $db->prepare('UPDATE offers SET name = :name, url = :url WHERE id = :id');
        $stmt->bindValue(':name', $name, SQLITE3_TEXT);
        $stmt->bindValue(':url', $url, SQLITE3_TEXT);
        $stmt->bindValue(':id', $id, SQLITE3_INTEGER);
        $stmt->execute();
    }
    header('Location: ai_002.php' . (isset($_GET['search']) ? '?search=' . urlencode($_GET['search']) : ''));
    exit;
}

// Search & sort
$search = isset($_GET['search']) ? trim($_GET['search']) : '';
$sort   = isset($_GET['sort']) && in_array($_GET['sort'], ['id','name','url']) ? $_GET['sort'] : 'id';
$order  = isset($_GET['order']) && $_GET['order'] === 'desc' ? 'DESC' : 'ASC';

$where = $search ? 'WHERE name LIKE :search OR url LIKE :search' : '';
$query = "SELECT * FROM offers $where ORDER BY $sort $order";
$stmt  = $db->prepare($query);
if ($search) {
    $stmt->bindValue(':search', '%' . $db->escapeString($search) . '%', SQLITE3_TEXT);
}
$result = $stmt->execute();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Free Tier AI Offers Dashboard</title>
    <style>
        body {font-family: Arial, sans-serif; margin: 20px; background: #f9f9f9;}
        h1 {text-align: center;}
        .container {max-width: 1200px; margin: auto; background: white; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0,0,0,0.1);}
        table {width: 100%; border-collapse: collapse; margin-top: 20px;}
        th, td {border: 1px solid #ddd; padding: 12px; text-align: left;}
        th {background: #007bff; color: white; cursor: pointer;}
        th:hover {background: #0056b3;}
        tr:nth-child(even) {background: #f2f2f2;}
        a {color: #007bff; text-decoration: none;}
        a:hover {text-decoration: underline;}
        .actions {white-space: nowrap;}
        .form-inline {display: inline;}
        input[type=text], input[type=url] {width: 100%; padding: 8px; margin: 4px 0; box-sizing: border-box;}
        input[type=submit] {background: #28a745; color: white; padding: 8px 12px; border: none; cursor: pointer;}
        input[type=submit]:hover {background: #218838;}
        .search-box {margin: 20px 0; text-align: center;}
        .add-form {background: #e9ecef; padding: 15px; border-radius: 8px; margin: 20px 0;}
    </style>
    <script>
        function toggleEdit(id) {
            document.getElementById('view-'+id).style.display = 'none';
            document.getElementById('edit-'+id).style.display = 'table-row';
        }
        function cancelEdit(id) {
            document.getElementById('edit-'+id).style.display = 'none';
            document.getElementById('view-'+id).style.display = 'table-row';
        }
        function sort(col) {
            const url = new URL(window.location);
            const current = url.searchParams.get('sort');
            const order = (current === col && url.searchParams.get('order') !== 'desc') ? 'desc' : 'asc';
            url.searchParams.set('sort', col);
            url.searchParams.set('order', order);
            window.location = url;
        }
    </script>
</head>
<body>
<div class="container">
    <h1>55 Free Tier AI Offers - Editable Dashboard</h1>

    <div class="search-box">
        <form method="get">
            <input type="text" name="search" value="<?php echo htmlspecialchars($search); ?>" placeholder="Search name or URL..." size="50">
            <input type="submit" value="Search">
            <?php if ($search): ?><a href="ai_002.php">Clear</a><?php endif; ?>
        </form>
    </div>

    <div class="add-form">
        <h2>Add New Offer</h2>
        <form method="post">
            <input type="hidden" name="action" value="add">
            Name: <input type="text" name="name" required placeholder="Service name">
            URL: <input type="url" name="url" required placeholder="https://...">
            <input type="submit" value="Add Offer">
        </form>
    </div>

    <table>
        <thead>
            <tr>
                <th onclick="sort('id')">#</th>
                <th onclick="sort('name')">Name</th>
                <th onclick="sort('url')">URL</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            <?php $num = 1; while ($row = $result->fetchArray(SQLITE3_ASSOC)): ?>
                <tr id="view-<?php echo $row['id']; ?>">
                    <td><?php echo $num++; ?></td>
                    <td><?php echo htmlspecialchars($row['name']); ?></td>
                    <td><a href="<?php echo htmlspecialchars($row['url']); ?>" target="_blank"><?php echo htmlspecialchars($row['url']); ?></a></td>
                    <td class="actions">
                        <button onclick="toggleEdit(<?php echo $row['id']; ?>)">Edit</button>
                        <a href="ai_002.php?delete=<?php echo $row['id']; ?>&search=<?php echo urlencode($search); ?>"
                           onclick="return confirm('Delete this offer?')">Delete</a>
                    </td>
                </tr>
                <tr id="edit-<?php echo $row['id']; ?>" style="display:none; background:#fffacd;">
                    <td colspan="4">
                        <form method="post" class="form-inline">
                            <input type="hidden" name="action" value="update">
                            <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                            Name: <input type="text" name="name" value="<?php echo htmlspecialchars($row['name']); ?>" required>
                            URL: <input type="url" name="url" value="<?php echo htmlspecialchars($row['url']); ?>" required>
                            <input type="submit" value="Update">
                            <button type="button" onclick="cancelEdit(<?php echo $row['id']; ?>)">Cancel</button>
                        </form>
                    </td>
                </tr>
            <?php endwhile; ?>
        </tbody>
    </table>
</div>
</body>
</html>
<?php
$db->close();
?>
```

Save this entire content as **ai_002.php** on your server.
Open it in a browser - it will automatically create the SQLite database, populate 55 free-tier AI offers with clickable hyperlinks, and provide a full HTML5 dashboard for searching, sorting, adding, editing, and deleting entries. No additional setup required.