Re: [PHP] Changing databases from MySQL to Oracle
On Friday 11 November 2005 19:29, Bernhard Janetzki wrote: > On Friday 11 November 2005 19:21, Janet Smith wrote: > > I am new to PHP and am trying to learn how it works. > > > > We have a PHP program that is using MySQL. We are wanting to use our > > Oracle database instead. The Oracle database is on a different server > > that our PHP program. Does any one know how I can change connections from > > MySQL to Oracle? > > [..] Hi, have a look at http://de3.php.net/manual/en/ref.oci8.php Greets Boerni -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Changing databases from MySQL to Oracle
On Friday 11 November 2005 19:21, Janet Smith wrote: > I am new to PHP and am trying to learn how it works. > > We have a PHP program that is using MySQL. We are wanting to use our Oracle > database instead. The Oracle database is on a different server that our PHP > program. Does any one know how I can change connections from MySQL to > Oracle? > [..] > > > Thanks Hi, have a look at http://de3.php.net/manual/en/ref.oci8.php Greets Boerni -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Changing databases from MySQL to Oracle
[snip] I am new to PHP and am trying to learn how it works. We have a PHP program that is using MySQL. We are wanting to use our Oracle database instead. The Oracle database is on a different server that our PHP program. Does any one know how I can change connections from MySQL to Oracle? We have this line in our dba.php... $tli_connection = dbconnect($dsn, $user, $pass); In our config.php we have the following that defines the above $dsn = "some.where.com"; // MySQL hostname ([EMAIL PROTECTED]) $user = "MYSQL USER NAME GOES HERE"; // Username with sufficient rights to the DB - need update, select, delete, insert only $pass = "MYSQL PASSWORD FOR ABOVE USER"; // Password for the above user [/snip] The first place is to look in the manual http://www.php.net/oracle For a connection; http://us3.php.net/manual/en/function.ora-plogon.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
