PHP |插入MySQL数据库-yiteyi-C++库

先决条件： MySQL简介 , 创建MySQL数据库插入语句用于在数据库表中插入新行。考虑到数据库已经存在，让我们看看如何插入到表中的语法。

null

语法：

INSERT INTO TABLE_NAME (column1, column2, column3, ... columnN) 
VALUES (value1, value2, value3, ...valueN);

这里，column1、column2、column3、…columnN是表中要插入数据的列的名称。如果要为表中的所有列添加值，则可能不需要在SQL查询中指定列名。但要确保值的顺序与表中的列的顺序相同。

因此，要使用带有适当值的INSERT INTO语句创建SQL查询，下面是一个示例，它将通过为first_name、last_name和email字段指定值，向newDB表插入一个新行。

使用MySQLi面向对象过程创建表：

                           <?php                         
                                                     $mysqli                                        =                                        new                                        mysqli(                                        "localhost"                                        ,                                        "root"                                        ,                                        ""                                        ,                                        "newdb"                                        );                         
                                      
                           if                                        (                                        $mysqli                                        == = false) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .                                        $mysqli                                        ->connect_error);                         
                           }                         
                                      
                           $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'ram'                                        ,                                        'singh'                                        ,                                        '25'                                        ) ";                         
                                                     if                                        (                                        $mysqli                                        ->query(                                        $sql                                        ) == = true)                         
                           {                         
                                                     echo                                        "Records inserted successfully."                                        ;                         
                           }                         
                           else                         
                           {                         
                                                     echo                                        "ERROR: Could not able to execute $sql. "                         
                                                     .                                        $mysqli                                        ->error;                         
                           }                         
                                      
                           // Close connection                         
                           $mysqli                                        ->close();                         
                           ? >                         

输出：

使用MySQLi过程创建表：

                           <?php                         
                           $link                                        = mysqli_connect(                                        "localhost"                                        ,                                        "root"                                        ,                                        ""                                        ,                                        "newdb"                                        );                         
                                      
                           if                                        (                                        $link                                        == = false) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .mysqli_connect_error());                         
                           }                         
                                      
                           $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'ram'                                        ,                                        'singh'                                        ,                                        '25'                                        ) ";                         
                                                     if                                        (mysqli_query(                                        $link                                        ,                                        $sql                                        ))                         
                           {                         
                                                     echo                                        "Records inserted successfully."                                        ;                         
                           }                         
                           else                         
                           {                         
                                                     echo                                        "ERROR: Could not able to execute $sql. "                         
                                                     .mysqli_error(                                        $link                                        );                         
                           }                         
                                      
                           mysqli_close(                                        $link                                        );                         
                           ? >                         

输出：

使用MySQLi PDO过程创建表：

                           <?php                         
                           try                                        {                         
                                                     $pdo                                        =                                        new                                        PDO(                                        "mysql:host=localhost;dbname=newdb"                                        ,                         
                                                     "root"                                        ,                                        ""                                        );                         
                                                     $pdo                                        ->setAttribute(PDO::ATTR_ERRMODE,                         
                                                     PDO::ERRMODE_EXCEPTION);                         
                           }                         
                           catch                                        (PDOException                                        $e                                        ) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .                                        $e                                        ->getMessage());                         
                           }                         
                                      
                           try                                        {                         
                                                     $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'ram'                                        ,                                        'singh'                                        ,                                        '25'                                        ) ";                         
                                                     $pdo                                        ->                                        exec                                        (                                        $sql                                        );                         
                                                     echo                                        "Records inserted successfully."                                        ;                         
                           }                         
                           catch                                        (PDOException                                        $e                                        ) {                         
                                                     die                                        (                                        "ERROR: Could not able to execute $sql. "                         
                                                     .                                        $e                                        ->getMessage());                         
                           }                         
                                      
                           // Close connection                         
                           unset(                                        $pdo                                        );                         
                           ? >                         

输出：

该表的值可以在MySql数据库中查看为—— 图片[4]-PHP |插入MySQL数据库-yiteyi-C++库

在表中插入多行

还可以使用一个insert查询同时向表中插入多行。为此，在INSERT INTO语句中包含多个列值列表，其中每行的列值必须用括号括起来，并用逗号分隔。

