Â¥Ö÷

[Ô­´´]ÓÃxmlÄ£·ÂmysqlµÄÀà <?php /****************************************************************************************** *                                                                                         * * ÎļþÃû£º xml.php                                                                        * * ×÷  Ó㺠xmlÀà,ÍêÉÆÖÐ,ÔÝÖ»Ö§³ÖÈý¼¶½Úµã                                                  * *                                                                                         * * ×÷  Õߣº loking(biyees)                                                                 * * Email£º  biyees@gmail.com  QQ:4967530                                                   * *                                                                                         * * example ¶ÁÈ¡Êý¾Ý£º                                                                      * * $xml = new xml("dbase.xml",'table');                                                    * * $data=$xml->xml_fetch_array();                                                          * * echo "<pre style=\"font-size:12px;\">";                                                 * * print_r($data);                                                                         * *                                                                                         * ******************************************************************************************/ class xml {  var $dbase;       //Êý¾Ý¿â,Òª¶ÁÈ¡µÄXMLÎļþ  var $dbname;      //Êý¾Ý¿âÃû³Æ,¶¥²ãÔªËØ,ÓëÊý¾Ý¿âÎļþÃû³ÆÒ»Ö  var $dbtable;     //Êý¾Ý±í,ҪȡµÃµÄ½Úµã  var $parser;      //ÆÊÎöÆ÷   var $vals;        //ÊôÐÔ  var $index;       //Ë÷Òý  var $dbtable_array;//½ÚµãÊý×é  var $array;        //ϼ¶½ÚµãµÄÊý×é  var $result;       //·µ»ØµÄ½á¹û  var $querys;        function xml($dbase,$dbtable)  {   $this->dbase=$dbase;   $this->dbname=substr($dbase,strrpos($dbase,"/")+1,-4);   $this->dbtable=$dbtable;   $data=$this->ReadXml($this->dbase);   if(!$data){    die("ÎÞ·¨¶ÁÈ¡ $this->dbname.xml");   }         $this->parser = xml_parser_create();         xml_parser_set_option($this->parser,XML_OPTION_CASE_FOLDING,0);   xml_parser_set_option($this->parser,XML_OPTION_SKIP_WHITE,1);         xml_parse_into_struct($this->parser,$data,$this->vals,$this->index);     xml_parser_free($this->parser);   //±éÀúË÷Òý£¬É¸Ñ¡³öҪȡֵµÄ½Úµã ½ÚµãÃû:$dbtable   foreach ($this->index as $key=>$val) {    if ($key == $this->dbtable) {     //È¡µÃ½ÚµãÊý×é     $this->dbtable_array = $val;     } else {     continue;    }   }   for ($i=0; $i < count($this->dbtable_array); $i+=2) {    $offset = $this->dbtable_array[$i] + 1;         $len    = $this->dbtable_array[$i + 1] - $offset;    //array_slice() ·µ»Ø¸ù¾Ý offset ºÍ length ²ÎÊýËùÖ¸¶¨µÄ array Êý×éÖеÄÒ»¶ÎÐòÁС£    //ËùÈ¡½Úµãϼ¶Êý×é    $value=array_slice($this->vals,$offset,$len);    //È¡µÃÓÐЧÊý×飬ºÏ²¢Îª½á¹ûÊý×é    $this->array[]=$this->parseEFF($value);   }   return true;  }  //½«XMLÎļþ¶ÁÈë²¢·µ»Ø×Ö·û´®  function ReadXml($file)  {   return file_get_contents($file);  }      //È¡µÃÓÐЧÊý×é  function parseEFF($effective) {   for ($i=0; $i < count($effective); $i++){    $effect[$effective[$i]["tag"]] = $effective[$i]["value"];   }   return $effect;  }  //xml_query(·½·¨,Ìõ¼þ,¶àÌõ¼þʱÂß¼­ÔËËã·ûand or or,×ÜÊý¾ÝÊý×é,²åÈë»ò¸üеÄÊý×é)  function xml_query($method,$condition,$if='and',$array=array())  {   if(($method=='select')||($method=='count')){    return $this->xml_select($method,$condition,$if);   } elseif($method=='insert') {    return $this->xml_insert($condition,$if,$array);   } elseif($method=='update') {    return $this->xml_update($condition,$if,$array);   }  }  //È¡µÃxmlÊý×é     function xml_fetch_array($condition,$if)     {   //$this->querys++;   $row = $this->array; //³õʼ»¯Êý¾ÝÊý×é   if($condition) {    //ÊÇ·ñÓÐÌõ¼þ,ÈçÓÐÌõ¼þÔòÉú³É·ûºÏÌõ¼þµÄÊý×é    //Éú³ÉÌõ¼þÊý×é,Ìõ¼þ¸ñʽ field,operator,match    $condition=explode(",",$condition);//Ìõ¼þÊý×é    $cs=count($condition)/3;           //Ìõ¼þÊý    for($i=0;$i<$cs;$i++){     $conditions[]=array("field"=>$condition[$i*3],"operator"=>$condition[$i*3+1],"match"=>$condition[$i*3+2]);    }    //echo count($row);    for($r=0;$r<count($row);$r++){     for($c=0;$c<$cs;$c++){      //$i++;      $condition=$conditions[$c];   //µ±Ç°Ìõ¼þ      $field=$condition['field'];      //×ֶΠ     $operator=$condition["operator"];//ÔËËã·û      $match=$condition['match'];      //Æ¥Åä         if(($operator=='=')&&($row[$r][$field]==$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1       } elseif(($operator=='!=')&&($row[$r][$field]!=$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1      } elseif(($operator=='<')&&($row[$r][$field]<$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1      } elseif(($operator=='<=')&&($row[$r][$field]<=$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1      } elseif(($operator=='>')&&($row[$r][$field]>$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1      } elseif(($operator=='>')&&($row[$r][$field]>=$match)){       $true++;//ÈôÌõ¼þ·ûºÏ,·ûºÏÊý¼Ó1      }          }         //¸ù¾ÝÌõ¼þÈ¡Öµ     if($if=='and'){      //Èç¹û¶àÌõ¼þΪand,µ±·ûºÏÊýµÈÓÚÌõ¼þÊýʱ,Éú³ÉÊý×é      if($true==$cs){       $result[]=$row[$r];      }     } else {      //Èç¹û¶àÌõ¼þΪor,µ±ÓзûºÏ¼Í¼ʱ,Éú³ÉÊý×é      if($true!=0){       $result[]=$row[$r];      }     }     //echo $true;     //echo "<pre style=\"font-size:12px;\text-align:left\">";     //print_r($true);     $true=0;//·ûºÏÌõ¼þÊý¹éÁã,½øÈëÏÂÒ»ÂÖÑ­»·    }   } else {    $result=$this->array;   }    //echo "<pre style=\"font-size:12px;\text-align:left\">";   //print_r($this->result);   return $result;     }  //ɸѡ»òͳ¼Æ  function xml_select($method,$condition,$if)  {   $result=$this->xml_fetch_array($condition,$if);   if($method=='select'){    return $result;   } else {    return count($result);   }     }  //²åÈëÊý¾Ý  function xml_insert($condition,$if,$array)  {   $data=$this->xml_fetch_array($condition,$if);//×ÜÊý¾ÝÊý×é   $data[]=$array;                              //²åÈëºóµÄ×ÜÊý¾ÝÊý×é   $this->array=$data;                          //¸üÐÂ×ÜÊý×é   $this->WriteXml($data);  }     //µÃµ½¸üеÄXML²¢¸Äд  function xml_update($condition,$if,$array)  {   $datas=$this->array;                              //×ÜÊý¾ÝÊý×é   $subtract=$this->xml_fetch_array($condition,$if);//Òª¸üеÄÊý×é   //echo "<pre style=\"font-size:12px;\text-align:left\">";   //print_r($data);   //print_r($datas);   //echo "ÿÌõ¼Ç¼ÖÐÓÐ".count($datas[0])."¸öÖµ<br>";   for($i=0;$i<count($datas);$i++){    $data=$datas[$i];    //echo "ԭʼ¼Ç¼ÖеĵÚ".$i."Ìõ<br>";    foreach($data as $k=>$v){     //echo "-µÚ".$i."ÌõµÄ".$k."ֵΪ".$v."<br>";     //echo "--Òª²éÕÒµÄÊý×é".$k."ֵΪ".$subtract[0][$k]."<br>";     if($v==$subtract[0][$k]){      $is++;     }       }    if($is==count($data)){     //echo "----ÓëµÚ".$i."Ìõ·ûºÏ<br>";     $datas[$i]=$array;     //array_splice($datas,$i,$i+1);    }    //echo "ԭʼ¼Ç¼ÖеĵÚ".$i."ÌõÓëÒª²éÕÒµÄÓÐ".$is."Æ¥Åä<br>";        //echo "ԭʼ¼Ç¼ÖеĵÚ".$i."Ìõ½áÊø<br>";    $is=0;   }   //array_splice($datas,2,2+1,$array);   //echo "<pre style=\"font-size:12px;\text-align:left\">";   //print_r($datas);   $this->array=$datas;   $this->WriteXml($datas);     }  //дÈëXMLÎļþ(È«²¿Ð´Èë)  function WriteXml($array)  {   if(!is_writeable($this->dbase)){    die("ÎÞ·¨Ð´Èë".$this->dbname.".xml");   }   $xml.="<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n";   $xml.="<$this->dbname>\r\n";   for($i=0;$i<count($array);$i++){    $xml.="<$this->dbtable>\r\n";    foreach($array[$i] as $k=>$s){     $xml.="<$k>$s</$k>\r\n";    }    $xml.="</$this->dbtable>\r\n";   }   $xml.="</$this->dbname>";   $fp=@fopen($this->dbase,"w");   flock($fp, LOCK_EX);   rewind($fp);     fputs($fp,$xml);   fclose($fp);  }  //ÖðÐÐдÈëxml(ÎÒÊÔ×ÅдÈë10000ÐÐ,¸Ð¾õûһ´ÎдÈë¿ì£¬ËùÒÔûÓÃÕâÖÖдÈ뷽ʽ)  function WriteLine($array)  {   if(!is_writeable($this->dbase)){    die("ÎÞ·¨Ð´Èë".$this->dbname.".xml");   }   $fp=@fopen($this->dbase,"w");   rewind($fp);   flock($fp, LOCK_EX);   fputs($fp,"<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n");   fputs($fp,"<$this->dbname>\r\n");   for($i=0;$i<count($array);$i++){    fputs($fp,"<$this->dbtable>\r\n");    $xml.="<$this->dbtable>\r\n";    foreach($array[$i] as $k=>$s){     fputs($fp,"<$k>$s</$k>\r\n");    }    fputs($fp,"</$this->dbtable>\r\n");   }   fputs($fp,"</$this->dbname>");   fclose($fp);  } } ?>    Êղؠ  ·ÖÏí   ¶¥(0)