3v4l.org

run code in 300+ PHP versions simultaneously
<?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");

preferences:
38.28 ms | 402 KiB | 5 Q