[TUT] Include mySQL into php.

[MyNameIs940]

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

[FBI]

Thats simple enough,
So, what CHMOD should implement on both files to securing?

[MyNameIs940]

Good idea, I shall add that into the tut once I get home.


EDIT: added it.

[xiofire]

Hmm... Shorthand? Yuck.
Heres how I connect to my databases

Code:

<?php
class connection {
    private $database, $connect;
    function connect() {
        $this->database = array(
        'username' => 'USERNAME',
        'password' => 'PASSWORD',
        'host' => 'localhost',
        'name' => 'DATABASE NAME'
        );

        $this->connect = mysql_connect($this->database['host'], $this->database['username'], $this->database['password']);
        mysql_select_db($this->database['name'], $this->connect);
    }
}

$db = new connection();
$db->connect();
?>

[immi]

Hmm... Shorthand? Yuck.
Heres how I connect to my databases

Code:

<?php
class connection {
    private $database, $connect;
    function connect() {
        $this->database = array(
        'username' => 'USERNAME',
        'password' => 'PASSWORD',
        'host' => 'localhost',
        'name' => 'DATABASE NAME'
        );

        $this->connect = mysql_connect($this->database['host'], $this->database['username'], $this->database['password']);
        mysql_select_db($this->database['name'], $this->connect);
    }
}

$db = new connection();
$db->connect();
?>

Correct, simple and easy enough.. Good work ;)

[xiofire]

Correct, simple and easy enough.. Good work ;)

Thank ya, I take pride in my PHP

[GizSho]

Both methods work, nice tutorial.

[flAmingw0rm]

Thanks for the great tutorial, worked well.

[El Zorro]

yeah both methods work

[HuNt3R]

Very nice TUT, this will help out alot of members