prepare("INSERT INTO investors (name, email, phone, entity_name, accreditation_status) VALUES (?, ?, ?, ?, ?)"); $stmt->execute([$name, $email, $phone, $entity_name, $accreditation_status]); $message = 'Investor added successfully!'; $message_type = 'success'; } catch (PDOException $e) { if ($e->getCode() == 23000) { // Integrity constraint violation (duplicate email) $message = 'An investor with this email already exists.'; $message_type = 'danger'; } else { $message = 'Error adding investor: ' . $e->getMessage(); $message_type = 'danger'; } } } } $investors = $pdo->query("SELECT * FROM investors ORDER BY created_at DESC")->fetchAll(); ?>
| Name | Phone | Entity | Status | |
|---|---|---|---|---|
| No investors found. | ||||
| = htmlspecialchars($investor['name']) ?> | = htmlspecialchars($investor['email']) ?> | = htmlspecialchars($investor['phone']) ?> | = htmlspecialchars($investor['entity_name']) ?> | = htmlspecialchars($investor['accreditation_status']) ?> |