Tugas 2 kuliah Web Service
Nama : M.Imam Catur T.P
NIM : 16.01.53.0187
Dipunyai database : akademik dan tabel mahasiswa dengan field sb:
nim varchar(15)
nama varchar(150)
alamat varchar(250)
progdi varchar(10)
Buatlah program php untuk menampilkan isi tabel mahasiswa dengan format XML
1. Coding access.php
<?php
//Koneksi
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "akademik";
// Membuat konesi
$conn = new mysqli($servername, $username, $password, $dbname);
// Mengecek koneksi
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT nim, nama, alamat, progdi FROM mahasiswa";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
// output data masing-masing row
$doc = new DOMDocument();
$doc->formatOutput = true;
$r = $doc->createElement( "akademik" );
$doc->appendChild( $r );
while($row = $result->fetch_assoc())
{
$b = $doc->createElement( "mhsw" );
echo "<br> nim: ". $row["nim"]. " - Nama: ". $row["nama"]. " "." - Alamat: " . $row["alamat"]." - Progdi: " . $row["progdi"] . "<br>";
echo "<br> ";
$nim = $doc->createElement( "nim" );
$nim->appendChild
(
$doc->createTextNode( $row["nim"] )
);
$b->appendChild( $nim );
$nama = $doc->createElement( "nama" );
$nama->appendChild
(
$doc->createTextNode( $row["nama"] )
);
$b->appendChild( $nama );
$alamat = $doc->createElement( "alamat" );
$alamat->appendChild
(
$doc->createTextNode( $row["alamat"] )
);
$b->appendChild( $alamat );
$progdi = $doc->createElement( "progdi" );
$progdi->appendChild
(
$doc->createTextNode( $row["progdi"] )
);
$b->appendChild( $progdi );
$r->appendChild( $b );
}
} else {
echo "0 results";
}
echo $doc->saveXML();
$doc->save("akademik.xml");
$conn->close();
?>
2. Gambar data dan hasil
Gambar data file php, sql dan xml
Gambar data di localhost
