AppGini Community Forums

Code: Select all

function TABLE_NAME_OF_CUSTOMER_after_insert($data, $memberInfo, &$args){
  // we assume only one record is not in the membership_users yet, otherwise you will need to use the appgini SQL function
  $_result_sql = sqlvalue ("SELECT customer_name 
                            FROM customer_table 
                            LEFT JOIN membership_users ON customer_table.customer_name = membership_users.memberID
                            WHERE membership_users.memberID IS NULL");  

  //now you have the name, that is not in the membership_users table yet - simply write it to the membership_users table, add password etc. and you are ready to go. something like this:
  $sql="update membership_users  set memberID='".$_result_sql."', passMD5 ='some MD5 of PW', otherfield=......";
  $_result_sql = sql($sql, $eo);
}