Tìm nạp dữ liệu là một khía cạnh quan trọng khi nói đến PHP. Trong bài viết này, chúng ta sẽ tìm hiểu phương thức mysql_fetch_array theo thứ tự sau
Mysql_fetch_array là gì?
Hàm trả về một hàng từ một tập bản ghi dưới dạng một mảng kết hợp và một mảng số hoặc cả hai. Hàm này lấy một hàng từ hàm mysql_query[] và nó trả về một mảng nếu nó ĐÚNG. Và khi xảy ra lỗi hoặc khi không còn hàng nào nữa thì FLASE
Mysql không có chức năng Tìm nạp mảng. mysql_fetch_array là một hàm PHP sẽ cho phép bạn truy cập dữ liệu được lưu trữ trong kết quả được trả về từ TRUE mysql_query nếu bạn muốn biết những gì được trả về khi bạn sử dụng hàm mysql_query để truy vấn cơ sở dữ liệu Mysql. Nó không phải là thứ mà bạn có thể thao tác trực tiếp
cú pháp
mysql_fetch_array[data,array_type]
Dữ liệu bắt buộc chỉ định con trỏ dữ liệu sẽ sử dụng và con trỏ dữ liệu là kết quả từ hàm mysql_query[]
Các kiểu mảng
giá trị có thể là
- *mysql_assoc đây là một mảng kết hợp
- *mysql_num đây là một mảng số
- *mysql_both đây là mặc định hoặc cả hai
Mã số
đầu ra
Array
{
[0] => Refsnes
[lastname] => Refsnes
[1] =>seesee
[FirstName] => seesee
}
Một hàng dữ liệu
Hàm mysql_fetch_array lấy tài nguyên truy vấn Mysql làm đối số
[$result] và nó sẽ trả về hàng dữ liệu đầu tiên được trả về bởi mysql_query
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_______4_______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_______5_______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_______4_______7
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______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];4_______7_______2
mysqli_query[$conn, $query]3_______4_______9
mysqli_query[$conn, $query]2_______5_______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_______8_______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
$stmt = $conn->prepare[$query]; $stmt->execute[];8
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$stmt = $conn->prepare[$query]; $stmt->execute[];5_______9_______1
$conn->close[];2
$conn->query[$query];7_______9_______4
$conn = mysqli_connect[$servername, $username, $password, $databasename];3____9_______6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______9_______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_______4_______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
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: 202
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_______8_______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
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh0
mysqli_query[$conn, $query]3_______90_______2
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3_______90_______4
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3_______90_______6
$stmt = $conn->prepare[$query]; $stmt->execute[];5_______90_______8
$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
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh3_______90_______2
$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];08
Roll 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_______4_______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
Roll 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];08
Roll 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_______4_______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
Roll 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_______9_______6
mysqli_query[$conn, $query]3_______4_______39
mysqli_query[$conn, $query]3_______4_______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_______4_______05
$conn = mysqli_connect[$servername, $username, $password, $databasename];45
$conn = mysqli_connect[$servername, $username, $password, $databasename];7
mysqli_query[$conn, $query]3_______9_______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
đầu ra
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: 20
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_______4_______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_______5_______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_______4_______7
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______5
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______7
$conn = mysqli_connect[$servername, $username, $password, $databasename];82_______4_______4_______4_______84
mysqli_query[$conn, $query]3_______4_______9
mysqli_query[$conn, $query]2_______5_______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_______8_______2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______8_______4
$conn = mysqli_connect[$servername, $username, $password, $databasename];97_______6_______7_______4_______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____9_______6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______9_______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_______4_______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
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];19_______6_______7
mysqli_query[$conn, $query]2
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
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
$stmt = $conn->prepare[$query]; $stmt->execute[];8
Roll 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[];5_______90_______8
$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_______90_______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[];2_______90_______8
$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
$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____9_______6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______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
đầu ra
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh
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_______4_______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_______5_______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_______4_______7
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______5
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______6_______7
$conn = mysqli_connect[$servername, $username, $password, $databasename];82_______4_______4_______4_______84
mysqli_query[$conn, $query]3_______4_______9
mysqli_query[$conn, $query]2_______5_______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_______8_______2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______8_______4
$conn = mysqli_connect[$servername, $username, $password, $databasename];97_______6_______7_______4_______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____9_______6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];3_______9_______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_______6_______37
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
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->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_______6_______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_______4_______9
mysqli_query[$conn, $query]2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];4_______7_______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_______6_______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_______6_______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
$conn->query[$query];58_______6_______81
$stmt = $conn->prepare[$query]; $stmt->execute[];8
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
$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
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[];8
Roll 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_______90_______8
$conn = mysqli_connect[$servername, $username, $password, $databasename];10
$conn = mysqli_connect[$servername, $username, $password, $databasename];11
$conn = mysqli_connect[$servername, $username, $password, $databasename];12_______4_______13
$conn = mysqli_connect[$servername, $username, $password, $databasename];21
$conn = mysqli_connect[$servername, $username, $password, $databasename];04
Roll 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
Roll 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];34
$conn = mysqli_connect[$servername, $username, $password, $databasename];7