将关联PHP数组插入到mysql中，而无需键入每个单独的插入名称和值

$data = array(
    'column1' => 'value1',
    'column2' => 'value2',
    'column3' => 'value3'
);

$columns = implode(', ', array_keys($data));
$values = "'" . implode("', '", array_values($data)) . "'";
$sql = "INSERT INTO table_name ($columns) VALUES ($values)";

$conn = new mysqli('localhost', 'username', 'password', 'database');
if ($conn->connect_error) {
    die('连接失败：' . $conn->connect_error);
}

if ($conn->query($sql) === TRUE) {
    echo '插入成功';
} else {
    echo '插入失败：' . $conn->error;
}

$conn->close();