TI

Pertanyaan

1. Saya menjalankan perintah query seperti ini
CREATE DATABASE `dbkuu` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

2. Lalu saya buat Table seperti ini di database 'dbkuu'
CREATE TABLE member
(
id int NOT NULL,
email varchar(255),
password varchar(255),
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

3. Lalu saya meng Insert seperti ini di Database 'dbkuu'

INSERT INTO member (id, email, password)
VALUES
(1,'member1@brainly.com','secretpasswordofmember1'),
(2,'member2@brainly.com','secretpasswordofmember2'),
(3,'member3@brainly.com','secretpasswordofmember3'),
(4,'member4@brainly.com','secretpasswordofmember4');

4. Lalu saya menjalankan script PHP seperti ini.

$servername = "localhost";
$username = "root";
$password = "xxxx";
$dbname = "dbku";

$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT id, email, password FROM member";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
echo '<ol><ul>';
while($row = $result->fetch_assoc()) {

echo "<li>Id : ".$row['id']." Email : ".$row['email']." Pass : ".$row['pass']."</li>";

}
echo '</ul></ol>';

?>

Pertanyaan nya. Apa Output dari kode php di atas?

1 Jawaban

  • Kolom ID di html tsb berisi data dari kolom ID di database
    Kolom Email di html tsb berisi data dari kolom Email di database
    Kolom Pass di html tsb berisi data dari kolom Pass di database

Pertanyaan Lainnya