Κωδικας PHP
Code: Select all
<?php
//Create a connection to MySQL and select "my_db" database
$con = mysql_connect('dbserver.gr','opencart','')
or die( 'Could not connect to DB: ' . mysql_error() );
mysql_select_db(opencart, $con) or die( mysql_error() );
mysql_query("SET NAMES 'utf8'", $con);
$sql = "SELECT product.product_id, product.price, product.model, product.sku, product.image, product.weight, product.stock_status_id, product.quantity , product_description.description FROM product, product_description WHERE (product.product_id = product_description.product_id AND language_id=2)";
$q = mysql_query($sql)or die(mysql_error());
$xml .= "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
$xml .= "<myeshop>";
$testSqlDateStamp = "1125442013";
echo "<BR>DateTest=".date('Y-m-d G:i:s',strtotime);
$xml .= "<products>";
while($r = mysql_fetch_array($q)){
$xml .= "<product>";
$xml .= "<id><![CDATA[" . $r["product_id"] . "]]></id>";
$xml .= "<name><![CDATA[" . $r["model"] . "]]></name>";
$xml .= "<link><![CDATA[" . $r["sku"] . "]]></link>";
$xml .= "<image><![CDATA[http://webgateserver.gr/eshop/image/" . $r["image"] . "]]></image>";
$xml .= "<category><![CDATA[" . $r["name"] . "]]></category>";
$xml .= "<price_with_vat><![CDATA[" . $r["price"] . "]]></price_with_vat>";
/* $xml .= "<manufacturer><![CDATA[" . $r["name"] . "]]></manufacturer>"; */
$xml .= "<description><![CDATA[" . $r["description"] . "]]></description>";
$xml .= "<weight><![CDATA[" . $r["weight"] . "]]></weight>";
$xml .= "<mpn><![CDATA[" . $r["sku"] . "]]></mpn>";
$xml .= "<InStock><![CDATA[" . $r["stock_status_id"] . "]]></InStock>";
$xml .= "<Availability><![CDATA[" . $r["quantity"] . "]]></Availability>";
$xml .= "</product>";
}
$xml .= "</products>";
$xml .= "</myeshop>";
$sxe = new SimpleXMLElement($xml);
$sxe->asXML("test.xml");
?>
Code: Select all
Αυτό το αρχείο XML δεν φαίνεται να έχει συσχετισμένες πληροφορίες μορφοποίησης. Το δένδρο εγγράφου φαίνεται παρακάτω.
<myeshop><products><product><id>30</id><name>75234343</name><link>75234343</link><image>http://webgateserver.gr/eshop/image/data/PRODUCTS/shoes/WOMEN/Boots/32129F128015_3_2.jpg</image><category></category><price_with_vat>130.0000</price_with_vat><description><p><span id="result_box" lang="el"><span class="hps">Ankle</span><span class="atn">-</span><span>υψηλή</span> <span class="hps">τραχυμένου</span> <span class="hps">δερμάτινες μπότες</span> <span class="hps">σε</span> <span class="hps">μαύρο ματ</span><span>.</span> <span class="hps">Almond</span> <span class="hps">toe</span><span>.</span> <span class="hps">Φερμουάρ</span> <span class="hps">στην</span> <span class="hps">εσωτερική επιφάνεια</span> <span class="hps">με</span> <span class="hps">μακρύ δερμάτινο</span> <span class="hps">φερμουάρ τραβήξτε</span><span>.</span> <span class="hps">Τραβήξτε το</span> <span class="hps">βρόχο</span> <span class="hps">στο γιακά</span> <span class="hps">φτέρνα</span><span>.</span> <span class="hps">Τονική</span> <span class="hps">ραφή</span> <span class="hps">και γλώσσας</span><span>.</span> <span class="hps">Περίπου</span><span>.</span> <span class="hps">2.5</span> <span class="hps atn">"</span><span>κουβανέζικο</span> <span class="hps">τακούνι</span> <span class="hps">Άνω και</span> <span class="hps">φόδρα:</span><span>.</span> <span class="hps">Δέρμα Σόλα</span><span>:</span><span>.</span><span>.</span> <span class="hps">Δέρμα και</span> <span class="hps">καουτσούκ</span> <span class="hps">Made in</span> <span class="hps">Italy</span><span>.</span></span></p>
</description><weight>0.00000000</weight><mpn>75234343</mpn><InStock>6</InStock><Availability>6</Availability></product>