Jump to content

Panta

Members
  • Content count

    115
  • Joined

  • Last visited

Everything posted by Panta

  1. header function not functioning

    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/'); }} ?>
  2. header function not functioning

    done already
  3. header function not functioning

    thanks so much, i checked db.php and saw spaces causing it.
  4. header function not functioning

    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
  5. header function not functioning

    tried this and is not relocating
  6. header function not functioning

    I tried this and it will not relocate to the address
  7. header function not functioning

    yes is PDO object.
  8. 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 ?>
  9. the code is working fine.and printing see, the problem is getting the code to stop running after doing the job
  10. i want a loop that will update all the rows in a table that met a certain condition.
  11. WHERE IN SQL NOT WORKING WELL

    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
  12. WHERE IN SQL NOT WORKING WELL

    ok thanks . let me check it
  13. WHERE IN SQL NOT WORKING WELL

    ok thanks bro
  14. what error to display from php

    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;} }} ?>
  15. what error to display from php

    Thanks so much bro +rep
  16. 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;} }} ?>
  17. i want to display error from php

    It do register to database when email has not been registered, and will not register when is existing.
  18. 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;} }} ?>
  19. what error to display from php

    i have done that ans is not working
  20. what error to display from php

    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"; }
  21. what error to display from php

    please explain more
  22. Others working but just 1

    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"); ?>
  23. Others working but just 1

    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
  24. Others working but just 1

    fixed
  25. please i have a function that gets time for me. Now i want to display the time twice on a page but is not displaying twice. it only displays just onces this is my code now when i repeat this <!--<span id="timeleftpay"> </span> it doesnt display again <script language="JavaScript"> <!-- var year = <?php echo $ydfx; ?>; // in what year will your target be reached? var month = <?php echo ($mdfx-1); ?>; // value between 0 and 11 (0=january,1=february,...,11=december) var day = <?php echo $ddfx; ?>; // between 1 and 31 var hour = <?php echo $hdfx; ?>; // between 0 and 24 var minute = <?php echo $idfx; ?>; // between 0 and 60 var second = <?php echo $sdfx; ?>; // between 0 and 60 var eventtext = " left to make payment"; // text that appears next to the time left var endtext = " made payment!!"; // text that appears when the target has been reached var end = new Date(year,month,day,hour,minute,second); function timeleftpay(){ var now = new Date(); if(now.getYear() < 1900) yr = now.getYear() + 1900; var sec = second - now.getSeconds(); var min = minute - now.getMinutes(); var hr = hour - now.getHours(); var dy = day - now.getDate(); var mnth = month - now.getMonth(); var yr = year - yr; var daysinmnth = 32 - new Date(now.getYear(),now.getMonth(), 32).getDate(); if(sec < 0){ sec = (sec+60)%60; min--; } if(min < 0){ min = (min+60)%60; hr--; } if(hr < 0){ hr = (hr+24)%24; dy--; } if(dy < 0){ dy = (dy+daysinmnth)%daysinmnth; mnth--; } if(mnth < 0){ mnth = (mnth+12)%12; yr--; } var sectext = " seconds "; var mintext = " minutes, and "; var hrtext = " hours, "; var dytext = " days, "; var mnthtext = " months, "; var yrtext = " years, "; if (yr == 1) yrtext = " year, "; if (mnth == 1) mnthtext = " month, "; if (dy == 1) dytext = " day, "; if (hr == 1) hrtext = " hour, "; if (min == 1) mintext = " minute, and "; if (sec == 1) sectext = " second "; if(now >= end){ document.getElementById("timeleftpay").innerHTML = endtext; clearTimeout(timerID); } else{ document.getElementById("timeleftpay").innerHTML = dy + dytext + hr + hrtext + min + mintext + sec + sectext + eventtext; } timerID = setTimeout("timeleftpay()", 1000); } window.onload = timeleftpay; //--> </script> <!--<span id="timeleftpay"> </span>
×