将XML数据插入SQL字段

Question

I wrote a function to insert the <IBAN></IBAN> and from the XML to MySQL Database. I cannot figure out why, I cant insert the data from there to MySQL. This is the code I wrote.

public function test2(){
        $xml = simplexml_load_file('C:\Users\Nihit\Desktop\test.xml') or die ("could not open xml file");
               // performing sql query

            // count xml nodes
        $node = $xml->xpath("//IBAN/text()");

        var_dump($node);
        $num = 0;

         $text = $xml->asXML();
         $sql = "INSERT INTO transfer_packet VALUES(null, null, 0, null, " . $node . " , null, '" . mysql_real_escape_string($text) . "', " . $num . ", 1, 0, NOW(), null);";

            $result = mysql_query($sql) or die(mysql_error());

            if (!$result){

                var_dump($result);
                $result = mysql_query("SHOW ERRORS;");
                var_dump($result);

                }else{

             echo 'SUCCESS';
             echo 'updating id...';

             $last_id = mysql_insert_id();


             $result = mysql_query("update transfer_packet set ORIG_ID = " . $last_id . " where ID = " . $last_id .";");
               }




    }

The code is written in codeigniter.

Update (error received)

Severity: Notice Message : Array to string conversion FIlename : controllers/xmlconverter.php Line Number :368 Unknown column 'Array' in field list' 

This is the xml file I used

fkl.fi/teemasivut/sepa/tekninen_dokumentaatio/Dokumentit/… 

And of course database does not update with a new row.

Answer 1

For this sample XML, you should use this code:

$xml        =   simplexml_load_file('https://www.fkl.fi/teemasivut/sepa/tekninen_dokumentaatio/Dokumentit/FI_camt_054_sample.xml.xml'); // get XML output

$xmlFile    =   file_get_contents('https://www.fkl.fi/teemasivut/sepa/tekninen_dokumentaatio/Dokumentit/FI_camt_054_sample.xml.xml'); // get XML output as text

$IBAN       =   $xml -> BkToCstmrDbtCdtNtfctn -> Ntfctn -> Acct -> Id -> IBAN; // get IBAN value
$BIC        =   $xml -> BkToCstmrDbtCdtNtfctn -> Ntfctn -> Acct -> Svcr -> FinInstnId -> BIC; // get BIC value

$transferDateTimestamp  =   strtotime($xml -> BkToCstmrDbtCdtNtfctn -> Ntfctn -> CreDtTm); // Get transfer date as timestamp for transferred_date column
$data = array
(
'IBAN'              => $IBAN,
'BIC'               => $BIC,
'INSERT_DT'         =>  time(),
'xml_file'          => $xmlFile,
'status'            =>  '1',
'transferred_date'  =>  $transferDateTimestamp
);
$this -> db -> insert('tableName', $data); // inserting a new row to our table

$id = $this -> db -> insert_id(); // get last inserted id

$uptArray   =   array('ORIG_ID' => $id);
$this -> db -> where('id', $id);
$this -> db -> update('tableName', $uptArray); // updating ORIG_ID column