/** * Constructor * * @param String $server * @param String $database * @param String $dbuser * @param String $dbpassword * @param boolean $debug Mostra tota la informació de les peticions SQL. */ public function __construct($server, $database, $dbuser, $dbpassword, $debug = false) { $this->setDebug($debug); if (!empty($server) && !empty($database) && !empty($dbuser) && !empty($dbpassword)) { $this->dbg('Connection', 'Intentant connectar amb el servidor.'); // $mysqli = new mysqli($server, $dbuser, $dbpassword, $database); /* comprobar la conexió */ if ($mysqli->connect_errno) { $this->dbg('Connection', "Falló la conexión: %s\n", $mysqli->connect_error); exit; } $this->dbg('Connection', 'Connexió correcte (OK)'); /* cambiar el conjunto de caracteres a utf8 */ if (!$mysqli->set_charset("utf8")) { $this->dbg('Connection', "Error cargando el conjunto de caracteres utf8: %s\n", $mysqli->error); } else { $this->dbg('Info', "Conjunt de caracteres actual: " . $mysqli->character_set_name()); } // $this->db = $mysqli; } else { $this->dbg('info', 'Database no inicialitzada'); } }
public function __construct($dsn = "", $user = "", $passwd = "", $chrset = "utf8") { #데이타베이스 접속 if (!empty($dsn)) { $dsn_args = explode(":", $dsn); parent::__construct($dsn_args[0], $user, $passwd, $dsn_args[1]); } else { //config.inc.php --> config.db.php parent::__construct(_DB_HOST, _DB_USER, _DB_PASSWD, _DB_NAME); } if (mysqli_connect_error()) { throw new ErrorException(mysqli_connect_error(), mysqli_connect_errno()); } #문자셋 $chrset_is = parent::character_set_name(); if (strcmp($chrset_is, $chrset)) { parent::set_charset($chrset); } }
function db_connect($mysql_host, $mysql_user, $mysql_password, $database) { $db_con = new mysqli($mysql_host, $mysql_user, $mysql_password, $database); /* check connection */ if ($db_con->connect_errno) { printf("<p><span class='red'> MySQL Connect failed: %s\n <br /></span></p>", $db_con->connect_error); } if (!$db_con->connect_errno) { /* define character set to utf8 */ if (!$db_con->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $db_con->error); /* Print current character set */ $charset = $db_con->character_set_name(); printf("<br />Current character set is: %s\n", $charset); $db_con->close(); exit; } } return $db_con; }
<?php $basedatos = "liberacioncelular"; $host = '130.211.174.74'; $user = '******'; $pass = '******'; $port = null; $socket = ''; /* $host=null; $user='******'; $pass=''; $port=null; $socket='/cloudsql/control-asx:control-db'; */ $mysqli = new mysqli($host, $user, $pass, $basedatos, $port, $socket); /* verificar la conexión */ if (mysqli_connect_errno()) { printf("Falló la conexión failed: %s\n", $mysqli->connect_error); exit; } if ('utf8' != $mysqli->character_set_name()) { if (!$mysqli->set_charset("utf8")) { printf("Error cargando el conjunto de caracteres utf8: %s\n", $mysqli->error); exit; } else { printf("Conjunto de caracteres actual: %s\n", $mysqli->character_set_name()); } }
<?php $host = 'localhost'; $database = 'test'; $username = '******'; $password = '******'; $selectName = 'harry'; //要查找的用户名,一般是用户输入的信息 $insertName = 'testname'; // 创建对象并打开连接,最后一个参数是选择的数据库名称 $mysqli = new mysqli($host, $username, $password, $database); // 编码转化为 utf8 if (!$mysqli->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $mysqli->error); } else { printf("Current character set: %s\n", $mysqli->character_set_name()); } if (mysqli_connect_errno()) { // 诊断连接错误 die("could not connect to the database.\n" . mysqli_connect_error()); } $selectedDb = $mysqli->select_db($database); //选择数据库 if (!$selectedDb) { die("could not to the database\n" . mysql_error()); } if ($stmt = $mysqli->prepare("select * from user where name = ?")) { /* bind parameters for markers */ $stmt->bind_param("s", $selectName); /* execute query */ $stmt->execute();
$zapisovy_ffmpeg_audio_channels = $_POST["odeslane_ffmpeg_audio_channels"]; $zapisovy_ffmpeg_audio_sampling = $_POST["odeslane_ffmpeg_audio_sampling"]; $zapisovy_csfd_title_cesky = str_replace("'", "\\'", $zapisovy_csfd_title_cesky); $zapisovy_csfd_title_original = str_replace("'", "\\'", $zapisovy_csfd_title_original); $zapisovy_csfd_description = str_replace("'", "\\'", $zapisovy_csfd_description); $servername = "127.0.0.1"; $username = "******"; $password = "******"; $dbname = "jakubkrizkacz1"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } if (!$conn->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $conn->error); } else { printf("Current character set: %s\n", $conn->character_set_name()); } $sql = "INSERT INTO csfd (\n id,\n title_original,\n title_cesky, \n year, \n genre, \n url, \n description)\nVALUES (\n '{$zapisovy_ffmpeg_id_csfd}', \n '{$zapisovy_csfd_title_original}', \n '{$zapisovy_csfd_title_cesky}', \n '{$zapisovy_csfd_year}', \n '{$zapisovy_csfd_genre}', \n '{$zapisovy_csfd_url}', \n '{$zapisovy_csfd_description}')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); ?> </body> </html>
public function ConnectBD($pSERVIDOR, $pUSUARIO, $pPASSWORD, $pBD, $pPORT, $pCHARSET) { // Conectarse a la BD o no $this->sysKrn->krn_audit_log(AUDIT_DB, __DIR__, __FILE__, __LINE__, __CLASS__, __METHOD__, __FUNCTION__, "Connect Server: " . $pSERVIDOR . " - User: "******"mysqli_connect_error ()"); } // cambiar el conjunto de caracteres a utf8 if (!$r->set_charset($pCHARSET)) { $this->sysKrn->krn_audit_log(AUDIT_DB, __DIR__, __FILE__, __LINE__, __CLASS__, __METHOD__, __FUNCTION__, "Charset Error - Server: " . $pSERVIDOR . " - Error Character Set: " . $r->error); } else { $this->sysKrn->krn_audit_log(AUDIT_DB, __DIR__, __FILE__, __LINE__, __CLASS__, __METHOD__, __FUNCTION__, "Charset ok - Server: " . $pSERVIDOR . " - Character Set: " . $r->character_set_name()); } // Comprobarmos si existen las tablas $CHECK_TABLES_LENGTH = count($this->sysCheckTables); for ($i = 0; $i < $CHECK_TABLES_LENGTH; $i++) { if (mysqli_query($r, "DESCRIBE `" . $this->sysCheckTables[$i] . "`")) { $this->sysKrn->krn_audit_log(AUDIT_DB, __DIR__, __FILE__, __LINE__, __CLASS__, __METHOD__, __FUNCTION__, " Table: " . $this->sysCheckTables[$i] . ": ok"); } else { $this->sysKrn->krn_audit_log(AUDIT_DB, __DIR__, __FILE__, __LINE__, __CLASS__, __METHOD__, __FUNCTION__, " Table: " . $this->sysCheckTables[$i] . ": not exists"); $this->sysKrn->krn_do_json($pSTATUS = FALSE, $pPARAM_1 = ERR_DB_CHECK_TABLES_FAIL, $pPARAM_2 = " Table: " . $this->sysCheckTables[$i] . ": not exists"); } } return $r; }
$Config['MySQL'] = $Config['URL']['Other'][$_Server]['MySQL']; $Config['Lang'] = $Config['URL']['Other'][$_Server]['Lang']; define("SERVER", $Config['URL']['Other'][$_Server]["Require.www"] ? "http://www." . $_Server : "http://" . $_Server); define("HOST", $Config['URL']['Other'][$_Server]["Require.www"] ? "www." . $_Server : $_Server); define("sSERVER", $Config['URL']['Other'][$_Server]["SSL.enabled"] ? "https://" . HOST : "http://" . HOST); } elseif (!empty($Config['URL']["Default"]["Server"])) { $Config['Lang'] = $Config['URL']['Default']['Lang']; define("SERVER", $Config["URL"]["Default"]["Require.www"] ? "http://www." . $Config['URL']["Default"]["Server"] : "http://" . $Config['URL']["Default"]["Server"]); define("HOST", $Config["URL"]["Default"]["Require.www"] ? "www." . $Config['URL']["Default"]["Server"] : $Config['URL']["Default"]["Server"]); define("sSERVER", $Config["URL"]["Default"]["SSL.enabled"] ? "https://" . HOST : "http://" . HOST); } else { echo "You don´t have access."; exit; } } else { exit; } $MySQLi = new mysqli($Config['MySQL']["host"], $Config['MySQL']["user"], $Config['MySQL']["pass"], $Config['MySQL']["dbname"]); if ($MySQLi->connect_error) { die('Error de Conexión MySQLi (' . $MySQLi->connect_errno . ') ' . $mysqli->connect_error); } $_mysqliCharacter = $MySQLi->character_set_name(); require 'Class.Core.php'; $Core = new Core(); require 'Class.Users.php'; $Users = new Users(); // AntiHTML & SQL Injection $_POST = str_replace(['<', '>', '\'', '\'', '\\'], ['<', '>', '"', ''', '\'], $_POST); $_GET = str_replace(['<', '>', '\'', '\'', '\\'], ['<', '>', '"', ''', '\'], $_GET); DEFINE('FILES', KERNEL . 'Files/' . DIRECTORY_SEPARATOR . $Config['Lang'] . DIRECTORY_SEPARATOR); DEFINE('GLOBALS', FILES . '/GLOBAL/');
/** * Возвращает кодировку по умолчанию, установленную для соединения с БД. * * @param void * @return string */ public function getCharset() { return $this->mysqli->character_set_name(); }
* @version 1.0 * @author Linea de Codigo (http://lineadecodigo.com) * @date 19-mayo-2013 * @url http://lineadecodigo.com/php/cambiar-el-charset-en-la-conexion-a-mysql/ * @description C—digo que nos muestra como cambiar el charset en la conexi—n a una base de datos MySQL, para cambiarlo de latin1 a utf8.. */ ?> <!doctype html> <html> <head><title>Especificar Charset al conectarnos a una Base de Datos</title> </head> <body> <h1>Especificar Charset al conectarnos a una Base de Datos</h1> <?php @($db = new mysqli(localhost, "root", "", "biblioteca")); if ($db->connect_error) { die('Error de Conexion (' . $db->connect_errno . ')' . $db->connect_error); } echo "Conexion correcta con la base de datos... <br>" . $db->host_info . "<br>"; echo "Utilizando un charset, por defecto, de tipo: " . $db->character_set_name() . "<br>"; $db->set_charset('utf8'); echo "Utilizando un nuevo charset de tipo: " . $db->character_set_name(); $db->close(); ?> </body> </html>