public function registerInterest($data, $connect) { $db = new db_config(); $dbCheck = new db_config(); $email_data = $data['@email']; $sqlCheck = $dbCheck->mquery("SELECT * FROM register_interest WHERE email = '" . $email_data . "'", $connect); $num = $dbCheck->numhasrows($sqlCheck); $row = $dbCheck->fetchobject($sqlCheck); if ($num == 0) { $sql = $db->mquery_insert("dbo.registerInterest", $data, $connect); header("location: confirmation?register_success=true"); } else { $sql = $db->mquery_insert("dbo.registerInterest", $data, $connect); header("location: confirmation?register_success=true"); //note: for the meantime duplicates are okay //header ("location: index.php?emailcheck=true"); } }
public function getBills($accountNum, $connect) { $db = new db_config(); $data = ''; $sql = $db->mquery("EXEC dbo.getbill_upload @account_number = '" . $accountNum . "'", $connect); $num = $db->numhasrows($sql); $uploadedbills = array(); $i = 0; while ($row = $db->fetchobject($sql)) { $ctr = $i++; $bill_id = $db->strip($row->id); $bill_date = $db->strip($row->bill_date); $data .= '<li id="btype_' . $ctr . '" onclick="btype_data(\'' . $ctr . '\', \'' . $bill_date . '\');" rel="' . $ctr . '" class="btype">'; $data .= '<a tabindex="-1" href="#" class="opt"><span class="pull-left">' . $bill_date . '</span></a>'; $data .= '</li>'; } return $data; }