sql return given php

Question

sql return given php

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

$hoje = date('d');
$data_hoje = "SELECT *  FROM vendas WHERE dataCompra = now()";
$result = mysqli_query($conexao, $data_hoje);

while($linha = mysqli_fetch_assoc($result)){    
    if($linha['dataCompra'] == $data_hoje){
        $hoje++;
    }
}

I'm doing a mysql table search to pick up and count all sales today and then insert that into a chart, but I can not print anything. can you help me?

php sql

asked by anonymous 26.10.2018 / 20:44

2 answers

Excel "Add-on" function, does not add the total of two distinct items in relation to the list? Retrieve values from an array of the next line in the previous row

score 0 · Answer 1

You can use CURDATE() instead of NOW() now get date + time):

$data_hoje = "SELECT * FROM vendas WHERE DATE_FORMAT(dataCompra,'%d/%m/%Y') = CURDATE()";

You can use DATE_ADD() for this control; as the field is a date, it is interesting to compare them by formatting:

$hoje = DATE_FORMAT(date(),'%d/%m/%Y');
$data_hoje = "SELECT *  FROM vendas WHERE DATE_FORMAT(dataCompra,'%d/%m/%Y') = CURDATE()"";
$result = mysqli_query($conexao, $data_hoje);

while($linha = mysqli_fetch_assoc($result)){    
    if(DATE_FORMAT($linha['dataCompra'],'%d/%m/%Y') == DATE_FORMAT($data_hoje,'%d/%m/%Y')){
        $hoje = DATE_ADD($hoje, INTERVAL 1 DAY);
    }
}

score 0 · Answer 2

You are comparing datetime, when you use campo = now() you are comparing date and time.

Try to give a date() in the fields of your select like this:

"SELECT *  FROM vendas WHERE date(dataCompra) = date(now())"