使用MySQLi面向对象过程创建表：

                           <?php                         
                           $mysqli                                        =                                        new                                        mysqli(                                        "localhost"                                        ,                                        "root"                                        ,                                        ""                                        ,                                        "newdb"                                        );                         
                                      
                           if                                        (                                        $mysqli                                        == = false) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .                                        $mysqli                                        ->connect_error);                         
                           }                         
                                      
                           $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'raj'                                        ,                                        'sharma'                                        ,                                        '15'                                        ),                         
                                                     (                                        'kapil'                                        ,                                        'verma'                                        ,                                        '42'                                        ),                         
                                                     (                                        'monty'                                        ,                                        'singh'                                        ,                                        '29'                                        ),                         
                                                     (                                        'arjun'                                        ,                                        'patel'                                        ,                                        '32'                                        ) ";                         
                                                     if                                        (                                        $mysqli                                        ->query(                                        $sql                                        ) == = true)                         
                           {                         
                                                     echo                                        "Records inserted successfully."                                        ;                         
                           }                         
                           else                         
                           {                         
                                                     echo                                        "ERROR: Could not able to execute $sql. "                         
                                                     .                                        $mysqli                                        ->error;                         
                           }                         
                                      
                           $mysqli                                        ->close();                         
                           ? >                         

输出：

使用MySQLi过程创建表：

                           <?php                         
                           $link                                        = mysqli_connect(                                        "localhost"                                        ,                                        "root"                                        ,                                        ""                                        ,                                        "newdb"                                        );                         
                                      
                           if                                        (                                        $link                                        == = false) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .mysqli_connect_error());                         
                           }                         
                                      
                           $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'raj'                                        ,                                        'sharma'                                        ,                                        '15'                                        ),                         
                                                     (                                        'kapil'                                        ,                                        'verma'                                        ,                                        '42'                                        ),                         
                                                     (                                        'monty'                                        ,                                        'singh'                                        ,                                        '29'                                        ),                         
                                                     (                                        'arjun'                                        ,                                        'patel'                                        ,                                        '32'                                        ) ";                         
                                                     if                                        (mysqli_query(                                        $link                                        ,                                        $sql                                        ))                         
                           {                         
                                                     echo                                        "Records added successfully."                                        ;                         
                           }                         
                           else                         
                           {                         
                                                     echo                                        "ERROR: Could not able to execute $sql. "                         
                                                     .mysqli_error(                                        $link                                        );                         
                           }                         
                                      
                           // Close connection                         
                           mysqli_close(                                        $link                                        );                         
                           ? >                         

输出：

使用MySQLi PDO过程创建表：

                           <?php                         
                           try                                        {                         
                                                     $pdo                                        =                                        new                                        PDO(                                        "mysql:host=localhost;dbname="                                        newdb",                         
                                                     "root"                                        ,                                        ""                                        );                         
                                                     $pdo                                        ->setAttribute(PDO::ATTR_ERRMODE,                         
                                                     PDO::ERRMODE_EXCEPTION);                         
                           }                         
                           catch                                        (PDOException                                        $e                                        ) {                         
                                                     die                                        (                                        "ERROR: Could not connect. "                                        .                                        $e                                        ->getMessage());                         
                           }                         
                                      
                           try                                        {                         
                                                     $sql                                        = "INSERT INTO mytable (first_name, last_name, age)                         
                                                     VALUES(                                        'raj'                                        ,                                        'sharma'                                        ,                                        '15'                                        ),                         
                                                     (                                        'kapil'                                        ,                                        'verma'                                        ,                                        '42'                                        ),                         
                                                     (                                        'monty'                                        ,                                        'singh'                                        ,                                        '29'                                        ),                         
                                                     (                                        'arjun'                                        ,                                        'patel'                                        ,                                        '32'                                        ) ";                         
                                                     $pdo                                        ->                                        exec                                        (                                        $sql                                        );                         
                                                     echo                                        "Records inserted successfully."                                        ;                         
                           }                         
                           catch                                        (PDOException                                        $e                                        ) {                         
                                                     die                                        (                                        "ERROR: Could not able to execute $sql. "                         
                                                     .                                        $e                                        ->getMessage());                         
                           }                         
                           unset(                                        $pdo                                        );                         
                           ? >                         

输出：

该表的值可以在MySql数据库中查看为—— 图片[8]-PHP |插入MySQL数据库-yiteyi-C++库

文章版权归作者所有，未经允许请勿转载。

THE END

Php