which connection is best?

[Ben]

Hi,

I started with php and mysql and i discovered three methods for connecting
to a database:
$conn="DRIVER={MySQL ODBC 3.51 DRIVER};SERVER=10.0.0.181;DATABASE=reserv";
$connect=odbc_connect($conn,'root','pw');

include('/inetpub/wwwroot/resphpaccess/adodb/adodb.inc.php');
$db = &ADONewConnection('mysql');
$db->Connect('localhost', 'root', 'pw', 'reserv');

$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Impossible de se connecter : " . mysql_error());
Which one is the best and why?
What are the pro/contras for each?

Thanks
Ben

[Andy Hassall]

On Sat, 17 Dec 2005 12:09:55 +0100, "Ben" <qsvqs@qsdcsqd> wrote:

I started with php and mysql and i discovered three methods for connecting
to a database:

$conn="DRIVER={MySQL ODBC 3.51 DRIVER};SERVER=10.0.0.181;DATABASE=reserv";
$connect=odbc_connect($conn,'root','pw');
ODBC. Used a lot on ASP, not so much in PHP, as PHP has native database
libraries (including MySQL).
include('/inetpub/wwwroot/resphpaccess/adodb/adodb.inc.php');
$db = &ADONewConnection('mysql');
$db->Connect('localhost', 'root', 'pw', 'reserv');
ADOdb database abstraction library (http://adodb.sourceforge.net), a thin PHP
wrapper over the native functions.

This is my favourite way of connecting to databases in PHP. It adds a
consistent interface on top of the different native calls, and supports several
databases (not just MySQL).

Importantly for MySQL it emulates placeholders, which makes it easier to avoid
SQL injection attacks.

There is some overhead versus accessing MySQL with the native functions
directly, but ADOdb fares well in benchmarks, particularly compared with other
PHP database libraries.
$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Impossible de se connecter : " . mysql_error());

Native MySQL library. The thinnest layer over MySQL, so presumably the fastest
performance. You'll have to remember to do all your own data escaping, else you
open yourself up to SQL injection attacks.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Erwin Moller]

Andy Hassall wrote:

On Sat, 17 Dec 2005 12:09:55 +0100, "Ben" <qsvqs@qsdcsqd> wrote:

I started with php and mysql and i discovered three methods for connecting
to a database:

$conn="DRIVER={MySQL ODBC 3.51 DRIVER};SERVER=10.0.0.181;DATABASE=reserv";
$connect=odbc_connect($conn,'root','pw');

ODBC. Used a lot on ASP, not so much in PHP, as PHP has native database
libraries (including MySQL).

include('/inetpub/wwwroot/resphpaccess/adodb/adodb.inc.php');
$db = &ADONewConnection('mysql');
$db->Connect('localhost', 'root', 'pw', 'reserv');

ADOdb database abstraction library (http://adodb.sourceforge.net), a thin
PHP
wrapper over the native functions.

This is my favourite way of connecting to databases in PHP. It adds a
consistent interface on top of the different native calls, and supports
several databases (not just MySQL).

Importantly for MySQL it emulates placeholders, which makes it easier to
avoid
SQL injection attacks.

There is some overhead versus accessing MySQL with the native functions
directly, but ADOdb fares well in benchmarks, particularly compared with
other PHP database libraries.

$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Impossible de se connecter : " . mysql_error());

Native MySQL library. The thinnest layer over MySQL, so presumably the
fastest
performance. You'll have to remember to do all your own data escaping,
else you open yourself up to SQL injection attacks.

I second this opion.
ADODB works just great. (But the documentation could use a little
scrubbing.)
I started using ADODB to connect MSSQL to PHP which didn't work any other
way for me. (I was missing some modern version of some dll, so couldn't use
the native PHP mssql_* functions.)

Great package. Give it a shot.
I used it from here: www.php.lens.com/adodb
I am not sure which one is the most up-to-date. Probably sourceforge.

Regards,
Erwin Moller

[Erwin Moller]

> I used it from here: www.php.lens.com/adodb

that is www.phplens.com/adodb

[Ben]

Thanks all
"Erwin Moller"
<si******************************************@spam yourself.com> schreef in
bericht news:43***********************@news.xs4all.nl...

I used it from here: www.php.lens.com/adodb

that is www.phplens.com/adodb