public function getBills($accountNum, $isNumRows, $connect) { $dbCon = new db_config(); $data = ''; $sqlQ = $dbCon->mquery("EXEC dbo.getbill_upload @account_number = '" . $accountNum . "'", $connect); $num = $dbCon->numrows($sqlQ); $counter = 1; while ($row = $dbCon->fetcharray($sqlQ, SQLSRV_FETCH_ASSOC)) { //use fetcharray function here not object $upload_date = date_format($row['upload_date'], 'd M Y'); $bill_name = $dbCon->strip($row['bill_name']); $bill_date = $dbCon->strip($row['bill_date']); $data .= "<tr>"; $data .= "<td>" . $upload_date . "</td>"; $data .= "<td>" . $bill_name . "</td>"; $data .= "<td>" . $bill_date . "</td>"; $data .= "</tr>"; //$totalContacts = $counter++; } if ($isNumRows == 'y') { //return $totalContacts; } else { return $data; } }
public function getReports($accountNum, $connect) { $db = new db_config(); $data = ''; $sql = $db->mquery("EXEC callchart @acct_no = '" . $accountNum . "'", $connect); $num = $db->numrows($sql); $callers = array(); while ($row = $db->fetcharray($sql)) { $fields[0] = $row[caller_tag]; $fields[1] = $row[No_of_Calls]; array_push($callers, $fields); } print json_encode($callers, JSON_NUMERIC_CHECK); //return $data; }
public function loginPage($username, $password, $connect) { $db = new db_config(); $sql = "SELECT * FROM tbl_users WHERE username = '******' AND password = '******'"; $result = mysqli_query($connect, $sql); $num = $db->numrows($result); $row = $db->fetcharray($result); if ($num == 0) { echo "user not existing"; } else { $data = ''; $username = $row['username']; $is_admin = $row['is_admin']; $brand_name = $row['brand_name']; $id = $row['id']; if ($is_admin == 1) { session_start(); $_SESSION['session_userid'] = $username; $_SESSION['session_is_admin'] = $is_admin; $_SESSION['brand_name'] = $brand_name; $_SESSION['id'] = $id; session_write_close(); header("Location: index.php"); } else { if ($is_admin == 0) { session_start(); $_SESSION['session_userid'] = $username; $_SESSION['session_is_admin'] = $is_admin; $_SESSION['brand_name'] = $brand_name; $_SESSION['id'] = $id; session_write_close(); header("Location: /user/index.php"); } } } return $data; }