Re: [phpesp-dev] ODBC support rewrite

[Charlie S. <Sm...@ld...>]

So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, =
$oracleSid);
you could have:

=66unction genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
  if (DB =3D=3D 'Oracle) {
      $connected =3D @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);

      if($error =3D OCIError()) {
        die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
      }
      return $connected;
  }
  else if (DB =3D=3D 'MySQL' {
      return mysql_connect($genDBSid, $genDBUser, $genDBPassword)
  }
}

Something like this?  along with other generic functions to handle each of =
the mysql/oracle functional pieces?


>>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
This does sound good.  But instead of porting to Oracle, a port to
PEAR or some other "generic" database abstraction layer would be even
better.

On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> I'm starting a project to give us an oracle interface ie. replacing mySQL=
 =
calls with Oracle.  Sounds like this could be beneficial to others, =
especially you.   Hope to be done by end of  day today.  Will let you know =
if sounds good to you.
>=20
> >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> Dear all,
>=20
>=20
> I'm going to use phpESP for a project inside a big tyre company. However,=
 =
I'll=20
> need to interface it with Oracle through ODBC. So, what do you think is=20
> better :
>=20
> - use normal ODBC (iODBC, unixODBC)
> - use PEAR libs
>=20
> Personally, I prefer ODBC because I read very poor benchmarks for PEAR=20
> database access.
>=20
> Any suggestions ?
>=20
> Stefan
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20
>=20
>=20
> This message may contain confidential information, and is intended only =
=66or the use of the individual(s) to whom it is addressed.
>=20
>=20
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20

--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D