/**
* 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>
