Panta

done already

thanks so much, i checked db.php and saw spaces causing it.

Thanks for effort, i printed it and the number is "1", i wish to know if there is another possible cause for it not redirecting

tried this and is not relocating

I tried this and it will not relocate to the address

yes is PDO object.

Please i dont know why the my little code do not run the header function - header('Location: http://www.example.com/'); Please i need ans. thanks <?php session_start(); //start the session for the page include("db.php"); //include database file //Check if page was entered by a submit button $user_name=$_POST['user_name']; //Get username !!FROM FORM!! $password=($_POST['password']); //Get name !!FROMFORM!! if (!empty($user_name) && !empty($password)) { $ck=$flash->prepare("SELECT * FROM `data` WHERE `user`=:user_name AND `password`=:password "); //get rows where the username or email address is allready registered $ck->bindParam(':user_name',$user_name); $ck->bindParam(':password',$password); $ck->execute(); //if email address allready excists if($ck->rowCount() > 0) { header('Location: http://www.example.com/'); }} ?>

the code is working fine.and printing see, the problem is getting the code to stop running after doing the job

i want a loop that will update all the rows in a table that met a certain condition.

Good day, please i want to update all that the time has elapsed a table (merged). I want the script to check for all that the current time is equals or greater than a fixed time. and update the colom (receiver). This i want the script to do see my code i tried using do-while but is not working <?php include "../../include/db.php"; $mergestatus="no"; $awaiting='awaiting'; $exp_to_donate='1'; $exp_tobe_paid='2'; $paidto_redonate='3'; $redonated_exp_balance='4'; //adding time db just to get time $new = $flash->query("SELECT * FROM `user` WHERE merged='awaiting' AND active='yes'"); if($new->rowCount() > 0){ echo "see"; $newrecord = $new->fetch(); $newsender=$newrecord['email']; echo $newsender; //adding time db just to get time $timeget = $flash->query("SELECT * FROM `merge` WHERE status='0' AND sender='$newsender'"); if($timeget->rowCount() > 0){ $xxx = $timeget->fetch(); $timeget_xtime=strtotime($xxx['xtime']); $currentTimestamp = strtotime(date('Y-m-d H:i:s')); $payment_time= date("Y-m-d H:i:s",strtotime(date("Y-m-d H:i:s")." +3 hours"));//adding 3hrs to the current time if($currentTimestamp >=$timeget_xtime ) { //checking for who to pay $placecheck = $flash->query("SELECT * FROM `user` WHERE `active`='yes' AND `right`='0' AND `merged`='no' AND (`level`='$exp_tobe_paid' OR `level`='$redonated_exp_balance') LIMIT 1"); if($placecheck->rowCount() > 0){ $ddd = $placecheck->fetch(); $togethelp=$ddd['email']; $gonow = $flash->query("UPDATE `merge` SET `receiver`='$togethelp',`payment_time`='$payment_time' WHERE `sender`='$newsender'"); $up= $flash->query("UPDATE `user` SET merged='yes' WHERE email IN ('$newsender','$togethelp')"); }//if there is someone active and not admin else{ $placeadmin = $flash->query("SELECT * FROM `user` WHERE `right`='1' LIMIT 1"); $profinadmin = $placeadmin->fetch(); $togethelpadmin=$profinadmin['email'];//sponsor email $payment_time= date("Y-m-d H:i:s",strtotime(date("Y-m-d H:i:s")." +3 hours"));//adding 3hrs to the current time $gonowadmin = $flash->query("UPDATE `merge` SET `receiver`='$togethelpadmin',`payment_time`='$payment_time' WHERE `sender`='$newsender'"); $upadmin= $flash->query("UPDATE `user` SET merged='yes' WHERE (`email`='$newsender')"); } }//if current time is above do{ //checking for who to pay $placecheck = $flash->query("SELECT * FROM `user` WHERE `active`='yes' AND `right`='0' AND `merged`='no' AND (`level`='$exp_tobe_paid' OR `level`='$redonated_exp_balance') LIMIT 1"); if($placecheck->rowCount() > 0){ $ddd = $placecheck->fetch(); $togethelp=$ddd['email']; $gonow = $flash->query("UPDATE `merge` SET `receiver`='$togethelp',`payment_time`='$payment_time' WHERE `sender`='$newsender'"); $up= $flash->query("UPDATE `user` SET merged='yes' WHERE email IN ('$newsender','$togethelp')"); }//if there is someone active and not admin else{ $placeadmin = $flash->query("SELECT * FROM `user` WHERE `right`='1' LIMIT 1"); $profinadmin = $placeadmin->fetch(); $togethelpadmin=$profinadmin['email'];//sponsor email $payment_time= date("Y-m-d H:i:s",strtotime(date("Y-m-d H:i:s")." +3 hours"));//adding 3hrs to the current time $gonowadmin = $flash->query("UPDATE `merge` SET `receiver`='$togethelpadmin',`payment_time`='$payment_time' WHERE `sender`='$newsender'"); $upadmin= $flash->query("UPDATE `user` SET merged='yes' WHERE (`email`='$newsender')"); } } while($currentTimestamp >=$timeget_xtime && ($timeget->rowCount() > 0)); }//if status is 0 in merge table }// if merge is awaiting in user table //end of assign sponsor to user ?>

