在数据库、php和mysql单行中插入数据

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// 使用MySQLi扩展连接数据库
$conn = new mysqli($servername, $username, $password, $dbname);

// 使用PDO扩展连接数据库
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

$table = "users";
$column1 = "name";
$column2 = "email";

// 构建SQL插入语句
$sql = "INSERT INTO $table ($column1, $column2) VALUES (?, ?)";

$stmt = $conn->prepare($sql);
$stmt->bind_param("ss", $name, $email);

$name = "John Doe";
$email = "john@example.com";

$stmt->execute();

$stmt = $conn->prepare($sql);
$stmt->bindParam(1, $name);
$stmt->bindParam(2, $email);

$name = "John Doe";
$email = "john@example.com";

$stmt->execute();

$stmt->execute();

$stmt->execute();

$conn->close();

$conn = null;