Merhabalar,
api ile çektiğim verileri otomatik olarak nasıl tablolaştırabilirim
kodum aşağıdaki gibi
<html>
<body>
<?php
date_default_timezone_set('Europe/Istanbul');
class GenesisPanoAPI {
private $baseURL = "
https://genesispano.com/servis/";
private $authCodeName;
private $authCode;
public function __construct($authCodeName, $authCode) {
$this->authCodeName = $authCodeName;
$this->authCode = $authCode;
}
private function makeRequest($action, $extraParams = []) {
$postData = array_merge([
'AuthCodeName' => $this->authCodeName,
'AuthCode' => $this->authCode,
'Action' => $action
], $extraParams);
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => $this->baseURL,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => json_encode($postData),
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json'
),
CURLOPT_TIMEOUT => 30
));
$response = curl_exec($curl);
$httpCode = curl_getinfo($curl, CURLINFO_HTTP_CODE);
curl_close($curl);
if ($httpCode === 200) {
return json_decode($response, true);
} else {
throw new Exception("API İsteği başarısız: HTTP $httpCode");
}
}
public function getLastPrices() {
return $this->makeRequest('GetLastPrices');
}
public function getProductList($category = null, $limit = null) {
$params = [];
if ($category) $params['category'] = $category;
if ($limit) $params['limit'] = $limit;
return $this->makeRequest('GetProductList', $params);
}
public function getStock($productId) {
return $this->makeRequest('GetStock', ['product_id' => $productId]);
}
public function updateStock($productId, $quantity) {
return $this->makeRequest('UpdateStock', [
'product_id' => $productId,
'quantity' => $quantity
]);
}
}
// Kullanım örneği
try {
$api = new GenesisPanoAPI('Ayn', 'RAK');
print_r($api->getLastPrices());
// Güncel fiyatları al
$prices = $api->getLastPrices();
echo "Altın Gram: " . $prices['Result'][0]['Satis'] . " TLn";
} catch (Exception $e) {
echo "Hata: " . $e->getMessage();
}
?>
</body>
</html>
burda sonuç çok karmaşık şekilde geliyor
Array ( [ResponseMsg] => SUCCESSFUL [Result] => Array ( [0] => Array ( [SembolAdi] => 22 AYAR (BİLEZİK) [SembolKodu] => yirmiiki_ayar_bilezik [Satis] => 5045 [GeriAlis] => 4685 [Takas] => 4825 [LastUpdate] => 2025-09-23 13:50:23 ) [1] => Array ( [SembolAdi] => 18 AYAR (ZİNCİR) [SembolKodu] => onsekiz_ayar_zincir [Satis] => 4760 [GeriAlis] => 3610 [Takas] => 3660 [LastUpdate] => 2025-09-23 13:50:23 ) [2] => Array ( [SembolAdi] => ATA LİRA [SembolKodu] => ata_lira [Satis] => 34900 [GeriAlis] => 34300 [Takas] => 34500 [LastUpdate] => 2025-09-23 13:50:23 ) [3] => Array ( [SembolAdi] => OSMANLI [SembolKodu] => osmanli [Satis] => 34900 [GeriAlis] => 34100 [Takas] => 34300 [LastUpdate] => 2025-09-23 13:50:23 ) [4] => Array ( [SembolAdi] => ÇEYREK ALTIN [SembolKodu] => ceyrek_altin_eski [Satis] => 8600 [GeriAlis] => 8300 [Takas] => 8400 [LastUpdate] => 2025-09-23 13:50:23 ) [5] => Array ( [SembolAdi] => YARIM ALTIN [SembolKodu] => yarim_altin_eski [Satis] => 17200 [GeriAlis] => 16600 [Takas] => 16800 [LastUpdate] => 2025-09-23 13:50:23 ) [6] => Array ( [SembolAdi] => ZİYNET LİRA [SembolKodu] => ziynet_lira_eski [Satis] => 34200 [GeriAlis] => 33200 [Takas] => 33700