Nikolay Nikolay - 1 year ago 113
SQL Question

error: Database not selected

I'm stuck with this issue: No database selected. I roll over the same problems posted here, but after hours of reading I can't figure out why the database is not selected. I created a database

job
and a table
job
. I run the script with WAMP server. Sorry about the "everyday question." Please help!

<?php

// load Smarty library
require('C:/wamp/www/smarty-3.1.21/libs/Smarty.class.php');

$servername = "localhost";
$dbname = "job";

// Create connection
$conn = mysqli_connect($servername, $dbname);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$smarty = new Smarty;

$smarty->setTemplateDir('C:\wamp\www\app\templates');
$smarty->setCompileDir('C:\wamp\www\app\templates_c');
$smarty->setConfigDir('C:\wamp\www\app\configs');
$smarty->setCacheDir('C:\wamp\www\app\cache');


$rows = array();
$sql = "SELECT * FROM job";
$result = mysqli_query($conn, $sql);

if (!$result) {
echo 'MySQL Error: ' . mysqli_error($conn);
exit;
}

while ($row = mysqli_fetch_assoc($result)) {
$rows[] = $row;
}

$smarty->assign('output', $rows);
$smarty->display('result.tpl');

mysqli_close($conn);

?>

Answer Source

Those aren't the right parameters to mysqli_connect. You have to pass host, username, password, and then database name. You are passing only the host and the database name, so you are not connecting correctly.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download