public function disconnect() { Logger::getInstance()->log('Disconnecting database.'); if (isset($this->connection)) { $this->connection->close(); } $this->connection = null; }
/** * Fecha a conexão com o banco de dados. * * @return void */ public function close() { if ($this->isConnected()) { $this->connection->close(); unset($this->connection); $this->connection = null; } }
private function _validateMysqli($data) { $conn = new \MySQLi($data['db_hostname'], $data['db_username'], $data['db_password']); if ($conn->connect_error) { $conn->close(); return false; } else { // Try to create database, if doesn't exist $sql = "CREATE DATABASE IF NOT EXISTS " . $data['db_database']; if ($conn->query($sql) === false) { // Couldn't create it, just check if exists $sql = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '" . $data['db_database'] . "'"; if (!$conn->query($sql)->num_rows) { $conn->close(); return false; } } $conn->close(); return true; } }
/** * Closes the connection to SphinxQL */ public function close() { $result = $this->_driver->close(); return $result; }
/** * Closes the database connection. */ public function close() { $this->_mysqli->close(); }
if ($len < 102400 || $len > 5 * 1024 * 1024) { die("Pic size error! Allow size: 100KB to 5MB"); } $ip = substr($_SERVER['REMOTE_ADDR'], 0, 49); $pic = base64_decode($pic_str); unset($pic_str); $name = date('YmdHis', time()); $dir = 'img/' . date('Y/m/d', time()); $url = $dir . '/' . substr($name, 8) . '_' . uniqid() . '.png'; $sql = "insert into p(ip,name,url,rotate) values(?,?,?,0)"; $con = new MySQLi(DB_HOST, DB_NAME, DB_USER, DB_PASS); $res = $con->prepare($sql); $res->bind_param("sss", $ip, $name, $url); $res->execute(); $res->close(); $con->close(); if (!is_dir($dir)) { mkdir($dir, 0755, true); } $file = fopen($url, "wb"); fwrite($file, $pic); fflush($file); fclose($file); $img = imagecreatefromstring($pic); unset($pic); $width = imagesx($img); $height = imagesy($img); $ratio = $height > $width ? 800 / $height : 800 / $width; $resize_img = imagecreatetruecolor($width * $ratio, $height * $ratio); imagecopyresampled($resize_img, $img, 0, 0, 0, 0, $width * $ratio, $height * $ratio, $width, $height); imagejpeg($resize_img, $url . "rs");
//数据库类型 $host = 'localhost'; //数据库主机名 $user = '******'; //数据库连接用户名 $pass = '******'; $rpfield = 'body'; // update table char $tostring = ''; // $sql_arr = array(table1, table2); $rpstring_arr = array('违规词1', '违规词2'); foreach ($rpstring_arr as $rpstring_one) { $rpstring = $rpstring_one; foreach ($sql_arr as $sql_one) { $mysqli = new MySQLi($host, $user, $pass, $sql_one); $mysqli->query("set names UTF8"); $exptable_obj = $mysqli->query("show tables like '%_addonarticle'"); // 获取表(内容表,标签表) $exptable = mysqli_fetch_array($exptable_obj); $exptable = $exptable[0]; $rs = $mysqli->query("UPDATE {$exptable} SET {$rpfield}=REPLACE({$rpfield},'{$rpstring}','{$tostring}')"); $mysqli->query("OPTIMIZE TABLE `{$exptable}`"); if ($rs) { echo $sql_one . "成功完成 " . $rpstring . " 数据替换!<br />"; } else { echo $sql_one . "中数据 " . $rpstring . " 替换失败!<br />"; } $mysqli->close(); } }
function add_user($Uname, $Upass, $Urole) { try { $host = "localhost"; $user = "******"; $pwd = "root"; $db = "adminp"; $con = new MySQLi($host, $user, $pwd); $con->select_db($db); $Uname1 = $Uname; $Uname = hash('md5', $Uname); $Upass = hash('md5', $Upass); $query = "insert into admin_users (u_name,u_pwd,u_role) values('" . $Uname . "','" . $Upass . "','" . $Urole . "')"; if ($con->query($query)) { ?> <div class="alert alert-success fade in" style="text-align:left;"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a><strong>Success !</strong>Admin User is Added. USER :<?php echo $Uname1; ?> </div> <?php } else { ?> <div class="alert alert-danger fade in" style="text-align:left;"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a><strong>Unsuccess !</strong>User already EXISTS</div> <?php } } catch (Exception $ex) { print "{$ex}"; } $con->close(); }
/** * Destructor, disconnect from database */ public function __destruct() { @$this->dbcon->close(); }
$t = preg_split("/(?<=\\w)\\b\\s*/", $row["time"]); echo "Posted Date : "; echo $t[0]; echo $t[1]; echo $t[2]; echo "<br><br>"; echo "Posted Time : "; echo $t[3]; echo $t[4]; echo $t[5]; echo "<br><br>"; } } else { echo " Sorry, No jobs your searched area. "; } $conn->close(); //echo "Successfully"; } ?> </center> </div> </form> </div> </div> </div> </body> </html>
/** * Database connection * * @param bool $persistent * @return object */ public function db_connect($persistent = FALSE) { // Do we have a socket path? if ($this->hostname[0] === '/') { $hostname = NULL; $port = NULL; $socket = $this->hostname; } else { // Persistent connection support was added in PHP 5.3.0 $hostname = $persistent === TRUE && is_php('5.3') ? 'p:' . $this->hostname : $this->hostname; $port = empty($this->port) ? NULL : $this->port; $socket = NULL; } $client_flags = $this->compress === TRUE ? MYSQLI_CLIENT_COMPRESS : 0; $this->_mysqli = mysqli_init(); $this->_mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 10); if (isset($this->stricton)) { if ($this->stricton) { $this->_mysqli->options(MYSQLI_INIT_COMMAND, 'SET SESSION sql_mode = CONCAT(@@sql_mode, ",", "STRICT_ALL_TABLES")'); } else { $this->_mysqli->options(MYSQLI_INIT_COMMAND, 'SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode, "STRICT_ALL_TABLES,", ""), ",STRICT_ALL_TABLES", ""), "STRICT_ALL_TABLES", ""), "STRICT_TRANS_TABLES,", ""), ",STRICT_TRANS_TABLES", ""), "STRICT_TRANS_TABLES", "")'); } } if (is_array($this->encrypt)) { $ssl = array(); empty($this->encrypt['ssl_key']) or $ssl['key'] = $this->encrypt['ssl_key']; empty($this->encrypt['ssl_cert']) or $ssl['cert'] = $this->encrypt['ssl_cert']; empty($this->encrypt['ssl_ca']) or $ssl['ca'] = $this->encrypt['ssl_ca']; empty($this->encrypt['ssl_capath']) or $ssl['capath'] = $this->encrypt['ssl_capath']; empty($this->encrypt['ssl_cipher']) or $ssl['cipher'] = $this->encrypt['ssl_cipher']; if (!empty($ssl)) { if (isset($this->encrypt['ssl_verify'])) { if ($this->encrypt['ssl_verify']) { defined('MYSQLI_OPT_SSL_VERIFY_SERVER_CERT') && $this->_mysqli->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, TRUE); } elseif (defined('MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT')) { $this->_mysqli->options(MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT, TRUE); } } $client_flags |= MYSQLI_CLIENT_SSL; $this->_mysqli->ssl_set(isset($ssl['key']) ? $ssl['key'] : NULL, isset($ssl['cert']) ? $ssl['cert'] : NULL, isset($ssl['ca']) ? $ssl['ca'] : NULL, isset($ssl['capath']) ? $ssl['capath'] : NULL, isset($ssl['cipher']) ? $ssl['cipher'] : NULL); } } if (@$this->_mysqli->real_connect($hostname, $this->username, $this->password, $this->database, $port, $socket, $client_flags)) { // Prior to version 5.7.3, MySQL silently downgrades to an unencrypted connection if SSL setup fails if ($client_flags & MYSQLI_CLIENT_SSL && version_compare($this->_mysqli->client_info, '5.7.3', '<=') && empty($this->_mysqli->query("SHOW STATUS LIKE 'ssl_cipher'")->fetch_object()->Value)) { $this->_mysqli->close(); $message = 'MySQLi was configured for an SSL connection, but got an unencrypted connection instead!'; log_message('error', $message); return $this->db->db_debug ? $this->db->display_error($message, '', TRUE) : FALSE; } return $this->_mysqli; } return FALSE; }
function __destruct() { // mysqli_report(MYSQLI_REPORT_OFF); parent::close(); }
} else { $slug = preg_replace('/[^a-z0-9]/si', '', $slug); if (is_numeric($slug) && strlen($slug) > 8) { $url = 'https://twitter.com/' . TWITTER_USERNAME . '/status/' . $slug; } else { $db = new MySQLi(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE); $db->set_charset('utf8mb4'); $escapedSlug = $db->real_escape_string($slug); $redirectResult = $db->query('SELECT url FROM redirect WHERE slug = "' . $escapedSlug . '"'); if ($redirectResult && $redirectResult->num_rows > 0) { $db->query('UPDATE redirect SET hits = hits + 1 WHERE slug = "' . $escapedSlug . '"'); $url = $redirectResult->fetch_object()->url; } else { $url = DEFAULT_URL . $_SERVER['REQUEST_URI']; } $db->close(); } } } } header('Location: ' . $url, null, 301); $attributeValue = htmlspecialchars($url); ?> <meta http-equiv=refresh content="0;URL=<?php echo $attributeValue; ?> "><a href="<?php echo $attributeValue; ?> ">Continue</a><script>location.href=<?php echo json_encode($url, JSON_HEX_TAG | JSON_UNESCAPED_SLASHES);
<?php $conn1=new MySQLi("localhost","user","password","database"); if($conn1->connect_errno){ echo mysqli_connect_error(); exit; } $res=$conn1->query("show tables") or die($conn1->error); while($tables=$res->fetch_array()){ $conn1->query("ALTER TABLE $tables[0] CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci") or die($conn1->error); } echo "The collation of your database has been successfully changed!"; $res->free(); $conn1->close(); ?>
private function AddSet() { if ($this->get_request_method() != "POST") { $this->response('', 406); } $action = $this->_request['Action']; $query = ""; $setName = $this->_request['Name']; $setNumber = $this->_request['Number']; $revision = $this->_request['Revision']; $universal = $setNumber . "-" . $revision; $pieces = $this->_request['Pieces']; $theme = $this->_request['Theme']; $subtheme = $this->_request['Subtheme']; $wptag = $this->_request['Tag']; $image = $this->_request['Image']; $released = $this->_request['Start']; $retired = $this->_request['End']; $description = $this->_request['Description']; $stub = $this->stubify($setName); if ($released == '') { $released = null; } if ($retired == '') { $retired = null; } $mysqli = new MySQLi(self::DB_SERVER, self::DB_USER, self::DB_PASSWORD, self::DB); if ($action == "new") { // $query = $mysqli->prepare("INSERT into test_setguide_main // set_number,revision,set_name,set_stub,theme_id,subtheme_id,pieces, // root_image,date_released,date_retired,wordpress_tag) // values(?,?,?,?,?,?,?,?,?,?,?)"); // $query->bind_param('iisssiiisiis',$number,$revision,$name,$stub,$theme,$subtheme, // $pieces,$image,$released,$retired,$wptag); $query = $mysqli->prepare("INSERT into test_setguide_main \r\n\t\t\t\t\t(set_number,set_name,theme_id,subtheme_id,pieces,root_image,revision,\r\n\t\t\t\t\tset_stub,date_released,date_retired,wordpress_tag,universal_id,`description`) \r\n\t\t\t\t\tvalues(?,?,?,?,?,?,?,?,?,?,?,?,?)"); $query->bind_param('isiiisisiisss', $setNumber, $setName, $theme, $subtheme, $pieces, $image, $revision, $stub, $released, $retired, $wptag, $universal, $description); } else { $query = $mysqli->prepare("UPDATE test_setguide_main SET \r\n\t\t\t\t\tset_name=?,theme_id=?,subtheme_id=?,pieces=?,\r\n\t\t\t\t\troot_image=?,revision=?,set_stub=?,date_released=?,date_retired=?,\r\n\t\t\t\t\twordpress_tag=?,universal_id=?,`description`=? \r\n\t\t\t\t\tWHERE set_number=" . $setNumber); $query->bind_param('siiisisiisss', $setName, $theme, $subtheme, $pieces, $image, $revision, $stub, $released, $retired, $wptag, $universal, $description); } $query->execute(); $mysqli->close(); $this->response('', 200); }
function __destruct() { parent::close(); }
public function __destruct() { if (!mysqli_connect_error()) { $this->link->close(); } }
/** * Disconnect from the server * * @return null */ public function disconnect() { $this->link->close(); $this->link = null; }
public function tearDown() { if ($this->db) { $this->db->close(); } }
/** * Automatically commits pending transactions * */ public function close() { $this->commit(); parent::close(); }
}); # Função para obter dados da tabela 'cliente'... //$app->get('/clientes','authenticate',function(){ $app->get('/clientes', function () { # Variável que irá ser o retorno (pacote JSON)... $retorno = array(); # Abrir conexão com banco de dados... $conexao = new MySQLi("localhost", "root", "", "mg"); # Validar se houve conexão... if (!$conexao) { echo "Não foi possível se conectar ao banco de dados"; exit; } # Selecionar todos os cadastros da tabela 'cliente'... $registros = $conexao->query("SELECT * FROM tb_cliente"); # Transformando resultset em array, caso ache registros... if ($registros->num_rows > 0) { while ($cliente = $registros->fetch_array(MYSQL_BOTH)) { $registro = array('id' => $cliente["ID_CLI"], 'nome' => utf8_encode($cliente["NOME_CLI"]), 'fone' => $cliente["FONE1_CLI"], 'email' => $cliente["EMAIL_CLI"]); $retorno[] = $registro; } # Encerrar conexão... $conexao->close(); # Retornando o pacote (JSON)... //$retorno = json_encode(array('clientes'=>$retorno)); $retorno = json_encode($retorno); echo $retorno; } }); # Executar a API (deixá-la acessível)... $app->run();
/** * Connect to the database. * * @param bool $persistent * @return mixed */ public function connect($persistent = false) { // Do we have a socket path? if ($this->hostname[0] === '/') { $hostname = null; $port = null; $socket = $this->hostname; } else { $hostname = $persistent === true ? 'p:' . $this->hostname : $this->hostname; $port = empty($this->port) ? null : $this->port; $socket = null; } $client_flags = $this->compress === true ? MYSQLI_CLIENT_COMPRESS : 0; $this->mysqli = mysqli_init(); $this->mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 10); if (isset($this->strictOn)) { if ($this->strictOn) { $this->mysqli->options(MYSQLI_INIT_COMMAND, 'SET SESSION sql_mode = CONCAT(@@sql_mode, ",", "STRICT_ALL_TABLES")'); } else { $this->mysqli->options(MYSQLI_INIT_COMMAND, 'SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode, "STRICT_ALL_TABLES,", ""), ",STRICT_ALL_TABLES", ""), "STRICT_ALL_TABLES", ""), "STRICT_TRANS_TABLES,", ""), ",STRICT_TRANS_TABLES", ""), "STRICT_TRANS_TABLES", "")'); } } if (is_array($this->encrypt)) { $ssl = []; empty($this->encrypt['ssl_key']) or $ssl['key'] = $this->encrypt['ssl_key']; empty($this->encrypt['ssl_cert']) or $ssl['cert'] = $this->encrypt['ssl_cert']; empty($this->encrypt['ssl_ca']) or $ssl['ca'] = $this->encrypt['ssl_ca']; empty($this->encrypt['ssl_capath']) or $ssl['capath'] = $this->encrypt['ssl_capath']; empty($this->encrypt['ssl_cipher']) or $ssl['cipher'] = $this->encrypt['ssl_cipher']; if (!empty($ssl)) { if (isset($this->encrypt['ssl_verify'])) { if ($this->encrypt['ssl_verify']) { defined('MYSQLI_OPT_SSL_VERIFY_SERVER_CERT') && $this->mysqli->options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true); } elseif (defined('MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT')) { $this->mysqli->options(MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT, true); } } $client_flags |= MYSQLI_CLIENT_SSL; $this->mysqli->ssl_set(isset($ssl['key']) ? $ssl['key'] : null, isset($ssl['cert']) ? $ssl['cert'] : null, isset($ssl['ca']) ? $ssl['ca'] : null, isset($ssl['capath']) ? $ssl['capath'] : null, isset($ssl['cipher']) ? $ssl['cipher'] : null); } } if ($this->mysqli->real_connect($hostname, $this->username, $this->password, $this->database, $port, $socket, $client_flags)) { // Prior to version 5.7.3, MySQL silently downgrades to an unencrypted connection if SSL setup fails if ($client_flags & MYSQLI_CLIENT_SSL && version_compare($this->mysqli->client_info, '5.7.3', '<=') && empty($this->mysqli->query("SHOW STATUS LIKE 'ssl_cipher'")->fetch_object()->Value)) { $this->mysqli->close(); $message = 'MySQLi was configured for an SSL connection, but got an unencrypted connection instead!'; log_message('error', $message); if ($this->db->db_debug) { throw new DatabaseException($message); } return false; } if (!$this->mysqli->set_charset($this->charset)) { log_message('error', "Database: Unable to set the configured connection charset ('{$this->charset}')."); $this->mysqli->close(); if ($this->db->debug) { throw new DatabaseException('Unable to set client connection character set: ' . $this->charset); } return false; } return $this->mysqli; } return false; }
if ($rowPassword != $password) { $message = "Das Passwort ist nicht korrekt!"; } } $hasUser = true; } if (!$hasUser) { $message = "Der Benutzer ist nicht vorhanden!"; } if (!isset($_SESSION['userId'])) { session_destroy(); } else { // Weiterleitung wenn alle Angaben korrekt. header("Location: main.php"); } $connection->close(); } } else { if (empty($username) && empty($passwordNonHash)) { $message = "Geben Sie bitte einen Benutzernamen und ein Passwort ein!"; } else { if (empty($username)) { $message = "Bitte geben Sie einen Benutzernamen ein"; } else { if (empty($passwordNonHash)) { $message = "Bitte geben Sie ein Passwort ein!"; } } } } }
function SendQuery($query) { $mydb = new MySQLi($this->GetServerName(), $this->GetUId(), $this->GetPassword(), $this->GetDatabase()); return $mydb->query($query); $mydb->close(); }