script.php

<?php

             use PHPMailer\PHPMailer\PHPMailer;
            use PHPMailer\PHPMailer\Exception;
            

session_start();
include('connection.php');
if(isset($_POST['bitcoin_deposit'])){


    $email = $_POST['email'];
    $amount = (float)$_POST['amount'];
    $transaction_id = $_POST['transaction_id'];
    $currency_type = $_POST['currency_type'];

    $query = "INSERT INTO deposit_history (transaction_id, user_email, amount, date, currency_type, status)
										 VALUES('$transaction_id', '$email', '$amount', now(), '$currency_type', '0')";

    $result = mysqli_query($myConn, $query);

    if ($result == TRUE) {

                
              $headers = array(
               'From' => 'support@fxglobalequity.com',
               'Reply-To' => 'support@fxglobalequity.com',
              'X-Mailer' => 'PHP/' . phpversion()
            );
            $to1 = "support@fxglobalequity.com";
            $subject = 'Bitcoin deposit';
            $txt1 = "$email has made a bitcoin deposit on the website<br>
            Amount:$amount<br>
            Transaction Id:$transaction_id
            
                    
            ";
            mail($to1,$subject,$txt1,$headers);
            
            ?>
            <script type="text/javascript">
               alert('Deposit was successfull');
                window.location = "deposit.php";
            </script>
<?php

        }
        else{

            echo mysqli_error($myConn);
        }


}
if(isset($_POST['ethereum_deposit'])){


    $email = $_POST['email'];
    $amount = (float)$_POST['amount'];
    $transaction_id = $_POST['transaction_id'];
    $currency_type = $_POST['currency_type'];

    $query = "INSERT INTO deposit_history (transaction_id, user_email, amount, date, currency_type, status)
										 VALUES('$transaction_id', '$email', '$amount', now(), '$currency_type', '0')";

    $result = mysqli_query($myConn, $query);

    if ($result == TRUE) {

                
              $headers = array(
               'From' => 'support@fxglobalequity.com',
               'Reply-To' => 'support@fxglobalequity.com',
              'X-Mailer' => 'PHP/' . phpversion()
            );
            $to1 = "support@fxglobalequity.com";
            $subject = 'Litecoin deposit';
            $txt1 = "$email has made a Litecoin deposit on <br>
            Amount:$amount<br>
            Transaction Id:$transaction_id
            
                    
            ";
            mail($to1,$subject,$txt1,$headers);
            
            ?>
            <script type="text/javascript">
               alert('Deposit was successfull');
                window.location = "deposit.php";
            </script>
<?php

        }
        else{

            echo mysqli_error($myConn);
        }


}

if(isset($_POST['bitcoin_withdraw'])){


    $email = $_POST['email'];
    $amount = (float)$_POST['amount'];
    $transaction_id = substr(str_shuffle(uniqid() . "00"), 0, 12);
    $add = $_POST['address'];

    $query = "INSERT INTO withdrawl_history (transaction_id, user_email, amount, date, currency_type, status,address)
										 VALUES('$transaction_id', '$email', '$amount', now(), 'dollar', '0','$add')";

    $result = mysqli_query($myConn, $query);

    if ($result == TRUE) {

              $headers = array(
               'From' => 'support@fxglobalequity.com',
               'Reply-To' => 'support@fxglobalequity.com',
              'X-Mailer' => 'PHP/' . phpversion()
            );
            $to1 = "support@fxglobalequity.com";
            $subject = 'Bitcoin Withdraw';
            $txt1 = "$email has submitted a withdraw application<br>
            Bitcoin address:$add<br>
            Amount:$amount<br>
            Transaction Id:$transaction_id
            
                    
            ";
            mail($to1,$subject,$txt1,$headers);
            


            ?>
            <script type="text/javascript">
               alert('Withdraw has been submitted successfully');
                window.location = "withdraw.php";
            </script>
<?php

        }
        else{

            echo mysqli_error($myConn);
        }


}

if(isset($_POST['paypal'])){


    $email = $_POST['email'];
    $amount = (float)$_POST['amount'];
    $transaction_id = $_POST['transaction_id'];
    $currency_type = $_POST['currency_type'];

    $query = "INSERT INTO deposit_history (transaction_id, user_email, amount, date, currency_type, status)
										 VALUES('$transaction_id', '$email', '$amount', now(), '$currency_type', '0')";

    $result = mysqli_query($myConn, $query);



    if ($result == TRUE) {

                 $headers = array(
               'From' => 'support@fxglobalequity.com',
               'Reply-To' => 'support@fxglobalequity.com',
              'X-Mailer' => 'PHP/' . phpversion()
            );
            $to1 = "support@fxglobalequity.com";
            $subject = 'Paypal deposit';
            $txt1 = "$email has made a Paypal deposit <br>
            Amount:$amount<br>
            Transaction Id:$transaction_id
            
                    
            ";
            mail($to1,$subject,$txt1,$headers);
            
            
        ?>
        <script type="text/javascript">
            alert('Deposit was successfull');
            window.location = "deposit.php";
        </script>
        <?php

    }
    else{

        echo mysqli_error($myConn);
    }


}

