PHP+phpmyadmin增删改查

以下是PHP+phpmyadmin增删改查的示例代码：

1. 连接数据库

$link = mysqli_connect('localhost', 'username', 'password', 'dbname', 'port', 'socket');
if (!$link) {
    die('连接失败: ' . mysqli_connect_error());
}
mysqli_set_charset($link, 'utf8');

2. 插入数据

$sql = "INSERT INTO `table_name` (`column1`, `column2`, `column3`) VALUES ('value1', 'value2', 'value3')";
if (mysqli_query($link, $sql)) {
    echo "插入成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($link);
}

3. 查询数据

$sql = "SELECT * FROM `table_name`";
$result = mysqli_query($link, $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 "0 结果";
}

4. 更新数据

$sql = "UPDATE `table_name` SET `column1`='new_value1' WHERE `column2`='value2'";
if (mysqli_query($link, $sql)) {
    echo "更新成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($link);
}

5. 删除数据

$sql = "DELETE FROM `table_name` WHERE `column1`='value1'";
if (mysqli_query($link, $sql)) {
    echo "删除成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($link);
}