Connecting

[DamienG]

Hi,

 

When connecting yo a MySql database I do the following witch works

 

<?php
//information
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'db';

//connect
$connect = @mysql_connect ($host,$user,$pass) or die (mysql_error () );

$select = @mysql_select_db ($db, $connect) or die (mysql_error () )
?>

 

Now last time I checked that works, is that the best way to do it?

 

Thanks!

[mikesta707]

as far as mysql goes, thats pretty much the only way to connect to a database. A lot of people make the database info (like $host, $user, etc) into constants rather than normal variables, but beyond that yeah, thats how you do it

[DamienG]

Thanks, It's just I have seen people do it different ways and I was hoping my way was okay

[faco]

depends on what and how you wanna connect to db in your files. you can put it all in some xy.php and inside create a function which hits the connect querry. then in next .php just include the xy file and write the name of the connecting function... but the process of connecting like this is the correct one!