insert(
$wpdb->prefix.'apt_clients',
array(
'first_name' => $first_name,
'last_name' => $last_name,
'phone' => $C_phone,
'skype_id' => $C_skyp_id,
'email' => $C_email,
'notes' => $C_notes,
)
);
$user_data = array(
'user_pass' => $user_pass,
'user_email' => $C_email,
'user_login' => $C_email,
'role' => 'subscriber' // Use default role or another role, e.g. 'editor'
);
$user_id = wp_insert_user( $user_data );
add_action( 'admin_init', 'wp_insert_user' );
}
//update customer
if(isset($_REQUEST['u_C_phone'])) {
$u_use_id = sanitize_text_field( $_REQUEST['u_use_id'] );
$u_first_name = sanitize_text_field( $_REQUEST['u_first_name'] );
$u_last_name = sanitize_text_field( $_REQUEST['u_last_name'] );
$u_C_phone = sanitize_text_field( $_REQUEST['u_C_phone'] );
$u_C_skyp_id = sanitize_text_field( $_REQUEST['u_C_skyp_id'] );
$u_C_email = sanitize_text_field( $_REQUEST['u_C_email'] );
$u_C_notes = sanitize_text_field( $_REQUEST['u_C_notes'] );
$wpdb->update( $wpdb->prefix.'apt_clients',array('first_name'=>$u_first_name,'last_name'=>$u_last_name,'phone'=>$u_C_phone,'skype_id'=>$u_C_skyp_id,'email'=>$u_C_email,'notes'=>$u_C_notes),array( 'id'=>$u_use_id ));
/*$user = get_user_by( 'email',$u_C_email);
//print_r($user);
$user_id = $user->ID;
if(isset( $_REQUEST['u_user_pass'])) {$user_pass = $_REQUEST['u_user_pass'];}
$user_login= $_REQUEST['u_u_ser_name'];
$wpdb->update($wpdb->users, array('user_pass'=>MD5($user_pass),'user_login' =>$user_login), array('ID' => $user_id));*/
}
//single delete
if(isset($_REQUEST['single_id'])) {
$del=$_REQUEST['single_id'];
$wpdb->delete( $wpdb->prefix.'apt_clients', array( 'id' => $del ));
}
// multi delete
if(isset($_REQUEST['id'])) {
$id_array = sanitize_text_field($_REQUEST['id']);
$arr = explode(',',$id_array);
echo $id_count = count($arr);
for($i=0;$i<=$id_count;$i++) {
$del=$arr[$i];
$wpdb->delete( $wpdb->prefix.'apt_clients', array( 'id' =>$del ) );
$wpdb->show_errors();
$wpdb->print_error();
}
}
?>