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);
?>Code: Select all
<?php
$db = array (
$db['host'] = 'localhost',
$db['user'] = 'root',
$db['pass'] = 'password',
$db['name'] = 'challenge_one'
);
?>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');