function xml($filename = 'Archivo.xml', $table = 'scaj') { $this->load->library("xml2sql"); $xml = new xml2sql($filename); $db = $xml->analizador(); foreach ($db as $key => $val) { //echo "<pre>"; //print_r($val); //echo "</pre>"; $this->db->insert($table, $val); echo 'insertado'; } }
function insertar($filename = 'Archivo1.xml', $table = 'gser') { $this->load->library("xml2sql"); $xml = new xml2sql($filename); $db = $xml->analizador(); //echo $filename; foreach ($db as $key => $val) { echo "<pre>"; print_r($val); echo "</pre>"; $this->db->insert($table, $val); echo $key; } }
function handle_event($ev) { global $sql; $this->long_name = $ev->parent_name; //$id,$current //$sql,$db,$tbl,$atbl if ($ev->rem_name == 'bt') { $sql->logquerys = false; $ld = new xml2sql(); $ld->sql =& $sql; $ld->tbl = 'xml_editor_nodes'; $ld->atbl = 'xml_editor_attributes'; $ld->id = 0; $sql->query('DELETE FROM xml_editor_nodes'); $sql->query('DELETE FROM xml_editor_attributes'); $ld->notrans = true; if ($ld->notrans) { $sql->query('ALTER TABLE ' . $ld->tbl . ' DISABLE KEYS'); } if ($ld->notrans) { $sql->query('ALTER TABLE ' . $ld->atbl . ' DISABLE KEYS'); } if ($ld->notrans) { $sql->query('START TRANSACTION'); } ini_set('max_execution_time', 60 * 10); $handle = fopen("../xml/LT.fods", "r"); // $handle = fopen("../xml/o.zml", "r"); // $handle = fopen("../xml/greport3.smc", "r"); // $handle = fopen("../xml/greport3.xml", "r"); // $handle = fopen("../xml/xls.xml", "r"); // $handle = fopen("../xml/ДОХОД_2НДФЛ_6025_6025026876602501001_20090226_CBED40B3-78D3-4B2A-BD21-AEC68E1837DF.xml", "r"); //print "<pre>".htmlspecialchars($v)."</pre>"; if ($handle) { while (!feof($handle)) { //$v=fread($handle,1); //if(ord($v)<ord(' '))$v=' '; //read 16K $v = fread($handle, 16384); //replace invalid chars with whitespace $v = preg_replace('/[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]/', ' ', $v); if (feof($handle)) { $ld->feed($v, true); } else { $ld->feed($v, false); } } } fclose($handle); if ($ld->notrans) { $sql->query('COMMIT'); } if ($ld->notrans) { $sql->query('ALTER TABLE ' . $ld->tbl . ' ENABLE KEYS'); } if ($ld->notrans) { $sql->query('ALTER TABLE ' . $ld->atbl . ' ENABLE KEYS'); } print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='read-Ok';"; if ($sql->logquerys) { print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='"; foreach ($sql->querylog as $e) { $a = "<div><div>" . htmlspecialchars($e->q) . "</div><div>" . htmlspecialchars($e->e) . "</div></div>\n"; print js_escape($a); } print "';"; } } if ($ev->rem_name == 'wo') { $sql->logquerys = false; $ld = new xml2sql(); $ld->sql =& $sql; $ld->tbl = 'xml_editor_nodes'; $ld->atbl = 'xml_editor_attributes'; $ld->id = 0; $this->handle = fopen("../xml/xmlsql-out.xml", "w"); ini_set('max_execution_time', 60 * 5); // $handle = fopen("../xml/greport3.xml", "r"); // $handle = fopen("../xml/xls.xml", "r"); // $handle = fopen("../xml/ДОХОД_2НДФЛ_6025_6025026876602501001_20090226_CBED40B3-78D3-4B2A-BD21-AEC68E1837DF.xml", "r"); //print "<pre>".htmlspecialchars($v)."</pre>"; $ld->wo(0, -1, 'testw', $this); $this->flushw(); fclose($this->handle); print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='Write-ok';"; if ($sql->logquerys) { print "\$i('" . js_escape($ev->context[$this->long_name]['msgid']) . "').innerHTML='"; foreach ($sql->querylog as $e) { $a = "<div><div>" . htmlspecialchars($e->q) . "</div><div>" . htmlspecialchars($e->e) . "</div></div>\n"; print js_escape($a); } print "';"; } } editor_generic::handle_event($ev); }