Page 2 of 2

Re: [Challenge - Beginner] Database Connection

Posted: Tue Jun 08, 2010 2:21 am
by Payton
Here's a MySQL connection method I've been meaning to test...

index.php

Code: Select all

<?php

$directory = dirname(__FILE__);
require("./{$directory}/config.php");

$con = mysql_connect($db['host'], $db['user'], $db['pass']) or die('Connection failed: ' mysql_error());
mysql_select_db($db['name'], $con) or die('Connection failed: ' mysql_error());

$sql = mysql_query("SELECT message FROM challenge_one") or die(mysql_error());
$fetch = mysql_fetch_array($query) or die(mysql_error());

echo $fetch['message'];

mysql_close($con);

?>
config.php:

Code: Select all

<?php

$db = array (
	$db['host'] = 'localhost',
	$db['user'] = 'root',
	$db['pass'] = 'password',
	$db['name'] = 'challenge_one'
);

?>
And finally, the SQL.

Code: Select all

CREATE DATABASE  `challenge_one` ;

CREATE TABLE  `challenge_one`.`message` (
`challenge_one` TEXT NOT NULL
) ENGINE = MYISAM ;

INSERT INTO `challenge_one`.`message` (`challenge_one`) VALUES ('Connection Successful');