本文整理汇总了PHP中mysql_close函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_close函数的具体用法?PHP mysql_close怎么用?PHP mysql_close使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_close函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: close
public function close()
{
if ($this->opened) {
$this->opened = false;
@mysql_close($this->conn);
}
}
开发者ID:diandengs,项目名称:RechoPHP,代码行数:7,代码来源:class.Db.php
示例2: disconnect
function disconnect()
{
if (!empty($this->db)) {
mysql_close($this->db);
$this->db = null;
}
}
开发者ID:Spark-Eleven,项目名称:revive-adserver,代码行数:7,代码来源:BucketDb_MySQL.php
示例3: getTangentText
function getTangentText($type, $keyword)
{
global $dbHost, $dbUser, $dbPassword, $dbName;
$link = @mysql_connect($dbHost, $dbUser, $dbPassword);
if (!$link) {
die("Cannot connect : " . mysql_error());
}
if (!@mysql_select_db($dbName, $link)) {
die("Cannot find database : " . mysql_error());
}
$result = mysql_query("SELECT sr_keywords, sr_text FROM soRandom WHERE sr_type = '" . $type . "' ORDER BY sr_ID ASC;", $link);
$tempCounter = 0;
while ($row = mysql_fetch_assoc($result)) {
$pKey = "/" . $keyword . "/";
$pos = preg_match($pKey, $row['sr_keywords']);
//echo $pos . " is pos<br>";
//echo $keyword;
//echo " is keyword and this is the search return: " . $row['keywords'];
if ($pos != 0) {
$text[$tempCounter] = stripslashes($row["sr_text"]);
$tempCounter++;
}
}
mysql_close($link);
//$text=htmlentities($text);
return $text;
}
开发者ID:ui-libraries,项目名称:TIRW,代码行数:27,代码来源:includes.php
示例4: getInsert
function getInsert($param, $name, $score)
{
$dbParams = get_object_vars($param);
$mysql_host = $dbParams['mysql_host'];
$mysql_user = $dbParams['mysql_user'];
$mysql_pass = $dbParams['mysql_pass'];
$dbName = $dbParams['dbName'];
$dbTable = $dbParams['dbTable'];
//connect
$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die('connection error: ' . mysql_error());
//select db
mysql_select_db($dbName) or die('DB error');
//check user highest score
$query_check_user = 'SELECT score FROM ' . $dbTable . ' WHERE name = ' . $name . ';';
$result_check_user = mysql_query($query_check_user) or die('Request down: ' . mysql_error());
$checkUser = mysql_fetch_array($result_check_user);
if ($checkUser['score'] < $score) {
//inserting new scores
$query_insert = 'INSERT INTO ' . $dbTable . '(name,score) VALUES (' . $name . ',' . $score . ') ON DUPLICATE KEY UPDATE score = VALUES(score);';
$result = mysql_query($query_insert) or die('Request insert down: ' . mysql_error());
}
return $result;
// clean
if (isset($result)) {
mysql_free_result($result);
}
// close
mysql_close($link);
}
开发者ID:queridoamigo,项目名称:querido-amigo,代码行数:29,代码来源:functions.php
示例5: HackingLog
function HackingLog()
{
echo "You're not allowed to use this program! This attempted violation has been logged and your IP address was captured.";
Warehouse('footer');
if ($_SERVER['HTTP_X_FORWARDED_FOR']) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
if ($openSISNotifyAddress) {
mail($openSISNotifyAddress, 'HACKING ATTEMPT', "INSERT INTO HACKING_LOG (HOST_NAME,IP_ADDRESS,LOGIN_DATE,VERSION,PHP_SELF,DOCUMENT_ROOT,SCRIPT_NAME,MODNAME,USERNAME) values('{$_SERVER['SERVER_NAME']}','{$ip}','" . date('Y-m-d') . "','{$openSISVersion}','{$_SERVER['PHP_SELF']}','{$_SERVER['DOCUMENT_ROOT']}','{$_SERVER['SCRIPT_NAME']}','{$_REQUEST['modname']}','" . User('USERNAME') . "')");
}
/*if($openSISNotifyAddress)
mail($openSISNotifyAddress,'HACKING ATTEMPT',"INSERT INTO HACKING_LOG (HOST_NAME,IP_ADDRESS,LOGIN_DATE,VERSION,PHP_SELF,DOCUMENT_ROOT,SCRIPT_NAME,MODNAME,USERNAME) values('$_SERVER[SERVER_NAME]','$_SERVER[REMOTE_ADDR]','".date('Y-m-d')."','$openSISVersion','$_SERVER[PHP_SELF]','$_SERVER[DOCUMENT_ROOT]','$_SERVER[SCRIPT_NAME]','$_REQUEST[modname]','".User('USERNAME')."')");*/
if (false && function_exists('mysql_query')) {
if ($_SERVER['HTTP_X_FORWARDED_FOR']) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
$link = @mysql_connect('os4ed.com', 'openSIS_log', 'openSIS_log');
@mysql_select_db('openSIS_log');
@mysql_query("INSERT INTO HACKING_LOG (HOST_NAME,IP_ADDRESS,LOGIN_DATE,VERSION,PHP_SELF,DOCUMENT_ROOT,SCRIPT_NAME,MODNAME,USERNAME) values('{$_SERVER['SERVER_NAME']}','{$ip}','" . date('Y-m-d') . "','{$openSISVersion}','{$_SERVER['PHP_SELF']}','{$_SERVER['DOCUMENT_ROOT']}','{$_SERVER['SCRIPT_NAME']}','{$_REQUEST['modname']}','" . User('USERNAME') . "')");
@mysql_close($link);
/*$link = @mysql_connect('os4ed.com','openSIS_log','openSIS_log');
@mysql_select_db('openSIS_log');
@mysql_query("INSERT INTO HACKING_LOG (HOST_NAME,IP_ADDRESS,LOGIN_DATE,VERSION,PHP_SELF,DOCUMENT_ROOT,SCRIPT_NAME,MODNAME,USERNAME) values('$_SERVER[SERVER_NAME]','$_SERVER[REMOTE_ADDR]','".date('Y-m-d')."','$openSISVersion','$_SERVER[PHP_SELF]','$_SERVER[DOCUMENT_ROOT]','$_SERVER[SCRIPT_NAME]','$_REQUEST[modname]','".User('USERNAME')."')");
@mysql_close($link);*/
}
}
开发者ID:26746647,项目名称:Belize-openSIS,代码行数:30,代码来源:HackingLog.php
示例6: disconnect
public function disconnect()
{
if ($this->_link) {
@mysql_close($this->_link);
}
$this->_link = false;
}
开发者ID:yiuked,项目名称:tmcart,代码行数:7,代码来源:DbMySQL.php
示例7: close
function close()
{
if (is_resource($this->_conn)) {
mysql_close($this->_conn);
}
parent::_clear();
}
开发者ID:BGCX262,项目名称:zys-blog-svn-to-git,代码行数:7,代码来源:mysql.php
示例8: TearDown
protected function TearDown()
{
// Drop database if needed
mysql_query('DROP DATABASE IF EXISTS ' . WF_SQL_BASE) or die(__FILE__ . ':' . __LINE__ . ':' . mysql_error());
// Close connection
mysql_close() or die(__FILE__ . ':' . __LINE__ . ':' . mysql_error());
}
开发者ID:lopacinski,项目名称:WebFinance,代码行数:7,代码来源:WebfinanceMantisTest.php
示例9: disconnect
public function disconnect()
{
if (isset($this->link)) {
mysql_close($this->link);
unset($this->link);
}
}
开发者ID:Zhiming,项目名称:PHP,代码行数:7,代码来源:db.php
示例10: delete_article_by_alias
public function delete_article_by_alias($alias)
{
include "../db_connect.php";
$query = "DELETE FROM `articles` WHERE `alias` = '" . $alias . "' ";
$result = mysql_query($query);
mysql_close($link);
}
开发者ID:beholder17,项目名称:ls.files,代码行数:7,代码来源:_class.articles.php
示例11: QUERY_SYSLOGS
function QUERY_SYSLOGS($sql)
{
$database = "syslogs";
$bd = @mysql_connect(":/var/run/syslogdb.sock", "root", null);
if (!$bd) {
echo "Connect failed\n";
return false;
}
$ok = @mysql_select_db($database, $bd);
if (!$ok) {
$errnum = @mysql_errno($bd);
$des = @mysql_error($bd);
echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n";
return false;
}
$results = mysql_query($sql, $bd);
if (!$results) {
$errnum = @mysql_errno($bd);
$des = @mysql_error($bd);
echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n";
return false;
@mysql_close($bd);
}
@mysql_close($bd);
return $results;
}
开发者ID:BillTheBest,项目名称:1.6.x,代码行数:26,代码来源:exec.purge.syslogdb.php
示例12: closedb
function closedb()
{
global $conn;
if ($conn) {
mysql_close($conn);
}
}
开发者ID:shiqianrongsx,项目名称:keytest,代码行数:7,代码来源:db.php
示例13: __destruct
/**
* Clos automatiquement la connexion MySQL.
*/
public function __destruct()
{
if ($this->connectionId) {
mysql_close($this->connectionId);
}
$this->connectionId = false;
}
开发者ID:BalamWeb,项目名称:ccv4,代码行数:10,代码来源:MySQLConnection.php
示例14: closeCon
/** 关闭连接,没有返回值 */
function closeCon()
{
if ($this->isCon) {
mysql_close($this->link);
$this->isCon = false;
}
}
开发者ID:Hank-wood,项目名称:meizizhi,代码行数:8,代码来源:MySQL.php
示例15: add_message
function add_message($locale, $groupid, $message)
{
global $mysqlprefix;
$link = connect();
perform_query("insert into {$mysqlprefix}chatresponses (locale,groupid,vcvalue) values ('" . mysql_real_escape_string($locale, $link) . "'," . ($groupid ? intval($groupid) . ", " : "null, ") . "'" . mysql_real_escape_string($message, $link) . "')", $link);
mysql_close($link);
}
开发者ID:kuell,项目名称:chat,代码行数:7,代码来源:cannededit.php
示例16: _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;
}
}
开发者ID:kang1022,项目名称:block,代码行数:35,代码来源:fun.inc.php
示例17: close_connection
/**
* close_connection();
*/
public function close_connection()
{
if (is_resource($this->_connection) or is_object($this->_connection)) {
mysql_close($this->_connection);
unset($this->_connection);
}
}
开发者ID:rampmaster,项目名称:XG-Proyect-v3.x.x,代码行数:10,代码来源:Database+-+orig.php
示例18: connetti_query
function connetti_query($query)
{
global $Host, $User, $Password, $Database, $link;
$ConfigManager = new ConfigManager();
$Host = $ConfigManager->getHost();
$User = $ConfigManager->getUser();
$Database = $ConfigManager->getDatabase();
$Password = $ConfigManager->getPassword();
// Connessione al database
if (!($link = mysql_connect($Host, $User, $Password))) {
die("Errore nella connessione al database! -> " . mysql_error());
}
// Apertura del database
if (!mysql_select_db($Database, $link)) {
die("Errore nell'apertura del database mba!" . mysql_error());
}
// Esucuzione della query
if (!($result = mysql_query($query, $link))) {
print "Errore nell'esecuzione della query! <br />";
die(mysql_error());
}
//chiusura del collegamento al database
mysql_close($link);
//restituzione all'ambiente chiamante del risultato della query
return $result;
}
开发者ID:sergiobelli,项目名称:geso,代码行数:26,代码来源:dblib.php
示例19: MainFunc
function MainFunc($path, $db_host, $db_user, $db_pass, $db_name)
{
if (!$path || $path == "") {
echo "error";
exit(0);
}
$db_host = "10.10.43.142";
$Conn = mysql_connect($db_host, $db_user, $db_pass);
mysql_query("SET NAMES 'GBK'");
$network_flag = 0;
if ($db_name == "LogFree") {
$network_flag = 1;
}
if ($db_name == "LogFree_WAN") {
$network_flag = 2;
}
mysql_select_db("LogFree", $Conn);
$qs = "delete from tbl_last_action_time";
mysql_query($qs);
$qs = "insert into tbl_last_action_time set lat_dtDateTime = now()";
mysql_query($qs);
process_all_info("{$path}/gac");
process_all_info("{$path}/gas");
process_all_server_common("{$path}/gas", $network_flag);
process_all_client_guid("{$path}/gas");
process_all_client_common("{$path}/gac", $network_flag);
$qs = "update tbl_client_log_common set happened_time = now() where happened_time > now()";
mysql_query($qs);
mysql_close();
}
开发者ID:svn2github,项目名称:ybtx,代码行数:30,代码来源:MainFunc.php
示例20: insert_hasher
function insert_hasher()
{
include 'configdb.php';
include 'opendb.php';
$hash_name = $_POST['hash_name'];
$insert = "INSERT INTO hashers set " . ($insert .= "hash_name = '" . $hash_name . "'");
$insert .= ",first_name = '" . $_POST['first_name'] . "'";
$insert .= ",last_name = '" . $_POST['last_name'] . "'";
$insert .= ",password = '" . $_POST['password'] . "'";
$insert .= ",email_address = '" . $_POST['email_address'] . "'";
$insert .= ",address = '" . $_POST['address'] . "'";
$insert .= ",active = '" . $_POST['active'] . "'";
$insert .= ",home_phone = '" . $_POST['home_phone'] . "'";
$insert .= ",work_phone = '" . $_POST['work_phone'] . "'";
$insert .= ",comments = '" . $_POST['comments'] . "'";
$insert .= ",hide_address = '" . $_POST['hide_address'] . "'";
$insert .= ",mother_hash = '" . $_POST['mother_hash'] . "'";
$insert .= ",T_shirt_size = '" . $_POST['T_shirt_size'] . "'";
$insert .= ",country = '" . $_POST['country'] . "'";
$insert .= ",food_choice = '" . $_POST['food_choice'] . "' ";
$result = mysql_query($insert);
if ($result) {
echo "<center><h2>Hasher {$hash_name} was added successfully</h2></center><p>";
} else {
echo "<center><h2>Sorry, there was an error adding hasher - {$hash_name}!<br>";
echo "Please make sure the hasher doesn't already exist in the database.</h2></center>";
echo "The insert statement was .... {$insert}<p>";
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
echo "The error was {$MYSQL_ERRNO} ... {$MYSQL_ERROR}<br>";
}
mysql_close();
}
开发者ID:normwheatley,项目名称:progs-php,代码行数:33,代码来源:add_yourself.php
注:本文中的mysql_close函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论