dongwei2983 2015-07-14 10:26
浏览 18

查询构建器上的Laravel中间数据类型

i have a date inside a query in laravel. query builder doesn't read my date as a string. i cant put a variable inside the query so i can't use date->format nor explode string..

here is my code..

if(isset($input['time']) && $input['time'] != '')
{
    //Useless, laravel cant read this
    $wew = explode('/', $input['time']);
    $time = $wew[0]."-".$wew[1]."-".$wew[2];

    $actlist = DB::table('activity')
    ->join('activity_details', function($join)
    {
        $join->on('activity.id','=','activity_details.activity_id')
             ->where('activity_details.time','>=', (date(str_replace('-','-',Input::get('time')).' 00:00:00',time())) )
             ->where('activity_details.time','<=', (date(str_replace('/','-',Input::get('time')).' 23:59:59',time())) );
    })
    ->orderBy('activity.id', 'desc')
    ->paginate(Config::get('app.conf')['pagin']);
}

the $wew = explode('/', $input['time']); returns undefined

where did i go wrong?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度