notes

xml_crud_example

{{ :xml-crud-example.zip |}}
, 
, http://peteolson.byethost22.com/sandbox/xml-crud-example|working example
, 
, I didnt include the css related files, they are all in the zip archive
, 
, <file xml data.xml>
, <?xml version=DQ1.0DQ?>
, <humans>
, 
,     <user id=DQ1DQ>
,         <name>peter</name>
,         <notes>notes</notes>
,     </user>	
, 	
,     <user id=DQ6DQ>
,         <name>janice</name>
,         <notes>notes</notes>
,     </user>
, 	
,     <user id=DQ3DQ>
,         <name>buddy</name>
,         <notes>notes</notes>
,     </user>
, 	
, </humans>
, 
, </file>
, 
, <file php index.php>
, <?php
,  header(location:process.php?list);
, </file>
, 
, <file php header.php>
, <!DOCTYPE html>
, <html lang=DQenDQ>
, <head>
, 
,   
,   <meta charset=DQutf-8DQ>
,   <title>Your page title here :)</title>
,   <meta name=DQdescriptionDQ content=DQDQ>
,   <meta name=DQauthorDQ content=DQDQ>
, 
,   
,   <meta name=DQviewportDQ content=DQwidth=device-width, initial-scale=1DQ>
, 
,   
,   <link href=DQ//fonts.googleapis.com/css?family=Raleway:400,300,600DQ rel=DQstylesheetDQ type=DQtext/cssDQ>
, 
,   
,   <link rel=DQstylesheetDQ href=DQcss/normalize.cssDQ>
,   <link rel=DQstylesheetDQ href=DQcss/skeleton.cssDQ>
, 
,   
,   <link rel=DQiconDQ type=DQimage/pngDQ href=DQimages/favicon.pngDQ>
, 
, </head>
, <body>
, <div class=DQcontainerDQ>
,     <div class=DQrowDQ>
,       <div class=DQone-half columnDQ style=DQmargin-top: 5%DQ>
, 
,   
,       
,         <h4><a class=DQnoUnderlineDQ href=DQindex.phpDQ>Home</a></h4>
,         <ul>
, 		<li><a href=DQuser.phpDQ>Add User</a></li>
, 		</ul>
, 
,             <form method=DQPOSTDQ action=DQprocess.php?filterDQ>
,                 <input type=DQtextDQ value= name=DQnameDQ/>
,                 <input type=DQsubmitDQ value=DQFilterDQ/>
,             </form>
,       
, 
, 
, </body>
, </html>
, </file>
, 
, <file php footer.php>
, </div>
, </div>
, </div>
, </file>
, 
, <file php user.php>
, <?php 
, if (!isset($id) || $id == DQDQ) :
, include(header.php);
, 
, ?>
, <h3>Add New Record</h3>
, <form method=DQPOSTDQ action=DQprocess.php?addDQ>
,     <table>
,         
,         <tr>
,             <td>Name</td>
,             <td><input type=text name=name/></td>
,         </tr>
,        
,         <tr>
,             <td>Notes</td>
, 
,             <td><input type=text name=notes/></td>
,         </tr>
,     </table>
,     <input type=DQsubmitDQ value=DQSaveDQ/>
, </form>
, <?php 
, include(footer.php);
, else:
, ?>
, 
,     <h3>Update:</h3>
,     <form method=DQPOSTDQ action=DQprocess.php?updateDQ>
,         <table>
,             <tr>
, 
,                 <td><input type=hidden name=id value=<?php echo $user->attributes()->id;?>/></td>
,             </tr>
,             <tr>
,                 <td>Name</td>
,                 <td><input type=text name=name value=<?php echo $user->name;?>/></td>
,             </tr>
,            
,             <tr>
,                 <td>Notes</td>
, 
,                 <td><input type=text name=notes value=<?php echo $user->notes;?>/></td>
,             </tr>
,         </table>
,         <input type=DQsubmitDQ value=DQSaveDQ/>
,     </form>
,     <form method=DQPOSTDQ action=DQprocess.php?deleteDQ>
, 	<input type=hidden name=id value=<?php echo $user->attributes()->id;?>/>
, 	<input type=DQsubmitDQ value=DQDeleteDQ/>
,     </form>
, 
, <?php 
, endif;
, ?>
, </file>
, 
, <file php process.php>
, <?php
, /**
,  * Created by Gayan Hewa
,  * User: Gayan
,  * Date: 6/7/13
,  * Time: 3:12 AM
,  */
,  include(header.php);
, 
, class Process
, {
,     protected $_xml;
,     protected $path;
, 
,     public function __construct()
,     {
,         $this->_xml = simplexml_load_file(DQdata.xmlDQ);
,     }
, 
,     public function getXml()
,     {
,         return $this->_xml;
,     }
, 
,     /**
,      * @param mixed $path
,      */
,     public function setPath($path)
,     {
,         $this->path = $path;
,     }
, 
,     /**
,      * @return mixed
,      */
,     public function getPath()
,     {
,         return $this->path;
,     }
, 
,     public function userlist()
,     {
,         echo DQ<table class=u-full-width>
, 				<thead>
, 					<tr>
, 					  <th>Name</th>
, 					  <th>Notes</th>
, 					</tr>
, 				</thead>
, 		
, 		DQ;
, 
,         foreach ($this->_xml as $user) {
,             echo DQ
,             <tr>
,                     <td>
,                      <a href=process.php?edit=DQ . $user->attributes()->id . DQ>{$user->name}</a> 
,                     </td>
, 					
, 					<td>
, 						{$user->notes} 
,                     </td>
,             </tr>
,             DQ;
,         }
,         echo DQ</table>DQ;
, 		
,     }
, 
,     public function filterList($post)
,     {
,         $xml = $this->_xml->xpath(username=DQ . strtolower($post) . DQ);
,         echo DQ<table>DQ;
, 
,         foreach ($xml as $user) {
, 
,             echo DQ
,             <tr>
,                     <td>{$user->name}</td>
,                     <td>{$user->notes}</td>
,             </tr>
,             DQ;
,         }
,         echo DQ</table>DQ;
,     }
, 	public function format_xml_file()
, 	{
, 		$xmlFile = $this->path;
, 		if( !file_exists($xmlFile) ) die(Missing file:  . $xmlFile);
, 		else
, 		{
, 		  $dom = new DOMDocument(1.0);
, 		  $dom->preserveWhiteSpace = false;
, 		  $dom->formatOutput = true;
, 		  $dl = @$dom->load($xmlFile); // remove error control operator //(@) to print any error message generated while loading.
, 		  if ( !$dl ) die(Error while parsing the document:  . $xmlFile);
, 		  $dom->save($xmlFile);
, 		}
, 	}
,     public function adduser($post)
,     {
,         if ($postDQnameDQ != DQDQ) 
,          {
,             $xml = $this->_xml;
,             $user = $xml->addChild(user);
,             $name = $user->addChild(DQnameDQ, $postDQnameDQ);
,             $user_notes = $user->addChild(DQnotesDQ, $postDQnotesDQ);
, 			$user->addAttribute(DQidDQ, $this->user_id());
,             $xml->asXML($this->path);
,         }
, 		$this->format_xml_file();
, 		header(location:process.php?list);
,     }
, 	public function user_id()
, 	{
, 		$id = 0;
, 		$ids = $this->_xml; 
, 			foreach ($this->_xml as $ids) 
, 			{
, 				if ($id < (int) $ids->attributes()->id)
, 				{
, 					$id = $ids->attributes()->id;				
, 				}
, 			}
, 		return $id +=1 ;
, 	}
, 	
,     public function getUserById($id)
,     {
,         $user = $this->_xml->xpath(//user@id=DQ . $id . DQ);
,         return $user0;
,     }
, 
,     public function updateUser($post)
,     {
,         $user = $this->_xml->xpath(user@id=DQ . $postid . DQ);
,         $user0->name = $postDQnameDQ;
,         $user0->notes = $postDQnotesDQ;
,         $this->_xml->asXML($this->path);
, 		header(location:process.php?list);
,     }
, 	public function deleteUser($post)
, 	{
, 		$id = $postid;
, 		$i = 0;
, 		foreach ($this->getXml() as $user){
, 			if ($user->attributes()->id == $id){
, 				unset($this->getXml()->user$i);
, 				$this->getXml()->asXML($this->path);
, 				break;
, 			}
,         $i++;
, 		}
, 		header(location:process.php?list);
, 	}
, }
, 
, //Include template
, //include index.php;
, 
, 
, 
, //Controller
, $param = $_SERVERQUERY_STRING;
, $arr = explode(DQ=DQ, $param);
, if (count($arr) > 1) {
,     $param = $arr0;
, }
, $path = getcwd().DQ/data.xmlDQ;
, $process = new Process();
, $process->setPath($path);
, 
, if ($param == DQlistDQ) {
,     $process->userlist();
, }
, if ($param == DQaddDQ) {
,     $post = $_POST;
,     $process->adduser($post);
, 	//echo $process->id();
,     //include user.php;
, }
, if ($param == DQfilterDQ) {
,     $post = $_POSTDQnameDQ;
,     $process->filterList($post);
, }
, 
, if ($param == DQdeleteDQ) {
, 	$post = $_POST;
,     $process->deleteUser($post);
, }
, 
, if ($param == DQeditDQ) {
,     $id = $arr1;
,     $user = $process->getUserById($id);
,     include user.php;
, }
, 
, if ($param == DQupdateDQ) {
,     $post = $_POST;
,     $process->updateUser($post);
, }
, 
, include(footer.php);
, ?>
,  
,  
, </file>