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");
Output for 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
Warning: Undefined variable $exchangeID in /in/hfgkv on line 7 Warning: Undefined variable $brokerID in /in/hfgkv on line 7 Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /in/hfgkv:9 Stack trace: #0 {main} thrown in /in/hfgkv on line 9
Process exited with code 255.
Output for 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.31, 7.4.0 - 7.4.33
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /in/hfgkv:9 Stack trace: #0 {main} thrown in /in/hfgkv on line 9
Process exited with code 255.
Output for 7.3.32 - 7.3.33
Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /in/hfgkv:9 Stack trace: #0 {main} thrown in /in/hfgkv on line 9
Process exited with code 255.
Output for 5.0.4 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Call to undefined function mysqli_query() in /in/hfgkv on line 9
Process exited with code 255.
Output for 5.0.0 - 5.0.3
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Call to undefined function mysqli_query() in /in/hfgkv on line 9
Process exited with code 255.
Output for 4.4.5 - 4.4.9
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Call to undefined function: mysqli_query() in /in/hfgkv on line 9
Process exited with code 255.
Output for 4.3.2 - 4.3.11, 4.4.0 - 4.4.4
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Call to undefined function: mysqli_query() in /in/hfgkv on line 9
Process exited with code 255.
Output for 4.3.0 - 4.3.1
Notice: Undefined variable: exchangeID in /in/hfgkv on line 7 Notice: Undefined variable: brokerID in /in/hfgkv on line 7 Fatal error: Call to undefined function: mysqli_query() in /in/hfgkv on line 9
preferences:
287.06 ms | 401 KiB | 460 Q