East Toronto Web Design Meetup

includes/config.php

<?php
$dbhost='localhost';
$dbuser='USERNAME';
$dbpass='PASSWORD';
$dbname='DATABASE';

// CONNECT TO THE DATABASE SERVER
$link = mysql_connect($dbhost, $dbuser, $dbpass);

// IF THERE ARE ERRORS, DISPLAY THEM AND EXIT
if (!$link) {
    die('Error connecting to server: ' . mysql_error());
}

// CONNECT TO THE SPECIFIED DATABASE
$db_selected = mysql_select_db($dbname, $link);

// IF THERE ARE ERRORS, DISPLAY THEM AND EXIT
if (!$db_selected) {
    die ('Error selecting table: ' . mysql_error());
}
?>
		

test.php

<?php
include('includes/config.php');
$query = "
	SELECT
		name,
		email
	FROM
		subscribers
";

$result = mysql_query($query);
if(!$result) {
	die("Query Failed: <pre>$query\n\nError: " . mysql_error());
}
while ($row = mysql_fetch_assoc($result)) {
	echo "Name: $row[name], Email: $row[email]<br>";
}
?>