$data['country_id'] = $_POST['ddlCountry']; $data['state_id'] = $_POST['ddlState']; $data['district_id'] = $_POST['ddlDistrict']; $data['fax'] = $_POST['txtFax']; $data['postal_code'] = $_POST['txtPostalCode']; $data['facebook_url'] = !empty($_POST['txtFacebookUrl']) ? FACEBOOK_URL . $_POST['txtFacebookUrl'] : ''; $data['twitter_url'] = !empty($_POST['txtTwitterUrl']) ? TWITTER_URL . $_POST['txtTwitterUrl'] : ''; if (!empty($_POST['txtStartTime']) && !empty($_POST['txtEndTime'])) { $data['sms_time'] = sprintf('%s-%s', $_POST['txtStartTime'], $_POST['txtEndTime']); } if (!empty($_POST['hdnId'])) { $data['id'] = $_POST['hdnId']; $data['updated_date'] = date('Y-m-d h:i:s'); $sendRegisterMail = false; } else { $password = $commonController->randomPassword(); $data['password'] = md5($password); $data['created_date'] = date('Y-m-d h:i:s'); $sendRegisterMail = false; } if ($uploadFlag) { $resultPackage = $commonController->getTableData(array('table' => 'packages', 'where' => array('price=0'))); if (mysql_num_rows($resultPackage) > 0) { $rowPackages = mysql_fetch_array($resultPackage); $data['subscription_id'] = $rowPackages['id']; $data['subscribed_on'] = date('Y-m-d h:i:s'); } if ($commonController->insertUpdateData($data) > 0) { if ($sendRegisterMail) { $registrationMsg = 'Hi ' . $data['username'] . ', <br /><br />'; $registrationMsg .= 'You have been successfully registered with Snoozeover site. <br />';