//checking for valid senior id $valid_senior_id = $managedata->getValue_where("member_table", "*", "membership_id", $Senior_id); if (!empty($valid_senior_id[0]['membership_id'])) { //make the name,address by concatening f_name,l_name AND address1, address2 $name = $firstname . " " . $lastname; $address = $address1 . "<br>" . $address2; //creting memebership id using unique id with prefix member $membership_id = uniqid('member'); //getting current date/time and expiration date $getdate = getdate(); $date = $getdate['year'] . "-" . $getdate['mon'] . "-" . $getdate['mday']; $expiration_date = date('Y-m-d', strtotime('+1 years')); //make membership_id as username of the user $username = $email_id; //inserting values in member_table $result = $managedata->insertMember($name, $email_id, $dob, $gender, $contact_no, $address, $city, $postal_code, $state, $country, $username, $password, $membership_id, $date, $expiration_date); //inserting membership id in mlm_table $result_mlm = $managedata->insertMembershipId($membership_id, $date); //checking for valid senior membership id if (isset($Senior_id) && !empty($Senior_id) && $result_mlm == 1) { //finding id value of memberdhip_id $member_id = $managedata->getValue_where("mlm_info", "id", "membership_id", $membership_id); //getting child ids of senior id $child_id = $managedata->getValue_where("mlm_info", "*", "membership_id", $Senior_id); //update parent id value of new member if (!empty($child_id[0]['id'])) { $update_parent_id = $managedata->updateValueWhere("mlm_info", "parent_id", $child_id[0]['id'], "membership_id", $membership_id); } //adding child id value if ($child_id[0]['child_id'] != "") { $new_child_id = $child_id[0]['child_id'] . "," . $member_id[0]['id'];