Contoh ini menggunakan sambungan MySQLi untuk melaksanakan operasi pangkalan data.
Jalankan skrip SQL berikut untuk mencipta pangkalan data dan jadual yang dipanggil pengguna:
CREATE DATABASE crud_example;
USE crud_example;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE
);
Buat fail config.php untuk mengurus sambungan pangkalan data:
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "crud_example";
// Conexão com o banco
$conn = new mysqli($servername, $username, $password, $dbname);
// Verifica conexão
if ($conn->connect_error) {
die("Falha na conexão: " . $conn->connect_error);
}
?>
Buat fail index.php untuk menyenaraikan pengguna dan menambah fungsi penciptaan, penyuntingan dan pemadaman:
<?php
include 'config.php';
// Leitura dos dados
$sql = "SELECT * FROM users";
$result = $conn->query($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>CRUD em PHP</title>
</head>
<body>
<h1>Lista de Usuários</h1>
<a href="create.php">Adicionar Novo Usuário</a>
<table border="1">
<tr>
<th>ID</th>
<th>Nome</th>
<th>Email</th>
<th>Ações</th>
</tr>
<?php while ($row = $result->fetch_assoc()) { ?>
<tr>
<td><?= $row['id'] ?></td>
<td><?= $row['name'] ?></td>
<td><?= $row['email'] ?></td>
<td>
<a href="edit.php?id=<?= $row['id'] ?>">Editar</a>
<a href="delete.php?id=<?= $row['id'] ?>" onclick="return confirm('Tem certeza que deseja excluir?')">Excluir</a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
Buat fail create.php untuk menambah pengguna baharu:
<?php
include 'config.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_POST['name'];
$email = $_POST['email'];
$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
if ($conn->query($sql) === TRUE) {
header("Location: index.php");
exit;
} else {
echo "Erro: " . $conn->error;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Criar Usuário</title>
</head>
<body>
<h1>Adicionar Novo Usuário</h1>
<form method="POST">
<label for="name">Nome:</label>
<input type="text">
<hr>
<h3>
Passo 5: Editar Usuário
</h3>
<p>Crie um arquivo edit.php para editar um usuário existente:<br>
</p>
<pre class="brush:php;toolbar:false"><?php
include 'config.php';
$id = $_GET['id'];
$sql = "SELECT * FROM users WHERE id = $id";
$result = $conn->query($sql);
$user = $result->fetch_assoc();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_POST['name'];
$email = $_POST['email'];
$sql = "UPDATE users SET name='$name', email='$email' WHERE>
<hr>
<h3>
Passo 6: Excluir Usuário
</h3>
<p>Crie um arquivo delete.php para excluir um usuário:<br>
</p>
<pre class="brush:php;toolbar:false"><?php
include 'config.php';
$id = $_GET['id'];
$sql = "DELETE FROM users WHERE>
<hr>
<h3>
Como Rodar o Projeto
</h3>
<ol>
<li>Configure o servidor local (como XAMPP ou LAMP).</li>
<li>Coloque todos os arquivos em uma pasta dentro do diretório público (htdocs ou equivalente).</li>
<li>Acesse http://localhost/sua_pasta/index.php no navegador.</li>
</ol>
<p>Esse é um CRUD básico e pode ser melhorado com validações, segurança (como SQL Injection), e estruturação MVC.</p>
<hr>
<h2>
CRUD usando PHP e MySQL, estruturado de forma <strong>orientada a objetos (OOP)</strong>
</h2>
<p>A abordagem inclui uma classe para gerenciar as operações do banco de dados e separação lógica.</p>
<hr>
<h3>
Passo 1: Configuração da Conexão com o Banco
</h3>
<p>Crie um arquivo Database.php para encapsular a conexão com o banco:<br>
</p>
<pre class="brush:php;toolbar:false"><?php
class Database {
private $host = "localhost";
private $user = "root";
private $pass = "";
private $dbname = "crud_example";
public $conn;
public function __construct() {
$this->conn = new mysqli($this->host, $this->user, $this->pass, $this->dbname);
if ($this->conn->connect_error) {
die("Erro na conexão: " . $this->conn->connect_error);
}
}
}
?>
Buat fail User.php untuk mengurus operasi CRUD:
<?php
include 'Database.php';
class User {
private $db;
public function __construct() {
$this->db = (new Database())->conn;
}
// Create
public function create($name, $email) {
$stmt = $this->db->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
$stmt->bind_param("ss", $name, $email);
return $stmt->execute();
}
// Read
public function getAll() {
$result = $this->db->query("SELECT * FROM users");
return $result->fetch_all(MYSQLI_ASSOC);
}
public function getById($id) {
$stmt = $this->db->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
return $stmt->get_result()->fetch_assoc();
}
// Update
public function update($id, $name, $email) {
$stmt = $this->db->prepare("UPDATE users SET name = ?, email = ? WHERE id = ?");
$stmt->bind_param("ssi", $name, $email, $id);
return $stmt->execute();
}
// Delete
public function delete($id) {
$stmt = $this->db->prepare("DELETE FROM users WHERE id = ?");
$stmt->bind_param("i", $id);
return $stmt->execute();
}
}
?>
Buat fail index.php untuk memaparkan senarai pengguna dan uruskan navigasi:
<?php
include 'User.php';
$user = new User();
$users = $user->getAll();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>CRUD OOP PHP</title>
</head>
<body>
<h1>Lista de Usuários</h1>
<a href="create.php">Adicionar Novo Usuário</a>
<table border="1">
<tr>
<th>ID</th>
<th>Nome</th>
<th>Email</th>
<th>Ações</th>
</tr>
<?php foreach ($users as $u) { ?>
<tr>
<td><?= $u['id'] ?></td>
<td><?= $u['name'] ?></td>
<td><?= $u['email'] ?></td>
<td>
<a href="edit.php?id=<?= $u['id'] ?>">Editar</a>
<a href="delete.php?id=<?= $u['id'] ?>" onclick="return confirm('Deseja excluir este usuário?')">Excluir</a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
Buat fail create.php untuk menambah pengguna baharu:
<?php
include 'User.php';
$user = new User();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_POST['name'];
$email = $_POST['email'];
if ($user->create($name, $email)) {
header("Location: index.php");
exit;
} else {
echo "Erro ao criar usuário.";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Criar Usuário</title>
</head>
<body>
<h1>Adicionar Novo Usuário</h1>
<form method="POST">
<label for="name">Nome:</label>
<input type="text">
<hr>
<h3>
Passo 5: Editar Usuário
</h3>
<p>Crie um arquivo edit.php para atualizar os dados do usuário:<br>
</p>
<pre class="brush:php;toolbar:false"><?php
include 'User.php';
$user = new User();
$id = $_GET['id'];
$data = $user->getById($id);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_POST['name'];
$email = $_POST['email'];
if ($user->update($id, $name, $email)) {
header("Location: index.php");
exit;
} else {
echo "Erro ao atualizar usuário.";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Editar Usuário</title>
</head>
<body>
<h1>Editar Usuário</h1>
<form method="POST">
<label for="name">Nome:</label>
<input type="text">
<hr>
<h3>
Passo 6: Excluir Usuário
</h3>
<p>Crie um arquivo delete.php para deletar um usuário:<br>
</p>
<pre class="brush:php;toolbar:false"><?php
include 'User.php';
$user = new User();
$id = $_GET['id'];
if ($user->delete($id)) {
header("Location: index.php");
exit;
} else {
echo "Erro ao excluir usuário.";
}
?>
Contoh ini ialah asas untuk CRUD berorientasikan objek dan boleh dipertingkatkan dengan amalan baik, seperti pengesahan input, pengendalian ralat yang lebih mantap dan penggunaan ruang nama.
Berikut ialah contoh cara mencipta dua API dalam PHP: satu API belakang untuk digunakan dan satu lagi sebagai klien untuk menggunakan API pertama.
Buat jadual pengguna dalam pangkalan data:
CREATE DATABASE api_example;
USE api_example;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE
);
Buat fail bernama api.php untuk menyediakan titik akhir.
<?php
header("Content-Type: application/json");
include 'Database.php';
class UserAPI {
private $db;
public function __construct() {
$this->db = (new Database())->conn;
}
public function handleRequest() {
$method = $_SERVER['REQUEST_METHOD'];
$endpoint = $_GET['endpoint'] ?? '';
switch ($endpoint) {
case 'users':
if ($method === 'GET') {
$this->getUsers();
} elseif ($method === 'POST') {
$this->createUser();
} else {
$this->response(405, "Method Not Allowed");
}
break;
default:
$this->response(404, "Endpoint Not Found");
}
}
private function getUsers() {
$result = $this->db->query("SELECT * FROM users");
$users = $result->fetch_all(MYSQLI_ASSOC);
$this->response(200, $users);
}
private function createUser() {
$input = json_decode(file_get_contents("php://input"), true);
if (empty($input['name']) || empty($input['email'])) {
$this->response(400, "Missing required fields: name or email");
return;
}
$stmt = $this->db->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
$stmt->bind_param("ss", $input['name'], $input['email']);
if ($stmt->execute()) {
$this->response(201, "User created successfully");
} else {
$this->response(500, "Internal Server Error");
}
}
private function response($status, $data) {
http_response_code($status);
echo json_encode(["status" => $status, "data" => $data]);
}
}
$api = new UserAPI();
$api->handleRequest();
?>
Buat fail bernama client.php untuk menggunakan API bahagian belakang.
CREATE DATABASE crud_example;
USE crud_example;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE
);
Contoh ini ialah asas berfungsi. Untuk pengeluaran, adalah disyorkan:
Jika anda sedang bersiap untuk temu duga teknikal untuk pembangun junior dengan PHP dan MySQL, berikut ialah topik utama yang biasanya diliputi, serta beberapa petua:
Syarikat junior juga menilai kemahiran insaniah. Sediakan untuk soalan seperti:
Atas ialah kandungan terperinci CRUD PHP dan MySQL dan API dan Asas Penting. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!
Perbezaan antara fungsi besar dan fungsi maksimum
Bagaimana untuk melaksanakan teknologi kontena docker di java
Apakah yang perlu saya lakukan jika saya terlupa kata laluan jalur lebar saya?
Adakah terdapat perbezaan besar antara bahasa c dan Python?
python menggabungkan dua senarai
Apakah fungsi rangkaian komputer
Perbezaan antara recv dan recvfrom
Bagaimana untuk menangani aksara Cina yang kacau dalam Linux
![[Web front-end] Permulaan pantas Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
