Forum Stats

  • 3,827,682 Users
  • 2,260,803 Discussions
  • 7,897,336 Comments

Discussions

Recommended IDE for php with oracle databases?

user5716448
user5716448 Member Posts: 1,748 Silver Badge
edited May 6, 2016 2:49AM in PHP

Hi,

New to php  oracle background.  (11.2.0.3 oracle)

Doing some searches see have netbeans and visual studio ide.

What is recommended best ide for ease of-use connecting to oracle  databases and writing php code, are there any with php wizards/rad type php tools bearing in mind novice.

Thanks

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited May 5, 2016 12:23AM

    if IDE's are your thing, then netbeans is a good choice in that it has built in support for the Oracle DB and you can set up php support.

    For a purely Oracle db IDE use SQL Developer, and hand craft your php code in what ever you like... vim, ...etc. I find sqlplus, sql developer and vim all the tools I need to craft php, perl, python, sql, pl/sql, etc... scripts.

    Hope that helps.

    Cheers,

    Gaz.

    user5716448
  • user5716448
    user5716448 Member Posts: 1,748 Silver Badge
    edited May 5, 2016 4:08AM

    Thanks for reply.  Like the idea of built in support with netbeans.  How do you set up php support?

    Also how does netbeans compare to visual studio for php development accessing oracle databases?

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited May 6, 2016 2:49AM

    The netbeans site has all the details you'll need,

    Here's a good start point:

    https://netbeans.org/kb/trails/php.html

    Here's how to install netbeans:

    https://netbeans.org/community/releases/73/install.html

    Here's how to setup php in netbeans:

    https://netbeans.org/kb/docs/ide/oracle-db.html#oci8

    As for how it compares to Visual Studio, I've not used VS, I am sure that is up to the task. I guess it is really a matter of personal preference. netbeans is sponsored by Oracle so the database side is covered for sure. "it's free and open source and has a large community of users and developers around the world"... https://netbeans.org/features/index.html

    Take some time to peruse the website and pages listed above,. I am sure that will help you choose...

    If you've already used VS, then the addage "stick with what you know" may apply in that it would save you time in not having to learn a new IDE

    For what it's worth, I'd go netbeans for the built in Oracle db support and ease of PHP integration with php_oci8_xx.dll and that its not tied to Windows, you can get it for LINUX, Windows and OSX.

    One last thing, yet another link... not IDE related, this one is for a PDF download, written by Oracle consultants, well worth reading:

    The Underground PHP and Oracle Manual | Homepage

    Cheers,

    Gaz.

This discussion has been closed.