Các thao tác cơ sở dữ liệu trong PHP là một điều rất quan trọng, đặc biệt cần thiết trong các thao tác CRUD [Tạo, Đọc, Cập nhật và Xóa]
Trong bài viết này, chúng ta sẽ thảo luận về Đọc phần i. e. lấy dữ liệu từ cơ sở dữ liệu
Có hai cách để kết nối với cơ sở dữ liệu bằng PHP. Chúng như sau
- MySQLi [“i” là viết tắt của cải tiến]
- PDO [Đối tượng dữ liệu PHP]
MySQLi so với PDO. Cả hai cách đều thực sự tốt nhưng chỉ có một điểm khác biệt giữa hai phương pháp, PDO có thể hoạt động trên 12 hệ thống cơ sở dữ liệu khác nhau trong khi MySQLi chỉ hoạt động với cơ sở dữ liệu MySQL
Kết nối với cơ sở dữ liệu
Hướng đối tượng MySQLi
$conn = new mysqli[$servername, $username, $databasename]
Thủ tục MySQLi
$conn = mysqli_connect[$servername, $username, $password, $databasename];
PDO
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];
Thực hiện truy vấn. Sau khi kết nối với cơ sở dữ liệu, chúng ta cần chạy các truy vấn để tìm nạp dữ liệu. Trong hoạt động Đọc, chúng tôi sẽ chỉ sử dụng các truy vấn được chọn để tìm nạp dữ liệu từ cơ sở dữ liệu
Hướng đối tượng MySQLi
$conn->query[$query];
Thủ tục MySQLi
mysqli_query[$conn, $query]
PDO
$stmt = $conn->prepare[$query]; $stmt->execute[];
Đóng kết nối. Sau khi quá trình tìm nạp được thực hiện, bạn nên đóng kết nối tới cơ sở dữ liệu bằng hàm close[]
$conn->close[];
Cơ sở dữ liệu mẫu
Tạo Table trong cơ sở dữ liệu
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`] ];
Chi tiết sinh viên
Cách tiếp cận hướng đối tượng MySQLi
Mã 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____35
$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];4
mysqli_query[$conn, $query]2
mysqli_query[$conn, $query]3
$conn = mysqli_connect[$servername, $username, $password, $databasename];9
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];4
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];9
mysqli_query[$conn, $query]9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____52
$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
$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->close[];2
$conn->query[$query];7
$conn->close[];4
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____66
$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];3
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`] ];1
$conn = mysqli_connect[$servername, $username, $password, $databasename];5
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`] ];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];7
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
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`] ];7
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
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`] ];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];5
$conn->query[$query];7
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`] ];92
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`] ];1
mysqli_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[];5
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`] ];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];70
mysqli_query[$conn, $query]3____872
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$conn = mysqli_connect[$servername, $username, $password, $databasename];74
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$conn = mysqli_connect[$servername, $username, $password, $databasename];76
$stmt = $conn->prepare[$query]; $stmt->execute[];5
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$conn = mysqli_connect[$servername, $username, $password, $databasename];5
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`] ];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];01
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$conn = mysqli_connect[$servername, $username, $password, $databasename];72
________ 104 ________ 105 ________ 106 ________ 62
$conn = mysqli_connect[$servername, $username, $password, $databasename];08
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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];08
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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];08
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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];08
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];72
________ 873 ________ 105 ________ 145 ________ 17
mysqli_query[$conn, $query]3
$conn->close[];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];50
$conn->query[$query];7____152
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];54
đầu ra
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`] ];9
Phương pháp thủ tục MySQLi
Mã 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____35
$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];9
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];4
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];9
mysqli_query[$conn, $query]9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____52
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______54
$conn = mysqli_connect[$servername, $username, $password, $databasename];97____37
$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____66
$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];3
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`] ];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];3
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`] ];7
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______79
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];19____37____42
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`] ];1
mysqli_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];27
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`] ];9
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];29
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];74
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];76______55
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];36
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`] ];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
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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[];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];7
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn->close[];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____66____141
$conn = mysqli_connect[$servername, $username, $password, $databasename];72
$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____66
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3______37
$conn = mysqli_connect[$servername, $username, $password, $databasename];52
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];54
đầu ra
$conn = mysqli_connect[$servername, $username, $password, $databasename];7
Phương pháp tiếp cận PDO
Mã 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____35
$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];9
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];4
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];9
mysqli_query[$conn, $query]9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____52
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______54
$conn = mysqli_connect[$servername, $username, $password, $databasename];97____37
$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____66
$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];3
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`] ];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____337
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____872
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$conn->query[$query];46
$conn = mysqli_connect[$servername, $username, $password, $databasename];84
$conn = mysqli_connect[$servername, $username, $password, $databasename];73
$conn = mysqli_connect[$servername, $username, $password, $databasename];9____42
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];4
mysqli_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];61
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`] ];1
mysqli_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[];8
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`] ];7
$stmt = $conn->prepare[$query]; $stmt->execute[];8
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`] ];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];5____358
$conn->query[$query];81
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];74
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn->query[$query];85
$stmt = $conn->prepare[$query]; $stmt->execute[];5
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`] ];9
$conn->query[$query];88
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$conn->query[$query];90
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];72
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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 = mysqli_connect[$servername, $username, $password, $databasename];21
$conn = mysqli_connect[$servername, $username, $password, $databasename];04
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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
$conn = mysqli_connect[$servername, $username, $password, $databasename];78
$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];34
$conn = mysqli_connect[$servername, $username, $password, $databasename];7