Jump to content

Panta

Members
  • Posts

    115
  • Joined

  • Last visited

Posts posted by Panta

  1. 5 minutes ago, iwato said:

    Yes.  Is there anything in the included file db.php that produces printed output -- say, an echo(), print_r(), or similar such statement?

    Roddy

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

  2. On 2/13/2018 at 2:53 AM, Ingolme said:

    You need to do some debugging. You can't just copy some code and give up when the code doesn't work. Look for solutions.

    You have one single condition to test for here:

    
    if($row['amount'] > 0) {
      header('Location: http://www.example.com/');
    }

    If it redirects, then the count is greater than zero, if it does not redirect then the count is zero or less. You have to do some debugging to find out why this number is zero or less. To start off, print the number. Since it's not redirecting, my guess is that the number is zero, but you should check to make sure.

    Once you have verified that the number is actually zero then that's clear evidence that the database table does not have any rows that match your query. Maybe there's something wring with your query. The query has two inputs, $user_name and $password. Print out both their values, then check the database table for yourself using phpMyAdmin or similar software to see if there is a row that contains both of those values. There are two possibilities: The values you passed into the query are wrong or the database actually does not contain that data.

    I can't tell you why the code is not working, but I've just told you how you can find out.

     

    On 2/12/2018 at 4:23 PM, iwato said:

    Insert the following code

    
    echo $row['amount'];

    after the following line of code

    
    $row = $cf->fetch(PDO::FETCH_ASSOC);

    and see if its value is, indeed, greater than zero.  For, if it is not, you have not met the condition of the if-statement in which the header() function is located.

    Roddy

    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

  3. On 2/5/2018 at 3:58 PM, iwato said:

    Eliminate all  blank spaces  before the header() function is invoked.  There should be no blank lines, and no blank spaces after each EOL delimiter.  This is, by far, the most common source of a failed header() function.  Well, at least in my experience.

    Roddy

    tried this and is not relocating

  4. On 2/10/2018 at 9:11 PM, Ingolme said:

    The rowCount() method usually only tells you how many rows were updated or deleted in the most recent query. See details here: http://php.net/manual/en/pdostatement.rowcount.php

    If you want to check that there were any results, you should use the fetch() method. Since all you're doing is checking that a row exists, it is inefficient to select *, because that's pulling all of the data in the row, which you don't need. Instead you should count the rows.

    
    // Count rows where the user exists 
    $ck=$flash->prepare("SELECT COUNT(*) AS `amount` FROM `data` WHERE `user`=:user_name  AND `password`=:password ");
    $ck->bindParam(':user_name',$user_name);
    $ck->bindParam(':password',$password);
    $ck->execute();
    $row = $cf->fetch(PDO::FETCH_ASSOC);
    if($row['amount'] > 0) {
      header('Location: http://www.example.com/');
    }

     

    I tried this and it will not relocate to the address

  5. 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/');
    }}
    ?>

  6. 6 hours ago, justsomeguy said:

    Is the rest of that code working?  For example, with this:

     

    
    if($new->rowCount() > 0){
        echo "see";

     

    Does that get printed?  I'm pretty sure we went over in another thread how rowCount does not work with select queries on all databases, and you should not use rowCount to determine if a select query returned any records.  It says that right in the documentation for rowCount too:

     

     

    The other problem is that your loop will never end.  You have this condition:

     

    
    while($currentTimestamp >=$timeget_xtime && ($timeget->rowCount() > 0))

     

    But inside the loop you do not change $currentTimestamp, $timeget_xtime, or $timeget, so if that condition is true then the loop will never end.

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

  7. 43 minutes ago, justsomeguy said:

    I don't quite understand what you're trying to do, or what your code is actually doing (saying it's "not working" doesn't explain much), but a do/while loop will loop 1 or more times, it always runs at least once.  A regular while loop will loop 0 or more times, it might not loop at all if the condition isn't true.  Is that what you want, a loop that runs 1 or more times?

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

  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. 13 hours ago, Gabrielphp said:

    Why use success and error ajax functions when you can use .done and .fail? .done and then you do all the checks in the php script even the return so that way you don't need to do that much of a javascript code in order to display an message.

    For example my way i use to display messages with jquery is very simple. For example

    index.php

    
    <div id="return_php" style="display: none;"></div>
    
    <form id="test">
      <input type="text" name="something" placeholder="Insert something ...">
      <input type="submit">
    </form>
    
    <script>
      $('#test').submit(function(e){
        e.preventDefault();
      	$.ajax({
        	url: 'path/to/something.php',
          	data: $(this).serialize(),
          	dataType: 'html',
          	type: 'POST'
        })
        .done(function(data){
        	$('#return_php').fadeIn(400).html(data).delay(5000).fadeOut(400);
        })
        .fail(function(){
        	$('#return_php').fadeIn(400).html('Something went wrong with the ajax script !').delay(5000).fadeOut(400);
        })
      });
    </script>

    This way you just call the php page in which you do the checks and whatever stuff and then you echo an alert which will then be displayed into the return_php div.

    The .delay(5000) acts as a delay for the fadeOut function, after 5 seconds the message will fade away.

    something.php

    
    $something = $_POST['something'];
    
    if(empty($something))
    {
    	echo "Something needs to be filled in !"; //This message will be then returned into the div return_php on the index.php page
    }
    else
    {
    	//Example of database
    	try {
    		$sql = "SELECT something FROM something WHERE something = :something";
    		$stmt = $db->prepare($sql); //$db is from a config file you have to include
    		$stmt->bindParam(":something", $something);
    		$stmt->execute();
    		$rowCount = $stmt->rowCount(); //This works for every case, at least i use it this way and for me works just fine.
    		
    		if($rowCount > 0) //let us presume that the something has more rows
    		{
    			echo "Ok, there is something in that something !";
    		}
    		else
    		{
    			echo "There is nothing in something with the something you typed !";
    		}
    	} catch (PDOException $e)
    	{
    		echo "Error: " . $e->getMesage(); //This will be showed into the return div aswell as the echo is still a part of this page, and this page is called by ajax.
    	}
    }

    Now, this is my way to do it time to time when i need live php script calling on my page without needing my page to refresh. Hope it helped at least for your issue with displaying messages.

    EDIT

    I've read again through your post and i think i figured out what is all about. When i try to use that ereg_replace() php function is always throwing me an Uncaught error as the function doesn't exist. This may be influencing how you are selecting the data by that variable. Instead of ereg_replace use preg_replace, It does the same thing.

    
    $email = $_POST['email'];
    $email = preg_replace('/\s+/, '', $email);

    NOTE! Some of the code i wrote may or may not fit your code if you copy paste it as it doesn't contain the same variables or functions that you wrote. You may need to adapt it to your use.

    Thanks so much bro +rep

    • Like 1
  10. 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

  11. On 4/25/2017 at 8:21 PM, justsomeguy said:

    How do you know the PHP is working fine?  What is the response that you see in your developer tools when you validate that with an email that already exists?

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

  12. 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;}
      }}
       
    
    ?>

     

  13. 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;}
      }}
       
    
    ?>

     

  14. 12 minutes ago, justsomeguy said:

    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"; }

     

  15. 15 minutes ago, justsomeguy said:

    The PDO rowCount function doesn't return the number of rows returned by the select statement for most databases, so instead of that you should send a query where you select the count.

    please explain more

  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. 1 minute ago, dsonesuk said:

    You have 3 inputs for first name, last name, and linked using the same value for name attribute 'txtfullname' it should be different for for each.

    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

  18. 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");
    ?>
    

     

  19. 14 minutes ago, Panta said:

    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

    Fixed .

×
×
  • Create New...