$stmt = $connection->prepare("INSERT INTO `users` (`username`, `email`, `password`) VALUES (?,?,?)");
$stmt->bind_param("sss", $username, $email, $password);
$stmt->execute();
$smsg="Регистрация прошла успешно";$data = [
['foo@example.com', password_hash('password1', PASSWORD_DEFAULT)],
['bar@example.com', password_hash('password2', PASSWORD_DEFAULT)],
];
$stmt = $mysqli->prepare("INSERT INTO users VALUES (null,?,?)");
$mysqli->begin_transaction();
foreach ($data as $row) {
$stmt->bind_param("ss", ...$row);
$stmt->execute();
}
$mysqli->commit();Хочется структурировать и нормально организовать хранение в оперативной памяти
$db = new PDO('sqlite::memory:');
$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$db->query("CREATE TABLE temp (mysite_id int,mysite_ext_id int,service_ext_id int,service_id int)");$db->query("INSERT into temp (mysite_id) values (1)");
var_dump($db->query("SELECT service_ext_id FROM temp where mysite_id=1")->fetchColumn());function connectDB()
{
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$dbLink = mysqli_connect( DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$dbLink->set_charset("utf8mb4");
return $dbLink;
}$sql = "INSERT INTO product(sku, supplier, quantity, price, status)
VALUES (?, 'supplier', ?, ?, 1)";
$stmt = $db->prepare($sql);
$ids = [];
foreach($xml->products as $product) {
$stmt->bind_param("sss", ...[$product->product_code, $product->stock, $product->price]);
$stmt->execute();
$ids[] = $db->insert_id;
}