Panta

Members
  • Content count

    97
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Panta

  • Rank
    Newbie

Contact Methods

  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Gender
  • Location
    Nigeria
  • Interests
    dreams that will come true, One day i will stand and say "i've gotten what i want"

Recent Profile Visitors

739 profile views
  1. 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"; }
  2. please explain more
  3. 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;} }} ?>
  4. 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
  5. fixed
  6. 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"); ?>
  7. Fixed .
  8. I want to execute a script at a particular time. What i want is that i want a user after registration will wait for like 15 mins to be assigned to be paired with ob_start(); date_default_timezone_set('Africa/Lagos'); $exp_to_donate='1'; $exp_tobe_paid='2'; $paidto_redonate='3'; $redonated_exp_balance='4'; $balanced_exp_tobe_paid='5'; $mergestatus="no"; $awaiting='awaiting'; //adding time db just to get time $profvso = $flash->prepare("SELECT xtime FROM `merge` WHERE `sender`=:email"); $profvso->bindParam(':email',$_SESSION['login_user']); $profvso->execute(); $profjj = $profvso->fetch(); $currentPage = $_SERVER['PHP_SELF']; $currentTimestamp = strtotime(date('Y-m-d H:i:s')); //Define your startTime here in {Year-Month-Day Hour:Minute:Second} format $startTime = $profjj['xtime']; $startTimestamp = strtotime($startTime); $numOfSecondsToReload = $startTimestamp - $currentTimestamp; if($startTimestamp >= $currentTimestamp) { ?> <!--<p>Live at <?php //echo date('H:i', $startTimestamp); ?></p>--> <?php //assigning sponsor to user //check if anyone is qualifies to receive $place = $flash->prepare("SELECT * FROM `user` WHERE ((`level`=:exp_tobe_paid) OR (`level`=:redonated_exp_balance) OR (`level`=:balanced_exp_tobe_paid)) AND `merged`=:no LIMIT 1"); $place->bindParam(':exp_tobe_paid',$exp_tobe_paid); $place->bindParam(':redonated_exp_balance',$redonated_exp_balance); $place->bindParam(':balanced_exp_tobe_paid',$balanced_exp_tobe_paid); $place->bindParam(':no',$mergestatus); $place->execute(); if($place->rowCount() > 0) { $profin = $place->fetch(); $togethelp=$profin['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 if($merged!=="yes"){ $gonow = $flash->prepare("UPDATE `merge` SET `receiver`=:togethelp,`payment_time`=:payment_time WHERE `sender`=:email"); $gonow->bindParam(':email',$email); $gonow->bindParam(':togethelp',$togethelp); $gonow->bindParam(':payment_time',$payment_time); if($gonow->execute()){ $up= $flash->query("UPDATE `user` SET merged='yes' WHERE `email`='$email'"); $up2= $flash->query("UPDATE `user` SET merged='yes' WHERE `email`='$togethelp'"); } }//end of if there is someone to pay header( "refresh:$numOfSecondsToReload;$currentPage"); }//end of if the time is greater } //end of assign sponsor to user ?> . but the script i have doesnt allow them stay till 15mins. if you refresh the page twice it will assign someone to them which is not what i want. This is my script
  9. Thanks brother . it worked
  10. so how do i fix this in my code?
  11. 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>
  12. oh now i get that. Thanks so much. much love
  13. am yet to understand. does it mean the 0 that came out means the fields are empty? while i was sending in that from the form
  14. oh the javascript side, when i try loggin in it pop up "0".
  15. i did that now, but is not even leaving the index page. i mean that login page.