GPT

Basic Database Operations

// src/pages/users.astro import { sql } from '../lib/db'; interface User { id: number; name: string; email: string; } let users: User[] = []; let error: string | null = null; try { users = await sql SELECT id, n

Prompt text

Original English text. Replace placeholders with your own details.

---
// src/pages/users.astro
import { sql } from '../lib/db';

interface User {
 id: number;
 name: string;
 email: string;
}

let users: User[] = [];
let error: string | null = null;

try {
 users = await sql<User[]>`
 SELECT id, name, email
 FROM users
 ORDER BY name ASC
 `;
} catch (e: any) {
 error = e.message;
}
---

<div>
 <h1>Users</h1>
 
 {error && <div class="error">{error}</div>}
 
 <ul>
 {users.map((user) => (
 <li>
 {user.name} ({user.email})
 <form method="POST" action="/api/users/delete">
 <input type="hidden" name="id" value={user.id} />
 <button type="submit">Delete</button>
 </form>
 </li>
 ))}
 </ul>

 <form method="POST" action="/api/users/create">
 <input type="text" name="name" placeholder="Name" required />
 <input type="email" name="email" placeholder="Email" required />
 <button type="submit">Add User</button>
 </form>
</div>

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →