/**
* Connect
* @param string $host
* @param string $user
* @param string $paswd
* @param string $db
* @param int $port
* @return mixed
*/
public function connect($host, $user, $paswd, $db, $port = self::DEFAULT_PORT)
{
$port = (int) $port;
$res = @$this->conn->connect($host, $user, $paswd, $db, $port);
if (0 !== mysqli_connect_errno($this->conn)) {
throw new Mage_DB_Exception(mysqli_connect_error($this->conn));
}
return $res;
}
public function connect($host = "92.222.29.95", $user = "******", $paswd = "CestLeProjet2.0", $db = "projetiweb")
{
//$port = (int) $port;
$res = @$this->conn->connect($host, $user, $paswd, $db, 3306);
if (0 !== mysqli_connect_errno($this->conn)) {
//throw new mysqli_connect_error($this->conn);
echo 'Erreur de connection<br>';
print_r(error_get_last());
echo "<br>" . mysqli_connect_errno($this->conn) . ": " . mysqli_connect_error($this->conn) . "<br>" . $this->conn->connect_errno . " | " . $this->conn->connect_error;
}
return $res;
}
/**
* 参数为了兼容parent类，代码不会使用传入的参数作为配置
* @param null $_host
* @param null $user
* @param null $password
* @param null $database
* @param null $port
* @param null $socket
* @return bool
*/
function connect($_host = null, $user = null, $password = null, $database = null, $port = null, $socket = null)
{
$db_config =& $this->config;
$host = $db_config['host'];
if (!empty($db_config['persistent'])) {
$host = 'p:' . $host;
}
if (isset($db_config['passwd'])) {
$db_config['password'] = $db_config['passwd'];
}
if (isset($db_config['dbname'])) {
$db_config['name'] = $db_config['dbname'];
} elseif (isset($db_config['database'])) {
$db_config['name'] = $db_config['database'];
}
parent::connect($host, $db_config['user'], $db_config['password'], $db_config['name'], $db_config['port']);
if ($this->connect_errno) {
trigger_error("mysqli connect to server[{$host}:{$db_config['port']}] failed: " . mysqli_connect_error(), E_USER_WARNING);
return false;
}
if (!empty($db_config['charset'])) {
$this->set_charset($db_config['charset']);
}
return true;
}
public function connect($host = NULL, $user = NULL, $password = NULL, $database = NULL, $port = NULL, $socket = NULL)
{
$config = $this->config;
if ($config['host'] === 'localhost') {
@parent::connect($config['host'], $config['user'], $config['password'], $config['database'], 0, $config['socket']);
} else {
@parent::connect($config['host'], $config['user'], $config['password'], $config['database'], $config['port']);
}
if ($this->connect_errno) {
Log::prn_log(ERROR, "database connect failed: " . $this->connect_error . "!");
return false;
}
Log::prn_log(INFO, "database connect ok ({$config['host']},{$config['port']})!");
if (isset($config['charset'])) {
Log::prn_log(INFO, "set charset names {$config['charset']}");
$this->query("set names {$config['charset']}");
}
if (isset($config['sqls'])) {
$sqls = explode(";", $config['sqls']);
foreach ($sqls as $sql) {
Log::prn_log(INFO, "{$sql}");
$this->query($sql);
}
}
return true;
}
function dbConnect()
{
//Connessione DB
$mysqli = new mysqli();
$mysqli->connect(_DB_SERVER, _DB_USER, _DB_PASSWORD, _DB_NAME);
return $mysqli;
}
private function __construct()
{
$this->ccnn = parent::connect($this->host, $this->user, $this->pass, $this->ddbb);
if ($this->connect_errno) {
die('Error # ' . $this->connect_errno . ': ' . $this->connect_error);
}
}
function connect()
{
$db_config =& $this->config;
parent::connect($db_config['host'], $db_config['user'], $db_config['password'], $db_config['dbname']);
if (mysqli_connect_errno()) {
exit("Connect failed: %s\n" . mysqli_connect_error());
}
$this->set_charset($db_config['charset']);
}
/**
* get database connection infos and connect to the database
*
* @return mysqli
*/
public static function initializeDbConnection()
{
$dbPath = config_get('hostname');
$dbUser = config_get('db_username');
$dbPass = config_get('db_password');
$dbName = config_get('database_name');
$mysqli = new mysqli($dbPath, $dbUser, $dbPass, $dbName);
$mysqli->connect($dbPath, $dbUser, $dbPass, $dbName);
return $mysqli;
}
/**
* create mysql connection
*/
protected function createConnection()
{
$config = $this->config;
$db = new \mysqli();
$db->connect($config['host'], $config['user'], $config['password'], $config['database'], $config['port']);
$db_sock = swoole_get_mysqli_sock($db);
swoole_event_add($db_sock, array($this, 'onSQLReady'));
$this->idle_pool[] = array('object' => $db, 'socket' => $db_sock);
$this->connection_num++;
}
/**
* Restituisce una connessione funzionante al db
* @return \mysqli una connessione funzionante al db dell'applicazione,
* null in caso di errore
*/
public function connectDb()
{
$mysqli = new mysqli();
$mysqli->connect(Settings::$db_host, Settings::$db_user, Settings::$db_password, Settings::$db_name);
if ($mysqli->errno != 0) {
return null;
} else {
return $mysqli;
}
}
function ConGestionDC()
{
try {
$con = new mysqli();
$con->connect('localhost', 'root', '', 'gestiondc');
return $con;
} catch (Exception $ex) {
return "Error: " . $ex->getMessage();
}
}
public function connect($host = null, $user = null, $psw = null, $dbname = null, $port = null, $socket = null, $tbname = null)
{
parent::connect($host, $user, $psw, $dbname, $port, $socket);
$host != null && ($this->_host = $host);
$port != null && ($this->_port = $port);
$user != null && ($this->_user = $user);
$psw != null && ($this->_psw = $psw);
$dbname != null && ($this->_dbname = $dbname);
$tbname != null && ($this->_tbname = $tbname);
$socket != null && ($this->_socket = $socket);
}
public static function f($connection)
{
list($host, $user, $pass, $db) = explode(':', $connection);
if (empty(self::$instance_f[$connection])) {
$i = new mysqli();
$i->connect($host, $user, $pass, $db, true);
self::$instance_f[$connection] = $i;
return $i;
} else {
return self::$instance_f[$connection];
}
}
function onStart($serv)
{
$this->serv = $serv;
for ($i = 0; $i < $this->pool_size; $i++) {
$db = new mysqli();
$db->connect('172.16.1.19', 'test', 'test', '1188test');
$db_sock = swoole_get_mysqli_sock($db);
swoole_event_add($db_sock, array($this, 'onSQLReady'));
$this->idle_pool[] = array('mysqli' => $db, 'db_sock' => $db_sock, 'fd' => 0);
}
echo "Server: start.Swoole version is [" . SWOOLE_VERSION . "]\n";
}
function connect()
{
$db_config =& $this->config;
parent::connect($db_config['host'], $db_config['user'], $db_config['passwd'], $db_config['name']);
if (mysqli_connect_errno()) {
trigger_error("Mysqli connect failed: %s\n" . mysqli_connect_error());
return false;
}
if (!empty($db_config['charset'])) {
$this->set_charset($db_config['charset']);
}
return true;
}
public function testEscapeSQL()
{
$o = new RequestInput("Test", "test");
$mysqli = new \mysqli();
$this->loadConnectionVars();
$mysqli->connect($this->db_host, $this->db_user, $this->db_password, $this->db_schema);
$this->assertEquals("null", $o->escapeSQL($mysqli), "Defaults to 'null'");
$o->value = '';
$this->assertEquals("''", $o->escapeSQL($mysqli), "Empty string");
$o->value = "abc";
$this->assertEquals("'abc'", $o->escapeSQL($mysqli), "Strings are quoted");
$this->unloadConnectionVars();
}
function db_insert($insert_query)
{
// Instantiate the mysqli class
$mysqli = new mysqli();
//Provide your DB credentials here
// Connect to the database server and select a database
$mysqli->connect('your db server', 'your db id', 'your password', 'your db name');
//Execute query
$result = $mysqli->query($insert_query);
//commit
$commit = $mysqli->commit();
// Close the connection
$mysqli->close();
}
function sqli()
{
$db_host = "localhost";
//连接的服务器地址
$db_user = "******";
//连接数据库的用户名
$db_psw = "123123";
//连接数据库的密码
$db_name = "test";
//连接的数据库名称
$mysqli = new mysqli();
$mysqli->connect($db_host, $db_user, $db_psw, $db_name);
$mysqli->query("SET NAMES utf8");
return $mysqli;
}
/**
* Restituisce una connessione funzionante al db
* @return \mysqli una connessione funzionante al db dell'applicazione,
* null in caso di errore
*/
public function connectDb()
{
$mysqli = new mysqli();
$mysqli->connect(Settings::$db_host, Settings::$db_user, Settings::$db_password, Settings::$db_name);
///PROVA
//$result = $mysqli->query("show tables");
//while($table = $result->fetch_array()) {
// echo($table[0] . "<BR>");
//}
if ($mysqli->errno != 0) {
return null;
} else {
return $mysqli;
}
}
function connect($host = null, $user = null, $password = null, $database = null, $port = null, $socket = null)
{
$db_config =& $this->config;
if (!empty($db_config['persistent'])) {
$db_config['host'] = 'p:' . $db_config['host'];
}
parent::connect($db_config['host'], $db_config['user'], $db_config['passwd'], $db_config['name'], $db_config['port']);
if (mysqli_connect_errno()) {
trigger_error("Mysqli connect failed: " . mysqli_connect_error());
return false;
}
if (!empty($db_config['charset'])) {
$this->set_charset($db_config['charset']);
}
return true;
}
/**
* create mysql connection
*/
protected function createConnection()
{
$config = $this->config;
$db = new \mysqli();
$db->connect($config['host'], $config['user'], $config['password'], $config['database'], $config['port']);
if ($db->connect_error) {
return [$db->connect_errno, $db->connect_error];
}
if (!empty($config['charset'])) {
$db->set_charset($config['charset']);
}
$db_sock = swoole_get_mysqli_sock($db);
swoole_event_add($db_sock, array($this, 'onSQLReady'));
$this->idle_pool[$db_sock] = array('object' => $db, 'socket' => $db_sock);
$this->connection_num++;
return 0;
}
public static function getConnection($mode = true)
{
$conn = null;
try {
$config = self::getDbConfig();
$conn = new mysqli();
$conn->connect($config["host"], $config["user"], $config["password"], $config["db"], $config["port"]);
if ($conn->connect_error) {
throw new Exception($conn->connect_error);
}
$conn->autocommit($mode);
//是否自动提交，默认自动提交
} catch (Exception $e) {
Tool::logger(__METHOD__, __LINE__, "连接数据库失败：" . $e->getMessage());
throw $e;
}
return $conn;
}
public function testEscapeSQL()
{
$o = new BooleanInput("Test", "test");
$mysqli = new \mysqli();
$this->loadConnectionVars();
$mysqli->connect($this->db_host, $this->db_user, $this->db_password, $this->db_schema);
$this->assertEquals("null", $o->escapeSQL($mysqli), "Defaults to 'null'");
$o->value = true;
$this->assertEquals("1", $o->escapeSQL($mysqli), "True value translates to 1");
$o->value = false;
$this->assertEquals("0", $o->escapeSQL($mysqli), "False value translates to 0");
$o->value = '1';
$this->assertEquals("", $o->escapeSQL($mysqli), "Invalid value (\"1\") translates to empty string");
$o->value = 1;
$this->assertEquals("", $o->escapeSQL($mysqli), "Invalid value (1) translates to empty string");
$o->value = 'true';
$this->assertEquals("", $o->escapeSQL($mysqli), "Invalid value (\"true\") translates to empty string");
$this->unloadConnectionVars();
}
/**
* Establishes a connection to the defined mysql-server.
*
* @return void
*/
public function connect()
{
if ($this->connected === TRUE) {
return;
}
if ($this->configuration['db']['driver'] != 'mysql') {
$this->logger->error('Cannot connect to a non-mysql database connection!');
return;
}
$host = $this->readonly === TRUE ? $this->ro_host : $this->rw_host;
if (isset($this->ssl_key, $this->ssl_cert, $this->ca_cert)) {
$this->mysqli->ssl_set($this->ssl_key, $this->ssl_cert, $this->ca_cert, $this->ca_path, $this->cipher);
}
$this->mysqli->connect($host, $this->user, $this->pwd, $this->db, $this->port, $this->socket);
if ($this->mysqli->errno === 0) {
$this->mysqli->set_charset('utf8');
$this->connected = TRUE;
}
}
/************************************************
The Search PHP File
************************************************/
/************************************************
MySQL Connect
************************************************/
// Credentials Please steal my account.
$dbhost = "sulley.cah.ucf.edu";
$dbname = 'ma578143';
$dbuser = '******';
$dbpass = '******';
// Connection
global $tempest_road;
$tempest_road = new mysqli();
$tempest_road->connect($dbhost, $dbuser, $dbpass, $dbname);
$tempest_road->set_charset("utf8");
//echo "connected";
// Check Connection
if ($tempest_road->connect_errno) {
printf("Connect failed: %s\n", $tempest_road->connect_error);
exit;
}
/************************************************
Search Functionality
************************************************/
// Define Output HTML Formating
$html = '';
$html .= '<li class="result">';
$html .= '<a target="_blank" href="urlString">';
$html .= '<p>nameString</p>';
/************************************************
The Search PHP File
************************************************/
/************************************************
MySQL Connect
************************************************/
// Credentials
$dbhost = "localhost";
$dbname = "hospital_management";
$dbuser = "******";
$dbpass = "";
// Connection
global $tutorial_db;
$tutorial_db = new mysqli();
$tutorial_db->connect($dbhost, $dbuser, $dbpass, $dbname);
$tutorial_db->set_charset("utf8");
// Check Connection
if ($tutorial_db->connect_errno) {
printf("Connect failed: %s\n", $tutorial_db->connect_error);
exit;
}
/************************************************
Search Functionality
************************************************/
// Define Output HTML Formating
$html = '';
$html .= '<li class="result">';
$html .= '<a target="_blank" href="urlString">';
$html .= '<h3>nameString</h3>';
$html .= '<h4>functionString</h4>';
// The name of the table used to store ES2 data.
$fileFieldName = "filename";
// The name of the field where we save our file names.
$filePrimaryName = "id";
// The name of the field containing the primary key for filenames.
$tagFieldName = "tag";
// The name of the field where you want to save the tag.
$dataFieldName = "data";
// The name of the field where you want to save the data.
$fileIDFieldName = "fileId";
// An index into the file table representing the file containing this tag.
// Turn off PHP errors.
error_reporting(0);
// Attempt to connect to database.
$mysqli = new mysqli();
$mysqli->connect($db_host, $db_user, $db_password, $db_name);
if (mysqli_connect_error()) {
if (!isset($_POST['mode'])) {
echo "Could not connect to database. ES2.php or MySQL database are incorrectly configured.";
exit;
}
echo "01";
// Could not connect to database with these credentials.
exit;
}
if (!isset($_POST['mode'])) {
echo "ES2.php and MySQL database are working correctly.";
exit;
}
// If user hasn't logged on or has forgot to enter any login details.
if (Authenticate($_POST['username'], $_POST['password']) == false) {
<?php
$mysqli = new mysqli();
$mysqli->connect('localhost', 'root', 'ps!seecjkshitsaym');
$mysqli->select_db('shcms');
$sql = "select a.*,b.* from news a left join channel b on b.code=a.channel_code where a.content like '%<A%href%' order by a.news_id desc";
$res = $mysqli->query($sql);
$data = array();
$i = 0;
while ($row = $res->fetch_assoc()) {
if ($i >= 10) {
continue;
}
$data[] = $row;
$i++;
}
var_dump($data);
//foreach($data as $v){
// $ch = curl_init();
// curl_setopt($ch, CURLOPT_URL,"http://w.huanqiu.com/apps/w.huanqiu/shcms2apu.php");
// curl_setopt($ch, CURLOPT_POST, true);
// curl_setopt($ch, CURLOPT_POSTFIELDS, array("data" => json_encode($v,JSON_UNESCAPED_UNICODE)));
// curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// $res = curl_exec($ch);
// curl_close($ch);
// var_dump($res);
//}
<?php
if (!function_exists('swoole_get_mysqli_sock')) {
die("no async_mysql support\n");
}
$db = new mysqli();
$db->connect('127.0.0.1', 'root', '123456', 'paopaogame');
$sql = "show tables";
$db->query($sql, MYSQLI_ASYNC);
$readinfo = "read mysql back:" . $sql;
$count = 0;
swoole_event_add(swoole_get_mysqli_sock($db), function ($__db_sock) {
global $db;
global $readinfo;
global $count;
global $sql;
// var_dump($__db_sock);
$res = $db->reap_async_query();
var_dump($res->fetch_all(MYSQLI_ASSOC));
$db->query("SELECT * FROM paopaogame.paopaoaccount limit 0,2;", MYSQLI_ASYNC);
echo $readinfo . " count=" . $count . "\n";
$count++;
// echo "sleep "."1"." second";
sleep(1);
});
echo "Finish\n";
protected function databaseFactory()
{
$mysqli = new \mysqli();
$mysqli->connect('localhost', 'zsql', 'nopass', 'zsql');
return $mysqli;
}
