[TUT] Include mySQL into php.

[Arеs]

Sorry for bumping this, but I must say this tutorial is awesome.

[haphazard]

You could also install lamp ;)
However this is still a neat tutorial
Thankyou OP

[Preeminent]

Thanks for the tutorial, will help people.

[Proof]

Make a settings.inc.php and put this in there:

(CHMOD should be: 755)

PHP Code:

<?
        $CONFIG['DBHOST'] = "localhost"; // Database servers location, normally localhost
        $CONFIG['DBUSER'] = "username"; // sql user
        $CONFIG['DBPASS'] = "password"; // db users password
        $CONFIG['DBNAME'] = "database"; // Database to connect to
?>

then make database.php

(CHMOD should be: 644)

PHP Code:

<?
        include("settings.inc.php");
        $connection = mysql_connect($CONFIG['DBHOST'],
        $CONFIG['DBUSER'],
        $CONFIG['DBPASS']) or die("Could not establish a connection with mysql.");
        mysql_select_db($CONFIG['DBNAME']) or die("Unable to select database.");
?>

Then in all your codes put:

PHP Code:

<? include("database.php"); ?>

You are done


Note: If you need help with CHMOD visit this link: http://www.supportforums.net/showthread.php?tid=182

You can also just use the define function:

PHP Code:

define("host", "HOSTHERE");
define("username", "USERNAMEHERE");
define("pass", "PASSWORDHERE");
define("db", "DATABASENAME"); 


[Bursihido]

Great guide mate THanks.

[Spafic]

Very nice tutorial!

It WILL help me in the future.

[C!RCU!T tr0jAn ☠]

Thanks for this, looks really good. I will use this for revising.

[Saint Michael]

Great beginners tutorial, will use this for reference.

[ZxPwn420]

Simple but useful script, should help a few newbies at php & mysql.

[nextlive]

Nice tut. Thanks a lot.