Panduan ini menunjukkan cara mengirim dan menyimpan data formulir ke database MySQL setelah pengiriman menggunakan PHP. Diperlukan pemahaman dasar tentang MySQL dan PHP
Mari kita mulai
- Buat database dan tabel Anda
Kolom di tabel Anda akan bergantung pada struktur formulir Anda. Lihat panduan ini untuk melihat nama bidang formulir atau kunci pos jika Anda tidak yakin kolom apa yang akan ditambahkan ke tabel database Anda - Untuk panduan ini, pastikan untuk menambahkan kolom “submission_id” di tabel Anda
Dalam contoh formulir kontak ini, tabelnya terlihat seperti berikut di phpMyAdmin
Catatan. Proses untuk membuat atau mengedit database Anda akan bergantung pada penyiapan server atau host web Anda. Hubungi dukungan penyedia Anda untuk mendapatkan bantuan
Operasi basis data dalam PHP adalah hal yang sangat krusial yang sangat dibutuhkan dalam operasi CRUD (Create, Read, Update dan Delete).
Pada artikel ini, kita akan membahas Baca bagian i. e. pengambilan data dari database
Ada dua cara untuk terhubung ke database menggunakan PHP. Mereka adalah sebagai berikut
- MySQLi ("i" berarti ditingkatkan)
- PDO (Objek Data PHP)
MySQLi vs PDO. Kedua cara tersebut sangat bagus tetapi hanya ada satu perbedaan antara kedua metode tersebut, PDO dapat bekerja pada 12 sistem database yang berbeda sedangkan MySQLi hanya bekerja dengan database MySQL
Menghubungkan ke Database
Berorientasi Objek MySQLi
$conn = new mysqli($servername, $username, $databasename)Prosedural MySQLi
$conn = mysqli_connect($servername, $username, $password, $databasename);_PDO
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);
Menjalankan Query. Setelah terhubung ke database, kita perlu menjalankan kueri untuk mengambil data. Dalam operasi Baca, kami hanya akan menggunakan kueri pemilihan untuk mengambil data dari database
Berorientasi Objek MySQLi
$conn->query($query);Prosedural MySQLi
mysqli_query($conn, $query)_PDO
$stmt = $conn->prepare($query); $stmt->execute();
Tutup Koneksi. Setelah pengambilan dilakukan, Anda harus menutup koneksi ke database menggunakan fungsi close()
$conn->close();_Contoh Basis Data
Buat Tabel di database
CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );Detail Siswa
Pendekatan Berorientasi Objek MySQLi
Kode PHP
PHP
$conn = mysqli_connect($servername, $username, $password, $databasename);_1
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = mysqli_connect($servername, $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->query($query);5
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->query($query);7 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);9 mysqli_query($conn, $query)0$conn = mysqli_connect($servername, $username, $password, $databasename);4mysqli_query($conn, $query)2
mysqli_query($conn, $query)3$conn = mysqli_connect($servername, $username, $password, $databasename);9mysqli_query($conn, $query)2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4mysqli_query($conn, $query)4_______2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();4 $stmt = $conn->prepare($query); $stmt->execute();5$conn->query($query);7$stmt = $conn->prepare($query); $stmt->execute();7
________5______8$stmt = $conn->prepare($query); $stmt->execute();9$stmt = $conn->prepare($query); $stmt->execute();5$conn->close();1 $conn->close();2$conn->query($query);7$conn->close();4
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->close();6
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->close();9
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1 $conn = mysqli_connect($servername, $username, $password, $databasename);5CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );3$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );7
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);7Roll No: 1 - Name: Ram | City: Delhi | Age: 18 Roll No: 2 - Name: Shyam | City: Mumbai | Age: 19 Roll No: 3 - Name: Rohit | City: Chennai | Age: 18 Roll No: 4 - Name: Suresh | City: Kolkata | Age: 202CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
mysqli_query($conn, $query)3$stmt = $conn->prepare($query); $stmt->execute();4 $stmt = $conn->prepare($query); $stmt->execute();5CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh0
________4$conn->query($query);_87_______2
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh6$stmt = $conn->prepare($query); $stmt->execute();5Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8 $conn = mysqli_connect($servername, $username, $password, $databasename);5CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9$conn = mysqli_connect($servername, $username, $password, $databasename);01
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh2
$conn = mysqli_connect($servername, $username, $password, $databasename);_04$conn = mysqli_connect($servername, $username, $password, $databasename);05 $conn = mysqli_connect($servername, $username, $password, $databasename);06 $conn->close();2
$conn = mysqli_connect($servername, $username, $password, $databasename);08Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);11$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);13 $conn->close();2
$conn = mysqli_connect($servername, $username, $password, $databasename);08Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);18$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);20 $conn = mysqli_connect($servername, $username, $password, $databasename);21
$conn = mysqli_connect($servername, $username, $password, $databasename);08Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);25$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);27 $conn = mysqli_connect($servername, $username, $password, $databasename);21
$conn = mysqli_connect($servername, $username, $password, $databasename);08Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);32$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);34$conn = mysqli_connect($servername, $username, $password, $databasename);7
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3$conn->close();6
mysqli_query($conn, $query)_3$conn = mysqli_connect($servername, $username, $password, $databasename);39
mysqli_query($conn, $query)_3$conn = mysqli_connect($servername, $username, $password, $databasename);41 Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh2
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3$conn = mysqli_connect($servername, $username, $password, $databasename);05 $conn = mysqli_connect($servername, $username, $password, $databasename);45$conn = mysqli_connect($servername, $username, $password, $databasename);7
________4$conn->query($query);_6_______6
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);50$conn->query($query);7$conn = mysqli_connect($servername, $username, $password, $databasename);52
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);_54
Keluaran
Roll No: 1 - Name: Ram | City: Delhi | Age: 18 Roll No: 2 - Name: Shyam | City: Mumbai | Age: 19 Roll No: 3 - Name: Rohit | City: Chennai | Age: 18 Roll No: 4 - Name: Suresh | City: Kolkata | Age: 20Pendekatan Prosedural MySQLi
Kode PHP
PHP
$conn = mysqli_connect($servername, $username, $password, $databasename);_1
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = mysqli_connect($servername, $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->query($query);5
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->query($query);7 $conn = mysqli_connect($servername, $username, $password, $databasename);82$conn = mysqli_connect($servername, $username, $password, $databasename);4$conn = mysqli_connect($servername, $username, $password, $databasename);84
mysqli_query($conn, $query)3$conn = mysqli_connect($servername, $username, $password, $databasename);9mysqli_query($conn, $query)2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4mysqli_query($conn, $query)4_______2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();4 $conn = mysqli_connect($servername, $username, $password, $databasename);97$conn->query($query);7$conn = mysqli_connect($servername, $username, $password, $databasename);99
$stmt = $conn->prepare($query); $stmt->execute();8$stmt = $conn->prepare($query); $stmt->execute();_9$stmt = $conn->prepare($query); $stmt->execute();5$conn->close();1 $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);04
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->close();6
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->close();9
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);13$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );7
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9 $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);19$conn->query($query);7mysqli_query($conn, $query)2CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();4 $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);27CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);29
$stmt = $conn->prepare($query); $stmt->execute();8Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
________5______8Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh6$stmt = $conn->prepare($query); $stmt->execute();5Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8 $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);36CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);38
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);39$conn = mysqli_connect($servername, $username, $password, $databasename);05 $conn = mysqli_connect($servername, $username, $password, $databasename);06 $conn->close();2________87______8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);11$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);46
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);39$conn->close();2$conn = mysqli_connect($servername, $username, $password, $databasename);13 $conn->close();2Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);18$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);34________1______7
$stmt = $conn->prepare($query); $stmt->execute();8$conn->close();6
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->close();6$conn = mysqli_connect($servername, $username, $password, $databasename);41 Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh2
$stmt = $conn->prepare($query); $stmt->execute();8$conn = mysqli_connect($servername, $username, $password, $databasename);05 $conn = mysqli_connect($servername, $username, $password, $databasename);45$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->close();6
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->query($query);7$conn = mysqli_connect($servername, $username, $password, $databasename);52
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);_54
Keluaran
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: SureshPendekatan PDO
Kode PHP
PHP
$conn = mysqli_connect($servername, $username, $password, $databasename);_1
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = mysqli_connect($servername, $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = mysqli_connect($servername, $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);6$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);1$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->query($query);5
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->query($query);7 $conn = mysqli_connect($servername, $username, $password, $databasename);82$conn = mysqli_connect($servername, $username, $password, $databasename);4$conn = mysqli_connect($servername, $username, $password, $databasename);84
mysqli_query($conn, $query)3$conn = mysqli_connect($servername, $username, $password, $databasename);9mysqli_query($conn, $query)2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4mysqli_query($conn, $query)4_______2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);9mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$stmt = $conn->prepare($query); $stmt->execute();4 $conn = mysqli_connect($servername, $username, $password, $databasename);97$conn->query($query);7$conn = mysqli_connect($servername, $username, $password, $databasename);99
$stmt = $conn->prepare($query); $stmt->execute();8$stmt = $conn->prepare($query); $stmt->execute();_9$stmt = $conn->prepare($query); $stmt->execute();5$conn->close();1 $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);04
$conn = mysqli_connect($servername, $username, $password, $databasename);_3$conn->close();6
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->close();9
$conn = mysqli_connect($servername, $username, $password, $databasename);3CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);33$conn = mysqli_connect($servername, $username, $password, $databasename);7
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$conn = mysqli_connect($servername, $username, $password, $databasename);3$conn->query($query);37
$conn = mysqli_connect($servername, $username, $password, $databasename);3Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh2
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);7 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);9 $conn->query($query);44
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3$conn->query($query);46$conn = mysqli_connect($servername, $username, $password, $databasename);84
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3$conn = mysqli_connect($servername, $username, $password, $databasename);_9mysqli_query($conn, $query)2$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);4mysqli_query($conn, $query)9
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);7$conn->query($query);56
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);58 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);7$conn->query($query);61CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );1mysqli_query($conn, $query)9
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);65
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);58$conn->query($query);68
$conn = mysqli_connect($servername, $username, $password, $databasename);_2
$stmt = $conn->prepare($query); $stmt->execute();8$conn->query($query);71 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);58$conn->query($query);74
$stmt = $conn->prepare($query); $stmt->execute();8CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );7
$stmt = $conn->prepare($query); $stmt->execute();8CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9 $conn = mysqli_connect($servername, $username, $password, $databasename);5$conn->query($query);58$conn->query($query);81
$stmt = $conn->prepare($query); $stmt->execute();8Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
________5______8$conn->query($query);85 $stmt = $conn->prepare($query); $stmt->execute();5CREATE TABLE `Student Details` ( `Roll_No` int(11) NOT NULL, `Name` varchar(255) NOT NULL, `City` varchar(255) NOT NULL, `Age` int(11) NOT NULL, PRIMARY KEY (`Roll_No`) );9 $conn->query($query);88 Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn->query($query);90
$stmt = $conn->prepare($query); $stmt->execute();8Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh2
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password, $databasename);39$conn = mysqli_connect($servername, $username, $password, $databasename);05 $conn = mysqli_connect($servername, $username, $password, $databasename);06 $conn->close();2________87______8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);11$conn = mysqli_connect($servername, $username, $password, $databasename);1_______12$conn = mysqli_connect($servername, $username, $password, $databasename);13 ________1______21
$conn = mysqli_connect($servername, $username, $password, $databasename);_04Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);18$conn = mysqli_connect($servername, $username, $password, $databasename);12$conn = mysqli_connect($servername, $username, $password, $databasename);20 $conn->close();2________87______8$conn = mysqli_connect($servername, $username, $password, $databasename);10$conn = mysqli_connect($servername, $username, $password, $databasename);25$conn = mysqli_connect($servername, $username, $password, $databasename);12____3____12____3____1