帮我一个链接My SQL的前端代码,并能通过简单的登录页面进行登录后进行修改数据库
时间: 2024-05-06 17:17:27 浏览: 5
这里给您提供一个简单的MySQL前端代码,可以通过登录页面进行登录后进行对数据库的增删改查操作:
index.html:
```html
<!DOCTYPE html>
<html>
<head>
<title>Login</title>
</head>
<body>
<h2>Login</h2>
<form action="login.php" method="POST">
<label>Username:</label>
<input type="text" name="username" required><br><br>
<label>Password:</label>
<input type="password" name="password" required><br><br>
<button type="submit">Login</button>
</form>
</body>
</html>
```
login.php:
```php
<?php
session_start();
if(isset($_POST['username']) && isset($_POST['password'])){
$username = $_POST['username'];
$password = $_POST['password'];
//connect to database
$host = 'localhost';
$dbname = 'mydb';
$user = 'root';
$pass = '';
$dsn = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
throw new \PDOException($e->getMessage(), (int)$e->getCode());
}
//check if user exists
$stmt = $pdo->prepare("SELECT * FROM users WHERE username=? AND password=?");
$stmt->execute([$username, $password]);
$user = $stmt->fetch();
if($user){
$_SESSION['user_id'] = $user['id'];
header("Location: dashboard.php");
exit();
} else {
echo "Invalid username or password!";
}
}
?>
```
dashboard.php:
```php
<?php
session_start();
if(!isset($_SESSION['user_id'])){
header("Location: index.html");
exit();
}
//connect to database
$host = 'localhost';
$dbname = 'mydb';
$user = 'root';
$pass = '';
$dsn = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
throw new \PDOException($e->getMessage(), (int)$e->getCode());
}
//insert data
if(isset($_POST['insert'])){
$name = $_POST['name'];
$email = $_POST['email'];
$stmt = $pdo->prepare("INSERT INTO users(name, email) VALUES (?,?)");
$stmt->execute([$name, $email]);
echo "Data inserted successfully!";
}
//update data
if(isset($_POST['update'])){
$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$stmt = $pdo->prepare("UPDATE users SET name=?, email=? WHERE id=?");
$stmt->execute([$name, $email, $id]);
echo "Data updated successfully!";
}
//delete data
if(isset($_POST['delete'])){
$id = $_POST['id'];
$stmt = $pdo->prepare("DELETE FROM users WHERE id=?");
$stmt->execute([$id]);
echo "Data deleted successfully!";
}
//fetch data
$stmt = $pdo->query("SELECT * FROM users");
$users = $stmt->fetchAll();
?>
<!DOCTYPE html>
<html>
<head>
<title>Dashboard</title>
</head>
<body>
<h2>Welcome <?php echo $user['username']; ?></h2>
<a href="logout.php">Logout</a><br><br>
<h3>Insert Data</h3>
<form action="" method="POST">
<label>Name:</label>
<input type="text" name="name" required><br><br>
<label>Email:</label>
<input type="email" name="email" required><br><br>
<button type="submit" name="insert">Insert</button>
</form><br><br>
<h3>Update Data</h3>
<form action="" method="POST">
<label>ID:</label>
<input type="text" name="id" required><br><br>
<label>Name:</label>
<input type="text" name="name" required><br><br>
<label>Email:</label>
<input type="email" name="email" required><br><br>
<button type="submit" name="update">Update</button>
</form><br><br>
<h3>Delete Data</h3>
<form action="" method="POST">
<label>ID:</label>
<input type="text" name="id" required><br><br>
<button type="submit" name="delete">Delete</button>
</form><br><br>
<h3>User List</h3>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
</tr>
<?php foreach($users as $user){ ?>
<tr>
<td><?php echo $user['id']; ?></td>
<td><?php echo $user['name']; ?></td>
<td><?php echo $user['email']; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
```
logout.php:
```php
<?php
session_start();
session_destroy();
header("Location: index.html");
exit();
?>
```
请注意,这个代码只是一个简单的例子,不适用于生产环境。在实际使用时,需要进行严格的输入验证和安全性检查。