{"action":"closed","issue":{"url":"https://api.github.com/repos/xocasdashdash/pfc/issues/4","labels_url":"https://api.github.com/repos/xocasdashdash/pfc/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/xocasdashdash/pfc/issues/4/comments","events_url":"https://api.github.com/repos/xocasdashdash/pfc/issues/4/events","html_url":"https://github.com/xocasdashdash/pfc/issues/4","id":58885359,"number":4,"title":"[Insight] PHP database functions should not be used - in web/oracle_test.php, line 10","user":{"login":"xocasdashdash","id":6722159,"avatar_url":"https://avatars.githubusercontent.com/u/6722159?v=3","gravatar_id":"","url":"https://api.github.com/users/xocasdashdash","html_url":"https://github.com/xocasdashdash","followers_url":"https://api.github.com/users/xocasdashdash/followers","following_url":"https://api.github.com/users/xocasdashdash/following{/other_user}","gists_url":"https://api.github.com/users/xocasdashdash/gists{/gist_id}","starred_url":"https://api.github.com/users/xocasdashdash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xocasdashdash/subscriptions","organizations_url":"https://api.github.com/users/xocasdashdash/orgs","repos_url":"https://api.github.com/users/xocasdashdash/repos","events_url":"https://api.github.com/users/xocasdashdash/events{/privacy}","received_events_url":"https://api.github.com/users/xocasdashdash/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-02-25T11:08:26Z","updated_at":"2015-09-19T16:30:50Z","closed_at":"2015-09-19T16:30:50Z","body":"**[in web/oracle_test.php, line 10](https://github.com/xocasdashdash/pfc/blob/3bf35d7db9f8b5c28f3260115788c4bb0e79a2bc/web/oracle_test.php#L10)**\r\n\r\n> Using a PHP Database function (like `oci_connect()` here) makes the code less portable. Prefer PDO or the Doctrine DBAL classes.\r\n\r\n```php\r\n$ora_pass =\t'jfc$24uah';\t //user password\r\n//$ora_host =\t'SERVER_IP_OF_ORACLE\"';\t //host name or server ip address\r\n$ora_db = 'XE';\t//database name\r\n\r\n// place variable into oci_connect function, then place funtion in variable\r\n$ora_conn = oci_connect($ora_user,$ora_pass,$ora_db);\r\nsystem('echo $LD_LIBRARY_PATH');\r\n//print_r($_SERVER);// error handling\r\nif (!$ora_conn){\t // if variable $ora_conn fails to connect\r\n// do the following if it fails\r\n$ora_conn_erno = oci_error(); // insert oci_error() function into variable\r\n```\r\n\r\n---------------------\r\n\r\n_Posted from [SensioLabsInsight](https://insight.sensiolabs.com/projects/e731285b-54b5-4e1b-91c8-1c955e1a0ece/analyses/10)_"}}