Trabla: XAMPP 7.0.13 with PHP7 + Oracle 11g Express Edition connection setup on Windows 7 x64
Solving:
Watch on YouTube
1. Download
- Oracle 11g ( registration required to download )
http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
- Oracle Instant Client ( registration required to download )
http://www.oracle.com/technetwork/topics/winsoft-085727.html
- XAMPP 7.0.13 with PHP7
https://www.apachefriends.org/download.html
2. Install Oracle 11g
- note password for SYSTEM \ SYS user
e.g. samuraikit123 :)
3. Setup Oracle Instant sClient
- unzip to C:\
- update Windows Environment variable Path
add C:\instantclient_12_1;
4. Install XAMPP 7.0.13 with PHP7
- edit php.ini - enable OCI extension - php_oci8_12c.dll
( remove semicolon - ; ) + save
- start Apache
5. Connection test PHP script
- create file testoracle.php
in C:\xampp\htdocs\ folder
- type following text
<?php
//Oracle DB user name
$username = 'SYSTEM';
// Oracle DB user password
$password = 'samuraikit123';
// Oracle DB connection string
$connection_string = 'localhost/xe';
//Connect to an Oracle database
$connection = oci_connect(
$username,
$password,
$connection_string
);
If (!$connection)
echo 'Oops :( connection failed';
else
echo 'Hooray !!! :) Oracle DB + php => OK ';
// Close connection
oci_close($connection);
?>
- open in browser
http:\\localhost\testoracle.php
No comments:
Post a Comment