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

Tutorial:Connect Oracle Database and PHP, using XAMPP

173 ratings | 51680 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 (54)
firdiansyah firdaus (4 months ago)
very useful.. thank you
viperowski (11 months 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 (1 year 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 (1 year 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 (1 year 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 (3 months ago)
Add port No
check in services, ORACLEListener must be UP
Mohammad Sheam (1 year 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...
Sharjeel Muhammad (6 months ago)
and I am using oracle 10g
Sharjeel Muhammad (6 months 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
wizrost (1 year ago)
To whom this message was?
samim tanjid (1 year ago)
hlw...how r u?i wan talk with you?
Hola, me muestra este error Fatal error: Call to undefined function oci_connect() in C:\xampp\htdocs\demo.php
Karl Nyabe (1 year ago)
where is the link
CarlosJobs (1 year ago)
Perfect
CarlosJobs (1 year ago)
thank you so much
Fariz Eliyev (1 year ago)
can u write here code of scriptdemo.php cos it is not seem full
Anechitoaei Bogdan (1 year 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 (2 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 (2 years ago)
Thanks a lot :)
Shakil, Azizul Hakim (2 years ago)
perfectly done!! :D thnx a lot... :D
Md Nafiz Al Ifat (2 years ago)
@shakil help me with that :D
Rei (2 years ago)
Im the only one here who enjoyed the song? Thanks for the video.
She Who (2 years ago)
thank you, really. it helps a lot.
Nurhayati Mohd Husni (2 years ago)
Thank you so much!
Xuân Bách (2 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 (1 year 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 (2 years ago)
+veninosscorpion  yeah, it worked ! Thanks so much !
Anechitoaei Bogdan (2 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 (2 years ago)
multumesc, colegu'!
Manh Dung (2 years ago)
please help me, i face error php startup unable to load dynamic library, php_oci8 dll
Anechitoaei Bogdan (2 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 (2 years ago)
Muchas gracias !!!!!
Bayu Cakra (2 years ago)
its very helpful, thankyou..
Francisco Gaviria (2 years ago)
Gracias

Would you like to comment?

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