php mysqli扩展实现原生sql增删改查

php使用mysqli扩展来连接数据库、实现增删改查操作。以下是使用mysqli扩展的示例代码

1. 连接数据库： 使用mysqli扩展连接MySQL数据库。示例代码如下：

   <?php
   $servername = "localhost";
   $username = "username";
   $password = "password";
   $dbname = "database";
   $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
       die("连接失败: " . mysqli_connect_error());
   }

    2.插入数据：

<?php
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";
if (mysqli_query($conn, $sql)) {
    echo "插入成功";
} else {
    echo "插入失败: " . mysqli_error($conn);
}

3.删除数据：

<?php
$sql = "DELETE FROM table_name WHERE condition";
if (mysqli_query($conn, $sql)) {
    echo "删除成功";
} else {
    echo "删除失败: " . mysqli_error($conn);
}

4.更新数据

<?php
$sql = "UPDATE table_name SET column1='value1', column2='value2' WHERE condition";
if (mysqli_query($conn, $sql)) {
    echo "更新成功";
} else {
    echo "更新失败: " . mysqli_error($conn);
}

 5.查询数据

<?php
$sql = "SELECT * FROM table_name";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "column1: " . $row["column1"]. " - column2: " . $row["column2"]. " - column3: " . $row["column3"]. "<br>";
    }
} else {
    echo "没有数据";
}