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;
}
