function buscar($tabela)
{
$pdo2 = conecta2();
$buscar = $pdo2->prepare("select * from {$tabela}");
$buscar->execute();
return $buscar->fetchAll(PDO::FETCH_OBJ);
}
function up_calc_mes($mes)
{
$pdo2 = conecta2();
//$gravar = $pdo->prepare("update set tb_registro(refeicao, ml, data, horas)
$update = $pdo2->prepare("UPDATE script SET mes = ? ");
$update->bindValue(1, $mes);
$update->execute();
return $update->rowCount() == 1 ? TRUE : FALSE;
}
function gravar_refeicao($refeicao, $ml, $data, $horas)
{
$pdo2 = conecta2();
$gravar2 = $pdo2->prepare("INSERT INTO tb_registro(refeicao, ml, data, horas)\n VALUES(?,?,?,?) ");
$gravar2->bindValue(1, $refeicao);
$gravar2->bindValue(2, $ml);
$gravar2->bindValue(3, $data);
$gravar2->bindValue(4, $horas);
$gravar2->execute();
$pdo1 = conecta();
$gravar = $pdo1->prepare("INSERT INTO tb_registro(refeicao, ml, data, horas)\n VALUES(?,?,?,?) ");
$gravar->bindValue(1, $refeicao);
$gravar->bindValue(2, $ml);
$gravar->bindValue(3, $data);
$gravar->bindValue(4, $horas);
$gravar->execute();
return $gravar2->rowCount() == 1 ? TRUE : FALSE;
return $gravar->rowCount() == 1 ? TRUE : FALSE;
}
function delete($id)
{
$pdo1 = conecta();
try {
$delete = $pdo1->prepare("DELETE FROM setup WHERE id = ?");
$delete->bindValue(1, $id, PDO::PARAM_INT);
$delete->execute();
$pdo2 = conecta2();
$delete = $pdo2->prepare("DELETE FROM setup WHERE id = ?");
$delete->bindValue(1, $id, PDO::PARAM_INT);
$delete->execute();
if ($delete->rowCount() == 1) {
return TRUE;
} else {
return FALSE;
}
} catch (PDOException $e) {
echo $e->getMessage();
}
}
############################################################################################### /*
$db2 = conect2();
$sql_db2 = "insert into tb_registro (refeicao, ml, data, horas)values (:r, :m, :d, :h)";
$stmt = $db2->prepare($sql_db2);
$stmt->bindValue(":r", "MAMADEIRA");
$stmt->bindValue(":m", 100);
$stmt->bindValue(":d", "2014-11-14");
$stmt->bindValue(":h", "18:22");
$stmt->execute();
*/
$pdo2 = conecta2();
//$listar = $pdo->query("SELECT SUM(ml)AS ml_total FROM tb_registro WHERE data= '$data_atual' ");
// $listar = $pdo->query("SELECT * FROM tb_registro WHERE data= '$data_atual' ");
$listar = $pdo2->query("SELECT SUM(ml) total FROM tb_registro where data ='11'");
$listar->fetchAll(PDO::FETCH_OBJ);
function mes($listar)
{
}
if (mes()) {
$dados_mes = mes();
foreach ($dados_mes as $dms) {
echo $dms->total;
}
} else {
}
?>
