PHP MySQL bir nechta yozuv kiritish
MySQL-ga bir nechta yozuvlarni joylashtiring
Bir vaqtning o‘zida bitta qo‘shish so‘rovi bilan jadvalga bir nechta qatorlarni kiritish ham mumkin.
Buni amalga oshirish uchun INSERT INTO iborasiga ustun qiymatlarining bir nechta ro‘yxatini kiriting, bunda har bir satr uchun ustun qiymatlari qavslar ichiga olinadi va vergul bilan ajratiladi.
Quyidagi misollarda biz "Mening mehmonlarim" jadvaliga uchta yangi yozuv qo‘shamiz:
Misol - MySQLi obyektga yo‘naltirilgan
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES
('John', 'Doe', 'john@example.com'),
('Mary', 'Moe', 'mary@example.com'),
('Julie', 'Dooley', 'julie@example.com')";
if ($conn->multi_query($sql) === TRUE) {
echo "New records inserted successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
Misol - MySQLi protsessual
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES
('John', 'Doe', 'john@example.com'),
('Mary', 'Moe', 'mary@example.com'),
('Julie', 'Dooley', 'julie@example.com')";
if (mysqli_multi_query($conn, $sql)) {
echo "New records inserted successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
Misol - PDO
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e){
die("Could not connect. " . $e->getMessage());
}
try {
$sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES
('John', 'Doe', 'john@example.com'),
('Mary', 'Moe', 'mary@example.com',
('Julie', 'Dooley', 'julie@example.com')";
$conn->exec($sql);
echo "New records inserted successfully";
} catch(PDOException $e) {
echo "Error: " . $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!