Students

>

[insert_php]
global $wpdb;
if($_POST[serch]){
if($_POST[phone]){
echo $_POST['special_content'];
$phone=$_POST[phone];
$result23=$wpdb->get_results("SELECT * FROM `lp_usermeta` where `meta_value` like '%$phone%'");
foreach($result23 as $result23s){
$ph_id=$result23s->user_id;
$where="where `ID`='$ph_id'";
}
}elseif($_POST[Email1]){
$Email1=$_POST[Email1];
$result23=$wpdb->get_results("SELECT * FROM `lp_users` where `user_email` like '%$Email1%'");
foreach($result23 as $result23s){
$ph_id=$result23s->ID;
$where="where `ID`='$ph_id'";
}
}elseif($_POST[id]){
$id=$_POST[id];
$where="where `ID`='$id'";
}
}
$sql="SELECT * FROM `lp_users`".$where." ORDER BY ID DESC";
$results=$wpdb->get_results($sql);
foreach($results as $results1){
$id=$results1->ID;
$display_name=$results1->display_name;
$login_name=$results1->user_login;
$admin_id=$results1->admin_id;
$user_email=$results1->user_email;
$result24=$wpdb->get_results("SELECT * FROM `lp_usermeta` where `user_id`='$id' AND `meta_key`='admin_id'");
foreach($result24 as $result24s){
$pass=$result24s->meta_value;
}
echo '

";
echo "

";
$result22=$wpdb->get_results("SELECT * FROM `lp_usermeta` where `user_id`='$id' AND `meta_key`='billing_phone'");
foreach($result22 as $result22s){
$phone=$result22s->meta_value;
}
$result23=$wpdb->get_results("SELECT * FROM `lp_usermeta` where `user_id`='$id' AND `meta_key`='pw_user_status'");
foreach($result23 as $result23s){
$status=$result23s->meta_value;
if($status=="approved"){
$status_icon="/wp-content/uploads/2018/04/approved.png name='desaple'";
$act='desaple';
}else{
$status_icon="/wp-content/uploads/2018/04/Cancel.png name='enaple'";
$act='enaple';
}
}

echo "

";

}
if($_POST[cert]){
if ( ! function_exists( 'wp_handle_upload' ) ) {
require_once( ABSPATH . 'wp-admin/includes/file.php' );
}
$uploadedfile = $_FILES['file_to_upload'];

$upload_overrides = array( 'test_form' => false );

$movefile = wp_handle_upload( $uploadedfile, $upload_overrides );

if ( $movefile && ! isset( $movefile['error'] ) ) {
echo "File is valid, and was successfully uploaded.n";
$cert=$movefile["url"];

$id=$_POST['sdu_id'];
$course_name=$_POST[course_name];
$wpdb->insert('lp_usermeta', array(
'user_id' => $id,
'meta_key' => 'course_name',
'meta_value'=>$course_name
));

$wpdb->insert('lp_usermeta', array(
'user_id' => $id,
'meta_key' => 'course_img',
'meta_value'=>$cert
));

} else {
/**
* Error generated by _wp_handle_upload()
* @see _wp_handle_upload() in wp-admin/includes/file.php
*/
echo $movefile['error'];
}

}

if($_GET[act]=='enaple'){
$id=$_GET['id'];
update_user_meta($id, 'pw_user_status', 'approved' );
header("location:/students/");
}
if($_GET[act]=='desaple'){
$id=$_GET['id'];
update_user_meta($id, 'pw_user_status', 'Pending' );
header("location:/students/");
}
if($_POST[edit]){
$id=$_POST['sdu_id'];
$display_name=$_POST[display_name];
$user_email=$_POST[user_email];
wp_update_user( array( 'ID' => $id, 'display_name' => $display_name,'user_email'=>$user_email ) );

$phone=$_POST[phone];
update_user_meta($id, 'billing_phone', $phone);
}
if($_POST[Register]){
$student_name=$_POST['student_name'];
$birthdate=$_POST['birthdate'];
$Student_Email=$_POST['Student_Email'];
$graduation_date=$_POST['graduation_date'];
echo $login=str_replace(' ','_',$student_name);
echo $password= wp_generate_password( $length=4, $include_standard_special_chars=false );
$userdata = array(
'user_login' => $login,
'user_email' => $Student_Email,
'user_pass' => $password,
'user_nicename'=>$student_name,
'display_name'=>$student_name
);

$user_id = wp_insert_user( $userdata ) ;

//On success
if ( ! is_wp_error( $user_id ) ) {
update_user_meta($user_id, 'admin_id', $password);
$phone=$_POST[Student_Phone];
update_user_meta($user_id, 'billing_phone', $phone);
echo "User created : ". $user_id;
}
}
if($_GET[action]=='del'){
$id2=$_GET[id1];
echo"

YES NO ";
}
if($_GET[action]=='okdel'){
$id2=$_GET[id2];
wp_delete_user($id2);
header("Refresh:0");
}
if($_POST[rem_select]){
$s_id= $_POST[colors];
foreach($s_id as $s_ids){
wp_delete_user($s_ids);
header("Refresh:0");
}
}
[/insert_php]

Select All			user name	pass
	$login_name	$pass