[Resolvido] Soma em PHP
como executar esse codigo em PHP
$sql = "SELECT SUM(preco) as TOTAL FROM usuario WHERE datatroca BETWEEN '2017-02-01' AND '2017-02-28'";
eu queria colocar na nessa pagina<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Controle de Toner</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<script src="js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<div class="row">
</br>
<div align="center"><img src="imagem/barilogo.png" alt="Imagem de página não encontrada" width="280" height="140" /></div>
</br>
<h3>Controle de Toner e Cartucho</h3>
</div>
<div class="row">
<p>
</br>
<a href="meses.php" class="btn btn-success"> Voltar</a>
</p>
</br>
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>Setor</th>
<th>Impressora</th>
<th>Toner / Cartucho</th>
<th>Data da Troca</th>
<th>Responsavel Pela Troca</th>
<th>Descrição</th>
<th>Preço</th>
</tr>
</thead>
<tbody>
<?php
//<th>Data da Recarga</th>
// SELECT SUM(preco) FROM usuario WHERE datatroca BETWEEN '2017-02-01' AND '2017-02-28'
// SELECT * FROM usuario WHERE datatroca BETWEEN '2017-01-01' AND '2017-01-31'
include 'database.php';
$pdo = Database::connect();
$sql = "SELECT * FROM usuario WHERE datatroca BETWEEN '2017-02-01' AND '2017-02-28'";
foreach ($pdo->query($sql) as $row) {
echo '<tr>';
echo '<td>'. $row['setor'] . '</td>';
echo '<td>'. $row['impressora'] . '</td>';
echo '<td>'. $row['toner'] . '</td>';
echo '<td>'. $row['datatroca'] . '</td>';
//echo '<td>'. $row['datarecarga'] . '</td>';
echo '<td>'. $row['resp_troca'] . '</td>';
echo '<td>'. $row['resp_recarga'] . '</td>';
echo '<td>'. $row['preco'] . '</td>';
echo '<td width=250>';
echo '<a class="btn" href="read.php?id='.$row['id'].'">Visualizar</a>';
echo ' ';
//echo '<a class="btn btn-success" href="update.php?id='.$row['id'].'">Update</a>';
//echo ' ';
echo '<a class="btn btn-danger" href="delete.php?id='.$row['id'].'">Excluir</a>';
echo '</td>';
echo '</tr>';
}
Database::disconnect();
?>
</tbody>
</table>
</br>
</div>
</div> <!-- /container -->
</body>
</html>Discussão (5)
Carregando comentários...