private function init()
{
// Create connection
TalentMeDB::$conn = mysqli_connect($this->servername, $this->username, $this->password);
// Check connection
if (TalentMeDB::$conn->connect_error) {
die("Connection failed: " . TalentMeDB::$conn->connect_error);
}
/* Attempt to select 'talentme_db' as database. If it does not exist, create it. */
if (TalentMeDB::$conn->select_db($this->dbname)) {
// select_db returns true if found, false if not found
$result = TalentMeDB::$conn->query("SELECT DATABASE()");
$row = $result->fetch_row();
// echo "Current database is " . $row[0] . "\n";
$result->close();
} else {
// database $dbname not found, create a new one
// echo "No database by the name '$this->dbname' found.\n";
// Create database
$sql = "CREATE DATABASE " . $this->dbname;
if (TalentMeDB::$conn->query($sql) === TRUE) {
TalentMeDB::$conn->select_db($this->dbname);
// echo "New database '$this->dbname' created successfully.\n";
$this->createUserTable(TalentMeDB::$conn);
$this->createGroupTable(TalentMeDB::$conn);
$this->createUserGroupTable(TalentMeDB::$conn);
$this->createChatLineTable(TalentMeDB::$conn);
} else {
// echo "Error creating database: " . TalentMeDB::$conn->error;
}
}
}
