A PHP Error was encountered

Severity: Warning

Message: simplexml_load_file(): SSL: Connection reset by peer

Filename: libraries/Currency.php

Line Number: 71

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 71
Function: simplexml_load_file

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 60
Function: get_tcmb_xml

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: simplexml_load_file(): Failed to enable crypto

Filename: libraries/Currency.php

Line Number: 71

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 71
Function: simplexml_load_file

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 60
Function: get_tcmb_xml

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: simplexml_load_file(https://www.tcmb.gov.tr/kurlar/today.xml): failed to open stream: operation failed

Filename: libraries/Currency.php

Line Number: 71

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 71
Function: simplexml_load_file

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 60
Function: get_tcmb_xml

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: simplexml_load_file(): I/O warning : failed to load "https://www.tcmb.gov.tr/kurlar/today.xml": No such file or directory

Filename: libraries/Currency.php

Line Number: 71

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 71
Function: simplexml_load_file

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 60
Function: get_tcmb_xml

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to get property 'Currency' of non-object

Filename: libraries/Currency.php

Line Number: 108

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 108
Function: _error_handler

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 63
Function: sort_data

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: libraries/Currency.php

Line Number: 108

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 108
Function: _error_handler

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 63
Function: sort_data

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 248
Function: __construct

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: USD

Filename: libraries/Currency.php

Line Number: 134

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 134
Function: _error_handler

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 250
Function: get_currency

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: EUR

Filename: libraries/Currency.php

Line Number: 134

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/libraries/Currency.php
Line: 134
Function: _error_handler

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 251
Function: get_currency

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/bratmobilya/ecommerce.bratmobilya.com/system/core/Exceptions.php:271)

Filename: core/Common.php

Line Number: 570

Backtrace:

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/models/site/Site_model.php
Line: 272
Function: get

File: /home/bratmobilya/ecommerce.bratmobilya.com/application/controllers/Web.php
Line: 365
Function: toplam_urun

File: /home/bratmobilya/ecommerce.bratmobilya.com/index.php
Line: 323
Function: require_once

Database Error

Bir Veri Tabanı Hatası Oluştu

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* (urun_fiyat - (urun_fiyat * urun_indirim / 100)), 4) WHEN urun_doviz = "USD" ' at line 3

SELECT `urun_indirim`, `urun_indirim_tur`, `urun_doviz`, `urun_ceviri_baslik`, `urun_id`, `urun_ceviri_aciklama`, `urun_one_cikarilan_gorsel`, `urun_fiyat`, `urun_ceviri_url`, `urun_ceviri_dil_kod`, `urun_marka_id`, (CASE WHEN urun_doviz = "TRY" THEN ROUND(1 * (urun_fiyat - (urun_fiyat * urun_indirim / 100)), 4) WHEN urun_doviz = "EUR" THEN ROUND( * (urun_fiyat - (urun_fiyat * urun_indirim / 100)), 4) WHEN urun_doviz = "USD" THEN ROUND( * (urun_fiyat - (urun_fiyat * urun_indirim / 100)), 4) END) AS `tl_karsilik` FROM `urunler` LEFT JOIN `urun_ceviriler` ON `urun_ceviriler`.`urun_ceviri_urun_id`=`urunler`.`urun_id` JOIN `urun_kategoriler` ON `urun_kategoriler`.`urun_kategori_urun_id` = `urunler`.`urun_id` LEFT JOIN `kategori_ceviriler` ON `kategori_ceviriler`.`kategori_ceviri_kategori_id` = `urun_kategoriler`.`urun_kategori_kategori_id` WHERE `urun_ceviri_dil_kod` = 'TR' AND `urun_durum` = 1 GROUP BY `urun_id` HAVING `tl_karsilik` >= '' ORDER BY `urun_sira` ASC, `urun_id` DESC

Filename: models/site/Site_model.php

Line Number: 272