connect_error) die(“Connection failed: ” . $conn->connect_error);
// Add company
if (isset($_POST[‘add’])) {
$name = $conn->real_escape_string($_POST[‘name’]);
if (!empty($name)) {
$conn->query(“INSERT INTO companies (name) VALUES (‘$name’)”);
}
}
// Update company
if (isset($_POST[‘update’])) {
$id = intval($_POST[‘id’]);
$name = $conn->real_escape_string($_POST[‘name’]);
if ($id && !empty($name)) {
$conn->query(“UPDATE companies SET name = ‘$name’ WHERE id = $id”);
}
}
// Delete company
if (isset($_POST[‘delete’])) {
$id = intval($_POST[‘id’]);
if ($id) {
$conn->query(“DELETE FROM companies WHERE id = $id”);
}
}
// Fetch companies
$result = $conn->query(“SELECT * FROM companies”);
?>
Company Manager
Manage Companies
Existing Companies
| ID |
Company Name |
Actions |
fetch_assoc()): ?>