ThinkPHP中SQL调试方法
$shop_orders = D('Orders');
$orderresult = $shop_orders->where("order_cookie = '".$_COOKIE['hr_think_userid']."'")->field('order_id')->select();
echo $shop_orders->getLastSql();
getLastSql这个函数打印出来的,放进数据库实行下,就是调试出有错误的地方。
$shop_orders = D('Orders');
$orderresult = $shop_orders->where("order_cookie = '".$_COOKIE['hr_think_userid']."'")->field('order_id')->select();
echo $shop_orders->getLastSql();