PHP 读取 MSSQL
- WBOY原创
- 2016-06-06 20:45:361649浏览
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
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn