HomeХобби и стильRelated VideosMore From: Anechitoaei Bogdan

Tutorial:Connect Oracle Database and PHP, using XAMPP

215 ratings | 58045 views
Oracle Database 12c: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-1968077.html Xampp: https://www.apachefriends.org/ro/download.html Instant Client(Version 12.1.0.2.0) http://www.oracle.com/technetwork/topics/winsoft-085727.html scriptdemo.php: https://www.dropbox.com/s/4yb3hehf8x4ljfy/scriptdemo.php?dl=0
Html code for embedding videos on your blog
Text Comments (61)
Denis Luciano (3 days ago)
Thank you. This videos help me :)
value in my oracle nothing please help me
Nikilean (1 month ago)
You saved me! So clear explanation. Best tutorial, thanks a lot!
fast work (1 month ago)
not working :(
Beast Master (5 months ago)
simple yet usefull. tq
firdiansyah firdaus (10 months ago)
very useful.. thank you
viperowski (1 year ago)
THANK YOU! <3 Best tutorial in the internet :)
hasibur rahaman (1 year ago)
Not Working Fatal error: Uncaught Error: Call to undefined function oci_connect()
Does it work in command line, it worked on browser but not on command line, i got "PHP Warning: PHP Startup: Unable to load dynamic library 'E:\Developments\XAMPP \php\ext\php_oci8_12c.dll' - The specified module could not be found. in Unknown on line 0" even "php_oci8_12c.dll" is existed. XAMPP 3.2.2 PHP 7.1.8 (cli) (built: Aug 1 2017 21:10:46) ( ZTS MSVC14 (Visual C++ 2015) x86)
kriti vishnoi (1 year ago)
hy..I am encountering with this error.. ( Fatal error: Uncaught Error: Call to undefined function oci_connect() in C:\xampp\htdocs\test.php:12 Stack trace: #0 {main} thrown in C:\xampp\htdocs\test.php on line 12) i had set the PATH and restarted the pc and m using Oracle 11g, instant_client_11_2 32bit , XAMPP 32 bit.. plz someone help..
Mr.Burek (2 years ago)
Someone, please. read this and save me some time if possible :) "Fatal error: Call to undefined function oci_connect()" Keep getting this for a few days now. I tried everything. What I think is the problem is perl. But I cannot find way to reinstall it. (My "php" command is not working in CMD). Also DB is working normally 11G version thou. 12C I cannot install it says "Oracle Database manager error". I tried to install DB 12c, I had it before and it worked fine. Now I cannot install it. Also I deleted all registries (all Oracle keys). Nothing happened differently. I might just reinstall W10.
Mr.Burek (2 years ago)
Dealt with a problem. Antivirus deleted "EXT" folder (xampp/php/ext) for some reason. I just reinstalled xampp and added oci8.dll's to EXT and it worked like charm.
Endre Szabo (2 years ago)
Warning: oci_connect(): ORA-12541: TNS:no listener in C:\xampp\htdocs\test\index.php on line 5 Failed to connect to Oracle Any idea....?
Sami Azam (9 months ago)
Add port No
check in services, ORACLEListener must be UP
Mohammad Sheam (2 years ago)
Fatal error: Uncaught Error: Call to undefined function oci_connect() in C:\xampp\htdocs\project\index.php on line 5 line 5 is $conn=oci_connect("admin","admin","localhost/RPDB"); username=admin password=admin service_name=RPDB Also set variable path...
akshat bhandari (3 months ago)
@Mohammad Sheam hello sir, facing the same error even the installed versions are of same bit. can you help?
mustafa57unix (6 months ago)
this is the fix https://www.youtube.com/watch?v=p65CRfSRgLY
Sharjeel Muhammad (1 year ago)
and I am using oracle 10g
Sharjeel Muhammad (1 year ago)
Sir I am facing same error, please guide me. Fatal error: Call to undefined function oci_connect() in C:\xampp\htdocs\test\scriptdemo.php on line 16
Mohammad Sheam (1 year ago)
@samim tanjid yeah you can talk here
Hola, me muestra este error Fatal error: Call to undefined function oci_connect() in C:\xampp\htdocs\demo.php
Karl Karly (2 years ago)
where is the link
CarlosJobs (2 years ago)
Perfect
CarlosJobs (2 years ago)
thank you so much
Fariz Eliyev (2 years ago)
can u write here code of scriptdemo.php cos it is not seem full
Anechitoaei Bogdan (2 years ago)
Here is the code of scriptdemo.php in case dropbox link doesn't work: <html> <head><title>Oracle demo</title></head> <body> <?php $conn=oci_connect("username","password","localhost/service_name"); If (!$conn) echo 'Failed to connect to Oracle'; else echo 'Succesfully connected with Oracle DB'; oci_close($conn); ?> </body> </html>
@fariz means the code is not shown complete on the video, and the dropbox link for the code is dead
muhammad burhan Zahid (2 years ago)
does this also work with 11g
Anechitoaei Bogdan (2 years ago)
It will not work with 11g, you need Oracle 12c.
muhammad burhan Zahid (2 years ago)
Anechitoaei Bogdan so can i connect with 11g
Anechitoaei Bogdan (2 years ago)
No, just with Oracle 12c.
Kamil Kot (2 years ago)
Thanks man, you really help me :)
Akbera Khowaja (3 years ago)
getting following error Warning: oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\xampp\htdocs\oracle\test.php on line 5 Failed to connect to Oracle
Vighnesh V (3 years ago)
Thanks a lot :)
Shakil, Azizul Hakim (3 years ago)
perfectly done!! :D thnx a lot... :D
Md Nafiz Al Ifat (2 years ago)
@shakil help me with that :D
Rei (3 years ago)
Im the only one here who enjoyed the song? Thanks for the video.
She Who (3 years ago)
thank you, really. it helps a lot.
Nurhayati Mohd Husni (3 years ago)
Thank you so much!
Xuân Bách (3 years ago)
help me. i had a problem. "Call to undefined function oci_connect()". In log apache "PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\xampp\\php\\ext\\php_oci8_11g.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0"
thong trinh (2 years ago)
ông xài bản oracle nào? của tui 11g express vs instant 32bit, đặt biến môi trường vs chỉnh trong php.in rồi mà vẫn báo Fatal error: Uncaught Error: Call to undefined function oci_connect()
Xuân Bách (3 years ago)
@veninosscorpion  yeah, it worked ! Thanks so much !
Anechitoaei Bogdan (3 years ago)
+Xuân Bách Be sure that you set the path like in the video: min 1:00 and then restart the computer.
Teodor Chirileanu (3 years ago)
multumesc, colegu'!
Manh Dung (3 years ago)
please help me, i face error php startup unable to load dynamic library, php_oci8 dll
Anechitoaei Bogdan (3 years ago)
+Manh Dung There is a problem with your Windows path.Be sure that you set the path like in the video: min 1:00 and then restart the computer.
Bismark Vargas Arias (3 years ago)
Muchas gracias !!!!!
Bayu Cakra (3 years ago)
its very helpful, thankyou..
Francisco Gaviria (3 years ago)
Gracias

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.