PDO - Orientação sobre valores

[Luccas Gaulia 1]

Ola pessoal,

 

 

Código funcionando corretamente, ele mostra o SUM e o COUNT, porém agora quero que mostre a lista de Usuários... Mas não sei como posso fazer isso...

 

functions.php

public function getPay($type) {
		try {

			switch ($type) {

				case 'day':
							
					$start = date("Y-m-d 00:00:00");

					$end = date("Y-m-d 23:59:59");

					break;

				case 'week':

					$actual_week = date('w');

					switch ($actual_week) {
						case '0':
							$day_before = 6;
							$day_after = 0;
							break;
						case '1':
							$day_before = 0;
							$day_after = 6;
							break;
						case '2':
							$day_before = 1;
							$day_after = 5;
							break;
						case '3':
							$day_before = 2;
							$day_after = 4;
							break;
						case '4':
							$day_before = 3;
							$day_after = 3;
							break;
						case '5':
							$day_before = 4;
							$day_after = 2;
							break;
						
						default:
							$day_before = 5;
							$day_after = 1;
							break;
					}

					$start = date("Y-m-d 00:00:00", strtotime("$start_week -$day_before days"));

					$end =  date("Y-m-d 23:59:59", strtotime("$end_week $day_after days"));
					
					break;

				case 'month':
							
					$start = date('Y-m-01 00:00:00');

					$end = date('Y-m-t 23:59:59');
					
					break;	
						
			}
	
			$stmt = $this->conn->prepare("SELECT SUM(transaction_amount) AS sum_transaction_amount,
							(SELECT COUNT(transaction_amount) 
							FROM tbl_credit_card_transactions  
							WHERE transaction_status = 'completed' 
							AND transaction_datetime 
							BETWEEN :_start AND :_end) AS count_transaction_amount 
							FROM tbl_credit_card_transactions  
							WHERE transaction_status = 'completed' 
							AND transaction_datetime BETWEEN :_start AND :_end");
	    
	    	$stmt->bindParam(':_start', $start, PDO::PARAM_STR);
	    	$stmt->bindParam(':_end', $end, PDO::PARAM_STR);
		    $stmt->execute();

		    if ($stmt->rowCount() > 0) {
		        return $stmt->fetch();

		    }
		    else {
		    	return 0;
		    }
		  }
		catch(PDOExeption $e) {
		    http_response_code(500);
		    sql_error("MYSQL ERROR: " . $e->getMessage() . "<br/>");
		}
	}

 

 

 

$type = $_POST['type'];

$datasource = new datasource();

$rows = $datasource->getPay($type);

/** Funciona corretamente **/
echo $rows['sum_transaction_amount'];
echo $rows['count_transaction_amount'];


/** Aqui que preciso de ajuda  **/
foreach ($rows as $result) {

/** Preciso listar os nomes **/

echo $result['first_name'] . " " . $result['last_name'];


}

Erro que aparece quando lista, mesmo estando na mesma tabela...

 

Warning: Illegal string offset 'last_name' in /admin/admin_pay_list.php on line 41