if(isset($_POST['ether_deposit'])){

    $email = $_POST['email'];
    $amount = (float)$_POST['amount'];
    $transaction_id = $_POST['transaction_id'];
    $currency_type = $_POST['currency_type'];

    $query = "INSERT INTO deposit_history (transaction_id, user_email, amount, date, currency_type, status)
										 VALUES('$transaction_id', '$email', '$amount', now(), '$currency_type', '0')";

    $result = mysqli_query($myConn, $query);

    if ($result == TRUE) {


        ?>
        <script type="text/javascript">
            alert('Deposit Made');
            window.location = "deposit.php";
        </script>
        <?php

    }
    else{

        echo mysqli_error($myConn);
    }


}


                        if(isset($_POST['sign_in'])) {
                            include('connection.php');
                            $email = $_POST['email'];
                            $password = $_POST['password'];
                            $sql = "SELECT * FROM users WHERE user_email = '$email' AND user_password = '$password'";
                            $result = mysqli_query($myConn, $sql);
                            if($result->num_rows == 1) {
                                $row = mysqli_fetch_array($result, MYSQLI_BOTH);
                                $_SESSION['user_email'] = $row['user_email'];
                                $_SESSION['user_name'] = $row['user_name']; ?>
                                <script type="text/javascript">

                                    window.location = "dashboard/account/home.php";
                                </script>
//
                         <?php   }
                            else{
                             ?>
                                <script type="text/javascript">
                                    alert('Invalid Email or Password');
                                    window.location = "login";
                                </script>
                          <?php  }

                        }
                        ?>



