当前位置：首页 > 数据库 > 正文

怎么用数组网数据库里写入数据

admin
数据库
2025-07-13
5

PHP中，连接数据库后，可将数组转为字符串或使用循环及预处理语句，将数据逐条插入数据库表中

编程中，将数组写入数据库是一项常见的操作，不同的编程语言和数据库系统有不同的实现方式,以下是几种常见的方法：

怎么用数组网数据库里写入数据第1张

使用PHP将数组写入MySQL数据库

方法	描述	示例代码
纯SQL语句	直接构造SQL语句插入数据	php $conn = mysqli_connect("localhost", "username", "password", "database"); $array = array("name" => "John", "age" => 28, "email" => "john@example.com"); $sql = "INSERT INTO table_name (name, age, email) VALUES ('{$array['name']}', {$array['age']}, '{$array['email']}')"; mysqli_query($conn, $sql); mysqli_close($conn);
预处理语句	使用预处理语句防止SQL载入	php $conn = mysqli_connect("localhost", "username", "password", "database"); $array = array("name" => "John", "age" => 28, "email" => "john@example.com"); $sql = "INSERT INTO table_name (name, age, email) VALUES (?, ?, ?)"; $stmt = mysqli_prepare($conn, $sql); mysqli_stmt_bind_param($stmt, "sis", $array['name'], $array['age'], $array['email']); mysqli_stmt_execute($stmt); mysqli_stmt_close($stmt); mysqli_close($conn);
ORM工具	使用ORM工具简化操作	php require 'vendor/autoload.php'; use IlluminateDatabaseCapsuleManager as Capsule; $capsule = new Capsule; $capsule->addConnection([ 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'database', 'username' => 'username', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ]); $capsule->bootEloquent(); class User extends IlluminateDatabaseEloquentModel { protected $table = 'table_name'; protected $fillable = ['name', 'age', 'email']; } $array = array("name" => "John", "age" => 28, "email" => "john@example.com"); $user = new User($array); $user->save();

使用Python将数组写入MySQL数据库

在Python中，可以使用mysql-connector-python库来连接MySQL数据库，并使用SQL语句或ORM工具（如SQLAlchemy）来插入数据。

示例代码（使用SQL语句）：

import mysql.connector # 连接数据库 conn = mysql.connector.connect( host="localhost", user="username", password="password", database="database" ) cursor = conn.cursor() # 要插入的数组 data = [ ("John", 28, "john@example.com"), ("Jane", 30, "jane@example.com") ] # 构造SQL语句 sql = "INSERT INTO table_name (name, age, email) VALUES (%s, %s, %s)" # 执行SQL语句 cursor.executemany(sql, data) # 提交事务 conn.commit() # 关闭连接 cursor.close() conn.close()

示例代码（使用SQLAlchemy）：

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData from sqlalchemy.orm import sessionmaker # 创建数据库连接 engine = create_engine('mysql+mysqlconnector://username:password@localhost/database') metadata = MetaData() # 定义表结构 users = Table('table_name', metadata, Column('id', Integer, primary_key=True), Column('name', String(50)), Column('age', Integer), Column('email', String(50)) ) # 创建会话 Session = sessionmaker(bind=engine) session = Session() # 要插入的数组 data = [ {"name": "John", "age": 28, "email": "john@example.com"}, {"name": "Jane", "age": 30, "email": "jane@example.com"} ] # 插入数据 for item in data: session.execute(users.insert().values(item)) # 提交事务 session.commit() # 关闭会话 session.close()

使用JavaScript（Node.js）将数组写入MongoDB数据库

在Node.js中，可以使用mongodb库来连接MongoDB数据库，并使用insertMany方法来插入数组数据。

怎么用数组网数据库里写入数据第2张

示例代码：

const { MongoClient } = require('mongodb'); // 连接数据库 const uri = "mongodb://localhost:27017"; const client = new MongoClient(uri); async function run() { try { await client.connect(); const database = client.db('database'); const collection = database.collection('table_name'); // 要插入的数组 const data = [ { name: "John", age: 28, email: "john@example.com" }, { name: "Jane", age: 30, email: "jane@example.com" } ]; // 插入数据 const result = await collection.insertMany(data); console.log(`${result.insertedCount} documents were inserted`); } finally { await client.close(); } } run().catch(console.dir);