I have a table that has the value column, I query those values as follows
$sql2 = 'SELECT * FROM comisao_trabalho WHERE idJob="10" && pagoA="Dalton" ORDER BY id ASC';
$buscar = $conexao->prepare($sql2);
$buscar->execute();
$retorno = array();
$retorno['dados'] = '';
$retorno['qtd'] = $buscar->rowCount();
if($retorno['qtd'] > 0):
while($conteudo = $buscar->fetchObject()){
$retorno['dados'] = $conteudo->valor;
}
echo json_encode($retorno);
endif;
The values are in this format: U $ 2,500.00