MysqliDb::now PHP Method

now() public method

Method returns generated interval function as an insert/update function
public now ( string $diff = null, string $func = "NOW()" ) : array
$diff string interval in the formats: "1", "-1d" or "- 1 day" -- For interval - 1 day Supported intervals [s]econd, [m]inute, [h]hour, [d]day, [M]onth, [Y]ear Default null;
$func string Initial date
return array
    public function now($diff = null, $func = "NOW()")
    {
        return array("[F]" => array($this->interval($diff, $func)));
    }

Usage Example

コード例 #1
0
ファイル: alipay.php プロジェクト: szgongyi/TrafficPolice-Web
function order_paid()
{
    require_once './submodules/php-mysqli-database-class/MysqliDb.php';
    require './includes/config.php';
    $db = new MysqliDb($db_host, $db_user, $db_pass, $db_name);
    $payid = $_GET['out_trade_no'];
    $aPayId = explode('_', $payid);
    $mtrid = $aPayId[1];
    $params = json_encode($_GET);
    //验证是否已经支付过
    $db->where("mtr_id = '{$mtrid}'")->get('mark_trafficpolice_reward');
    if ($db->count == 0) {
        $aNew = array('mtr_id' => $mtrid, 'pay_id' => $payid, 'pay_success' => 1, 'pay_money' => $_GET['total_fee'], 'pay_date' => $_GET['gmt_payment'], 'pay_params' => $params, 'created_date' => $db->now());
        $id = $db->insert('mark_trafficpolice_reward', $aNew);
        //给用户增加余额
        $sql = "SELECT mt.user_id,u.user_money FROM `mark_trafficpolice` mt\n            LEFT JOIN mark_trafficpolice_received mtr ON mt.id=mtr.mt_id\n            LEFT JOIN users u ON u.user_id=mt.user_id\n            WHERE mtr.id= '{$mtrid}'";
        $aUser = $db->rawQuery($sql);
        if ($db->count) {
            $aUpdate = array('user_money' => $aUser[0]['user_money'] + $_GET['total_fee'], 'updated_date' => $db->now());
            $db->where('user_id', $aUser[0]['user_id']);
            $db->update('users', $aUpdate);
        }
    } else {
        echo "already rewarded";
    }
}
All Usage Examples Of MysqliDb::now