+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: [SOLVED] How to test if a database is connected (/showthread.php?tid=74971)
[SOLVED] How to test if a database is connected - John_Betong - 12-02-2019
I am having difficulty in trying to test if database has connected.
I know that the database does not exist and would like the application to fail gracefully.
When the database does not exist I would like to show download SQL database installation details.
Edit:
PHP Code:
//============================================================
private function isConnected
(
string $dbName
)
: bool
{
$result = FALSE;
error_reporting(0);
$link = mysqli_connect("localhost", "userName", "passWord", $dbName);
error_reporting(-1);
$result = isset($link->errno) ;
return $result;
}//
//============================================================
private function newDatabase
(
string $dbName
)
: bool
{
$result = FALSE;
# error_reporting(0);
$conn = mysqli_connect("localhost", "userName", "passWord");
$sql = 'CREATE DATABASE ' . $dbName ;
$result = $conn->query($sql);
return $result;
}//
//============================================================
private function newTable
(
object $conn,
string $dbName,
string $table
)
: bool
{
$result = FALSE;
$sql = file_get_contents(BASEURL .'assets/sql/' .$table .'.sql');
$result = $conn->query($sql);
return $result = TRUE;
}//
Next hurdle - create indexii
