本文整理汇总了PHP中mysql_set_charset函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_set_charset函数的具体用法?PHP mysql_set_charset怎么用?PHP mysql_set_charset使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_set_charset函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: installWithoutDemo
public static function installWithoutDemo(JO_Db_Adapter_Abstract $db)
{
mysql_connect($db->getConfig('host'), $db->getConfig('username'), $db->getConfig('password'));
mysql_select_db($db->getConfig('dbname'));
mysql_set_charset('utf8');
$structure = APPLICATION_PATH . '/modules/install/structure.sql';
if (!file_exists($structure)) {
return false;
}
$queryes = self::getQueryes(file($structure));
$results = array();
foreach ($queryes as $query) {
if (trim($query)) {
try {
/*$results[] = */
(bool) mysql_query($query);
} catch (JO_Exception $e) {
/*$results[] = false;*/
}
}
}
$request = JO_Request::getInstance();
$results[] = $db->insert('users', array('user_id' => 1, 'username' => $request->getPost('username'), 'password' => md5(md5($request->getPost('password'))), 'register_datetime' => new JO_Db_Expr('NOW()'), 'status' => 'activate', 'groups' => 'a:1:{i:2;s:2:"on";}'));
/*$results[] = */
$db->update('system', array('value' => $request->getPost('admin_mail')), array('`key` = ?' => 'admin_mail'));
/*$results[] = */
$db->update('system', array('value' => $request->getPost('report_mail')), array('`key` = ?' => 'report_mail'));
if (!in_array(false, $results)) {
$db_set = "\r\r\n\tdb.adapter = \"MYSQLi\"\r\r\n\tdb.params.host = \"" . $db->getConfig('host') . "\"\r\r\n\tdb.params.username = \"" . $db->getConfig('username') . "\"\r\r\n\tdb.params.password = \"" . $db->getConfig('password') . "\"\r\r\n\tdb.params.dbname = \"" . $db->getConfig('dbname') . "\"\r\r\n\tdb.params.charset =\"utf8\"";
$results[] = (bool) @file_put_contents(APPLICATION_PATH . '/config/config_db.ini', $db_set);
}
return !in_array(false, $results);
}
开发者ID:noikiy,项目名称:PD,代码行数:33,代码来源:Install.php
示例2: connect
protected function connect()
{
if (!function_exists('mysql_connect')) {
// We have to '@' the actual call since it can spew all sorts of silly
// noise, but it will also silence fatals caused by not having MySQL
// installed, which has bitten me on three separate occasions. Make sure
// such failures are explicit and loud.
throw new Exception("About to call mysql_connect(), but the PHP MySQL extension is not " . "available!");
}
$user = $this->getConfiguration('user');
$host = $this->getConfiguration('host');
$database = $this->getConfiguration('database');
$pass = $this->getConfiguration('pass');
if ($pass instanceof PhutilOpaqueEnvelope) {
$pass = $pass->openEnvelope();
}
$conn = @mysql_connect($host, $user, $pass, $new_link = true, $flags = 0);
if (!$conn) {
$errno = mysql_errno();
$error = mysql_error();
throw new AphrontQueryConnectionException("Attempt to connect to {$user}@{$host} failed with error " . "#{$errno}: {$error}.", $errno);
}
if ($database !== null) {
$ret = @mysql_select_db($database, $conn);
if (!$ret) {
$this->throwQueryException($conn);
}
}
mysql_set_charset('utf8', $conn);
return $conn;
}
开发者ID:relrod,项目名称:libphutil,代码行数:31,代码来源:AphrontMySQLDatabaseConnection.php
示例3: db_connect
function db_connect($host, $username, $password)
{
if ($r = mysql_connect($host, $username, $password)) {
mysql_set_charset('cp1251', $r);
}
return $r;
}
开发者ID:kktsvetkov,项目名称:1double.com,代码行数:7,代码来源:db_body.inc.php
示例4: OpenConnection
function OpenConnection()
{
global $mysqlAuthentication;
global $sqlserverAuthentication;
$host = null;
$options = null;
if (isset($mysqlAuthentication)) {
$host = $mysqlAuthentication["host"];
$options = $mysqlAuthentication;
}
if ($this->databaseType == 'mySql' || $this->databaseType == 'both') {
$this->mysqlConnection = @mysql_connect($host, $options["username"], $options["password"]);
}
if (isset($this->mysqlConnection)) {
@mysql_set_charset("utf8");
@mysql_select_db($options["database"], $this->mysqlConnection);
}
if (isset($sqlserverAuthentication)) {
$host = $sqlserverAuthentication["host"];
$options = array("Database" => $sqlserverAuthentication["database"], "CharacterSet" => "UTF-8", "UID" => $sqlserverAuthentication["username"], "PWD" => $sqlserverAuthentication["password"]);
}
if ($this->databaseType == 'sqlServer' || $this->databaseType == 'both') {
$this->sqlserverConnection = sqlsrv_connect($host, $options);
}
}
开发者ID:renatosans,项目名称:contratos,代码行数:25,代码来源:DataConnector.php
示例5: save3
public function save3()
{
//获取数据库主机
$host = $_POST['host'];
//获取用户帐号
$user = $_POST['user'];
//获取用户密码
$pass = $_POST['pass'];
//获取数据库名
$name = $_POST['name'];
//获取字段前缀
$prefix = $_POST['prefix'];
$str = "<?php" . "\r\n";
$str .= " define('Sql_type', 'mysql'); //数据库类型" . "\r\n\r\n";
$str .= " define('Sql_host', '{$host}'); //服务器地址" . "\r\n\r\n";
$str .= " define('Sql_name', '{$name}'); //数据库名 " . "\r\n\r\n";
$str .= " define('Sql_user', '{$user}'); //用户名" . "\r\n\r\n";
$str .= " define('Sql_pwd', '{$pass}'); //密码" . "\r\n\r\n";
$str .= " define('Sql_port', '3306'); //端口" . "\r\n\r\n";
$str .= " define('Sql_prefix', '{$prefix}'); //数据库表前缀" . "\r\n\r\n";
$str .= " define('Sql_charset', 'utf8'); //数据库编码默认采用utf8";
file_put_contents(APP_PATH . 'Lib/tm_db.php', $str);
$lnk = @mysql_connect($host, $user, $pass);
mysql_set_charset('utf8');
mysql_query("CREATE DATABASE {$name}");
mysql_query("USE {$name}");
$arr = file_get_contents(APP_PATH . '/Lib/tongmeng.sql');
$res = explode(';', $arr);
foreach ($res as $Res) {
$Sql = $Res . ';';
mysql_query($Sql);
}
$this->display('temp_4');
}
开发者ID:wujunze,项目名称:tongmeng,代码行数:34,代码来源:InstallController.class.php
示例6: connect
function connect()
{
$this->_action = 'connect';
if (false === ($this->_link = @mysql_connect($this->_config['host'], $this->_config['user'], $this->_config['pass']))) {
$this->_throwException();
}
$this->_action = 'select database';
if (false === @mysql_select_db($this->_config['path'], $this->_link)) {
$this->_throwException();
}
if (isset($this->_config['params']['charset'])) {
$this->_action = 'set charset';
$success = false;
if (function_exists('mysql_set_charset')) {
// MySQL 5.0.7 and PHP 5.2.3
$success = @mysql_set_charset($this->_config['params']['charset'], $this->_link);
} else {
$success = @mysql_query('SET NAMES "' . $this->_config['params']['charset'] . '"', $this->_link);
}
if (!$success) {
$this->_throwException();
}
}
return $this;
}
开发者ID:Dim4n,项目名称:Q,代码行数:25,代码来源:QMysql.package.php
示例7: connect
/**
* 连接数据库
* @return resource
*/
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PWD) or die("数据库连接失败Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die("指定数据库打开失败");
return $link;
}
开发者ID:hardihuang,项目名称:zihuaxiang,代码行数:11,代码来源:mysql.func.php
示例8: mcm_open_db
function mcm_open_db()
{
global $mcm;
mysql_connect($mcm['db_server'], $mcm['db_username'], $mcm['db_password']) or die("Unable to connect to database server.\n");
mysql_select_db($mcm['db_database']) or die("Unable to open database.\n");
mysql_set_charset('utf8');
}
开发者ID:jaquer,项目名称:MusicCollectionManagement,代码行数:7,代码来源:mysql.php
示例9: connect
public function connect($host = '', $user = '', $pass = '', $dbname = '', $port = '3066')
{
$this->dbname = $dbname;
if (!$this->con) {
$myconn = @mysql_connect($host . ':' . $port, $user, $pass);
// mysql_connect() with variables defined at the start of Database class
if ($myconn) {
mysql_set_charset('utf8', $myconn);
$this->mysql_link = $myconn;
$seldb = @mysql_select_db($this->dbname, $myconn);
// Credentials have been pass through mysql_connect() now select the database
if ($seldb) {
$this->con = true;
return true;
// Connection has been made return TRUE
} else {
array_push($this->result, mysql_error($this->mysql_link));
return false;
// Problem selecting database return FALSE
}
} else {
array_push($this->result, 'Something unexpected has gone wrong');
return false;
// Problem connecting return FALSE
}
} else {
return true;
// Connection has already been made return TRUE
}
}
开发者ID:rorystandley,项目名称:php-mvc,代码行数:30,代码来源:Database.class.php
示例10: connect
/**
* Created by PhpStorm.
* User: Administrator
* Date: 16-1-19
* Time: 下午9:54
*/
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('数据库连接失败!');
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die('指定数据库打开失败');
return $link;
}
开发者ID:yangchenglong,项目名称:myshop,代码行数:13,代码来源:mysql.func.php
示例11: db_connect
function db_connect($dbhost, $dbname, $dbuser, $dbpass)
{
global $DB_DIE_ON_FAIL, $DB_DEBUG, $CFG;
if (!($dbh = mysql_connect($dbhost, $dbuser, $dbpass))) {
if ($DB_DEBUG) {
echo "<h2>Can't connect to {$dbhost} as {$dbuser}</h2>";
echo "<p><b>MySQL Error</b>: ", mysql_error();
} else {
echo "<h2>Database error encountered</h2>";
}
if ($DB_DIE_ON_FAIL) {
echo "<p>This script cannot continue, terminating.";
echo "<a href=\"./\">Click here</a> to return to the homepage.";
die;
}
}
if (!$CFG->dont_select_db) {
if (!mysql_select_db($dbname)) {
if ($DB_DEBUG) {
echo "<h2>Can't select database {$dbname}</h2>";
echo "<p><b>MySQL Error</b>: ", mysql_error();
} else {
echo "<h2>Database error encountered</h2>";
db_error_mail("{$_SERVER['HTTP_HOST']} DB Select Failed", "Page: {$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}");
}
if ($DB_DIE_ON_FAIL) {
echo "<p>This script cannot continue, terminating.";
echo "<a href=\"./\">Click here</a> to return to the homepage.";
die;
}
}
}
mysql_set_charset('utf8');
return $dbh;
}
开发者ID:MirellJ,项目名称:backstage2,代码行数:35,代码来源:dblib.php
示例12: conectar
function conectar()
{
$li = mysql_connect("localhost", "artes_cotizacion", "Cotizaciones_1209");
mysql_set_charset('utf8');
mysql_select_db("artes01_Cotizaciones", $li) or die("Conexión no hecha");
return $li;
}
开发者ID:nevinsantana,项目名称:principalArtefactosLuminicos,代码行数:7,代码来源:funciones.php
示例13: connecter
/**
* Etablit la connexion à la base de données
* @param array $aErreurs Le tableau contenant les messages d'erreurs rencontrées
*/
function connecter(&$aErreurs)
{
// Connexion
$this->link = @mysql_connect($this->host, $this->login, $this->password);
mysql_select_db($this->database);
mysql_set_charset('utf8', $this->link);
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
// En cas d'erreur
if (!$this->link) {
ajouterErreurDansTableau("Impossible de se connecter à la base de données !", $aErreurs);
if (MODE_DEBUG) {
ajouterErreurDansTableau(' -> ' . mysql_error(), $aErreurs);
}
return false;
}
// Sélection de la base de données
if (!@mysql_select_db($this->database, $this->link)) {
ajouterErreurDansTableau("Impossible de sélectionner la base '" . BD_BASE . "' !", $aErreurs);
if (MODE_DEBUG) {
ajouterErreurDansTableau(' -> ' . mysql_error(), $aErreurs);
}
return false;
}
return true;
}
开发者ID:D3Cnet,项目名称:cuisine,代码行数:29,代码来源:lib_BD.php
示例14: db_conn
function db_conn()
{
require __DIR__ . "/../config/config.php";
$connect = mysql_connect($host, $user, $pass) or die("Ошибка соединения: " . mysql_error());
mysql_set_charset('utf8', $connect);
mysql_select_db($db_name);
}
开发者ID:bottookku,项目名称:botto,代码行数:7,代码来源:db.php
示例15: connect
/**
* Connect to database
* @return resource
*/
function connect()
{
$link = mysql_connect(HOST, USER, PWD) or die("Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DATABASE) or die("Connect MySQL failed!");
return $link;
}
开发者ID:win87,项目名称:homarget2,代码行数:11,代码来源:mysql.func.php
示例16: db_connect
function db_connect($db_host, $db_name, $db_user, $db_pass)
{
$conn = mysql_connect($db_host, $db_user, $db_pass) or die("MySQL-servern är okontaktbar.");
$databas = mysql_select_db($db_name) or die("Databasen {$db_name} fungerar inte.");
mysql_set_charset('utf8', $conn);
return $conn;
}
开发者ID:carriercomm,项目名称:shell-2,代码行数:7,代码来源:db_connect.php
示例17: connect
function connect($zf_host, $zf_user, $zf_password, $zf_database, $zf_pconnect = 'false', $zp_real = false)
{
//@TODO error class required to virtualise & centralise all error reporting/logging/debugging
$this->database = $zf_database;
if ($zf_pconnect != 'false') {
$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
} else {
// pconnect disabled ... leaving it as "connect" here instead of "pconnect"
$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
}
if ($this->link) {
//Check MySQL version and set character_set
$mysql_version = function_exists('mysql_get_server_info') ? @mysql_get_server_info() : '';
if ($mysql_version >= '4.1') {
$character_set_name = 'ujis';
if (function_exists('mysql_set_charset')) {
@mysql_set_charset($character_set_name);
} else {
@mysql_query("set names '" . $character_set_name . "';");
}
}
if (@mysql_select_db($zf_database, $this->link)) {
$this->db_connected = true;
return true;
} else {
$this->set_error(mysql_errno(), mysql_error(), $zp_real);
return false;
}
} else {
$this->set_error(mysql_errno(), mysql_error(), $zp_real);
return false;
}
}
开发者ID:homework-bazaar,项目名称:zencart-sugu,代码行数:33,代码来源:query_factory.php
示例18: db_connect
function db_connect()
{
if (defined('CONN')) {
return;
}
define('CONN', @mysql_pconnect(DBHOST, DBUSER, DBPASS));
$db = @mysql_select_db(DBDATE, CONN);
if (!CONN) {
die('Verbindung nicht möglich, bitte prüfen Sie ihre mySQL Daten wie Passwort, Username und Host<br />');
}
if (!$db) {
die('Kann Datenbank "' . DBDATE . '" nicht benutzen : ' . mysql_error(CONN));
}
if (function_exists('mysql_set_charset') and version_compare(mysql_get_server_info(CONN), '5.0.7') !== -1) {
//Für ältere Installation die init.php nachladen
if (!defined('ILCH_DB_CHARSET') && file_exists('include/includes/init.php')) {
require_once 'include/includes/init.php';
}
mysql_set_charset(ILCH_DB_CHARSET, CONN);
}
$timeZoneSetted = false;
if (function_exists('date_default_timezone_get')) {
$timeZoneSetted = mysql_query('SET time_zone = "' . date_default_timezone_get() . '"');
}
if (!$timeZoneSetted && version_compare(PHP_VERSION, '5.1.3')) {
$timeZoneSetted = mysql_query('SET time_zone = "' . date('P') . '"');
}
}
开发者ID:kveldscholten,项目名称:Ilch-1.1,代码行数:28,代码来源:mysql.php
示例19: getConnectionLocal
public function getConnectionLocal()
{
try {
$ini = parse_ini_file("config.ini", TRUE);
$this->setLoginBanco(base64_decode($ini['local']['usuario']));
$this->setSenhaBanco(base64_decode($ini['local']['senha']));
$this->setServidorBanco(base64_decode($ini['local']['server']));
$this->setPortaBanco(base64_decode($ini['local']['porta']));
$this->setDatabase(base64_decode($ini['local']['database']));
// if(!isset(self::$instance)){
// self::$instance = new PDO('mysql:host=$this->servidor;dbname=$this->database', $this->loginBanco, $this->senhaBanco, array(PDO::MYSQL_ATTR_INIT_COMMAND=>"SET NAMES utf8"));
// self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// self::$instance->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_EMPTY_STRING);
// }
$conecta = mysql_connect($this->servidor, $this->loginBanco, $this->senhaBanco) or die("Erro ao conectar o banco de dados. Especificação técnica: " . mysql_connect_error());
mysql_select_db($this->database, $conecta);
mysql_set_charset('utf8', $conecta);
// $mysql = new mysqli($this->servidor, $this->loginBanco, $this->senhaBanco, $this->database, $this->porta);
// echo "Servidor: ".$this->servidor."\n";
// echo "Usuário: ".$this->loginBanco."\n";
// echo "Senha: ".$this->senhaBanco."\n";
// echo "Database: ".$this->database."\n";
return $conecta;
// return self::$conecta;
// return self::$instance;
} catch (Exception $ex) {
echo "Ocorreu um erro na conexão. Erro: " . $ex->getMessage();
}
}
开发者ID:pereiraMichel,项目名称:mapti,代码行数:29,代码来源:conexao.php
示例20: drawList
private function drawList()
{
$html = '<div style="width:100%;clear:both;float:left;height:40px;"><hr></div><table style="clear:both;float:left;">';
$html .= '<thead><th></th><th>Redigeret</th><th>Tekst</th><th>Søgning</th><th>Aktiv</th><th></th></thead><tbody>';
//mysql_set_charset('Latin1');
//$SQL='select id, changed, substr(content,1,60) as content, target, active from promos';
$SQL = 'select id, changed, content, target, active from promos';
mysql_set_charset('utf8');
$result = $this->query($SQL);
while ($row = mysql_fetch_array($result)) {
$selected = $row['id'] == $this->selected_id ? ' class="selected"' : '';
$html .= '<tr id="' . $row['id'] . '"' . $selected . '>';
$html .= '<td><input type="button" value="Red." style="font-size:11px;" onclick="Promo.edit(' . $row['id'] . ');"/></td>';
$html .= '<td>' . $row['changed'] . '</td>';
$html .= '<td><div style="width:440px;overflow:hidden;white-space:nowrap;text-overflow:ellipsis;">' . strip_tags($row['content']) . '</div></td>';
$html .= '<td>' . $row['target'] . '</td>';
$html .= '<td style="text-align:center;">';
if ($row['active'] == '1') {
$html .= '●';
}
$html .= '</td>';
$html .= '<td><input type="button" value="Slet!" style="font-size:11px;" onclick="Promo.deletePromo(' . $row['id'] . ');"/></td>';
$html .= '</tr>';
}
$html .= '</tbody></table>';
echo $html;
}
开发者ID:davidkonrad,项目名称:allearter,代码行数:27,代码来源:ajax_promo.php
注:本文中的mysql_set_charset函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论