Section Artikel Show
Definisi dan PenggunaanFungsi Tip: Gunakan fungsi SyntaxObject oriented style:
Procedural style:
Nilai Parameter
Detail Teknis
Contoh – Object oriented style <?php $mysqli = new mysqli("localhost","my_user","my_password","my_db"); if ($mysqli -> connect_errno) { echo "Gagal Menghubungkan ke MySQL: " . $mysqli -> connect_error; exit(); } // Matikan autocommit $mysqli -> autocommit(FALSE); // Tambahkan beberapa value $mysqli -> query("INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Peter','Griffin',35)"); $mysqli -> query("INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)"); // Lakukan commit transaksi if (!$mysqli -> commit()) { echo "Commit transaksi gagal"; exit(); } $mysqli -> close(); ?> Contoh – Procedural style <?php $con=mysqli_connect("localhost","my_user","my_password","my_db"); if (mysqli_connect_errno()) { echo "Gagal menghubungkan ke MySQL: " . mysqli_connect_error(); exit; } // Matikan autocommit mysqli_autocommit($con,FALSE); // Tambahkan beberapa value mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Peter','Griffin',35)"); mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)"); // Lakukan commit transaksi if (!$mysqli_commit($con)) { echo "Commit transaksi gagal"; exit(); } // Tutup koneksi mysqli_close($con); ?> Section Artikel
Definisi dan PenggunaanFungsi Tip: Gunakan fungsi SyntaxObject oriented style:
Procedural style:
Nilai Parameter
Detail Teknis
Contoh – Object oriented style <?php $mysqli = new mysqli("localhost","my_user","my_password","my_db"); if ($mysqli -> connect_errno) { echo "Gagal menyambungkan ke MySQL: " . $mysqli -> connect_error; exit(); } // Matikan autocommit $mysqli -> autocommit(FALSE); // Insert beberapa nilai $mysqli -> query("INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Peter','Griffin',35)"); $mysqli -> query("INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)"); // Lakukan commit transaksi if (!$mysqli -> commit()) { echo "Commit transaction failed"; exit(); } $mysqli -> close(); ?> Contoh – Procedural style <?php $con=mysqli_connect("localhost","my_user","my_password","my_db"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit; } // Matikan autocommit mysqli_autocommit($con,FALSE); // Insert beberapa nilai mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Peter','Griffin',35)"); mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)"); // Lakukan commit transaksi if (!$mysqli_commit($con)) { echo "Commit transaction failed"; exit(); } // Tutup Koneksi mysqli_close($con); ?> |