CRUD XML PHP MYSQLI

Code di atas didapat dari code generate xml sbb:

anggota.php
<?php
require_once"../konmysqli.php";

$sql = "SELECT * FROM `member` order by `id` desc";
$xml .= "<record>";
$arr=getData($conn,$sql);
foreach($arr as $d) {
  $xml .= "<member>";
  $xml .= "<id>".$d['id']."</id>";
  $xml .= "<nama>".$d['nama']."</nama>";
  $xml .= "<alamat>".$d['alamat']."</alamat>";
  $xml .= "</member>";
}
$xml .= "</record>";

$sxe = new SimpleXMLElement($xml);//instansiasi objek SimpleXMLElement
$sxe->asXML("member.xml");
?>

tambahanggota,.php

<?php 

require_once"../konmysqli.php";

$nama = $_POST['nama'];

$alamat = $_POST['alamat'];

$xml = simplexml_load_file("member.xml"); //instansiasi objek SimpleXML

$sxe = new SimpleXMLElement($xml->asXML());

$sql= "insert into `member`(`nama`,`alamat`)values('$nama','$alamat')";

$simpan=process($conn,$sql);

$no_rows = getJum($conn,$sql);

$query = $sxe->addChild("member");  

$query->addChild("id", $no_rows);

$query->addChild("nama",  ($nama));

$query->addChild("alamat", ($alamat));

//Buat File XML

$sxe->asXML("member.xml");

?>

code di atas akan menambah data ke database sekaligus menggenerate ulang .xml nya

hapusanggota.php

<?php 

require_once"../konmysqli.php";

$id = $_GET['kode'];

$xml = simplexml_load_file("member.xml"); 

$sxe = new SimpleXMLElement($xml->asXML());//instansiasi objek SimpleXML

    $sql = "delete from `member` where `id`='$id'";

    $proses=process($conn,$sql);

//hapus data pada file xml

    $rows = count($sxe);

    for($i = 0, $length = $rows; $i < $length; $i++){

        if($sxe->member[$i]->id == $id){

            unset($sxe->member[$i]);

            break;

        }

        }

    $sxe->asXML("member.xml");

?>

updateanggota.php
<?php
require_once"../konmysqli.php";


if (isset($_POST['kode'])) {
$xml = simplexml_load_file("member.xml");
$sxe = new SimpleXMLElement($xml->asXML());

$id = $_POST['kode'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];

    $sql = "update member set `nama` = '$nama', `alamat` = '$alamat' where `id`='$kode'";
    $simpan=process($conn,$sql);

 $rows = count($sxe);
    for($i = 0, $length = $rows; $i < $length; $i++){
         if($sxe->member[$i]->id == $idmem){
            $sxe->member[$i]->nama = ($nama);
$sxe->member[$i]->alamat = ($alamat);
          }
    }
    $sxe->asXML("member.xml");
}
?>


Selamat mencoba......:-)

Download Source Code