Hoạt động 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 hoạt động CRUD [Tạo, đọc, cập nhật và xóa].
Trong bài viết này, chúng tôi sẽ thảo luận về phần đọc, tức là dữ liệu tìm nạp từ cơ sở dữ liệu.Read part i.e. data fetching from database.
Có hai cách để kết nối với cơ sở dữ liệu bằng PHP. Họ là như sau.
- MySQLI [Hồi I ”là viết tắt của cải tiến][“i” stands for improved]
- PDO [Đối tượng dữ liệu PHP] [PHP Data Objects]
MySQLI vs PDO: Cả hai cách thực sự tốt nhưng chỉ có một sự 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.: Both the ways are really good but there is only one difference between the two methods, PDO can work on 12 different database systems whereas MySQLi works with MySQL databases only.
Kết nối với cơ sở dữ liệu:
Mysqli hướng đối tượng & nbsp;
$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 các truy vấn: Sau khi kết nối với cơ sở dữ liệu, chúng tôi cần chạy các truy vấn để tìm nạp dữ liệu. Trong các hoạt động đọc, chúng tôi sẽ chỉ sử dụng các truy vấn để tìm nạp dữ liệu từ cơ sở dữ liệu.After connecting to the database we need to run queries to fetch data. In Read operations, we will use only select queries to fetch data from the database.
MySQLI hướng đối tượng
$conn->query[$query];
Thủ tục MySQLI
mysqli_query[$conn, $query]
PDO
$stmt = $conn->prepare[$query]; $stmt->execute[];
Thực hiện các truy vấn: Sau khi kết nối với cơ sở dữ liệu, chúng tôi cần chạy các truy vấn để tìm nạp dữ liệu. Trong các hoạt động đọc, chúng tôi sẽ chỉ sử dụng các truy vấn để tìm nạp dữ liệu từ cơ sở dữ liệu.After the fetching is performed, you should close the connection to the database using the close[] function.
$conn->close[];
MySQLI hướng đối tượng
Kết nối gần: Sau khi tìm nạp được thực hiện, bạn nên đóng kết nối với cơ sở dữ liệu bằng hàm đóng [].
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`] ];
Cơ sở dữ liệu mẫu
Tạo bảng trong cơ sở dữ liệu:
Chi tiết sinh viên
Cách tiếp cận hướng đối tượng MySQLI:
$conn = mysqli_connect[$servername, $username, $password, $databasename];1
Mã PHP:
PHP
$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];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];5
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn->query[$query];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
mysqli_query[$conn, $query]5
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];5
$conn->query[$query];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
$conn->query[$query];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->query[$query];3
$stmt = $conn->prepare[$query]; $stmt->execute[];0
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$stmt = $conn->prepare[$query]; $stmt->execute[];2___
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];1
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn->query[$query];9
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`] ];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];3
$conn->close[];9
$conn->close[];1
mysqli_query[$conn, $query]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
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`] ];8
$conn->query[$query];9
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->close[];6
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`] ];6
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 | 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: 200
mysqli_query[$conn, $query]8
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
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];6
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: 205
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: 208
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: 209
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh0
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh1
‘
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 | 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
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh4
$conn = mysqli_connect[$servername, $username, $password, $databasename];16
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh6
$conn = mysqli_connect[$servername, $username, $password, $databasename];18
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
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
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn->query[$query];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];23
Các
‘
$conn->query[$query];9
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];33
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];35
$conn = mysqli_connect[$servername, $username, $password, $databasename];36
Output:
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
$conn->query[$query];
9$conn = mysqli_connect[$servername,
$username, $password, $databasename];
25 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`]
];
8
Chi tiết sinh viên
Cách tiếp cận hướng đối tượng MySQLI:
$conn = mysqli_connect[$servername, $username, $password, $databasename];1
Mã PHP:
PHP
$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];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];5
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn->query[$query];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
mysqli_query[$conn, $query]5
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];5
$conn->query[$query];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
$conn->query[$query];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->query[$query];3
$stmt = $conn->prepare[$query]; $stmt->execute[];0
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$stmt = $conn->prepare[$query]; $stmt->execute[];2___
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];1
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];3
$conn->close[];9
$conn->close[];1
mysqli_query[$conn, $query]5
$conn->query[$query];9
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->close[];6
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`] ];6
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 | 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: 200
mysqli_query[$conn, $query]8
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
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];6
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: 205
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$stmt = $conn->prepare[$query]; $stmt->execute[];9
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: 208
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: 209
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh0
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh1
‘
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];35
$conn = mysqli_connect[$servername, $username, $password, $databasename];36
Output:
Roll No: 1 - Name: Ram Roll No: 2 - Name: Shyam Roll No: 3 - Name: Rohit Roll No: 4 - Name: Suresh
Các
Chi tiết sinh viên
Cách tiếp cận hướng đối tượng MySQLI:
$conn = mysqli_connect[$servername, $username, $password, $databasename];1
Mã PHP:
PHP
$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];2
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];5
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn->query[$query];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];8
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
mysqli_query[$conn, $query]5
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];5
$conn->query[$query];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];3
$conn->query[$query];8
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->query[$query];3
$stmt = $conn->prepare[$query]; $stmt->execute[];0
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];91
$conn = mysqli_connect[$servername, $username, $password, $databasename];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`] ];8
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$stmt = $conn->prepare[$query]; $stmt->execute[];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`] ];9
$conn->query[$query];00
$conn = mysqli_connect[$servername, $username, $password, $databasename];62
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];8
mysqli_query[$conn, $query]1
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];3
mysqli_query[$conn, $query]5
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];1
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn->close[];6
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->query[$query];3
$conn->close[];9
$conn->close[];1
mysqli_query[$conn, $query]5
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$conn->query[$query];11
$conn->query[$query];19
$conn->query[$query];9
mysqli_query[$conn, $query]7
mysqli_query[$conn, $query]8
$conn->close[];6
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`] ];6
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 | 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: 200
mysqli_query[$conn, $query]8
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
$conn = mysqli_connect[$servername, $username, $password, $databasename];4
$conn->close[];6
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: 205
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$conn->query[$query];31
mysqli_query[$conn, $query]8
$conn->close[];6
$conn->query[$query];34
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
$conn->query[$query];36
$stmt = $conn->prepare[$query]; $stmt->execute[];1
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`] ];8
Is
Các
$stmt = $conn->prepare[$query]; $stmt->execute[];1
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$conn = new PDO["mysql:host=$servername;dbname=myDB", $username, $password, $databasename];27
$conn->query[$query];66
$conn->query[$query];67
$conn->query[$query];68
$conn = mysqli_connect[$servername, $username, $password, $databasename];74
$stmt = $conn->prepare[$query]; $stmt->execute[];1
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: 209
$conn->query[$query];72
$stmt = $conn->prepare[$query]; $stmt->execute[];5
$conn->query[$query];68
$conn->query[$query];75
$conn = mysqli_connect[$servername, $username, $password, $databasename];2
$stmt = $conn->prepare[$query]; $stmt->execute[];9
$conn->query[$query];3
$conn = mysqli_connect[$servername, $username, $password, $databasename];35
$conn = mysqli_connect[$servername, $username, $password, $databasename];36
Output:
$conn = mysqli_connect[$servername, $username, $password, $databasename];0