PHP - Automatic Scripting To Access Bank Accounts For Balance Updates

I am using a php web video script which allows Users to purchase videos successfully. The purchases are made from the amount available in the Users’ “wallet” (the User can also earn compensation, which gets added to his “balance”.). When there’s not enough available in the “wallet” for the purchase, the script checks and displays a message “not enough money”. I’d like help adding the ability where the script first checks the “wallet” amount, and if empty will then check the “balance” amount, and use a required amount from the balance, and if both are empty, then the “not enough money” appears. Here’s the portion of the code that I believe needs the modification:

// get cost video
    $db->where('name', 'video_play_price');
    $db_cost = $db->getOne('config');
    $video_cost = (float)$db_cost->value;

    $count_video = count($id_array);
    $user_id = $user->id;
    $wallet = (float)str_replace(',', '', $user->wallet);


	$amout = 0;
	foreach ($id_array as $id) {
            $video_id = (int)PT_Secure($id);

            // get video data
            $video = $db->where('id', $id)->getOne(T_VIDEOS);
			$amout += $video->video_play_price?$video->video_play_price:$video_cost;
	}

//   $amout = $video_cost * $count_video;

    $charge = ( $video_cost *0.50 );



    if ($wallet >= $amout) {

        //$new_wallet = (string)($wallet - $amout);
        $wallet = (string)($wallet - $amout);

        $db->startTransaction();

        $inserted_records = 0;
        foreach ($id_array as $id) {
            $video_id = (int)PT_Secure($id);


		// $uploader_amount = $video_cost - $charge; //100 - 20% = 80

            // get video data
            $video = $db->where('id', $id)->getOne(T_VIDEOS);



			$video_cost_new = $video->video_play_price?$video->video_play_price:$video_cost;

			$uploader_amount = ( $video_cost_new *0.50 );
            // add data to paid table
            $insert_buy = $db->insert('u_paid_videos', [
                'id_user' => $user_id,
                'id_video' => $video_id,
                'session_key' => $_SESSION['session_key'],
                'video_play_price' => (string)$video_cost,
                'video_title' => $video->title,
                'user_id_uploaded' => $video->user_id,
            ]);

            if ($insert_buy) { $inserted_records++; }
            //add wallet users' video
        $userwallet = $db->where('id', $video->user_id)->getOne(T_USERS);


        //$videouserwallet = $userwallet->balance+$video_cost;
        $videouserwallet = $userwallet->balance+$uploader_amount;
        $db->where('id', $video->user_id);
        $update_balance = $db->update(T_USERS, [
          // 'wallet' => $videouserwallet,
            'balance' => number_format($videouserwallet, 1, '.', ''),
        ]);
        }


        $db->where('id', $user_id);
        //$update_wallet = $db->update(T_USERS, [
        $update_wallet = $db->update(T_USERS, [
            'wallet' => $wallet,
        ]);


        if (($inserted_records == $count_video) && $update_wallet) {
            $db->commit();

            echo json_encode([
                'status' => 200
            ]);
            exit();
        } else {
            $db->rollback();

            echo json_encode([
                'status' => 400,
                'error' => 'Buy process error'
            ]);
            exit();
        }

    } else {

        echo json_encode([
            'status' => 400,
            'error_num' => 1,
            'error' => 'Not enough money'
        ]);
        exit();

    }

} else {

    echo json_encode([
        'status' => 400,
        'error' => 'Bad Request, Invalid or missing parameter'
    ]);
    exit();

 

Hello,

Im making a little script to keep track on how much people have currently earnt on my site.

I have everything work but i can't figure out how to work out the current balance


At the moment ive got:

Code: [Select]
$currentbalance = $row['totalpaid'] - $row['points'];
Which works untill the points becomes more then the total paid then it starts going in minus.

Im sure there's a simple fix but i just can't think of a way.

Any help would be great.
Thanks

hello  I am  a  chemical teacher  in the middle school
I hope  Balancing Chemical Equations  via  PHP
 I google  some thing
perhaps  the  CML( http://en.wikipedia.org/wiki/Chemical_Markup_Language)  may  give me  a hand.
and  this one  the http://shinkirou.org/blog/2010/11/balancing-chemical-equations-with-linear-algebra/  tells  me  using the Linear Algebra is  a  good way
how can I   Balancing Chemical Equations  via  PHP( by  CML )?
is their a  demo  ?
thank you   very much~!

Hi friends,
  I am creating a  site where  users can add credit  to their account via Liberty Reserve, and after  that their account  will  automatically  be updated with  the amount they added so that they can use it to purchase products.. And  after any purchase,  the amount will be subtracted from their account.. I cant  really  find a  php code  to do that... i have done  a  search on here but still cant  find anything close to it.. Can someone kindly help? Thank you

Does anybody have links or scripst on a script where the user has an account with money which decreases as one purchases items.

Regards

hi all, i have a page which lists all of my registered users from the mysql database but i want the ability to edit an account,

here is my list users code (just shown the appropiate code and not the rest):

Code: [Select]
<?php

require ('../secure/connect.php');


$sql = "SELECT * FROM users ORDER BY user_level ASC";
$result=mysql_query($sql);

echo '<table width="80%" border="0" cellspacing="5" cellpadding="0">';

echo ' <tr>
    <th><p align="left">User ID:</th>
    <th><p align="left">User Level:</th>
<th><p align="left">Username:</th>
<th><p align="left">User Title:</th>
<th><p align="left">Email:</th>
<th><p align="left">Actions:</th>
  </tr>';

while($rows=mysql_fetch_array($result)){
?>



<tr>
<td><?php echo $rows['userid']; ?></td>
<td><?php echo $rows['user_level']; ?></td>
<td><?php echo $rows['username']; ?></td>
<td><?php echo $rows['user_title']; ?></td>
                <td><?php echo $rows['email']; ?></td>
<td><a href="edit_account.php?id=">Edit Account</a></td>
</tr>

<?php
}
?>

this lists my users nicely, as you can see i put it a edit account action at the end with a empty id= because that may be a way of doing it but im not sure what else to do or if there is a better way of doing it. any help would be great!

I am having a problem with my User Log-In...


When a User creates an account on my website, an e-mail is sent that looks like this...
Quote

Congratulations!

Your account has been created, and a confirmation e-mail sent to: "john.doe@mail.com"

Please click on the link in that e-mail to activate your account.



Then when they click on the link, it takes them to my 'activate.php" page which updates the User's record by removing the Activation Code.

The "Activation" seems to work fine.  However, the problem that I just realized is that I am doing nothing to prevent someone from Registering, NOT Activating his/her account, but still being able to Log In?!

I guess what I need to do when a User logs in is check to be sure that the "activation_code" column is NULL, right?

Here is a snippet of my Log In script...

if (empty($errors)){
// Valid form data.

// ************************
// Find Member Record. *
// ************************

// Connect to the database.
require_once(WEB_ROOT . 'private/mysqli_connect.php');

// Build query.
$q = 'SELECT id, first_name
FROM member
WHERE email=? AND pass=?';

// Prepare statement.
$stmt = mysqli_prepare($dbc, $q);

// Bind variables to query.
mysqli_stmt_bind_param($stmt, 'ss', $email, $pass);

// Execute query.
mysqli_stmt_execute($stmt);

// Store results.
mysqli_stmt_store_result($stmt);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt)==1){
// Member was Found.

// Bind result-set to variables.
mysqli_stmt_bind_result($stmt, $memberID, $memberFirstName);

// Fetch record.
mysqli_stmt_fetch($stmt);

// Set Session variables.
$_SESSION['memberID'] = $memberID;
$_SESSION['memberFirstName'] = $memberFirstName;
$_SESSION['loggedIn'] = TRUE;


What would be the best way to fix this?

Thanks,


Debbie

Hello all,
I am a total noob in php and some VIP asked me to make something simple for our clubhouse;
A page where users can submit/input 2 codes through a textbox and store it in a database.

There are 2 things i want: max 2 submits/inputs per IP(to prevent abuse)(ip stored in database).
$ip = $_SERVER['REMOTE_ADDR'];
$check = mysql_query("select * from table where ipcolumn='$ip'");
if (mysql_num_rows($check) > 0)
$insertip = "insert into table (ipcolumn) values ('$ip')";

And i wanna catch the error when an user put in a code lower than 5 characters.
not something like:
if ($textarea == ""){

This is where i am so far.

new.php
<?php
include 'includes/config.php';

mysql_select_db($mysql_database, $con);
$sql="INSERT INTO users (code, code2)
VALUES

('$_POST[code]','$_POST[code2]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
}else{

    header ("Location: /thanks.php");
}


?>

includes/config.php
<?php

$mysql_host = "myhost.com";
$mysql_database = "mydb";
$mysql_user = "myuser";
$mysql_password = "mypass";

$con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
?>

sql.sql
--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `code` varchar(30) collate latin1_general_ci NOT NULL,
  `code2` varchar(32) collate latin1_general_ci default NULL,
  `timestamp` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


index.html
<form action="new.php" method="post"
 onsubmit="return onSubmitButton();"> 
        <input value="" id="something" class="LoginForm-Input" name="code1" size="34" style="float: left;">[/code]

How can i detect someone who is using proxy and has 2 or more accounts on my website?Or anyway, the important thing for me it is that they dont cheat because i have a competition and its forbidden to have 2 or more accounts.

I am looking to see if I could use one of the paypal features to pay two diffierent account from a single transaction and does paypal does that automatically?..

I was checking the immediate payment for a third party from the express checkout but I don't know that much about it.
Does anyone knows how to achieve this?

Hello!

I want to build a script to basically keep track of the number of hosting accounts that are currently on each server. I have roughly 30 servers (root access,  WHM, cPanel) that I would like to be able to track all of from a single page. Could someone help/point me in the right direction/offer any input?


thanks! much appreciated!

Not sure if this is related to the thread but I do think that it is    I have a server using Apache   I tried to set up an email doing something@domain.com   I tried to point the MX records to the server  It still doesn't work, if I try to send anything to that email, I get a response saying "Recepient not found" smtp.secureserver.net... blah    Since I changed the MX records to something other than smtp.secureserver.net, I don't know why I still get that message    I was trying to save on spending the $3.95 or whatever for email with office 365 haha    Any help would be greatly appreciated  Still, logically one question is obvious, don't I need to specify the storage location of the email... ? I mean there was an option in Cpanel where I created the email account but I don't understand what that means... did it configure a storage location? I don't know...   This probably is not an appropriate thread section for this question 
Edited by greenace92, 04 December 2014 - 05:18 AM.

Hi guys,

This is very important. The supervisor of my system wants to close accounts which contain zero balances for long time periods.

There is a separate page contains ID and Account Number.This is included in a form and a "close account" button is there.

When he clicks on that button the relevant record should be deleted from all tables which include that ID.

The table structure looks like this. There are 4 account types which contain same fields.

 savings_investment(ID,account_type,full_name_balance,interest,customer_id)

I want full coding of this scenario.

Thanks,
Heshan

Hey everybody,   I'm a noob when it comes to PHP so I have a few questions.   I'm in the planning stages for a new website and I need it to do something but I'm not sure how. People would have to log into my website in order to make a purchase and I need to be able to link their account with the software they bought. Think of it like a bit like Steam, you buy the game and its right there in your library.   The way I see it working is they buy their software and when they look in their profile they see a list of the stuff they've bought and have the ability to open it.   The Ecommerce company I'm looking to sign up with to make the transactions and keep the money side of it in order (FastSpring) don't have a way of tracking user purchases  so I have to come up with a way of doing my end.   What I would like to know is what language is best to do this? I assume PHP would be the best especially considering the website itself is likely to be built in WordPress.   Secondly does anybody have any links to articles, videos or tutorials on this as I have not been able to find any all afternoon. I know they're going to be out there but I'm not having any luck finding them   Thanks for your time