public function readUnits() { $con = self::openConnection(); $currencies = new Currencies(); mysqli_begin_transaction($con); $sql = "SELECT * FROM currency WHERE 1"; $res = mysqli_query($con, $sql); while ($arrRes = mysqli_fetch_assoc($res)) { $currency = new Currency(); $currency->setId($arrRes['id']); $currency->setCode($arrRes['code']); $currencies->setUnit($currency); } return $currencies; }
public function parseCurrencies() { $currencies = new Currencies(); $keyParams = array(); foreach ($this->xmlProducts as $product) { $cur = $product->getCurrency(); if (!empty($cur) && !in_array($cur, $keyParams)) { array_push($keyParams, $cur); $currency = new Currency(); $currency->setCode($cur); $currencies->setUnit($currency); } } $currencyDAO = new CurrencyDAO(); $currencyDAO->insertUnits($currencies); $currencies = $currencyDAO->readUnits(); return $currencies; }