public function saveCustomer(\CustomerVO $customerVO)
{
$sqlSaveCus = "INSERT INTO RICH_CUSTOMER (CUS_ID,CUS_USERNAME,CUS_PASSWORD,CUS_EMAIL,CUS_FIRST_NAME,CUS_LAST_NAME,CUS_GENDER,CUS_CONTACT_ADDRESS,CUS_RECEIPT_ADDRESS,CUS_PHONE_NUMBER,CUS_FACEBOOK_ADDRESS,CREATED_DATE_TIME,FORCE_CHANGE) " . "VALUES " . "('" . $customerVO->getCusID() . "','" . $customerVO->getCusUsername() . "','" . $customerVO->getCusPassword() . "','" . $customerVO->getCusEmail() . "','" . $customerVO->getCusFirstName() . "','" . $customerVO->getCusLastName() . "','" . $customerVO->getCusGender() . "','" . $customerVO->getCusContactAddr() . "','" . $customerVO->getCusReceiptAddr() . "','" . $customerVO->getPhoneNumber() . "','" . $customerVO->getCusFacebookAddr() . "',NOW(),'" . $customerVO->getForceChange() . "');";
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$query = mysql_query($sqlSaveCus);
if ($query) {
return 200;
} else {
return "Cannot save customer with error '" . mysql_error() . "'";
}
}
