WEB Service - Program PHP untuk menampilkan tabel format XML

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