PHP date_splitter Exemples

Exemple #1

Fichier : dashboard.php Projet : smilecs/ctra

function drivers()
{
    $tmp_date = date_splitter();
    $result = query("SELECT * FROM driver WHERE date LIKE '{$tmp_date}-%'");
    return mysql_num_rows($result);
}

Exemple #2

Fichier : utility.php Projet : smilecs/microfinance

function no_accounts()
{
    $tmp_date = date_splitter();
    $result = query("SELECT * FROM account WHERE d_opened LIKE '{$tmp_date}-%'");
    $thrift_total = 0;
    $special_total = 0;
    $count = 0;
    while ($row = mysql_fetch_array($result)) {
        $type = $row['acct_type'];
        if ($type == 1) {
            $thrift_total += 1;
        } else {
            $special_total += 1;
        }
        $count += 1;
    }
    $tm = [$count, $thrift_total, $special_total];
    return $tm;
}