/** * Creates the Database object and sets the database connection info based on * the config file. * * You can connect to another database on the server listed in the config class by passing its * name in the constructor * * Only supports Mysql databases. * * @see includes/walleye.config.php * @param string $db */ private function __construct($db = null) { $dbOptions = Walleye::getInstance()->getDbOptions(); $server = $dbOptions['SERVER']; $user = $dbOptions['USER']; $password = $dbOptions['PASS']; $port = $dbOptions['PORT']; if (is_null($db)) { $database = $dbOptions['DATABASE']; } else { $database = $db; } parent::mysqli($server, $user, $password, $database, $port); }
/** * Creates a mysqli instance representing a connection to a database * * @author Basilio Briceno <*****@*****.**> * @param array $dsn An array with DSN information * @return mysqli Returns a mysqli object on success */ public function __construct(array &$dsn) { $conn = parent::mysqli($dsn['host'], $dsn['username'], $dsn['password'], $dsn['name']); if (mysqli_connect_errno($this)) { throw new Exception("Failed to connect: " . mysqli_connect_error()); } return $conn; }
require_once "../vendor/autoload.php"; use Configuration\Configuration; error_reporting(0); echo "\n<!DOCTYPE html>\n<html>\n<head>\n<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />\n<meta name='viewport' content='width=device-width'/>\n<title>Login & Signup Kit Database Installation</title>\n</head>\n\n<body>\n<h1>Login & Signup Kit Database Installation</h1>\n"; if (isset($_GET["install"])) { $dbPassword = Configuration::DATABASE_PASSWORD; $dbUser = Configuration::DATABASE_USER; $dbHost = Configuration::DATABASE_HOST; $dbPort = Configuration::DATABASE_PORT; $dbDatabase = Configuration::DATABASE_NAME; $dbDatabasePrefix = Configuration::DATABASE_PREFIX; $completeDatabaseName = $dbDatabasePrefix . $dbDatabase; $dbInstall = false; $mysqli = new mysqli(); $mysqli->mysqli($dbHost, $dbUser, $dbPassword, $completeDatabaseName, $dbPort); if ($mysqli->connect_error) { $cfg_result = "<p>Cant connect to MySQL server. Check MySQL configuration file (DbConnection.php)</p>"; } else { $databaseCreate = "\n CREATE DATABASE IF NOT EXISTS " . $completeDatabaseName . " DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;\n "; $loginAttempts = "\n\t CREATE TABLE IF NOT EXISTS login_attempts (\n user_id int(11) NOT NULL,\n time varchar(30) NOT NULL,\n attemp_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n time_stamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;\n\t "; $membersTable = "\n CREATE TABLE IF NOT EXISTS members (\n id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n username varchar(30) NOT NULL,\n email varchar(50) NOT NULL,\n password char(128) NOT NULL\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;\n\t "; $password = '******'; $membersData = "\n INSERT INTO members (username, email, password) VALUES\n ('test', '*****@*****.**','" . $password . "');\n "; $passwordRequest = "\n CREATE TABLE IF NOT EXISTS password_requests (\n id_request int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n user_email varchar(50) NOT NULL,\n time_stamp varchar(100) NOT NULL,\n token varchar(150) NOT NULL\n ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\n "; echo '<h2>Installer Log:</h2>'; $stmt = $mysqli->prepare($databaseCreate); if ($stmt->execute()) { $cfg_result = "<p style='color: green'>New " . $completeDatabaseName . " database created successfully</p>"; } else { $cfg_result = "<p>Error creating " . $completeDatabaseName . " database</p>";
function __construct() { parent::mysqli(DBHOST, DBUSERNAME, DBPASSWORD, DBNAME); }