Jump to content

Undefined Variable


davidolson

Recommended Posts

$TotalCashoutsQuery = "SELECT amount FROM cashouts_pending WHERE status = :status";
$TotalCashouts = $dbh->prepare($TotalCashoutsQuery);
$TotalCashouts->bindValue(':status', 1, PDO::PARAM_INT);
$TotalCashoutsNumRow = $TotalCashouts->rowCount();
    if($TotalCashoutsNumRow > 0){
        while($TotalCashoutsRow = $TotalCashouts->fetch(PDO::FETCH_ASSOC)){
	    $TotalCashoutsMade = $TotalCashoutsMade + $TotalCashoutsRow['amount'];
	}
    }else{
	$TotalCashoutsMade = '0';
    }

Why is $TotalCashoutsMade UNDEFINED VARIABLE

Link to comment
https://forums.phpfreaks.com/topic/287326-undefined-variable/
Share on other sites

Because on the first iteration of the while loop $TotalCashoutsMade is not defined. To prevent the notice you should initialise this variable before the while loop

$TotalCashoutsMade = 0; // init $TotalCashoutsMade to zero

if($TotalCashoutsNumRow > 0){
    while($TotalCashoutsRow = $TotalCashouts->fetch(PDO::FETCH_ASSOC)){
        $TotalCashoutsMade += $TotalCashoutsRow['amount']; // add $TotalCashoutsRow['amount'] to $TotalCashoutsMade
    }
}

No that $TotalCashoutsMade is defined before the while loop, the else statement is not needed.

Link to comment
https://forums.phpfreaks.com/topic/287326-undefined-variable/#findComment-1474093
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.