回復(fù)@叫我老三 Service::M()->db->table("ssc_order")->select('ifnull(sum(ball1),0) as ball1,ifnull(sum(ball2),0) as ball2,ifnull(sum(ball3),0) as ball3,ifnull(sum(ball4),0) as ball4,ifnull(sum(ball5),0) as ball5,ifnull(sum(ball6),0) as ball6,ifnull(sum(ball7),0) as ball7,ifnull(sum(ball8),0) as ball8,ifnull(sum(ball9),0) as ball9,ifnull(sum(ball10),0) as ball10')->groupBy('number')->get()->getRowArray(); 可以這樣做 謝謝呀 雖說(shuō)還是那么麻煩 但是也是一種解決方法
@叫我老三：解決了 謝謝 Service::M()-db-table(ssc_order)-select(ifnull(sum(ball1),0) as ball1,ifnull(sum(ball2),0) as ball2,ifnull(sum(ball3),0) as ball3,ifnull(sum(ball4),0) as ball4,ifnull(sum(ball5),0) as ball5,ifnull(sum(ball6),0) as ball6,ifnull(sum(ball7),0) as ball7,ifnull(sum(ball8),0) as ball8,ifnull(sum(ball9),0) as ball9,ifnull(sum(ball10),0) as ball10)-groupBy(number)-get()-getRowArray()
怎么寫(xiě)的代碼？報(bào)什么錯(cuò)
Service::M()->db->table("ssc_order")->field(['sum(ball1)'=>'ball1','sum(ball2)'=>'ball2','sum(ball3)'=>'ball3','sum(ball4)'=>'ball4','sum(ball5)'=>'ball5','sum(ball6)'=>'ball6','sum(ball7)'=>'ball7','sum(ball8)'=>'ball8','sum(ball9)'=>'ball9','sum(ball10)'=>'ball10'])->where("number = ".$data['number']+1)->groupBy('number')->select(); 代碼是這樣的
這是報(bào)錯(cuò)信息
肯定錯(cuò)誤了，沒(méi)見(jiàn)過(guò)這個(gè)語(yǔ)法啊，這哪里的語(yǔ)法，根本不是ci4的語(yǔ)法啊
回復(fù)@幸福佬 這是在TP的寫(xiě)法 寫(xiě)TP寫(xiě)習(xí)慣了 CI這個(gè)框架第一次接觸 新項(xiàng)目要用CI做 所以在學(xué) 發(fā)現(xiàn)好多都不通用 所以才來(lái)求助的
我去，tp的語(yǔ)法怎么可以用在ci框架里面，你是怎么想的。。。先看ci框架開(kāi)發(fā)文檔吧
回復(fù)@又是一年冬
回復(fù)@呂布 就是找不到呀 用原生的我能實(shí)現(xiàn)效果 我就查下有沒(méi)有類似函數(shù)能達(dá)到原生效果，我看上面只有校驗(yàn)字段是否存在數(shù)據(jù)庫(kù)的函數(shù) 沒(méi)有找到查詢出指定字段的函數(shù)
\Phpcmf\Service::M()->db->query("select語(yǔ)句")->getResultArray();回復(fù)@老豆 您的意思只能用原生的寫(xiě) 沒(méi)有那種特殊函數(shù)處理 是這個(gè)意思吧
他這種寫(xiě)法是原始sql寫(xiě)法，可以按ci框架的鏈?zhǔn)綄?xiě)法，比如查詢文章
https://codeigniter4.github.io/userguide/database/query_builder.html
$builder = \Phpcmf\Service::M()->db->table('users'); $builder->where('name', $name); $builder->where('title', $title); xxxxxxxxxxxxx回復(fù)@又是一年冬
回復(fù)@叫我老三 您這種是給條件賦值 多個(gè)條件吧 我想要的效果是一個(gè)表里多個(gè)字段 我只想查詢出2-3個(gè)字段出來(lái)
回復(fù)@叫我老三 Service::M()->db->table("ssc_order")->select('ifnull(sum(ball1),0) as ball1,ifnull(sum(ball2),0) as ball2,ifnull(sum(ball3),0) as ball3,ifnull(sum(ball4),0) as ball4,ifnull(sum(ball5),0) as ball5,ifnull(sum(ball6),0) as ball6,ifnull(sum(ball7),0) as ball7,ifnull(sum(ball8),0) as ball8,ifnull(sum(ball9),0) as ball9,ifnull(sum(ball10),0) as ball10')->groupBy('number')->get()->getRowArray(); 可以這樣做 謝謝呀 雖說(shuō)還是那么麻煩 但是也是一種解決方法