Database and form creation in PHP development

First create a CREATE DATABASE database in the database using the database creation statement. The name is regedit:

<?php
// 创建连接
$conn = new mysqli("localhost", "root", "root");
// 检测连接
if ($conn->connect_error) 
{    
    die("连接失败: " . $conn->connect_error);} 
    // 创建数据库
    $sql = "CREATE DATABASE regedit";
        if ($conn->query($sql) === TRUE) 
        {    
        echo "数据库创建成功";
        } else {    
        echo "Error creating database: " . $conn->error;
        }
    $conn->close();
?>

In this way, the database is created. Next, we create a form called form in the regedit library. The form contains information as follows:

Table name: form

##Field nameidusernamepasswordField typeintvarcharvarcharField length5100100Field description User idUsernameUser passwordBased on the information in the table, we create the table and use the table creation statement:

<?php
// 创建连接
$conn = new mysqli("localhost", "root", "root","regedit");
// 检测连接
if ($conn->connect_error) 
{    
die("连接失败: " . $conn->connect_error);
} 
// 使用 sql 创建数据表
$sql = "CREATE TABLE form (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
if ($conn->query($sql) === TRUE) 
{    
echo "Table MyGuests created successfully";
} else {    
echo "创建数据表错误: " . $conn->error;
}
$conn->close(); 
?>

In this way, the database is built, the data table is also built, and the rest can be added.

Of course, we can also use another method to add, which will be faster.

Take phpStudy as an example:

1I`05H5O_6~S50G]%I99[4H.png

Click the button, select phpMyStudy, enter the database login page, and the account and password are both root.

Then enter this page and click "Database", as shown in the picture:

}[HE0[@CYK[$`ZQ(ZNFU6[F.png

Then when you get to this page, you can fill in the name of the database where the arrow points. , click Create, and it is created.

0DHDHR3(~C6F``S35CFQH5J.png

Next, you can create the data table, name the table, and number of fields. After creating it, there will be an execution in the lower right corner. Click to create the form.

VBL)D`703M3LYF}26GPGF.png

Continuing Learning

new file

<?php // 创建连接 $conn = new mysqli("localhost", "root", "root"); // 检测连接 if ($conn->connect_error) { die("连接失败: " . $conn->connect_error);} // 创建数据库 $sql = "CREATE DATABASE regeit"; if ($conn->query($sql) === TRUE) { echo "数据库创建成功"; } else { echo "Error creating database: " . $conn->error; } $conn->close(); ?>

submit Reset Code

Automatic operation

Previous section Next Section

Tutorial List

get help

Course Recommendations
Courseware download

The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~

Students who have watched this course are also learning

Database and form creation in PHP development

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]