ok thanks . let me check it

ok thanks bro

Thanks so much bro +rep

Please i dont know why this is not working fine, $unsetmerge=$flash->query("UPDATE `user` SET merged='no' WHERE email IN ('$emailuser','$togethelp')"); it will SET '$emailuser' to no but will not do same for '$togethelp' . i dont know what am not doing right and when i print $togethelp it contains the proper data

It do register to database when email has not been registered, and will not register when is existing.

i have done that ans is not working

please am not very good with javascript. i need this to display error that the email is already in use. but it keeps displaying success message. the php script is working fine. just the javascript side $(function() { $("#registerForm").find("input,textarea,select").jqBootstrapValidation({ preventSubmit: true, submitError: function($form, event, errors) { // additional error messages or events }, submitSuccess: function($form, event) { event.preventDefault(); // prevent default submit behaviour // get values from FORM var firstname = $("input#firstname").val(); var lastname = $("input#lastname").val(); var linked = $("input#linked").val(); var email = $("input#email").val(); var phone = $("input#phone").val(); var gender = $("select#gender").val(); var accountname = $("input#accountname").val(); var accountnumber = $("input#accountnumber").val(); var address = $("input#address").val(); var bankname = $("select#bankname").val(); var namenow = firstname; // For Success/Failure Message // Check for white space in name for Success/Fail message if (namenow.indexOf(' ') >= 0) { namenow = firstname.split(' ').slice(0, -1).join(' '); } $.ajax({ url: "././member/register.php", type: "POST", data: { firstname: firstname, lastname: lastname, linked: linked, email: email, phone: phone, gender: gender, bankname: bankname, accountnumber: accountnumber, accountname: accountname, address: address }, cache: false, success: function(result) { // Success message if(result=="1"){ $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); } else{ $('#success').html("<div class='alert alert-success'>"); $('#success > .alert-success').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-success') .append("<strong>Your Registeration is successful. Check your email/spam to validate. </strong>"); $('#success > .alert-success') .append('</div>'); //clear all fields $('#registerForm').trigger("reset");} }, error: function() { // Fail message $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); }, }) }, filter: function() { return $(this).is(":visible"); }, }); $("a[data-toggle=\"tab\"]").click(function(e) { e.preventDefault(); $(this).tab("show"); }); }); /*When clicking on Full hide fail/success boxes */ $('#firstname').focus(function() { $('#success').html(''); }); <?php session_start(); //start the session for the page date_default_timezone_set("Africa/Lagos"); include("../include/db.php"); //include database file include("../include/settings.php"); //include configuration file //Check if page was entered by a submit button $firstname=$_POST['firstname']; //Get username !!FROM FORM!! $firstname = ereg_replace(" ", "", $firstname); //take away all spaces from username (if any) !!FROM FORM!! $lastname=$_POST['lastname']; //Get name $linked=$_POST['linked']; //Get name $email=$_POST['email']; //Get email !!FROM FORM!! $email = ereg_replace(" ", "", $email); //take away all spaces from email (if any) !!FROM FORM!! $phone=$_POST['phone']; //Get email $gender=$_POST['gender']; //Get email $bankname=$_POST['bankname']; //Get email $accountname=$_POST['accountname']; //Get email $accountnumber=$_POST['accountnumber']; //Get email $address=$_POST['address']; //Get email $joined=date("Y-m-d H:i:s"); //check to see if the username or email allready excists $ck=$flash->prepare("SELECT * FROM `user` WHERE `email`=:email"); //get rows where the username or email address is allready registered $ck->bindParam(':email',$email); $ck->execute(); //if email address allready excists if($ck->rowCount() > 0){ //tell the user //echo "The email you selected ($email) has all ready been registered! Please press back and choose another"; //return false; echo "1"; }else{ //IF THE USER GOT TO HERE, THEN HES FILLED OUT ALL THE FORMS, THE PASSWORDS MATCH, AND ENTERED A VALID USERNAME AND EMAIL, SO CREATE THE ACCOUNT //add account to DB srand ((double) microtime( )*1000000); $random=rand(10000,100000000); //check to see if admin has enabled email confirmation if ($_emailconfirmation == "1"){ //add the info to the database $reg = $flash->prepare("INSERT INTO `user` ( email , firstname , lastname ,referral, bank , bank_account_name , bank_account_number, phone , gender ,address , token, joined) VALUES (:email, :firstname, :lastname, :linked, :bankname, :accountname,:accountnumber,:phone,:gender,:address, :random , :joined )"); $reg->bindParam(':email',$email); $reg->bindParam(':firstname',$firstname); $reg->bindParam(':lastname',$lastname); $reg->bindParam(':linked',$linked); $reg->bindParam(':bankname',$bankname); $reg->bindParam(':accountname',$accountname); $reg->bindParam(':accountnumber',$accountnumber); $reg->bindParam(':phone',$phone); $reg->bindParam(':gender',$gender); $reg->bindParam(':address',$address); $reg->bindParam(':random',$random); $reg->bindParam(':joined',$joined); if($reg->execute()){ $to = "$email"; $subject = "Email Confirmation"; $body = "Thankyou for registering! you will now need to visit: $_sitelink/member/verifyaccount.php?actkeycode=$random&email=$email"; //send confirmation email to the user to activate their account via a link mail($to, $subject, $body, "From: $_replyemail"); //let them know it went well die("Welcome $username! You have registered successfully!<br>An email has been sent to the registered email with a link you need to vist it activate your account!"); return true;} }} ?>

please am not very good with javascript. i need this to display error that the email is already in use. but it keeps displaying success message. the php script is working fine. just the javascript side $(function() { $("#registerForm").find("input,textarea,select").jqBootstrapValidation({ preventSubmit: true, submitError: function($form, event, errors) { // additional error messages or events }, submitSuccess: function($form, event) { event.preventDefault(); // prevent default submit behaviour // get values from FORM var firstname = $("input#firstname").val(); var lastname = $("input#lastname").val(); var linked = $("input#linked").val(); var email = $("input#email").val(); var phone = $("input#phone").val(); var gender = $("select#gender").val(); var accountname = $("input#accountname").val(); var accountnumber = $("input#accountnumber").val(); var address = $("input#address").val(); var bankname = $("select#bankname").val(); var namenow = firstname; // For Success/Failure Message // Check for white space in name for Success/Fail message if (namenow.indexOf(' ') >= 0) { namenow = firstname.split(' ').slice(0, -1).join(' '); } $.ajax({ url: "././member/register.php", type: "POST", data: { firstname: firstname, lastname: lastname, linked: linked, email: email, phone: phone, gender: gender, bankname: bankname, accountnumber: accountnumber, accountname: accountname, address: address }, cache: false, success: function(result) { // Success message if(result=="1"){ $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); } else{ $('#success').html("<div class='alert alert-success'>"); $('#success > .alert-success').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-success') .append("<strong>Your Registeration is successful. Check your email/spam to validate. </strong>"); $('#success > .alert-success') .append('</div>'); //clear all fields $('#registerForm').trigger("reset");} }, error: function() { // Fail message $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); }, }) }, filter: function() { return $(this).is(":visible"); }, }); $("a[data-toggle=\"tab\"]").click(function(e) { e.preventDefault(); $(this).tab("show"); }); }); /*When clicking on Full hide fail/success boxes */ $('#firstname').focus(function() { $('#success').html(''); }); <?php session_start(); //start the session for the page date_default_timezone_set("Africa/Lagos"); include("../include/db.php"); //include database file include("../include/settings.php"); //include configuration file //Check if page was entered by a submit button $firstname=$_POST['firstname']; //Get username !!FROM FORM!! $firstname = ereg_replace(" ", "", $firstname); //take away all spaces from username (if any) !!FROM FORM!! $lastname=$_POST['lastname']; //Get name $linked=$_POST['linked']; //Get name $email=$_POST['email']; //Get email !!FROM FORM!! $email = ereg_replace(" ", "", $email); //take away all spaces from email (if any) !!FROM FORM!! $phone=$_POST['phone']; //Get email $gender=$_POST['gender']; //Get email $bankname=$_POST['bankname']; //Get email $accountname=$_POST['accountname']; //Get email $accountnumber=$_POST['accountnumber']; //Get email $address=$_POST['address']; //Get email $joined=date("Y-m-d H:i:s"); //check to see if the username or email allready excists $ck=$flash->prepare("SELECT * FROM `user` WHERE `email`=:email"); //get rows where the username or email address is allready registered $ck->bindParam(':email',$email); $ck->execute(); //if email address allready excists if($ck->rowCount() > 0){ //tell the user //echo "The email you selected ($email) has all ready been registered! Please press back and choose another"; //return false; echo "1"; }else{ //IF THE USER GOT TO HERE, THEN HES FILLED OUT ALL THE FORMS, THE PASSWORDS MATCH, AND ENTERED A VALID USERNAME AND EMAIL, SO CREATE THE ACCOUNT //add account to DB srand ((double) microtime( )*1000000); $random=rand(10000,100000000); //check to see if admin has enabled email confirmation if ($_emailconfirmation == "1"){ //add the info to the database $reg = $flash->prepare("INSERT INTO `user` ( email , firstname , lastname ,referral, bank , bank_account_name , bank_account_number, phone , gender ,address , token, joined) VALUES (:email, :firstname, :lastname, :linked, :bankname, :accountname,:accountnumber,:phone,:gender,:address, :random , :joined )"); $reg->bindParam(':email',$email); $reg->bindParam(':firstname',$firstname); $reg->bindParam(':lastname',$lastname); $reg->bindParam(':linked',$linked); $reg->bindParam(':bankname',$bankname); $reg->bindParam(':accountname',$accountname); $reg->bindParam(':accountnumber',$accountnumber); $reg->bindParam(':phone',$phone); $reg->bindParam(':gender',$gender); $reg->bindParam(':address',$address); $reg->bindParam(':random',$random); $reg->bindParam(':joined',$joined); if($reg->execute()){ $to = "$email"; $subject = "Email Confirmation"; $body = "Thankyou for registering! you will now need to visit: $_sitelink/member/verifyaccount.php?actkeycode=$random&email=$email"; //send confirmation email to the user to activate their account via a link mail($to, $subject, $body, "From: $_replyemail"); //let them know it went well die("Welcome $username! You have registered successfully!<br>An email has been sent to the registered email with a link you need to vist it activate your account!"); return true;} }} ?>

is this correct? $ck=$flash->prepare("SELECT COUNT(email) FROM `user` WHERE `email`=:email"); //get rows where the username or email address is allready registered $ck->bindParam(':email',$email); $ck->execute(); //if email address allready excists if($ck->fetchAll() > 0){ //tell the user //echo "The email you selected ($email) has all ready been registered! Please press back and choose another"; //return false; echo "1"; }

please explain more

please am not very good with javascript. i need this to display error that the email is already in use. but it keeps displaying success message. the php script is working fine. just the javascript side $(function() { $("#registerForm").find("input,textarea,select").jqBootstrapValidation({ preventSubmit: true, submitError: function($form, event, errors) { // additional error messages or events }, submitSuccess: function($form, event) { event.preventDefault(); // prevent default submit behaviour // get values from FORM var firstname = $("input#firstname").val(); var lastname = $("input#lastname").val(); var linked = $("input#linked").val(); var email = $("input#email").val(); var phone = $("input#phone").val(); var gender = $("select#gender").val(); var accountname = $("input#accountname").val(); var accountnumber = $("input#accountnumber").val(); var address = $("input#address").val(); var bankname = $("select#bankname").val(); var namenow = firstname; // For Success/Failure Message // Check for white space in name for Success/Fail message if (namenow.indexOf(' ') >= 0) { namenow = firstname.split(' ').slice(0, -1).join(' '); } $.ajax({ url: "././member/register.php", type: "POST", data: { firstname: firstname, lastname: lastname, linked: linked, email: email, phone: phone, gender: gender, bankname: bankname, accountnumber: accountnumber, accountname: accountname, address: address }, cache: false, success: function(result) { // Success message if(result=="1"){ $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); } else{ $('#success').html("<div class='alert alert-success'>"); $('#success > .alert-success').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-success') .append("<strong>Your Registeration is successful. Check your email/spam to validate. </strong>"); $('#success > .alert-success') .append('</div>'); //clear all fields $('#registerForm').trigger("reset");} }, error: function() { // Fail message $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); }, }) }, filter: function() { return $(this).is(":visible"); }, }); $("a[data-toggle=\"tab\"]").click(function(e) { e.preventDefault(); $(this).tab("show"); }); }); /*When clicking on Full hide fail/success boxes */ $('#firstname').focus(function() { $('#success').html(''); }); <?php session_start(); //start the session for the page date_default_timezone_set("Africa/Lagos"); include("../include/db.php"); //include database file include("../include/settings.php"); //include configuration file //Check if page was entered by a submit button $firstname=$_POST['firstname']; //Get username !!FROM FORM!! $firstname = ereg_replace(" ", "", $firstname); //take away all spaces from username (if any) !!FROM FORM!! $lastname=$_POST['lastname']; //Get name $linked=$_POST['linked']; //Get name $email=$_POST['email']; //Get email !!FROM FORM!! $email = ereg_replace(" ", "", $email); //take away all spaces from email (if any) !!FROM FORM!! $phone=$_POST['phone']; //Get email $gender=$_POST['gender']; //Get email $bankname=$_POST['bankname']; //Get email $accountname=$_POST['accountname']; //Get email $accountnumber=$_POST['accountnumber']; //Get email $address=$_POST['address']; //Get email $joined=date("Y-m-d H:i:s"); //check to see if the username or email allready excists $ck=$flash->prepare("SELECT * FROM `user` WHERE `email`=:email"); //get rows where the username or email address is allready registered $ck->bindParam(':email',$email); $ck->execute(); //if email address allready excists if($ck->rowCount() > 0){ //tell the user //echo "The email you selected ($email) has all ready been registered! Please press back and choose another"; //return false; echo "1"; }else{ //IF THE USER GOT TO HERE, THEN HES FILLED OUT ALL THE FORMS, THE PASSWORDS MATCH, AND ENTERED A VALID USERNAME AND EMAIL, SO CREATE THE ACCOUNT //add account to DB srand ((double) microtime( )*1000000); $random=rand(10000,100000000); //check to see if admin has enabled email confirmation if ($_emailconfirmation == "1"){ //add the info to the database $reg = $flash->prepare("INSERT INTO `user` ( email , firstname , lastname ,referral, bank , bank_account_name , bank_account_number, phone , gender ,address , token, joined) VALUES (:email, :firstname, :lastname, :linked, :bankname, :accountname,:accountnumber,:phone,:gender,:address, :random , :joined )"); $reg->bindParam(':email',$email); $reg->bindParam(':firstname',$firstname); $reg->bindParam(':lastname',$lastname); $reg->bindParam(':linked',$linked); $reg->bindParam(':bankname',$bankname); $reg->bindParam(':accountname',$accountname); $reg->bindParam(':accountnumber',$accountnumber); $reg->bindParam(':phone',$phone); $reg->bindParam(':gender',$gender); $reg->bindParam(':address',$address); $reg->bindParam(':random',$random); $reg->bindParam(':joined',$joined); if($reg->execute()){ $to = "$email"; $subject = "Email Confirmation"; $body = "Thankyou for registering! you will now need to visit: $_sitelink/member/verifyaccount.php?actkeycode=$random&email=$email"; //send confirmation email to the user to activate their account via a link mail($to, $subject, $body, "From: $_replyemail"); //let them know it went well die("Welcome $username! You have registered successfully!<br>An email has been sent to the registered email with a link you need to vist it activate your account!"); return true;} }} ?>

Thanks but i have fixed it. i am using ID not name, the problem was that i did not clear cacher . i did that and it started working fine. Thanks for looking into the script

fixed

i have a working registration form, but when i try to add a new form field "linked" it dosent send data to database. but when i remove it then it works fine. these are my codes <form name="register" id="registerForm" novalidate> <div class="form-group"> <label for="exampleInputEmail1">First name</label> <input type="text" class="form-control" id="firstname" name="txtfullname" placeholder="First name" required data-validation-required-message="Please enter your First name."> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Last name</label> <input type="text" class="form-control" id="lastname" name="txtfullname" placeholder="Last name" required data-validation-required-message="Please enter your Last name."> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Last name</label> <input type="text" class="form-control" id="linked" name="txtfullname" placeholder="Last name" required data-validation-required-message="Please enter your Last name."> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Email address</label> <div class="input-group date"> <div class="input-group-addon"> <i class="fa fa-envelope"></i> </div> <input type="email" class="form-control" name="txtemail" id="email" placeholder="Enter email" required data-validation-required-message="Please enter your Email."> </div> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label>Phone Number</label> <div class="input-group date"> <div class="input-group-addon"> <i class="fa fa-phone"></i> </div> <input type="tel" class="form-control pull-right" id="phone" name="txtbdate" placeholder="Enter email" required data-validation-required-message="Please enter your Phone number."> </div> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label>Gender</label> <select class="form-control" id="gender" required data-validation-required-message="Please enter your Gender."> <option value=""></option> <option>Male</option> <option>Female</option> </select> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label>Bank</label> <select class="form-control" id="bankname" required data-validation-required-message="Please enter your Phone Bank."> <option value="" ></option> <option value="Access Bank Plc" >Access Bank Plc</option> <option value="Diamond Bank Limited">Diamond Bank Limited</option> <option value="Ecobank Nigeria Plc">Ecobank Nigeria Plc</option> <option value="Equitorial Trust Bank Limited" >Equitorial Trust Bank Limited</option> <option value="Fidelity Bank Plc">Fidelity Bank Plc</option> <option value="First Bank of Nigeria Plc.">First Bank of Nigeria Plc.</option> <option value="First City Monument Bank Ltd." >First City Monument Bank Ltd.</option> <option value="Guaranty Trust Bank Plc.">Guaranty Trust Bank Plc.</option> <option value="Intercontinental Bank Ltd.">Intercontinental Bank Ltd.</option> <option value="StanbicIBTC Bank" >StanbicIBTC Bank</option> <option value="Standard Chartered Bank Nigeria Ltd">Standard Chartered Bank Nigeria Ltd</option> <option value="Sterling Bank Plc">Sterling Bank Plc</option> <option value="Union Bank of Nigeria Plc." >Union Bank of Nigeria Plc.</option> <option value="United Bank for Africa Plc.">United Bank for Africa Plc.</option> <option value="Unity Bank">Unity Bank</option> <option value="Wema Bank Plc." >Wema Bank Plc.</option> <option value="Zenith International Bank Ltd.">Zenith International Bank Ltd.</option> </select> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Account name</label> <input type="text" class="form-control" id="accountname" placeholder="Account name" required data-validation-required-message="Please enter your account name."> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Account number</label> <input type="tel" class="form-control" id="accountnumber" placeholder="Account number" required data-validation-required-message="Please enter your account number."> <p class="help-block text-danger"></p> </div> <div class="form-group"> <label for="exampleInputEmail1">Present Address</label> <input type="text" class="form-control" id="address" placeholder="Present Address" required data-validation-required-message="Please enter your address."> <p class="help-block text-danger"></p> </div> <div class="clearfix"></div> <div class="col-lg-12 text-center"> <div id="success"></div> <button type="submit" class="btn btn-primary">Register</button> </div> </form> $(function() { $("#registerForm").find("input,textarea,select").jqBootstrapValidation({ preventSubmit: true, submitError: function($form, event, errors) { // additional error messages or events }, submitSuccess: function($form, event) { event.preventDefault(); // prevent default submit behaviour // get values from FORM var firstname = $("input#firstname").val(); var lastname = $("input#lastname").val(); var linked = $("input#linked").val(); var email = $("input#email").val(); var phone = $("input#phone").val(); var gender = $("select#gender").val(); var accountname = $("input#accountname").val(); var accountnumber = $("input#accountnumber").val(); var address = $("input#address").val(); var bankname = $("select#bankname").val(); var namenow = firstname; // For Success/Failure Message // Check for white space in name for Success/Fail message if (namenow.indexOf(' ') >= 0) { namenow = firstname.split(' ').slice(0, -1).join(' '); } $.ajax({ url: "././member/register.php", type: "POST", data: { firstname: firstname, lastname: lastname, linked: linked, email: email, phone: phone, gender: gender, bankname: bankname, accountnumber: accountnumber, accountname: accountname, address: address }, cache: false, success: function() { // Success message $('#success').html("<div class='alert alert-success'>"); $('#success > .alert-success').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-success') .append("<strong>Your Registeration is successful. Check your email/spam to validate. </strong>"); $('#success > .alert-success') .append('</div>'); //clear all fields $('#registerForm').trigger("reset"); }, error: function() { // Fail message $('#success').html("<div class='alert alert-danger'>"); $('#success > .alert-danger').html("<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;") .append("</button>"); $('#success > .alert-danger').append("<strong>Sorry " + namenow + ", it seems that my mail server is not responding. Please try again later!"); $('#success > .alert-danger').append('</div>'); //clear all fields $('#registerForm').trigger("reset"); }, }) }, filter: function() { return $(this).is(":visible"); }, }); $("a[data-toggle=\"tab\"]").click(function(e) { e.preventDefault(); $(this).tab("show"); }); }); /*When clicking on Full hide fail/success boxes */ $('#firstname').focus(function() { $('#success').html(''); }); <?php session_start(); //start the session for the page date_default_timezone_set("Africa/Lagos"); include("../include/db.php"); //include database file include("../include/settings.php"); //include configuration file //Check if page was entered by a submit button $firstname=$_POST['firstname']; //Get username !!FROM FORM!! $firstname = ereg_replace(" ", "", $firstname); //take away all spaces from username (if any) !!FROM FORM!! $lastname=$_POST['lastname']; //Get name $linked=$_POST['linked']; //Get name $email=$_POST['email']; //Get email !!FROM FORM!! $email = ereg_replace(" ", "", $email); //take away all spaces from email (if any) !!FROM FORM!! $phone=$_POST['phone']; //Get email $gender=$_POST['gender']; //Get email $bankname=$_POST['bankname']; //Get email $accountname=$_POST['accountname']; //Get email $accountnumber=$_POST['accountnumber']; //Get email $address=$_POST['address']; //Get email $joined=date("Y-m-d H:i:s"); //check to see if the username or email allready excists $ck=$flash->prepare("SELECT * FROM `user` WHERE `email`=:email"); //get rows where the username or email address is allready registered $ck->bindParam(':email',$email); $ck->execute(); //if email address allready excists if($ck->rowCount() > 0){ //tell the user echo "The email you selected ($email) has all ready been registered! Please press back and choose another"; include("loginform.php"); die(); } //IF THE USER GOT TO HERE, THEN HES FILLED OUT ALL THE FORMS, THE PASSWORDS MATCH, AND ENTERED A VALID USERNAME AND EMAIL, SO CREATE THE ACCOUNT //add account to DB srand ((double) microtime( )*1000000); $random=rand(10000,100000000); //check to see if admin has enabled email confirmation if ($_emailconfirmation == "1"){ //add the info to the database $reg = $flash->prepare("INSERT INTO `user` ( email , firstname , lastname ,referral, bank , bank_account_name , bank_account_number, phone , gender ,address , token, joined) VALUES (:email, :firstname, :lastname, :linked, :bankname, :accountname,:accountnumber,:phone,:gender,:address, :random , :joined )"); $reg->bindParam(':email',$email); $reg->bindParam(':firstname',$firstname); $reg->bindParam(':lastname',$lastname); $reg->bindParam(':linked',$linked); $reg->bindParam(':bankname',$bankname); $reg->bindParam(':accountname',$accountname); $reg->bindParam(':accountnumber',$accountnumber); $reg->bindParam(':phone',$phone); $reg->bindParam(':gender',$gender); $reg->bindParam(':address',$address); $reg->bindParam(':random',$random); $reg->bindParam(':joined',$joined); if($reg->execute()){ $to = "$email"; $subject = "Email Confirmation"; $body = "Thankyou for registering! you will now need to visit: $_sitelink/member/verifyaccount.php?actkeycode=$random&email=$email"; //send confirmation email to the user to activate their account via a link mail($to, $subject, $body, "From: $_replyemail"); //let them know it went well die("Welcome $username! You have registered successfully!<br>An email has been sent to the registered email with a link you need to vist it activate your account!"); } } include("loginform.php"); ?>

Fixed .