***Connection establish : #Mysql : $con = mysql_connect('Server Host Name','User Name' ,'Password'); mysql_select_db('Database name',$con); #XML : $xml = simplexml_load_file("users.xml"); //This line will load the XML file. $sxe = new SimpleXMLElement($xml->asXML()); ***View the details: #Mysql: #XML : $rows = count($sxe); for($i=0;$i<$no_rows;$i++){ echo ($sxe->users[$i]->name); } ***Insert the details: #Mysql: $query = "insert into users(id,name)values($id,'$name')"; $result = mysql_query($quesry); #XML: $no_rows = count($sxe); $query = $sxe->addChild("users"); $query->addChild("id", $no_rows+1); $query->addChild("name", ($name)); $sxe->asXML("users.xml"); ***Edit the details: #Mysql : $query = "select * from users where id=".$edit_id; //and update query : $query_update = "update users set name = '$name' where id=$edit_id"; $result = mysql_query($query_update); #XML: users[$i]->id == $edit_id){ ?> users[$i]->id == $edit_id){ $sxe->users[$i]->name = ($name); } } $sxe->asXML("users.xml"); ***Delete the details: #Mysql : $query = "delete from users where id=".$edit_id; $result = mysql_query($query); #XML : $rows = count($sxe); for($i = 0, $length = $rows; $i < $length; $i++){ if($sxe->users[$i]->id == $edit_id){ unset($sxe->users[$i]); break; } } $sxe->asXML("users.xml"); ***Database: CREATE TABLE `users` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 250 ) NOT NULL ) #XML File: //(users.xml)