Home >Backend Development >PHP Tutorial >PHP 读取 MSSQL
MSSQL 储存的手机 datatime 类型!
<code>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" } .... } } </code>
怎么把里面的['date']
区出来?
我这样写的 报错!
<code>$result = $db->table('t_rm_payflow')->select(); foreach($result as $key => $val) { echo('<tr>'); echo "<td>".$val['flow_no']."</td>"; echo "<td>".sprintf("%.2f",$val['sale_amount'])."</td>"; echo "<td>".$val['pay_way']."</td>"; echo "<td>".$val['oper_id']."</td>"; echo "<td>".$val['oper_date']->date."</td>"; echo('</tr>'); } 我这样就是` $val['oper_date']->date` 取不到报错! Notice: Undefined property: DateTime::$date in D:\htdocs\php2mssql\index.php on line XX </code>
MSSQL 储存的手机 datatime 类型!
<code>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" } .... } } </code>
怎么把里面的['date']
区出来?
我这样写的 报错!
<code>$result = $db->table('t_rm_payflow')->select(); foreach($result as $key => $val) { echo('<tr>'); echo "<td>".$val['flow_no']."</td>"; echo "<td>".sprintf("%.2f",$val['sale_amount'])."</td>"; echo "<td>".$val['pay_way']."</td>"; echo "<td>".$val['oper_id']."</td>"; echo "<td>".$val['oper_date']->date."</td>"; echo('</tr>'); } 我这样就是` $val['oper_date']->date` 取不到报错! Notice: Undefined property: DateTime::$date in D:\htdocs\php2mssql\index.php on line XX </code>
那是个对象先取出来oper_date,然后$oper_date->date