Work List

[insert_php] $prefix=”zerocosts_” ; global $wpdb; // Add record if(isset($_POST[‘but_submit’])){ $name = $_POST[‘txt_name’]; $mobile = $_POST[‘txt_mobile’]; $password = $_POST[‘txt_password’]; $email = $_POST[‘txt_email’]; $tablename = $prefix.”zerocostsuser”; echo ” data = “.$name.” , “.$mobile.” , “.$password.” , “.$email. ” ) “; if(($name != ”) && ($mobile != ”) && ($password != ”) && ($email != ”)){ $check_data = $wpdb->get_results(“SELECT * FROM “.$tablename.” WHERE mobile='”.$mobile.”‘ “); if(count($check_data) == 0){ $insert_sql = “INSERT INTO “.$tablename.”(name,mobile,password,email) values(‘”.$name.”‘,'”.$mobile.”‘,'”.$password.”‘,'”.$email.”‘) “; $wpdb->query($insert_sql); echo “Save sucessfully.”; } else { echo “User Already Exists.”; } } else { echo “All Fields required, Try Again”; } } [/insert_php]

New User Register

Name
mobile
password
Email
 
Hello html
S.no Name Username Email User Type  
“.$count.” “.$name.” “.$uname.” “.$email.” “.$usertype.”
S.noNameUsernameEmailUser Type 
“.$count.”“.$name.”“.$uname.”“.$email.”“.$usertype.”
New User Register
Name

mobile

password

Email

 



Thanks