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);
?>
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With