Welcome Guest, Not a member yet? Register   Sign In
[SOLVED] How to test if a database is connected
#1

(This post was last modified: 12-03-2019, 09:50 AM by John_Betong.)

[font=Tahoma, Verdana, Arial, sans-serif]I am having difficulty in trying to test if database has connected. [/font]

[font=Tahoma, Verdana, Arial, sans-serif]I know that the database does not exist and would like the application to fail gracefully. [/font]

[font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif]When the database does not exist I would like to show download SQL database installation details.[/font][/font][/font][/font]

[font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif]Edit:      [/font][/font][/font][/font]

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;
}
//  
[font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif][font=Tahoma, Verdana, Arial, sans-serif]
Next hurdle - create indexii Smile
[/font]
[/font]
[/font]
[/font]
Reply


Messages In This Thread
[SOLVED] How to test if a database is connected - by John_Betong - 12-02-2019, 09:38 PM



Theme © iAndrew 2016 - Forum software by © MyBB