- trim: documentation ( source)
<?php
$sql = "select ex.opening_minutes as opening, asset.assetID, ex.google_code as exch_google_code, asset.google_code as asset_google_code from selected_asset as sa".
" inner join asset on asset.assetID = sa.assetID".
" inner join asset_exchange ae on ae.assetID = sa.assetID".
" inner join exchange as ex on ex.exchangeID = ae.exchangeID".
" where ae.exchangeID = ".$exchangeID." and sa.brokerID = ".$brokerID;
$extension = "";
if ($result = mysqli_query($this->db, $sql) ) {
while ($rec = $result->fetch_assoc()){
$asset_google_code = $rec["asset_google_code"];
$exchange_google_code = $rec["exch_google_code"];
$assetentry = array ( $rec["assetID"] => $asset_google_code );
$this->assets[] = $assetentry;
$extension .= trim($exchange_google_code) .":".$asset_google_code.",";
}
}
//$extension = rtrim($extension, ",");
$extension .= "'";
$sql = "select ex.opening_minutes as opening from exchange as ex where ex.exchangeID = ".$exchangeID;
if ($result = mysqli_query($this->db, $sql) ) {
while ($rec = $result->fetch_assoc()){
$this->opening_minutes = "+" . $rec["opening"]." minutes";
}
}
$this->closetime = $this->opening->modify ($this->opening_minutes);
$this->closetime = $this->closetime->format( "Y-m-d H:i:s");