Undefined Variable

[davidolson]

$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

[Ch0cu3r]

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.

[davidolson]

Thanks for help