/**
* Constructor method for the adapter. This constructor implements the setting of the
* 3 required properties for the object.
*
* The body of this method was provided by Mario Falomir... Thanks.
*
* @param resource $d The datasource resource
*/
function odbcAdapter($d)
{
parent::RecordSetAdapter($d);
// count number of fields
$fieldcount = odbc_num_fields($d);
$ob = "";
$be = $this->isBigEndian;
$fc = pack('N', $fieldcount);
if (odbc_num_rows($d) > 0) {
$line = odbc_fetch_row($d, 0);
do {
// write all of the array elements
$ob .= "\n" . $fc;
for ($i = 1; $i <= $fieldcount; $i++) {
// write all of the array elements
$value = odbc_result($d, $i);
if (is_string($value)) {
// type as string
$os = $this->_directCharsetHandler->transliterate($value);
//string flag, string length, and string
$len = strlen($os);
if ($len < 65536) {
$ob .= "" . pack('n', $len) . $os;
} else {
$ob .= "\f" . pack('N', $len) . $os;
}
} elseif (is_float($value) || is_int($value)) {
// type as double
$b = pack('d', $value);
// pack the bytes
if ($be) {
// if we are a big-endian processor
$r = strrev($b);
} else {
// add the bytes to the output
$r = $b;
}
$ob .= "" . $r;
} elseif (is_bool($value)) {
//type as bool
$ob .= "";
$ob .= pack('c', $value);
} elseif (is_null($value)) {
// null
$ob .= "";
}
}
} while ($line = odbc_fetch_row($d));
}
$this->serializedData = $ob;
// grab the number of fields
// loop over all of the fields
for ($i = 1; $i <= $fieldcount; $i++) {
// decode each field name ready for encoding when it goes through serialization
// and save each field name into the array
$this->columnNames[$i - 1] = $this->_directCharsetHandler->transliterate(odbc_field_name($d, $i));
}
$this->numRows = odbc_num_rows($d);
}
public function get_json_data()
{
$lista = json_decode($this->field_list);
$base = $this->db->getDB();
$this->conn = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ={$base}", '', '') or exit('Cannot open with driver.');
if (!$this->conn) {
exit("Connection Failed: " . $this->conn);
}
$rs = odbc_exec($this->conn, $this->sql);
if (!$rs) {
exit("Error in SQL");
}
$value = '[';
while (odbc_fetch_row($rs)) {
$value .= '[';
foreach ($lista as $valor) {
$value .= $this->not_null(odbc_result($rs, $valor[0]), $valor[1]) . ',';
}
$value .= '],';
}
$value .= ']';
$value = str_replace(",]", "]", $value);
odbc_close_all();
//$value = utf8_encode($value);
return $value;
}
public function execAsJson($query, $logComponent)
{
$query = 'sparql define output:format "RDF/XML" ' . $query;
/*
$query= 'sparql define output:format "TTL" ' .$query;
*/
/*
echo $query;
die;
*/
$odbc_result = $this->exec($query, $logComponent);
odbc_longreadlen($odbc_result, ODBC_MAX_LONGREAD_LENGTH);
odbc_fetch_row($odbc_result);
$data = false;
do {
$temp = odbc_result($odbc_result, 1);
if ($temp != null) {
$data .= $temp;
}
} while ($temp != null);
//=$data;
$conv = new XmlConverter();
$arr = $conv->toArray($data);
//print_r($arr);
//die;
//Logger::warn('check if faster with default graph, ');
return $arr;
}
function Table($sql, $col)
{
global $conn;
//Query
$res = odbc_do($conn, $sql);
if (!$res) {
die('SQL error');
}
//Header
$this->SetFillColor(255, 0, 0);
$this->SetTextColor(255);
$this->SetDrawColor(128, 0, 0);
$this->SetLineWidth(0.3);
$this->SetFont('', 'B');
$tw = 0;
foreach ($col as $label => $width) {
$tw += $width;
$this->Cell($width, 7, $label, 1, 0, 'C', 1);
}
$this->Ln();
//Rows
$this->SetFillColor(224, 235, 255);
$this->SetTextColor(0);
$this->SetFont('');
$fill = false;
while (odbc_fetch_row($res)) {
foreach ($col as $field => $width) {
$this->Cell($width, 6, odbc_result($res, $field), 'LR', 0, 'L', $fill);
}
$this->Ln();
$fill = !$fill;
}
$this->Cell($tw, 0, '', 'T');
}
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 = '******'";
$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 = '******' WHERE User_Name = '" . $userName . "'";
$rs = odbc_exec($conn, $sql);
}
return "OK";
}
function db_dataseek(&$qhandle,$row)
{
$i=0;
while($i<$row)
{
odbc_fetch_row($qhandle);
$i++;
}
}
function ddlVille($conn)
{
$result = odbc_exec($conn, "SELECT IDVILLE, NOMVILLE from ville;");
while (odbc_fetch_row($result)) {
$nomville = odbc_result($result, 2);
$id = odbc_result($result, 1);
echo '<option value=' . $id . '>' . $nomville . '</option>';
}
}
public function getKOSUserByCharacter($chr_uid, $con)
{
$sql = "select * from dbo.chr_info where chr_uid = {$chr_uid}";
$result = odbc_exec($con, $sql);
while (odbc_fetch_row($result)) {
$return = array('UserId' => odbc_result($result, "chr_uin"));
}
return $return;
}
function ddlPlage2($conn, $id)
{
$req = "SELECT plage.IDPLAGE, PLAGE \n FROM plage WHERE plage.IDPLAGE BETWEEN 25 AND 32 AND IDPLAGE NOT IN (SELECT IDPLAGE FROM paiement\n INNER JOIN contratlocation ON paiement.IDCONTRAT = contratlocation.IDCONTRAT\n WHERE IDAPPARTEMENT=" . $id . ");";
$result = odbc_exec($conn, $req);
while (odbc_fetch_row($result)) {
$plage = odbc_result($result, 2);
$id = odbc_result($result, 1);
echo '<option value=' . $id . '>' . $plage . '</option>';
}
}
function db_gettablelist()
{
global $conn;
$ret=array();
$rs = odbc_tables($conn);
while(odbc_fetch_row($rs))
if(odbc_result($rs,"TABLE_TYPE")=="TABLE" || odbc_result($rs,"TABLE_TYPE")=="VIEW")
$ret[]=odbc_result($rs,"TABLE_NAME");
return $ret;
}
public function CheckEmailIfExists($db)
{
$query = "select Fc_Email from tblMember";
$rows = odbc_exec($db, $query);
while (odbc_fetch_row($rows)) {
$existing = odbc_result($rows, "Fc_Email");
if ($this->email == $existing) {
return true;
}
}
}
/**
* Devuelve la cantidad de filas de un resultado de query
*
* @access public
* @param (object) result set
* @return (int) cantidad de filas en el resulta set
*/
function numero_filas($rs)
{
// Fix para odbc_num_rows que siempre devuelve -1 para MS Access
$count = 0;
while ($temp = odbc_fetch_into($rs, $counter)) {
$count++;
}
// Reset cursor position
odbc_fetch_row($rs, 0);
return $count;
}
/**
* @return Array
*/
public function db_gettablelist()
{
$ret = array();
$rs = odbc_tables($this->connectionObj->conn);
while (odbc_fetch_row($rs)) {
if (odbc_result($rs, "TABLE_TYPE") == "TABLE" || odbc_result($rs, "TABLE_TYPE") == "VIEW") {
$ret[] = odbc_result($rs, "TABLE_NAME");
}
}
return $ret;
}
function db_fetch_row($res)
{
switch (DATABASE) {
case 'mysql':
return mysql_fetch_row($res);
case 'mysqli':
return mysqli_fetch_row($res);
case 'sqlserver':
return odbc_fetch_row($res);
}
}
/**
* access不支持limit,所以自写方法完成
* 获取所有记录
* odbc_fetch_row 让游标偏移 $offset
*
* @param int $offset 游标偏移量
* @param int $pagesize 查询的结果行数
* @return array
*/
function result_access($offset, $pagesize = 0)
{
odbc_fetch_row($this->result_id, $offset);
$i = 1;
while ($row = $this->_fetch_assoc()) {
if ($i <= $pagesize) {
$this->result_array[] = $row;
}
$i++;
}
}
public function GetLoginUser($db, $user)
{
try {
$query = "select Fc_Fullname from tblMember\n\t\t\t\t \twhere Pk_MemberID='" . $user . "'";
$toprow = odbc_exec($db, $query);
if (odbc_fetch_row($toprow)) {
return odbc_result($toprow, "Fc_Fullname");
}
} catch (Exception $e) {
return "";
}
}
function DBGetQuery($result)
{
// Devuelve la siguiente fila dentro del result-array..
$arr = array();
if (odbc_fetch_row($result)) {
for ($i = 1; $i <= odbc_num_fields($result); $i++) {
$value = odbc_result($result, $i);
array_push($arr, $value);
}
}
return $arr;
}
/**
* @see DatabaseInfo::initTables()
*/
protected function initTables()
{
include_once 'creole/drivers/odbc/metadata/ODBCTableInfo.php';
$result = @odbc_tables($this->conn->getResource());
if (!$result) {
throw new SQLException('Could not list tables', $this->conn->nativeError());
}
while (odbc_fetch_row($result)) {
$tablename = strtoupper(odbc_result($result, 'TABLE_NAME'));
$this->tables[$tablename] = new ODBCTableInfo($this, $tablename);
}
@odbc_free_result($result);
}
function checkAlreadyId($conn, $sql)
{
$rs = odbc_exec($conn, $sql);
if (!$rs) {
exit("Error in SQL");
} else {
$num = odbc_fetch_row($rs);
if ($num) {
return "Already-Id";
} else {
return "Empty-Id";
}
}
odbc_close($conn);
}
function afficheTables($pFichAction)
{
//remplissage de la liste
$tablelist = odbc_tables($this->connexion);
echo '<form name="choixTables" method="get" action="' . $pFichAction . '">';
echo '<select name="lesTables">';
while (odbc_fetch_row($tablelist)) {
if (odbc_result($tablelist, 4) == "TABLE") {
// Si l'objet en cours a pour indicateur TABLE //test à ajouter dans la condition pour ne pas afficher les tables système en Access && !(substr(odbc_result($tablelist,3),0,4)=="MSys")
echo '<option value="' . odbc_result($tablelist, 3) . '">' . odbc_result($tablelist, 3) . '</option>';
}
// Affiche nom de la TABLE
}
echo '</select><input type="submit" value="Afficher"></input></form>';
}
public function LoadUserInfo($db)
{
try {
$query = "select Fc_Fullname,Fc_Gender,Fc_Email,Fc_Bday,Fc_PhotoLink from tblMember \n\t\t\t\t\t\twhere Pk_MemberID='" . $this->userID . "'";
$rows = odbc_exec($db, $query);
while (odbc_fetch_row($rows)) {
$user = odbc_result($rows, "Fc_Fullname");
$sex = odbc_result($rows, "Fc_Gender");
$email = odbc_result($rows, "Fc_Email");
$bday = odbc_result($rows, "Fc_Bday");
$avatar = odbc_result($rows, "Fc_PhotoLink");
echo "\n\t\t\t\t<table><tr><td>\n\t\t\t\t\t<table style='border-right:1px solid gray;'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><img src='Users/Avatar/" . $avatar . "' alt='no photo'\n\t\t\t\t\t\t\t height='180px' width='180px' style='border-radius:7px;'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><input type='button' name='submit-editphoto' value='Change Photo'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><input type='button' name='submit-changepass' value='Change Password'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table></td><td>\n\t\t\t\t\t<table>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><b style='color:gray;'>Username:</b></td>\n\t\t\t\t\t\t\t<td><input type='text' name='fullname' value='" . $user . "' style='color:teal;'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><b style='color:gray;'>Sex:</b></td>\n\t\t\t\t\t\t\t<td><b style='color:teal;'>" . $sex . "</b></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><b style='color:gray;'>Birthday:</b></td>\n\t\t\t\t\t\t\t<td><b style='color:teal;'>" . $bday . "</b></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td><b style='color:gray;'>Email:</b></td>\n\t\t\t\t\t\t\t<td><b style='color:teal;'>" . $email . "</b></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td colspan='2'>\n\t\t\t\t\t\t\t\t<input type='button' name='submit-updateprofile' value='Update Profile'>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table></td></tr>\n\t\t\t\t</table>\n\t\t\t\t";
}
} catch (Exception $e) {
}
}
function listeFourni()
{
global $cnx, $liste;
$cnx = ouvresylob(1);
//on selectionne tous les champs qui seront utiles
$sQuery = "SELECT distinct (f.no_frn) as id, f.rais_soc as raison_sociale, a.nom as contact, f.telph as tel, telex as email, \r\n CONCAT(a.adr1,a.adr2) as adresse, CONCAT(a.cd_post,a.ville) as ville\r\n FROM (informix.bas_frn f \r\n INNER JOIN informix.bas_adrfrn a ON a.no_frn = f.no_frn) \r\n LEFT JOIN informix.zz_materiel m ON m.frn_materiel = f.no_frn\r\n WHERE f.no_frn is not null\r\n AND a.no_adr = 1\r\n ORDER BY f.rais_soc asc, a.nom asc";
//echo $sQuery;
$res = odbc_exec($cnx, $sQuery);
$i = 0;
while (odbc_fetch_row($res)) {
for ($j = 1; $j <= odbc_num_fields($res); $j++) {
$liste[$i][odbc_field_name($res, $j)] = odbc_result($res, $j);
}
$i++;
}
//odbc_close($cnx);
return $liste;
}
public function LoadTrails($db)
{
$query = "select \n\t\t\t\t\tFk_ID,\n\t\t\t\t\ta.Fc_Fullname,\n\t\t\t\t\tFc_Doing,\n\t\t\t\t\tFc_Desc,\n\t\t\t\t\tFc_Where,\n\t\t\t\t\tFc_TimeStart,\n\t\t\t\t\tpkTrailID,\n\t\t\t\t\tFc_Tag,\n\t\t\t\t\ta.Fc_PhotoLink,\n\t\t\t\t\tb.Fc_PhotoLink as [User_PLink]\n\t\t\t\t\tfrom tblQuickTrail a\n\t\t\t\t\tLEFT JOIN tblMember b on a.Fk_ID = b.Pk_MemberID \n\t\t\t\t\torder by pkTrailID desc";
$rows = odbc_exec($db, $query);
while (odbc_fetch_row($rows)) {
$id = odbc_result($rows, "Fk_ID");
$user = odbc_result($rows, "Fc_Fullname");
$d = odbc_result($rows, "Fc_Doing");
$desc = odbc_result($rows, "Fc_Desc");
$w = odbc_result($rows, "Fc_Where");
$t = odbc_result($rows, "Fc_TimeStart");
$trailID = odbc_result($rows, "pkTrailID");
$tag = odbc_result($rows, "Fc_Tag");
$photolink = odbc_result($rows, "Fc_PhotoLink");
$userphoto = odbc_result($rows, "User_PLink");
echo "\n\t\t\t<div class='ui-content' style='border-radius:7px;border:1px solid #585899;background-color:white;'>\n\t\t\t\t<div style='background-color:white;padding:2%;border-radius:7px;'>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t<img src='Users/Avatar/" . $userphoto . "' \n\t\t\t\t\t\t\t\t\theight='50px' width='50px' style='border-radius:7px;'>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td><a href='' class='ui-btn'><b style='color:teal;'>" . $user . "</b></a></td>\n\t\t\t\t\t\t\t\t<td><small style='color:gray;'>is " . $this->MiniEvent($photolink) . "</small></td>\n\t\t\t\t\t\t\t\t<td>" . $this->GetEventIcon($d) . "</td>\n\t\t\t\t\t\t\t\t<td id='event'><b>" . $d . "</b></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t\t<hr>\n\t\t\t\t\t\t" . $this->isPhoto($photolink) . "\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td><span>" . $desc . "</span></td>\n\t\t\t\t\t\t\t\t<td><b style='font-size:large;color:teal;'>" . $tag . "</b></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t<small style='color:teal;'>at " . $w . "</small>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t<small style='color:gray;'>" . $t . "</small>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t</div>\n\t\t\t\t<div class='ui-content' id='writecomment'>\n\t\t\t\t\t<form action='Dashboard.php' method='POST'>\n\t\t\t\t\t<input type='hidden' name='trailID' value='" . $trailID . "'>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t<img src='Users/Avatar/" . $_SESSION["userAvatar"] . "' \n\t\t\t\t\t\t\t\theight='30px' width='30px' style='border-radius:7px;'>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<textarea name='comment' placeHolder='say something'></textarea></td><td>\n\t\t\t\t\t\t\t<input type='submit' name='submit-comment' value='add comment'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</form>\n\t\t\t\t</div>\n\t\t\t\t<div id='comments'>\n\t\t\t\t<small>comments</small><img src='images/Comment.png'>\n\t\t\t\t\t<iframe id='frameComments'\n\t\t\t\t\t src='pagelets/LoadComments.php?id=" . $trailID . "' width='100%'\n\t\t\t\t\t onload='resizeIframe(this)' frameborder='0' scrolling='yes'>\n\t\t\t\t\t</iframe>\n\t\t\t\t</div>\n\t\t\t</div><br>";
}
}
/**
* Constructor method for the adapter. This constructor implements the setting of the
* 3 required properties for the object.
*
* The body of this method was provided by Mario Falomir... Thanks.
*
* @param resource $d The datasource resource
*/
function odbcAdapter($d)
{
parent::RecordSetAdapter($d);
// count number of fields
$fieldcount = odbc_num_fields($d);
// grab the number of fields
// loop over all of the fields
for ($i = 0; $i < $fieldcount; $i++) {
// decode each field name ready for encoding when it goes through serialization
// and save each field name into the array
$this->columns[] = odbc_field_name($d, $i + 1);
}
if (odbc_num_rows($d) > 0) {
$line = odbc_fetch_row($d, 0);
do {
$this->rows[] = $line;
} while ($line = odbc_fetch_row($d));
}
}
public function Authenticate($user, $pass)
{
try {
$query = "select username,password from tblUser\n\t\t\t\t \twhere username='******'\n\t\t\t\t \t and password='******'";
$toprow = odbc_exec($this->link, $query);
if (odbc_fetch_row($toprow)) {
$u = odbc_result($toprow, "username");
$p = odbc_result($toprow, "password");
if ($user == $u && $pass == $p) {
return true;
} else {
return false;
}
} else {
return false;
}
} catch (Exception $e) {
}
}
function printSearch()
{
global $search_bar_fields;
?>
<form id="form1" name="form1" method="post" action="index.php">
<?php
foreach ($search_bar_fields as $key => $value) {
echo "<label><b>{$key}</b> <input name=\"{$value}\" type=\"text\" id=\"givenname\" size=\"10\" /></label> ";
}
echo "<strong>Dept</strong> <select name=\"dept\"><option value=\"\"></option>";
include "../../oit/config/config.php";
$query = odbc_exec($dbconn, "SELECT DISTINCT dept_name FROM org_chart_depts ORDER BY dept_name");
for ($i = 1; $i <= odbc_num_rows($query); $i++) {
odbc_fetch_row($query, $i);
$dept = odbc_result($query, "dept_name");
echo "<option value=\"{$dept}\">{$dept}</option>\n";
}
echo "</select>";
?>
<label><input name="Search" type="submit" id="Search" value="Search" /></label>
</form>
<?php
}
function get_report(client $client, $table_name, $show, $rownum)
{
if ($table_name == null) {
return "Bad table name.";
}
//TODO check table_name is one word
//compile query
$colnames = odbc_exec($client->get_connection(), "SELECT column_name, data_type, data_length FROM ALL_TAB_COLUMNS WHERE table_name = '" . strtoupper($table_name) . "';");
if ($colnames === false) {
return "Unable to get table fields.";
}
$query = "SELECT ";
$i = 0;
while (odbc_fetch_row($colnames)) {
if (isset($show) && isset($show[$i]) && $show[$i] == true) {
if ($query != "SELECT ") {
$query .= ", ";
}
$query .= odbc_result($colnames, 1);
}
$i += 1;
}
$query .= " FROM " . $table_name . " WHERE rownum <= ?;";
//prepare statement
$statement = odbc_prepare($client->get_connection(), $query);
if ($statement === false) {
return $query . "\n\n" . get_odbc_error();
}
$items = array();
$items[] = (int) $rownum;
$result = odbc_execute($statement, $items);
if ($result === false) {
return $query . "\n\n" . get_odbc_error();
}
return $statement;
}
//53
echo "\t";
//54
echo "\t";
//55
echo "\t";
//56
echo "\t";
//57
echo "\t";
//58
echo "\t";
//59
odbc_close($connection_string);
$process2 = odbc_exec($connection_string2, "Exec usp_USI_getReferralProcedures '" . $_GET['pReferral_ud'] . "'");
while (odbc_fetch_row($process2)) {
echo odbc_result($process2, "procedurecode_ud") . "\t";
// 60,70,80,90,100,110
echo odbc_result($process2, "description") . "\t";
// 61,71,81,91,101,111
echo round(odbc_result($process2, "average_cost")) . "\t";
// 62,72,82,92,102,112
// Spare fields for later use
echo odbc_result($process2, "modifier_1") . "\t";
// 63,73,83,93,103,113
echo "\t";
// 64,74,84,94,104,114
echo "\t";
// 65,75,85,95,105,115
echo "\t";
// 66,76,86,96,106,116
/**
* Fetches the row at current position and moves the internal cursor to the next position.
* @param bool TRUE for associative array, FALSE for numeric
* @return array array on success, nonarray if no next record
* @internal
*/
public function fetch($assoc)
{
if ($assoc) {
return odbc_fetch_array($this->resultSet, ++$this->row);
} else {
$set = $this->resultSet;
if (!odbc_fetch_row($set, ++$this->row)) {
return FALSE;
}
$count = odbc_num_fields($set);
$cols = array();
for ($i = 1; $i <= $count; $i++) {
$cols[] = odbc_result($set, $i);
}
return $cols;
}
}
<?php
include "php/configModeler.php";
global $DB;
$DB = str_replace("\"", "", $DB);
$connection_string = odbc_connect($DB, "", "");
$q = "exec usp_getAvgRates_With_Medicare_And_Rev '861,818,3337,599', '74178', '2011'";
$pr = odbc_exec($connection_string, $q);
while (odbc_fetch_row($pr)) {
echo odbc_result($pr, "Description") . "<BR>";
echo odbc_result($pr, "AvgRate") . "<BR>";
echo odbc_result($pr, "MinRate") . "<BR>";
echo odbc_result($pr, "MaxRate") . "<BR>";
}
?>
