12-02-2019, 09:38 PM
(This post was last modified: 12-03-2019, 09:50 AM by John_Betong.)
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:
Next hurdle - create indexii
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
