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() . "'"; } }