本文整理汇总了PHP中mysql_errno函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_errno函数的具体用法？PHP mysql_errno怎么用？PHP mysql_errno使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_errno函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: delete
public function delete()
{
if (!empty($_POST['del'])) {
// Nuke departments..
mysql_query("DELETE FROM `" . DB_PREFIX . "departments`\n WHERE `id` IN(" . implode(',', $_POST['del']) . ")\n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
$rows = mysql_affected_rows();
// Nuke user department association..
mysql_query("DELETE FROM `" . DB_PREFIX . "userdepts`\n WHERE `deptID` IN(" . implode(',', $_POST['del']) . ")\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
if (mswRowCount('departments') == 0) {
@mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "departments`");
}
if (mswRowCount('userdepts') == 0) {
@mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "userdepts`");
}
// Rebuild order sequence..
$seq = 0;
$q = mysql_query("SELECT `id` FROM `" . DB_PREFIX . "departments` ORDER BY `orderBy`");
while ($RB = mysql_fetch_object($q)) {
$n = ++$seq;
mysql_query("UPDATE `" . DB_PREFIX . "departments` SET\n\t `orderBy` = '{$n}'\n WHERE `id` = '{$RB->id}'\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
}
return $rows;
}
return '0';
}示例2: connect
/**
* 连接数据库方法
* @access public
* @throws ThinkExecption
*/
public function connect($config = '', $linkNum = 0, $force = false)
{
if (!isset($this->linkID[$linkNum])) {
if (empty($config)) {
$config = $this->config;
}
// 处理不带端口号的socket连接情况
$host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
// 是否长连接
$pconnect = !empty($config['params']['persist']) ? $config['params']['persist'] : $this->pconnect;
if ($pconnect) {
$this->linkID[$linkNum] = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS);
} else {
$this->linkID[$linkNum] = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS);
}
if (!$this->linkID[$linkNum] || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum]) || C('SPARE_DB_DEBUG')) {
$errStr = mysql_error();
$errno = mysql_errno();
if ($errno == 13047 || C('SPARE_DB_DEBUG')) {
if (C('SMS_ALERT_ON')) {
Sms::send('mysql超额被禁用,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
}
//[sae]启动备用数据库
if (C('SPARE_DB_HOST')) {
$this->linkID[$linkNum] = mysql_connect(C('SPARE_DB_HOST') . (C('SPARE_DB_PORT') ? ':' . C('SPARE_DB_PORT') : ''), C('SPARE_DB_USER'), C('SPARE_DB_PWD'), true, CLIENT_MULTI_RESULTS);
if (!$this->linkID[$linkNum]) {
throw_exception('备用数据库连接失败');
}
mysql_select_db(C('SPARE_DB_NAME'), $this->linkID[$linkNum]);
//标记使用备用数据库状态
$this->is_spare = true;
} else {
throw_exception($errStr);
}
} else {
//[sae] 短信预警
if (C('SMS_ALERT_ON')) {
Sms::send('数据库连接时出错,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
}
throw_exception($errStr);
}
}
$dbVersion = mysql_get_server_info($this->linkID[$linkNum]);
if ($dbVersion >= '4.1') {
//使用UTF8存取数据库 需要mysql 4.1.0以上支持
mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID[$linkNum]);
}
//设置 sql_model
if ($dbVersion > '5.0.1') {
mysql_query("SET sql_mode=''", $this->linkID[$linkNum]);
}
// 标记连接成功
$this->connected = true;
// 注销数据库连接配置信息
if (1 != C('DB_DEPLOY_TYPE')) {
unset($this->config);
}
}
return $this->linkID[$linkNum];
}示例3: select
function select($sql)
{
//Para MYSQL
switch ($_SESSION["gestor"]) {
case 'MYSQL':
$result = mysql_query($sql,$this->conn);
if(!$result)
{
$this->message = mysql_error() . "\n";
$this->message .= mysql_errno();
//die($message);
}
else
{
//$data=$this->obtener_datos($result);
return $result;
}
break;
case 'POSTGRE':
$result = pg_query($this->conn,$sql);
if(!$result)
{
$message = 'Invalid query: ' . pg_last_error() . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
else
{
//$data=$this->obtener_datos($result);
return $result;
}
break;
}
} 示例4: query
function query($sql, $unbuffered = false)
{
if (defined('PUN_SHOW_QUERIES')) {
$q_start = get_microtime();
}
if ($unbuffered) {
$this->query_result = @mysql_unbuffered_query($sql, $this->link_id);
} else {
$this->query_result = @mysql_query($sql, $this->link_id);
}
if ($this->query_result) {
if (defined('PUN_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('PUN_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, 0);
}
$this->error_no = @mysql_errno($this->link_id);
$this->error_msg = @mysql_error($this->link_id);
return false;
}
}示例5: query
public function query($sql)
{
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit;
}
}示例6: __construct
public function __construct()
{
// attempt to connect
if (!($this->db = !$_SERVER['tracker']['db_persist'] ? mysql_connect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass']) : mysql_pconnect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass'])) or !mysql_select_db($_SERVER['tracker']['db_name'], $this->db)) {
tracker_error(mysql_errno($this->db) . ' - ' . mysql_error($this->db));
}
}示例7: query
/**
* Performs an SQL query.
*
* @param string $query
* @param mixed $limit
* @param boolean $warnOnFailure
* @param boolean $tablesAlreadyCreated
* @access public
*/
function query($query, $limit = false, $warnOnFailure = true, $tablesAlreadyCreated = false)
{
if ($this->isManip($query)) {
if (!$tablesAlreadyCreated) {
$query = $this->_replaceTableNames($query);
}
if (isset($this->result) && is_resource($this->result)) {
@mysql_free_result($this->result);
}
if ($this->config['debug_level'] > 1) {
$this->debugQuery($query);
}
$this->result = @mysql_query($query, $this->connection);
if (!$this->result) {
$throwError = $warnOnFailure ? true : false;
if (!$tablesAlreadyCreated && mysql_errno($this->connection) == 1146) {
$this->_createNewTables();
$this->query($query, $limit, $warnOnFailure, true);
$throwError = false;
}
if ($throwError) {
phpOpenTracker::handleError(@mysql_error($this->connection), E_USER_ERROR);
}
}
} else {
$query = $this->_rewriteSelectQuery($query);
if ($limit != false) {
$query .= ' LIMIT ' . $limit;
}
parent::query($query);
}
}示例8: insertToDB
public static function insertToDB($paramosPriemone, $nuo, $iki, $paraiskuKiekis)
{
$paramosPriemone = repairSqlInjection($paramosPriemone);
$nuo = repairSqlInjection($nuo);
$iki = repairSqlInjection($iki);
$paraiskuKiekis = repairSqlInjection($paraiskuKiekis);
if (!ParamosKiekiaiValidation::validateParamosPriemone($paramosPriemone)) {
ParamosKiekiai::$error = "Neteisingas priemones formatas formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateNuo($nuo)) {
ParamosKiekiai::$error = "Neteisingas datos Nuo formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateIki($iki)) {
ParamosKiekiai::$error = "Neteisingas datos Iki formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateParaiskuKiekis($paraiskuKiekis)) {
ParamosKiekiai::$error = "Neteisingas paraisku kiekio formatas!";
return false;
}
$result = mysql_query("INSERT INTO `PPOS`.`ParamosKiekiai` (`idParamosKiekiai`, `ParamosPriemone`, `Nuo`, `Iki`, `ParaiskuKiekis`) \n VALUES (null, '" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')");
if (!$result) {
if (mysql_errno() != 1062) {
ErrorMessages::setError(7, "insertToDB('" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')", "ParamosKiekiai.php", "ParamosKiekiai", mysql_error());
}
ParamosKiekiai::$error = mysql_error();
return false;
} else {
return true;
}
}示例9: query
function query($query)
{
global $notify;
$query_lower = strtolower($query);
if (strpos($query_lower, 'union') > 0) {
die('UNION statements are now allowed in database queries.');
return;
}
// query runtime start
$start = microtime(true);
// Tries to query
if ($result = mysql_query($query, $this->connection)) {
// Successfully
$this->count_successfully++;
$this->last_query = $query;
// debug output
global $debug;
$debug->add('db::query', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)');
$this->query_time_sum += microtime(true) - $start;
return $result;
} else {
// something goes wrong, raise an error
$this->count_failed++;
die('
<h1>Error: ' . 'mysql:query ' . mysql_errno($this->connection) . '</h1>
<p>' . mysql_error($this->connection) . '<br />' . $query . '</p>');
// debug output
global $debug;
$debug->add('db::query (failed)', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)');
$this->query_time_sum += microtime(true) - $start;
}
}示例10: getDatabaseConnection
/**
* return a mysqli object for database access
*/
function getDatabaseConnection()
{
$dbconfig = new configReader("db.config");
$mysqli = new mysqli($dbconfig->config->host, $dbconfig->config->username, $dbconfig->config->password, $dbconfig->config->dbname);
echo mysql_errno();
return $mysqli;
}示例11: 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;
}示例12: tabledump
function tabledump($result)
{
if ($result == 0) {
echo "<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>";
} else {
if (@mysql_num_rows($result) == 0) {
echo "<b>Query completed. Empty result.</b><br>";
} else {
$nf = mysql_num_fields($result);
$nr = mysql_num_rows($result);
echo "<table border='1'> <thead>";
echo "<tr>";
for ($i = 0; $i < $nf; $i++) {
echo "<th>" . mysql_field_name($result, $i) . "</th>";
}
echo "</tr>";
echo "</thead><tbody>";
for ($i = 0; $i < $nr; $i++) {
echo "<tr>";
$row = mysql_fetch_array($result);
for ($j = 0; $j < $nf; $j++) {
echo "<td>" . $row[$j] . "</td>";
}
echo "</tr>";
}
echo "</tbody></table>";
}
}
return $row;
}示例13: 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;
}示例14: writeToDestination
function writeToDestination($data)
{
$sqlInsertStatement = "INSERT INTO TILLEGG (TI_ID, TI_SAID, TI_JPID, TI_DOKID, TI_DOKVER, TI_VARIANT, TI_RNR, TI_ITYPE, TI_TGKODE, TI_TGGRUPPE, TI_REGDATO, \nTI_REGAV, TI_PVGAV, TI_TEKST) VALUES (";
$sqlInsertStatement .= "'" . $data->TI_ID . "',";
$sqlInsertStatement .= "'" . $data->TI_SAID . "',";
$sqlInsertStatement .= "'" . $data->TI_JPID . "',";
$sqlInsertStatement .= "'" . $data->TI_DOKID . "',";
$sqlInsertStatement .= "'" . $data->TI_DOKVER . "',";
$sqlInsertStatement .= "'" . $data->TI_VARIANT . "',";
$sqlInsertStatement .= "'" . $data->TI_RNR . "',";
$sqlInsertStatement .= "'" . $data->TI_ITYPE . "',";
$sqlInsertStatement .= "'" . $data->TI_TGKODE . "',";
$sqlInsertStatement .= "'" . $data->TI_TGGRUPPE . "',";
$sqlInsertStatement .= "'" . $data->TI_REGDATO . "',";
$sqlInsertStatement .= "'" . $data->TI_REGAV . "',";
$sqlInsertStatement .= "'" . $data->TI_PVGAV . "',";
$sqlInsertStatement .= "'" . $data->TI_TEKST . "'";
$sqlInsertStatement .= ");";
$this->uttrekksBase->printErrorIfDuplicateFail = false;
if ($this->uttrekksBase->executeStatement($sqlInsertStatement) == false) {
// 1062 == duplicate key. Scary to hardcode, but can't find mysql constants somewhere
if (mysql_errno() == Constants::MY_SQL_DUPLICATE) {
// This table is know to contain duplicates. We just log and continue
$this->logger->log($this->XMLfilename, "Duplicate values on PK detected. This is probably not an error in ESA but more a problem with the extraction code not being able to convert løpenummer to journalpostnummer TI_ID(" . $data->TI_ID . "), TI_TEKST(" . $data->TI_TEKST . ")", Constants::LOG_ERROR);
}
}
$this->uttrekksBase->printErrorIfDuplicateFail = true;
}示例15: _mysql
/**
* 数据库处理函数
* @param $query mysql处理语句
* @param $kind 处理类型
* @return 如果$kind等于count，则返回符合语句的条数
* @return 如果$kind等于search，则返回符合语句的二维数组，第一维代表第几个符合，第二维为数据库信息，键为数据库表名
* @return 如果$kind等于其他，如果操作成功则返回大于零的数，否则返回零
*/
function _mysql($query, $kind)
{
/*
此处有配置
*/
$conn = @mysql_connect($host, $user, $password) or die('数据库链接失败:' . mysql_errno());
@mysql_select_db($name) or die('数据库错误：' . mysql_errno());
@mysql_query('SET NAMES UTF8') or die('字符集错误：' . mysql_errno());
$result = mysql_query($query, $conn);
if ($kind == 'count') {
$many = mysql_num_rows($result);
mysql_close();
return $many;
} elseif ($kind == 'search') {
$arRow = array();
$i = 0;
while (!!($row = mysql_fetch_array($result))) {
$arRow[$i] = $row;
$i++;
}
mysql_close();
return $arRow;
} else {
mysql_close();
return $result;
}
}