Setting Oracle XE instant client with XAMPP and Windows XP
I got question from my student :
“Is it possible to try PHP5 and Oracle ? I already have working Xampp in my computer .
I my self install Oracle XE on my computer and grant access for my student .
But I have problem when installing Oracle Client , Oracle XE client need 256 MB memory
Since other plugin takes it and make actual memory to 254 MB.
After reading “The Underground PHP and Oracle Manual ” I got proper solution for my student :
1. Download Oracle instant client for windows
2. Extract the file and put all extracted file into one folder , ex : C:\myoracle10
3. Setting PATH
Right Click on My Computer Icon and choose Properties
Choose Environment Variables
You can edit existing “PATH” variables by double clicking PATH line
Add C:\myoracle10 plus ” ; ” sign
Click OK to save
4. Tell PHP to load oracle extension
Open php.ini in apache/bin folder
Restart XAMPP
Test the connection by running this file : (save as oracle.php)
$c = oci_connect(‘hr’, ‘palcomtech’, ‘//localhost/XE’);
$s = oci_parse($c, ‘select city from locations’);
oci_execute($s);
while ($res = oci_fetch_array($s)) {
echo $res['CITY'] . ”
“;
}
oci_close($c);
Test it in localhost
You should see city names if no error found .
Congratulation
Related Reading:
- xampp oracle
- xampp and oracle
- xampp with oracle
- oracle XAMPP
- xampp oracle windows
- konfigurasi oracle di xampp
- oracle instant client
- xamp oracle
- oracle xe client
- Oracle XE instant client
- xampp oracle xe
- oracle xe xampp
- oracle xampp windows
- oracle on xampp
- xampp and oracle 10g
- xampp und oracle
- oracle xe xamp
- xampp install oracle
- xampp instant client oracle
- oracle with xampp
- xampp oci_connect
- oracle XE
- setup oracle express with zampp
- xampp php oracle
- oracle en xampp
- setting oracle di xampp
- xampp select oracle
- connect oracle with php instant client windows
- oracle instant client tutorial windows
- php oracle xe dummies
- tutorial einrichten oracle mit xampp
- php xampp oracle
- xampp for oracle
- xampp installation of oracle
- oracle instant client on xampp
- oracle in xampp
- windows oracle 10g php
- oracle xe and xamp
- xampp client
- oracle dengan xampp
- oracle instant client php
- xampp client version
- mengaktifkan oracle pada xampp di windows
- lampp oracle
- oracle 10g instant client download
- oracle xamp
- xampp access to oracle express
- tutorial oracle instant client
- xammp oracle
- Howto: Install Oracle Instant Client xampp
4 Comments
Untuk mengkoneksikan PHP dengan oracle yang terinstal di komputer lain gmn caranya, Pak?
Misal Webserver yg dilengkapi PHP diinstal di komputer A. Trus oracle 10g enterprise edition diinstal di komputer B.
Gmn tuh cara meng-koneksikannya?
Mohon bantuannya.
Pingback & Trackback
Random Post
Leave Your Comments Below
FreeBSD, PF, OpenBSD Books
-
pfSense: The Definitive Guide
-
Learning FreeNAS: Configure and manage a network attached storage solution
-
The Book of PF: A No-Nonsense Guide to the OpenBSD Firewall
-
Building Firewalls with OpenBSD and PF, 2nd Edition
-
Mastering FreeBSD and OpenBSD Security
-
The Definitive Guide to PC-BSD (Expert's Voice in BSD)
-
Absolute FreeBSD: The Complete Guide to FreeBSD, 2nd Edition
-
The Complete FreeBSD: Documentation from the Source
-
The Design and Implementation of the FreeBSD Operating System
Hacking Computer Books
-
Hacking: The Art of Exploitation, 2nd Edition
-
Hacking For Dummies
-
Secrets of Computer Espionage: Tactics and Countermeasures
-
Hacking Exposed Computer Forensics, Second Edition: Computer Forensics Secrets & Solutions
-
Hacking Exposed: Network Security Secrets and Solutions, Sixth Edition
-
Gray Hat Hacking, Second Edition: The Ethical Hacker's Handbook
-
The Web Application Hacker's Handbook: Discovering and Exploiting Security Flaws
-
Hacking Wireless Networks For Dummies (For Dummies (Computer/Tech))
-
Chained Exploits: Advanced Hacking Attacks from Start to Finish
-
Professional Penetration Testing: Creating and Operating a Formal Hacking Lab
-
Ethical Hacking and Countermeasures: Threats and Defense Mechanisms (Ec-Council Press Series: Certified Ethical Hacker)
-
Ethical Hacking and Countermeasures: Secure Network Infrastructures (Ethical Hacking and Countermeasures: C/ E H: Certified Ethical Hacker)













Thanks a lot!
Very useful post.