CREATE DATABASE mydatabase;
USE mydatabase;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL
);
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
prepare("INSERT INTO users (name, email) VALUES (?, ?)");
$stmt->bind_param("ss", $name, $email);
$stmt->execute();
$stmt->close();
header('Location: users.php');
exit();
}
?>
Create User
Create User
query("SELECT * FROM users");
?>
Users
Users
Create New User
| ID |
Name |
Email |
Actions |
fetch_assoc()): ?>
|
|
|
Edit
Delete
|
prepare("UPDATE users SET name = ?, email = ? WHERE id = ?");
$stmt->bind_param("ssi", $name, $email, $id);
$stmt->execute();
$stmt->close();
header('Location: users.php');
exit();
}
$result = $conn->query("SELECT * FROM users WHERE id = $id");
$user = $result->fetch_assoc();
?>
Edit User
Edit User
prepare("DELETE FROM users WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->close();
header('Location: users.php');
exit();
?>
Login
Login