setup database connection include file in PHP

crmpicco · September 27th, 2007, 02:32 PM

Code:

<?php 
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'mypassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'crmpicco_mini';
mysql_select_db($dbname);
?>

Is there a way I can have all of this in a database include file at the top of all my scripts? When i try it it just errors. Can only some of it go in an include?

I tried:

Code:

<?php include("/mini/inc/db_conn.php"); ?>

It didn't like that, or splitting the code into two seperate files as one site had suggested. Incidentally, do I always need to use "<?php" can't I just have "<?" to open scripting tags?

Cheers in advance,
Picco

www.crmpicco.co.uk
www.ie7.com

sdi126 · September 28th, 2007, 06:12 PM

Why didn't it like the include? Did it error out?

The code looks fine to have as its own include file. Try using require_once though instead of include....this will force php to use this file (if it can't find it through include....it simple continues execution of the program) if it cant find the file using require then you will get an error.

And in regards to using <?php as opposed to <?

This is a setting within php.ini use short open tags....if it is turned on you can use <?

* You should however just start using <?php because starting in version 6 and on this feature will no longer be available

http://mynameissteve.com

crmpicco · September 30th, 2007, 04:18 PM

ok cool, cheers for that. i'll give it a go again and postback up. I'll just keep using "<?php" and not get into the way of dropping the PHP.

Do you mean that as of PHP 6 the "short open tags" option will not exist? Does it not go down well with some?

Picco

www.crmpicco.co.uk
www.ie7.com