object(DateTime)#2 (3) { ["date"]=>">
当前位置:Gxlcms > PHP教程 > PHP读取MSSQL

PHP读取MSSQL

时间:2021-07-01 10:21:17 帮助过:16人阅读

MSSQL 储存的手机 datatime 类型!

array(2622) {
  [0]=>
  array(28) {
...
["oper_date"]=>
    object(DateTime)#2 (3) {
      ["date"]=>
      string(19) "2014-02-28 14:04:37"
      ["timezone_type"]=>
      int(3)
      ["timezone"]=>
      string(13) "Asia/Shanghai"
    }
....
}
}

怎么把里面的['date'] 区出来?

我这样写的 报错!

$result = $db->table('t_rm_payflow')->select();
    foreach($result as $key => $val)
    {
        echo('');
        echo "".$val['flow_no']."";
        echo "".sprintf("%.2f",$val['sale_amount'])."";
            echo "".$val['pay_way']."";
            echo "".$val['oper_id']."";
            echo "".$val['oper_date']->date."";
            echo('');
    }

我这样就是` $val['oper_date']->date`  取不到报错!

    Notice: Undefined property: DateTime::$date in D:\htdocs\php2mssql\index.php on line XX

回复内容:

MSSQL 储存的手机 datatime 类型!

array(2622) {
  [0]=>
  array(28) {
...
["oper_date"]=>
    object(DateTime)#2 (3) {
      ["date"]=>
      string(19) "2014-02-28 14:04:37"
      ["timezone_type"]=>
      int(3)
      ["timezone"]=>
      string(13) "Asia/Shanghai"
    }
....
}
}

怎么把里面的['date'] 区出来?

我这样写的 报错!

$result = $db->table('t_rm_payflow')->select();
    foreach($result as $key => $val)
    {
        echo('');
        echo "".$val['flow_no']."";
        echo "".sprintf("%.2f",$val['sale_amount'])."";
            echo "".$val['pay_way']."";
            echo "".$val['oper_id']."";
            echo "".$val['oper_date']->date."";
            echo('');
    }

我这样就是` $val['oper_date']->date`  取不到报错!

    Notice: Undefined property: DateTime::$date in D:\htdocs\php2mssql\index.php on line XX

那是个对象先取出来oper_date,然后$oper_date->date

人气教程排行