Membuat Data XML dari PHP dan MYSQLI

 Membuat Data XML dari PHP dan MYSQLi










Buat Database Dulu

-- phpMyAdmin SQL Dump -- version 4.1.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 10, 2014 at 11:57 AM -- Server version: 10.0.10-MariaDB-1~wheezy-log -- PHP Version: 5.4.4-14+deb7u10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `belajar` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_siswa` -- CREATE TABLE IF NOT EXISTS `tbl_siswa` ( `id_siswa` int(11) NOT NULL AUTO_INCREMENT, `nama` varchar(250) NOT NULL, `kelas` varchar(250) NOT NULL, `jurusan` varchar(250) NOT NULL, `foto` varchar(250) NOT NULL, PRIMARY KEY (`id_siswa`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `tbl_siswa` -- INSERT INTO `tbl_siswa` (`id_siswa`, `nama`, `kelas`, `jurusan`, `foto`) VALUES (1, 'Muhammad Taufiq Hidayat', '11', 'Rekayasa Perangkat Lunak', '33.jpg'), (2, 'Agus Krisnamukti', '12', 'Rekayasa Perangkat Lunak', '22.jpeg'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Lalu Buat File Untuk Membuat File php dengan nama siswa_xml.php

<?php Header('Content-type: text/xml'); $ganteng = new mysqli('localhost','root','mutahz','belajar'); $data = "<siswalist>"; $query = "SELECT * FROM tbl_siswa"; $result = $ganteng->query($query); if ($result->num_rows>0) { while ($row=$result->fetch_array()) { $data .= "<siswa id=\"".$row['id_siswa']."\">"; $data .= "<nama>".$row['nama']."</nama>"; $data .= "<kelas>".$row['kelas']."</kelas>"; $data .= "<jurusan>".$row['jurusan']."</jurusan>"; $data .= "<foto>".$row['foto']."</foto>"; $data .= "</siswa>"; } $data.="</siswalist>"; $jadi = new SimpleXMLElement($data); echo $jadi->asXML(); }else{ echo "Data Kosong"; } $ganteng->close(); ?>

Nanti Hasilnya Kayak Gini
http://toko-islam.web.id/siswa_xml.php