<?php
if(isset($_POST['register'])) {
    include('connection.php');

    $name = $_POST['name'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $reg_plan = $_POST['reg_plan'];
    $account_manager = $_POST['account_manager'];
   
   // $ref = $_POST['refer'];

    $to = $email;
    $subject = "Welcome to Fx Global Equity";
    $txt = "Thank you for registering with us, find your login details below: <br> email:" . $email . " <br> Password:" . $password . ".";
    $headers = array(
        'From' => 'support@fxglobalequity.com',
        'Reply-To' => 'support@fxglobalequity.com',
        'X-Mailer' => 'PHP/' . phpversion()
    );

    $check_email = "SELECT * FROM users WHERE user_email = '$email'";
    $result = mysqli_query($myConn, $check_email);
    if ($result->num_rows > 0) { ?>

        <script type="text/javascript">
            alert('Email Already Exists, please try to log in');
            window.location = "sign-in.php";
        </script>

  <?php   } else {
//



        $query = "INSERT INTO users (user_email, user_name, user_password, bitcoin_balance, ethereum_balance, bitcoin_cash_balance, date, type, account_manager)
										 VALUES('$email', '$name', '$password', '0', '0', '0', now(), '$reg_plan', '$account_manager')";

        $result = mysqli_query($myConn, $query);
        //echo mysqli_error($myConn);exit();
        if ($result == TRUE) {

          echo "  <script type='text/javascript'>
                    alert('Registration Successful, Check your Mail for details');
                    window.location = 'login/index.php';
                </script>";
                

            $to1 = "support@fxglobalequity.com";
            $subject = 'user Registeration';
            $txt1 = "$name just created an account on Fx Global Equity
                    
            ";
            mail($to1,$subject,$txt1,$headers);
            
             mail($to, $subject, $txt, $headers);

          
            /**
             * This example shows sending a message using PHP's mail() function.
             */
            
            
            /* Exception class. */
            require 'PHPMailer-master/src/Exception.php';
            
            /* The main PHPMailer class. */
            require 'PHPMailer-master/src/PHPMailer.php';
            
            /* SMTP class, needed if you want to use SMTP. */
            require 'PHPMailer-master/src/SMTP.php';

         //   require 'mailer/PHPMailerAutoload.php';

//Create a new PHPMailer instance
            $mail = new PHPMailer;
//Set who the message is to be sent from
            $mail->setFrom('support@fxglobalequity.com', 'support@fxglobalequity.com');
//Set an alternative reply-to address
            $mail->addReplyTo('noreply@elitemining.com', 'support@fxglobalequity.com');
//Set who the message is to be sent to
            $mail->addAddress($email, $name);
//Set the subject line
            $mail->Subject = 'Welcome to Fx Global Equity';
//Read an HTML message body from an external file, convert referenced images to embedded,
//convert HTML into a basic plain-text alternative body
            $mail->msgHTML(file_get_contents('contents.html'), dirname(__FILE__));
//Replace the plain text body with one created manually
            $mail->AltBody = 'Thank you for registering with us, find your login details below: <br> email:' . $email . ' <br> Password:' . $password . '.';
//Attach an image file
            $mail->addAttachment('images/phpmailer_mini.png');

            $mail->Body    = '<p> Thank you for becoming a part of the trading community at Fx Global Equity , 
where trading makes sense. Fx Global Equity Trade Ltd is one the world\'s leading regulated online trading brokers.
 To ensure the safest and securest trading experience possible, it is fully regulated by various regulators. Exclusively on Fx Global Equity ! Introducing Fx Global Equity Rewards, loyalty programme awarding you Cashback for every trade you make. As a Fx Global Equity trader, you will benefit from:
  <br>• Fx Global Equity  Rewards – The loyalty programme that awards you Cashback for every trade you make. 
 <br> • MassInsights  Technology- Live Stream of Market Events & Aggregated Trader Behaviour 
 <br> • Fully Regulated and Secure Trading Environment. 
 <br> • 24/7 support and a Personal Trading Consultant.
 
 <br>find your login details below:</p></br>'
                .'Email: '.$email.'</br>'
                .'Password: '.$password.'</br>';

//send the message, check for errors
            if (!$mail->send()) { ?>
                
                <script type="text/javascript">
                    alert('An email error occurred fool');
                    window.location = "register/index.hmtl";
                </script>
           <?php } else { ?>
                
           <?php }



             } else {
             
             echo mysqli_error($myConn);exit();
             ?>
             
            <script type="text/javascript">
                alert('query error');
                window.location = "register/index.html";
            </script>
    <?php    }

    }
}

?>


<?php
if(isset($_POST['set_password'])) {
    include('connection.php');


    $password = $_POST['password'];
    $email = $_SESSION['user_email'];
    //get old password
    $query_userdetails = "SELECT * FROM users WHERE user_email = '$email'";
    $result = mysqli_query($myConn, $query_userdetails);
    $row = mysqli_fetch_array($result, MYSQLI_BOTH);
    if($row){
        if($row['user_password'] == $_POST['old_password']){
    $update_history =  "UPDATE users SET user_password = '$password' WHERE  user_email = '$email'";



    $result = mysqli_query($myConn, $update_history);
    if ($result == true) {

         require 'PHPMailer-master/src/Exception.php';
            
            /* The main PHPMailer class. */
            require 'PHPMailer-master/src/PHPMailer.php';
            
            /* SMTP class, needed if you want to use SMTP. */
            require 'PHPMailer-master/src/SMTP.php';

//Create a new PHPMailer instance
        $mail = new PHPMailer;
//Set who the message is to be sent from
        $mail->setFrom('support@Fx Global Equity.com', 'Fx Global Equity.com');
//Set an alternative reply-to address
        $mail->addReplyTo('noreply@Fx Global Equity.com', 'Fx Global Equity.com');
//Set who the message is to be sent to
        $mail->addAddress($email, 'password Change');
//Set the subject line
        $mail->Subject = 'Password Change Activity on Account';
//Read an HTML message body from an external file, convert referenced images to embedded,
//convert HTML into a basic plain-text alternative body
 //Replace the plain text body with one created manually
        $mail->AltBody = 'Thank you for registering with us, find your login details below: <br> email:' . $email . ' <br> Password:' . $password . '.';
//Attach an image file
        $mail->addAttachment('images/phpmailer_mini.png');

        $mail->Body    = '<b>Your Password has been Changed:</b></br>'
            .'Email: '.$email.'</br>'
            .'New Password: '.$password.'</br>';

//send the message, check for errors
       ?>
            <script type="text/javascript">
                alert('Password Changed Successfully');
                window.location = "account.php";
            </script>
        <?php 

         } else { ?>


        <script type="text/javascript">
            alert('Email Already Exists, please try to log in');
            window.location = "sign-in.php";
        </script>

 <?php }}else{ ?>
 
    <script type="text/javascript">
            alert('Incorrect old password');
            window.location = "change_password.php";
        </script>
 
 <?php }}else{?>  
    
         <script type="text/javascript">
            alert('Unable to change password');
            window.location = "change_password.php";
        </script>
       
         <?php   } }?>