/** * @param $sql * * @return array */ public function query($sql) { // $this->connection = $this->getConnection(); // Run query $query = mssql_query($sql, $this->connection); // On error if ($query === false) { Response::error(500, $_SERVER["SERVER_PROTOCOL"] . ' DB query failed (SQL): ' . mssql_get_last_message()); } // E.g. boolean is returned if no rows (e.g. no resource found or on UPDATE) if ($query === true) { $response = $query; } else { // Response $response = array(); // // Loop rows and add to response array if (mssql_num_rows($query) > 0) { while ($row = mssql_fetch_assoc($query)) { $response[] = $row; } } // Free the query result mssql_free_result($query); } // Close link $this->closeConnection(); // return $response; }
public function closeCursor() { if ($this->_result) { mssql_free_result($this->_result); $this->_result = false; } }
function econnect_copy($sql, $key, $node) { global $old_gp; global $new_gp; $name = ""; $inc = 0; $break = 0; $st_proc = ""; $rset = mssql_query($sql, $old_gp); while ($line = mssql_fetch_assoc($rset)) { $st_proc = ""; $break = 0; for ($inc = 0; $inc < mssql_num_fields($rset); $inc++, $break++) { $name = trim(mssql_field_name($rset, $inc)); if ($break > 1) { $st_proc .= "\n "; $break = 0; } $st_proc .= "@I_v{$name}='" . str_replace("'", "''", trim($line[$name])) . "', "; } $st_proc = "\n declare @O_iErrorState int; declare @oErrString varchar(255); \n select @O_iErrorState = 0;\n exec {$node}\n {$st_proc} @oErrString = @oErrString output,@O_iErrorState = @O_iErrorState output;\n select @O_iErrorState as ret_val, ErrorDesc from DYNAMICS..taErrorCode where errorcode = @O_iErrorState;\n "; #PHP bug fix work around $st_proc = str_replace("@I_vUnrealized_Purchase_Price_Vari=", "@I_vUnrealized_Purchase_Price_Variance_Acct=", $st_proc); echo "{$node} " . trim($line[$key]) . ". "; $rset_x = mssql_query($st_proc, $new_gp); $line_x = mssql_fetch_assoc($rset_x); if ($line_x["ret_val"] == 0) { echo "Successful.\n"; } else { echo "Failed. Reason: " . trim($line_x["ErrorDesc"]) . "\n{$st_proc}\n"; #exit(); } mssql_free_result($rset_x); } }
private function executeQuery() { $return = false; if ($this->queryType == 'other') { if (mssql_query($this->query, $this->link) === true) { $return = true; $this->error = mssql_get_last_message(); } } else { if ($result = mssql_query($this->query, $this->link)) { // Conteo de registros if ($this->queryType == 'insert' || $this->queryType == 'update' || $this->queryType == 'delete') { $this->numRows = mssql_rows_affected($this->link); $return = true; } else { $this->numRows = mssql_num_rows($result); $fetchType = MSSQL_NUM; if ($this->queryReturn == 'assoc') { $fetchType = MSSQL_ASSOC; } elseif ($this->queryReturn == 'both') { $fetchType = MSSQL_BOTH; } $return = array(); while ($row = mssql_fetch_array($result, $fetchType)) { array_push($return, $row); } } $this->error = mssql_get_last_message(); mssql_free_result($result); } else { $this->error = mssql_get_last_message(); } } return $return; }
function free_result() { if (is_resource($this->result_id)) { mssql_free_result($this->result_id); $this->result_id = FALSE; } }
/** * This function frees the command reference. * * @access public * @override */ public function free() { if ($this->command !== NULL) { @mssql_free_result($this->command); $this->command = NULL; $this->record = FALSE; } }
function free_result() { if ($this->Query_ID) { mssql_free_result($this->Query_ID); } $this->Query_ID = 0; $this->VEOF = -1; }
public function close() { if ($this->rsrc) { mssql_free_result($this->rsrc); $this->rsrc = null; } $this->current = null; }
public function getLastId() { $last_id = false; $resource = mssql_query("SELECT @@identity AS id", $this->link); if ($row = mssql_fetch_row($resource)) { $last_id = trim($row[0]); } mssql_free_result($resource); return $last_id; }
function getOneColumnAsArray() { $column = array(); $queryId = $this->connection->execute($this->getSQL()); while (is_array($row = mssql_fetch_row($queryId))) { $column[] = is_numeric($row[0]) ? $row[0] : mb_convert_encoding($row[0], 'UTF-8', 'Windows-1251'); } mssql_free_result($queryId); return $column; }
public function exec(&$statement) { if ($result = @mssql_query($statement, $this->link)) { if (is_resource($result)) { mssql_free_result($result); return 0; } return mssql_rows_affected($this->link); } return false; }
function loadTables() { if ($this->isExisting && !$this->isTablesLoaded) { $queryId = $this->connection->execute("select TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_CATALOG='" . $this->name . "'"); while (is_array($row = mssql_fetch_row($queryId))) { $this->tables[$row[0]] = null; } mssql_free_result($queryId); $this->isTablesLoaded = true; } }
public function getNamaBulanById($id) { $sql = 'SELECT Bulan FROM ' . $this->table . ' WHERE BulanId=' . $id; $result = mssql_query($sql); if (mssql_num_rows($result) > 0) { while ($val = mssql_fetch_assoc($result)) { $namaBulan = $val['Bulan']; } } mssql_free_result($result); return $bulan; }
public function getKecamatanByKelurahan($id) { $sql = 'SELECT a.Nama, a.KecamatanId, a.KodeDepdagri FROM ' . $this->table . ' a INNER JOIN M_Kelurahan b on a.KecamatanId=b.KecamatanId WHERE b.KelurahanId=' . $id; $result = mssql_query($sql); $data = array(); if (mssql_num_rows($result) > 0) { while ($val = mssql_fetch_assoc($result)) { $data[] = array('KecamatanId' => $val['KecamatanId'], 'Nama' => $val['Nama'], 'KodeDedagri' => $val['KodeDepdagri']); } } mssql_free_result($result); return $data; }
public function getAlasanTidakKbById($id) { $sql = 'SELECT * FROM ' . $this->table . ' WHERE ID=' . $id; $result = mssql_query($sql); $data = array(); if (mssql_num_rows($result) > 0) { while ($val = mssql_fetch_assoc($result)) { $data[] = array('ID' => $val['ID'], 'Alasan' => $val['Alasan'], 'SortNumber' => $val['SortNumber'], 'IsActive' => $val['IsActive']); } } mssql_free_result($result); return $data; }
function _select($query) { // echo $query."<BR>"; if ($result = mssql_query($query, $this->_LINK)) { $trow = array(); while ($row = mssql_fetch_array($result)) { $trow[] = $row; } mssql_free_result($result); return count($trow) > 0 ? $trow : false; } return false; }
public function getAllRecord() { $sql = 'SELECT * FROM ' . $this->table . ' ORDER BY TempatPelayananKBId'; $result = mssql_query($sql); $data = array(); if (mssql_num_rows($result) > 0) { while ($val = mssql_fetch_assoc($result)) { $data[] = array('TempatPelayananKBId' => $val['TempatPelayananKBId'], 'Nama' => $val['Nama']); } } mssql_free_result($result); return $data; }
public function getRwByKelurahan($id) { $sql = 'SELECT * FROM ' . $this->table . ' WHERE KelurahanId=' . $id; $result = mssql_query($sql); $data = array(); if (mssql_num_rows($result) > 0) { while ($val = mssql_fetch_assoc($result)) { $data[] = array('RWId' => $val['RWId'], 'Nama' => $val['Nama'], 'KelurahanId' => $val['KelurahanId']); } } mssql_free_result($result); return $data; }
/** * Performs an SQL query. * * @param string $query * @param mixed $limit * @param boolean $warnOnFailure * @access public */ function query($query, $limit = false, $warnOnFailure = true) { if ($limit != false) { $query = str_replace('SELECT', 'SELECT TOP ' . $limit, $query); } if ($this->config['debug_level'] > 1) { $this->debugQuery($query); } @mssql_free_result($this->result); $this->result = @mssql_query($query, $this->connection); if (!$this->result && $warnOnFailure) { phpOpenTracker::handleError('Database query failed.', E_USER_ERROR); } }
public function query($sql) { LogMaster::log($sql); $res = mssql_query($sql, $this->connection); if ($this->insert_operation) { $last = mssql_fetch_assoc($res); $this->last_id = $last["dhx_id"]; mssql_free_result($res); } if ($this->start_from) { mssql_data_seek($res, $this->start_from); } return $res; }
function tmssql() { print "<h3>mssql</h3>"; $db = mssql_connect('JAGUAR\\vsdotnet', 'adodb', 'natsoft') or die('No Connection'); mssql_select_db('northwind', $db); $rs = mssql_query('select getdate() as date', $db); $o = mssql_fetch_row($rs); print_r($o); mssql_free_result($rs); print "<p>Delete</p>"; flush(); $rs2 = mssql_query('delete from adoxyz', $db); $p = mssql_num_rows($rs2); mssql_free_result($rs2); }
/** * 按SQL语句获取记录结果,返回数组 * * @param sql 执行的SQL语句 */ public function getArray($sql) { if (!($result = $this->exec($sql))) { return array(); } if (!mssql_num_rows($result)) { return array(); } $rows = array(); while ($rows[] = mssql_fetch_array($result, MSSQL_ASSOC)) { } mssql_free_result($result); array_pop($rows); return $rows; }
function close() { global $res, $databaseType; if ($databaseType == "mysql") { @mysql_free_result($this->index); @mysql_close($res); } if ($databaseType == "postgresql") { @pg_free_result($this->index); @pg_close($res); } if ($databaseType == "sqlserver") { @mssql_free_result($this->index); @mssql_close($res); } }
public function execute($sql, $bindParams = array(), $additionalParameters = array()) { $sql = $this->bind($sql, $bindParams); if ($result = mssql_query($sql, $this->connection)) { $rows = array(); if (is_resource($result)) { while ($row = mssql_fetch_assoc($result)) { $rows[] = $row; } mssql_free_result($result); $this->affectedRows = 0; } else { $this->affectedRows = mssql_rows_affected($this->connection); } return empty($rows) ? null : $rows; } else { $this->executeError($sql); } }
function ReaPaises($nIdPais) { $sp = mssql_init('REAPAISES'); //SP //Parámetros SP mssql_bind($sp, '@nIdPais', $nIdPais, SQLINT4); $resultado = mssql_execute($sp); //Ejecución SP $i = 0; while ($row = mssql_fetch_array($resultado)) { $html[$i]['id_pais'] = $row[0]; $html[$i]['nombre'] = $row[1]; $i++; } return $html; mssql_free_result($resultado); //Liberación del recurso mssql_free_statement($sp); //Liberación del recurso }
function get_mssql_table($table, $dbconfig) { $link = mssql_connect($dbconfig['hostname'], $dbconfig['username'], $dbconfig['password']); if (!$link || !mssql_select_db($dbconfig['database'], $link)) { die('<div class="alert alert-danger"><strong>Ошибка подключения к БД.</strong> Проверьте параметры соединения в файле config.php.</div>'); } if ($result = mssql_query("SELECT * FROM " . $table, $link)) { $table_code = ''; while ($row = mssql_fetch_assoc($result)) { $table_code = $table_code . '<tr>' . "\r\n"; foreach ($row as $key => $value) { $table_code = $table_code . '<td>' . $value . '</td>' . "\r\n"; } $table_code = $table_code . '</tr>' . "\r\n"; } mssql_free_result($result); } else { $table_code = ''; } mssql_close($link); return $table_code; }
function &executeQuery($query, $interrupt = true, $raw = false) { $result = null; if ($this->link != null && $this->dbsel != null) { if (is_array(MSSQL_Connector::$traza)) { MSSQL_Connector::$traza[] = $query; } $result = @mssql_query($query, $this->link); if ($result == false) { $err = mssql_get_last_message(); if ($interrupt) { $this->agrErr("Error en la consulta: <b>\"" . $query . "\"</b><br>\nMensaje de SQL SERVER: \"<i>" . $err . "</i>\"", $interrupt); } if ($result != false) { mssql_free_result($result); } return false; } } else { $this->agrErr("No hay conexión valida o BD seleccionada: " . $query); } if ($raw) { return $result; } $res = null; if ($result != null && !is_bool($result) && mssql_num_rows($result) > 0) { $aux = array(); while ($unreg = mssql_fetch_assoc($result)) { $aux[] = $unreg; } $res = $aux; } else { if (is_bool($result)) { $res = $result; } } return $res; }
/** * Returns information about a table or a result set * * NOTE: only supports 'table' and 'flags' if <var>$result</var> * is a table name. * * @param object|string $result DB_result object from a query or a * string containing the name of a table. * While this also accepts a query result * resource identifier, this behavior is * deprecated. * @param int $mode a valid tableInfo mode * * @return array an associative array with the information requested. * A DB_Error object on failure. * * @see DB_common::tableInfo() */ function tableInfo($result, $mode = null) { if (is_string($result)) { /* * Probably received a table name. * Create a result resource identifier. */ if (!@mssql_select_db($this->_db, $this->connection)) { return $this->mssqlRaiseError(DB_ERROR_NODBSELECTED); } $id = @mssql_query("SELECT * FROM {$result} WHERE 1=0", $this->connection); $got_string = true; } elseif (isset($result->result)) { /* * Probably received a result object. * Extract the result resource identifier. */ $id = $result->result; $got_string = false; } else { /* * Probably received a result resource identifier. * Copy it. * Deprecated. Here for compatibility only. */ $id = $result; $got_string = false; } if (!is_resource($id)) { return $this->mssqlRaiseError(DB_ERROR_NEED_MORE_DATA); } if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) { $case_func = 'strtolower'; } else { $case_func = 'strval'; } $count = @mssql_num_fields($id); $res = array(); if ($mode) { $res['num_fields'] = $count; } for ($i = 0; $i < $count; $i++) { if ($got_string) { $flags = $this->_mssql_field_flags($result, @mssql_field_name($id, $i)); if (DB::isError($flags)) { return $flags; } } else { $flags = ''; } $res[$i] = array('table' => $got_string ? $case_func($result) : '', 'name' => $case_func(@mssql_field_name($id, $i)), 'type' => @mssql_field_type($id, $i), 'len' => @mssql_field_length($id, $i), 'flags' => $flags); if ($mode & DB_TABLEINFO_ORDER) { $res['order'][$res[$i]['name']] = $i; } if ($mode & DB_TABLEINFO_ORDERTABLE) { $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; } } // free the result only if we were called on a table if ($got_string) { @mssql_free_result($id); } return $res; }
/** * Executes a SQL statement * * @param string|fStatement $statement The statement to perform * @param array $params The parameters for prepared statements * @return void */ private function perform($statement, $params) { fCore::startErrorCapture(); $extra = NULL; if (is_object($statement)) { $result = $statement->execute($params, $extra, $statement != $this->statement); } elseif ($this->extension == 'ibm_db2') { $result = db2_exec($this->connection, $statement, array('cursor' => DB2_FORWARD_ONLY)); } elseif ($this->extension == 'mssql') { $result = mssql_query($statement, $this->connection); } elseif ($this->extension == 'mysql') { $result = mysql_unbuffered_query($statement, $this->connection); } elseif ($this->extension == 'mysqli') { $result = mysqli_query($this->connection, $statement, MYSQLI_USE_RESULT); } elseif ($this->extension == 'oci8') { $extra = oci_parse($this->connection, $statement); $result = oci_execute($extra, $this->inside_transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS); } elseif ($this->extension == 'pgsql') { $result = pg_query($this->connection, $statement); } elseif ($this->extension == 'sqlite') { $result = sqlite_exec($this->connection, $statement, $extra); } elseif ($this->extension == 'sqlsrv') { $result = sqlsrv_query($this->connection, $statement); } elseif ($this->extension == 'pdo') { if ($this->type == 'mssql' && !fCore::checkOS('windows')) { $result = $this->connection->query($statement); if ($result instanceof PDOStatement) { $result->closeCursor(); } } else { $result = $this->connection->exec($statement); } } $this->statement = $statement; $this->handleErrors(fCore::stopErrorCapture()); if ($result === FALSE) { $this->checkForError($result, $extra, is_object($statement) ? $statement->getSQL() : $statement); } elseif (!is_bool($result) && $result !== NULL) { if ($this->extension == 'ibm_db2') { db2_free_result($result); } elseif ($this->extension == 'mssql') { mssql_free_result($result); } elseif ($this->extension == 'mysql') { mysql_free_result($result); } elseif ($this->extension == 'mysqli') { mysqli_free_result($result); } elseif ($this->extension == 'oci8') { oci_free_statement($oci_statement); } elseif ($this->extension == 'pgsql') { pg_free_result($result); } elseif ($this->extension == 'sqlsrv') { sqlsrv_free_stmt($result); } } }
function checkToken($token) { global $url_login, $url_authenn, $sys_code; if (isset($token)) { $data = getAuthen($token); if (isset($data->BappGetSessionResult->Username)) { $_SESSION["user_name"] = sprintf("%08s", $data->BappGetSessionResult->Username); $_SESSION["name"] = $data->BappGetSessionResult->FullNameTH; $_SESSION['token'] = $token; $_SESSION['image_url'] = $data->BappGetSessionResult->ImageUrl; // Role $conn = ConnectDB(); $sql = "select ROLE_CODE from DB_DS.DBO.GET_ROLE_BY_PER_SYSID ('" . sprintf("%08s", $_SESSION["user_name"]) . "', '" . $sys_code . "')"; $query = mssql_query($sql); $row = mssql_fetch_array($query, MSSQL_ASSOC); $_SESSION["role"] = $row['ROLE_CODE']; mssql_free_result($query); mssql_close($conn); header('Location: /meeting/index.php'); } else { header('Location: ' . $url_login); } } else { header('Location: ' . $url_login); } }