Home php教程 php手册 PHP simple connection operation to mysql database

PHP simple connection operation to mysql database

Dec 05, 2016 pm 01:26 PM

After I finished working on the company’s front-end static pages a while ago, I briefly learned the basics of PHP. Today I thought about reviewing the way PHP connects to the database, and write an essay and save it for later

php connect database port and create new database

<?<span style="color: #000000">php
        </span><span style="color: #800080">$servername</span> = "localhost"<span style="color: #000000">;
        </span><span style="color: #800080">$username</span> = "root"<span style="color: #000000">;
        </span><span style="color: #008000">//</span><span style="color: #008000"> 创建连接</span>
        <span style="color: #800080">$conn</span> = <span style="color: #008080">mysqli_connect</span>(<span style="color: #800080">$servername</span>, <span style="color: #800080">$username</span><span style="color: #000000">);
        </span><span style="color: #008000">//</span><span style="color: #008000"> 检测连接</span>
        <span style="color: #0000ff">if</span> (!<span style="color: #800080">$conn</span><span style="color: #000000">) {

            </span><span style="color: #0000ff">die</span>("连接失败: " . <span style="color: #008080">mysqli_connect_error</span><span style="color: #000000">());
        }

        </span><span style="color: #008000">//</span><span style="color: #008000"> 创建数据库</span>
        <span style="color: #800080">$sql</span> = "CREATE DATABASE myDB"<span style="color: #000000">;
        </span><span style="color: #0000ff">if</span> (<span style="color: #008080">mysqli_query</span>(<span style="color: #800080">$conn</span>, <span style="color: #800080">$sql</span><span style="color: #000000">)) {
            </span><span style="color: #0000ff">echo</span> "数据库创建成功"<span style="color: #000000">;
        } </span><span style="color: #0000ff">else</span><span style="color: #000000"> {
            </span><span style="color: #008000">//</span><span style="color: #008000">数据库已经存在</span>
            <span style="color: #0000ff">echo</span> "Error creating database: " . <span style="color: #008080">mysqli_error</span>(<span style="color: #800080">$conn</span><span style="color: #000000">);
        }

        </span><span style="color: #008080">mysqli_close</span>(<span style="color: #800080">$conn</span><span style="color: #000000">);
        </span>?>
Copy after login

After the connection is successful, create a simple data table

<span style="color: #008000">//</span><span style="color: #008000"> 使用 sql 创建数据表</span>
        <span style="color: #800080">$sql</span> = "<span style="color: #000000">CREATE TABLE MyGuests (
        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        firstname VARCHAR(30) NOT NULL,
        lastname VARCHAR(30) NOT NULL,
        email VARCHAR(50),
        reg_date TIMESTAMP
        )</span>"<span style="color: #000000">;

        </span><span style="color: #0000ff">if</span> (<span style="color: #800080">$conn</span>->query(<span style="color: #800080">$sql</span>) === <span style="color: #0000ff">TRUE</span><span style="color: #000000">) {
            </span><span style="color: #0000ff">echo</span> "Table MyGuests created successfully"<span style="color: #000000">;
        } </span><span style="color: #0000ff">else</span><span style="color: #000000"> {
            </span><span style="color: #0000ff">echo</span> "创建数据表错误: " . <span style="color: #800080">$conn</span>-><span style="color: #000000">error;
        }</span>
Copy after login

When connecting to the database, make sure the server port of the database is open, otherwise you cannot connect. Before writing the code, you can use navicat to test the connection to the database

When learning, open the database service, which can be done through the integrated environment of wamp

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)