Home > Article > Backend Development > How to create a simple PHP project using the HBuilder editor
How to create a simple PHP project using the HBuilder editor
- PHPzOriginal
- 2023-04-06 09:13:041588browse
PHP is a very popular programming language used to develop many web applications. In this article, we will learn how to use the HBuilder editor to create a simple PHP project, including adding, deleting, and modifying operations.
In order to start writing PHP code, you need to install PHP and the HBuilder editor. You can download PHP from the official website and HBuilder editor from here and install them on your computer.
Step One: Create HTML File
First, we will create an HTML file that will serve as the home page of our web application. Create a file named "index.html" under HBuilder, which should include the following HTML code:
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>简单 PHP 项目：增删改 HBuilder</title> </head> <body> <h1>欢迎来到我的简单 PHP 项目</h1> <p>这个项目包括增删改功能。</p> </body> </html>
This HTML file will serve as the home page of our web application and contain basic information about the project.
Step 2: Create a database
Next, we need to create a MySQL database instance to store our data. We will use the phpMyAdmin tool to create and manage our database.
Using the tool, create a database named "php_project" and create a table named "users" with the following fields:
- id: for unique Identify each user;
- name: the user’s name;
- email: the user’s email address;
- phone: the user’s phone number;
Step 3: Create a PHP file
Now, we will create a PHP file to connect to the database and perform operations such as select, insert, update, and delete. Create a file called "index.php" in the HBuilder editor and use the following code:
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "php_project";
$conn = mysqli_connect($host, $user, $password, $database);
if(!$conn){
die("<h3>连接数据库失败：" . mysqli_connect_error() . "</h3>");
}
echo "<h3>成功连接到数据库！</h3>";
?>
This code will connect to the database and display a message, if the connection is successful, it will display "Successful connection To database!" message.
Next, let’s write the code to select, insert, update, and delete users:
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "php_project";
$conn = mysqli_connect($host, $user, $password, $database);
if(!$conn){
die("<h3>连接数据库失败：" . mysqli_connect_error() . "</h3>");
}
// 选择用户
$select_query = "SELECT * FROM users";
$result = mysqli_query($conn, $select_query);
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
echo "<p>ID：" . $row['id'] . "<br>";
echo "名称：" . $row['name'] . "<br>";
echo "邮箱：" . $row['email'] . "<br>";
echo "电话：" . $row['phone'] . "<br></p>";
}
}else{
echo "<p>没有找到用户。</p>";
}
// 插入新用户
$name = "张三";
$email = "zhangsan@example.com";
$phone = "13111111111";
$insert_query = "INSERT INTO users (name, email, phone) VALUES ('$name', '$email', '$phone')";
if(mysqli_query($conn, $insert_query)){
echo "<p>新用户添加成功！</p>";
}else{
echo "<p>添加用户时出错：" . mysqli_error($conn) . "</p>";
}
// 更新用户信息
$id = 1;
$new_phone = "13222222222";
$update_query = "UPDATE users SET phone='$new_phone' WHERE id=$id";
if(mysqli_query($conn, $update_query)){
echo "<p>用户信息更新成功！</p>";
}else{
echo "<p>更新用户信息时出错：" . mysqli_error($conn) . "</p>";
}
// 删除用户信息
$id = 2;
$delete_query = "DELETE FROM users WHERE id=$id";
if(mysqli_query($conn, $delete_query)){
echo "<p>用户信息删除成功！</p>";
}else{
echo "<p>删除用户信息时出错：" . mysqli_error($conn) . "</p>";
}
mysqli_close($conn);
?>
This code will select, insert, update, and delete user information and output the results so that we can View in browser.
Step 4: Test your application
Now, you have created an HTML file, a database, and a PHP file for database connections and data operations. Let's test your application by visiting "http://localhost/PATH_TO_PROJECT/index.html" and see the output.
If your output matches the code above, you have successfully created a simple PHP project, including additions, deletions, and modifications.
Now you can use the HBuilder editor to optimize your code and continue to improve your web application to better match your needs and goals.
The above is the detailed content of How to create a simple PHP project using the HBuilder editor. For more information, please follow other related articles on the PHP Chinese website!