kode php

Cara mengambil data dari database di php untuk halaman login

Saya menggunakan manageLoginMHS hanya sebagai file pembantu. NRP & varchar dari loginMHS akan diperiksa. Jika user tidak menginput NRP, program akan menampilkan pesan "Input perwalian belum dapat diakses saat ini". Apakah saya benar-benar membutuhkan file ini?

Input perwalian belum dapat diakses saat ini" . "
"; } else { header('Location: inputPerwalian.php'); } } if(mysqli_num_rows($result) > 0) { if($pass == $row['password'] && $nrp == $row['nrp']) { $_SESSION['login'] = TRUE; header("Location: inputPerwalian.php"); } else { echo "Invalid Password"; } } else { echo "User not found"; } break; default: die("Unknown"); } ?>

Kemudian program akan menampilkan data di inputPerwalian dari database, yang memiliki NRP & varchar yang sama. Ini kodenya

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)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

$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$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`) );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

mysqli_query($conn, $query)3Roll 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: 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

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$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

Pendekatan 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 = 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

$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

$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`) );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

$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: 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________88______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$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$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: Suresh

Pendekatan PDO