Dashboard Temp Share Shortlinks Frames API

HTMLify

queries.html
Views: 41 | Author: karbonsites 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>SQL Editor - RowSQL</title>
    <link rel="stylesheet" href="style.css">
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@100..900&display=swap" rel="stylesheet">
</head>
<body>
    <aside class="sidebar">
        <div class="logo">RowSQL</div>
        <nav class="nav-main">
            <a href="index.html" class="nav-item"><span class="icon">📊</span> Dashboard</a>
            <a href="tables.html" class="nav-item"><span class="icon">🗄️</span> Tables</a>
            <a href="queries.html" class="nav-item active"><span class="icon">🔍</span> Queries</a>
            <a href="settings.html" class="nav-item"><span class="icon">⚙️</span> Settings</a>
        </nav>
        <div class="user-profile">
            <div class="avatar">JD</div>
            <div class="user-info">Jane Doe <span class="status">Online</span></div>
        </div>
    </aside>

    <main class="dashboard-container">
        <header class="header">
            <h1 class="dashboard-title">SQL Query Editor</h1>
            <div class="header-actions">
                <button class="btn-primary" id="runQueryBtn"><span class="icon">▶️</span> Run Query</button>
            </div>
        </header>

        <section class="section query-editor-area fade-in-up">
            <h2>SQL Input</h2>
            <textarea id="sqlEditor" placeholder="SELECT * FROM users_production WHERE status = 'active' LIMIT 10;">
SELECT 
    t1.user_id, 
    t1.email, 
    t2.last_login
FROM 
    users_production t1
JOIN 
    user_metrics t2 ON t1.user_id = t2.user_id;
            </textarea>
            <div class="editor-footer">
                <span id="queryStatus">Ready to execute.</span>
            </div>
        </section>

        <section class="section query-results fade-in-up" data-delay="0.3">
            <h2>Results (<span id="rowCount">0</span> Rows)</h2>
            <div class="table-responsive">
                <table class="data-table results-table">
                    <thead>
                        <tr>
                            <th>user_id</th>
                            <th>email</th>
                            <th>last_login</th>
                        </tr>
                    </thead>
                    <tbody id="queryResultsBody">
                        <tr id="loadingRow" style="display:none;"><td colspan="3" class="loading-text">Executing query... Please wait.</td></tr>
                        <!-- Results will be inserted here -->
                    </tbody>
                </table>
            </div>
        </section>

    </main>

    <script src="script.js"></script>
</body>
</html>

Share this file: