PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/onegrandholding.com/public_html/dashboard/bitcoin.php

<?php
$pagename = "Fund account";
require "header.php";
$user_id = $_SESSION['user_id'];

$query = mysqli_query($conn, "SELECT balance, coin FROM users WHERE id='$user_id'");
if (mysqli_num_rows($query) > 0) {
    $row = mysqli_fetch_assoc($query);
    $rem_bal = $row['balance'];
    $coin = $row['coin'];
}

$bitcoinUrl = 'https://api.coincap.io/v2/assets/bitcoin';
$bitcoinResponse = file_get_contents($bitcoinUrl);
$bitcoinData = json_decode($bitcoinResponse, true);

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $amount = $_POST['amount'];

    $bitcoinPrice = $bitcoinData['data']['priceUsd'];
    $equivalentValue = $amount / $bitcoinPrice;

    if ($rem_bal >= $amount) {
        $new_balance = $rem_bal - $amount;

        $update_balance_query = "UPDATE users SET balance = $new_balance WHERE id = $user_id";
        mysqli_query($conn, $update_balance_query);

        $new_coin_balance = $coin + $equivalentValue; 
        $update_coin_query = "UPDATE users SET coin = $new_coin_balance WHERE id = $user_id";
        mysqli_query($conn, $update_coin_query);

        echo "<script>
        swal('Success', 'Your purchase of ($equivalentValue) Bitcoin was successful', 'success')
        .then((value) => {
            window.location.href = 'crypto.php';
        });
        </script>";

        exit; 
    } else {
        echo "<script>
        swal('Error', 'Insufficient Balance', 'error');
        </script>";
    }
}
?>




<div class="container my-4 py-4">
    <div class="row my-4 py-4">
        <div class="col-lg-6 mx-auto">
            <div class="card mb-4">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h3 class="mb-0">Convert Fiat To  Bitcoin 
                        <br> (Balance - $ <?php echo number_format($rem_bal,2); ?>) </h3>
                    <small class="text-muted float-end"></small>
                </div>
                <div class="card-body">
                    <form method="post">
                        <div class="mb-3">
                            <label class="form-label" for="basic-icon-default-company">Select A Coin</label>
                            <div class="input-group input-group-merge">
                                <span id="basic-icon-default-company2" class="input-group-text"><i
                                        class='bx bx-timer'></i>
                                </span>
                                <select class="form-control" style="color:#fff; background-color:#000;" name="currency" id="currency" required>
    <option value="bitcoin">Bitcoin</option>
</select>

                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label" for="basic-icon-default-email">Amount To Convert</label>
                            <div class="input-group input-group-merge">
                                <span class="input-group-text"><i class='bx bx-dollar-circle'></i></span>
                                <input type="number" name="amount" id="basic-icon-default-email" class="form-control"
                                    style="color:#fff; background-color:#000;" placeholder="Amount" aria-label="Amount"
                                    aria-describedby="basic-icon-default-email2" required />
                                <span id="basic-icon-default-email2" class="input-group-text">USD</span>
                            </div>
                        </div>


                        <button type="submit" class="btn btn-primary">Convert</button>
                    </form>
                </div>
            </div>
        </div>

    </div>
</div>


<?php require "footer.php"; ?>
Back to Directory=ceiIENDB`