本文整理汇总了PHP中odbc_close函数的典型用法代码示例。如果您正苦于以下问题：PHP odbc_close函数的具体用法？PHP odbc_close怎么用？PHP odbc_close使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了odbc_close函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: changeUserPassword
public function changeUserPassword($userName, $userOldPassword, $userNewPassword, $portalID)
{
VDSN;
$conn = odbc_connect(VDSN, USER, PW) or die('ODBC Error:: ' . odbc_error() . ' :: ' . odbc_errormsg() . ' :: ' . VDSN);
//test for user name
if ($conn) {
$sql = "SELECT '1' outputFlag FROM Portal_User WHERE User_Name = '" . $userName . "' AND Portal_ID = '" . $portalID . "'";
$rs = odbc_exec($conn, $sql);
$row = odbc_fetch_row($rs);
if ($row == null) {
odbc_close($conn);
return "You have entered an invalid user name; please try again.";
}
}
//test for password
if ($conn) {
$sql = "SELECT '1' FROM Users WHERE User_Name = '" . $userName . "' AND User_Password = '" . $userOldPassword . "'";
$rs = odbc_exec($conn, $sql);
$row = odbc_fetch_row($rs);
if ($row == null) {
odbc_close($conn);
return "You have entered an invalid password for your account; please try again.";
}
}
//save new password
if ($conn) {
$sql = "UPDATE Users SET User_Password = '" . $userNewPassword . "' WHERE User_Name = '" . $userName . "'";
$rs = odbc_exec($conn, $sql);
}
return "OK";
}示例2: sql_close
function sql_close()
{
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;
if ($this->db_connect_id) {
if ($this->query_result) {
@odbc_free_result($this->query_result);
}
$result = @odbc_close($this->db_connect_id);
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$this->sql_time += $endtime - $starttime;
return $result;
} else {
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$this->sql_time += $endtime - $starttime;
return false;
}
}示例3: updateSF
/**
* PHP Template.
*/
function updateSF($tableName, $rowID, $sfID)
{
$odbc = odbcConnect();
$stmt = odbc_prepare($odbc, "INSERT into SalesForceUpdateQueue (creationDate, mysqlTableName, mysqlRowID, salesForceID) VALUES(CURRENT_TIMESTAMP(), ?, ?, ?)");
$rs = odbc_execute($stmt, array($tableName, $rowID, $sfID));
odbc_close($odbc);
}示例4: sql_close
function sql_close()
{
if($this->db_connect_id)
{
if( $this->in_transaction )
{
@odbc_commit($this->db_connect_id);
}
if( count($this->result_rowset) )
{
unset($this->result_rowset);
unset($this->field_names);
unset($this->field_types);
unset($this->num_rows);
unset($this->current_row);
}
return @odbc_close($this->db_connect_id);
}
else
{
return false;
}
}示例5: head_cus
function head_cus($customer_no)
{
$link = Fconectar();
if ($link) {
// Se define la consulta que va a ejecutarse, como en sql
$sql_datos_cus = "\n\t\t\t\t\tSELECT C.par_cus_no, C.cus_no, C.cus_name, V1.slspsn_name AS Vendedor, V2.slspsn_name AS Cobrador, C.ar_terms_cd \n\t\t\t\t\tFROM\n\t\t\t\t\tARCUSFIL_SQL AS C,\n\t\t\t\t\tARSLMFIL_SQL AS V1,\n\t\t\t\t\tARSLMFIL_SQL AS V2\n\t\t\t\t\tWHERE\n\t\t\t\t\tC.slspsn_no = V1.slspsn_no AND\n\t\t\t\t\tC.collector = V2.slspsn_no AND\n\t\t\t\t\tC.cus_no = '{$customer_no}'\n\t\t\t\t";
// Se ejecuta la consulta y se guardan los resultados
$results = odbc_exec($link, $sql_datos_cus) or die("Error en instruccion SQL {$sql_datos_cus}");
$existe = odbc_num_rows($results);
if ($existe) {
$registro = odbc_fetch_array($results);
$head_cus_no = $registro['cus_no'];
$head_cus_name = $registro['cus_name'];
$head_ar_terms_cd = $registro['ar_terms_cd'];
$head_slspsn_name = $registro['Vendedor'];
$head_collector = $registro['Cobrador'];
} else {
$mensaje = "No existen registros!";
}
} else {
Ferror("No se pudo establecer coneccion con la Base de Datos!");
}
// Se cierra la conexión
odbc_close($link);
echo "\n\t\t<div align='center'>\n\t\t<table width='40%' border='3' cellpadding='0' cellspacing='10' bordercolor='#DCF3A4' align='center'>\n\t\t\t<th colspan='2'>EDADES DE CARTERA POR CLIENTE (Datos hasta: " . date('d-m-Y') . ")</th>\t\n\t\t\t<tr>\n\t\t\t\t<td>Cliente:</td>\n\t\t\t\t<td>(" . number_format($head_cus_no, 0, '', '') . ") - {$head_cus_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Vendedor:</td>\n\t\t\t\t<td>{$head_slspsn_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Cobrador:</td>\n\t\t\t\t<td>{$head_collector}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Condición de Pago:</td>\n\t\t\t\t<td>{$head_ar_terms_cd}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='center'>Generado: " . date('d-m-Y H:i:s') . "</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</div>\n\t\t";
}示例6: sql_close
function sql_close()
{
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;
if ($this->db_connect_id) {
if ($this->in_transaction) {
@odbc_commit($this->db_connect_id);
}
if (count($this->result_rowset)) {
unset($this->result_rowset);
unset($this->field_names);
unset($this->field_types);
unset($this->num_rows);
unset($this->current_row);
}
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$this->sql_time += $endtime - $starttime;
return @odbc_close($this->db_connect_id);
} else {
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$this->sql_time += $endtime - $starttime;
return false;
}
}示例7: db_close
function db_close($conn)
{
if (odbc_close($conn)) {
return true;
} else {
return false;
}
}示例8: close
public function close()
{
$this->transactionDepth = 0;
$this->transactionRolledBack = false;
if ($this->conn !== false) {
$cn = $this->conn;
$this->conn = false;
odbc_close($cn);
}
}示例9: Disconnect
/**
* @return bool
*/
function Disconnect()
{
if ($this->_conectionHandle) {
$this->FreeResult();
@odbc_close($this->_conectionHandle);
$this->_conectionHandle = null;
return true;
} else {
return false;
}
}示例10: __destruct
public function __destruct()
{
if ($this->activeTransaction) {
if ($this->autoCommit) {
$this->transactionCommit();
} else {
$this->transactionRollback();
}
}
@odbc_close($this->connection);
}示例11: sql_close
function sql_close()
{
if ($this->db_connect_id) {
if ($this->query_result) {
@odbc_free_result($this->query_result);
}
$result = @odbc_close($this->db_connect_id);
return $result;
} else {
return false;
}
}示例12: index
public function index()
{
//test the dynamic connection with other databases seems successfull
$systems = System::all();
$res = [];
foreach ($systems as $system) {
$query = "SELECT [states].eq_id, [states].time, [states].[state_OK],[states].[state_MaintRQ], [states].[state_InMaint], [states].[state_Fault], [equipment].eq_id, CAST(CAST([equipment].eq_name AS VARBINARY) AS VARCHAR) as eq_name FROM [states] LEFT JOIN [equipment] on states.eq_id = [equipment].eq_id";
if ($system['dbversion'] == '2000') {
$port = '1434';
try {
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=" . $system['host'] . "," . $port . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass']));
} catch (ErrorException $e) {
$system->status = 'default';
$system->save();
$res[$system['name']] = ['error' => $e];
}
if ($conn) {
$results = odbc_exec($connection, $query);
$realData = [];
$i = 0;
while ($row = json_decode(json_encode(odbc_fetch_object($results)), true)) {
foreach ($row as $key => $item) {
if ($key == "eq_name" && is_string($item)) {
$row[$key] = iconv('UCS-2LE', 'UTF-8', $item);
}
}
$realData[$i] = $row;
$i++;
}
$res[$system['name']] = $realData;
odbc_free_result($results);
odbc_close($connection);
}
} else {
try {
$conn = new PDO("sqlsrv:Server=" . $system['host'] . ";Database=" . $system['dbname'], $system['dbuser'], Crypt::decrypt($system['dbuserpass']));
} catch (PDOException $e) {
$system->status = 'default';
$system->save();
$res[$system['name']] = ['error' => $e];
}
if ($conn) {
$sql = $conn->prepare($query);
$sql->execute();
$res[$system['name']] = $sql->fetchAll();
$conn = null;
}
}
}
return $res;
}示例13: db_close
function db_close($link = NULL)
{
db_link(false);
/* close db link */
switch (DATABASE) {
case 'mysql':
return mysql_close($link);
case 'mysqli':
return mysqli_close($link);
case 'sqlserver':
odbc_close($link);
return false;
}
}示例14: odbc_fila
function odbc_fila($sql, $fila)
{
$cnn_odbc = odbc_connect("ctw", "", "");
$rs = odbc_exec($cnn_odbc, $sql);
$value = "NO_EXISTE";
$value = odbc_fetch_array($rs, 1);
odbc_free_result($rs);
odbc_close($cnn_odbc);
//if(!$rs){
// return odbc_error($rs);
//} else {
return $value[$fila];
//}
}示例15: Disconnect
/**
* @return bool
*/
function Disconnect()
{
if ($this->_conectionHandle) {
if ($this->_resultId) {
@odbc_free_result($this->_resultId);
$this->_resultId = null;
}
@odbc_close($this->_conectionHandle);
$this->_conectionHandle = null;
return true;
} else {
return false;
}
}