[Challenge - Beginner] Database Connection

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
Payton
Forum Commoner
Posts: 33
Joined: Sun Dec 06, 2009 4:03 pm

Re: [Challenge - Beginner] Database Connection

Post 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');
Post Reply