Connecting to Oracle DB using PHP

Question

I'm trying to connect to an Oracle database using PHP using the following code:

$username = 'my_username';
$password = 'my_password';
$environment = 'my_environment';
// CHANGE HOST, PORT, SID
$tns = "
(DESCRIPTION =
     (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = my_port))
     )
     (CONNECT_DATA =
          (SID = my_sid)
     )
)
";

$conn = oci_connect($username, $password, $tns);

if (!$conn) {
   $e = oci_error();
   trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

It is working fine. But what I want to do is connect without exposing the username and password in plain text. Like in Postman where you can use Basic authentication header instead of plain text. Is there a way to do that?

Christopher Jones · Accepted Answer · 2019-12-04 02:47:10Z

1

The preferred solution is to use an Oracle wallet, doing "External Authentication". See p116 of Oracle's free The Underground PHP and Oracle Manual.

Once the wallet is set up your code would look like:

$c = oci_connect("/", "", $tns, null, OCI_CRED_EXT);

An lesser alternative is to pass the password in from an environment variable.

answered Dec 4, 2019 at 2:47

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Adrian Over a year ago

Can you also share the second alternative? The first alternative is good but it's kinda complicated to do in our current set up so I'm looking for other ways.

Christopher Jones Over a year ago

The environment variable solution depends on what webserver and OS you are running on, and how you want to start PHP. There are plenty of resources on the web that will help.

Collectives™ on Stack Overflow

Connecting to Oracle DB using PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related