yiisoft/yii

https://join.slack.com/t/yii/shared_invite/MjIxMjMxMTk5MTU1LTE1MDE3MDAwMzMtM2VkMTMyMjY1Ng

ajithfort

@ajithfort

$first_array = Yii::app()->db->createCommand()
->select('*')
->from('form_fields')
->where(array('not in', 'id', $sorted_array))
->andWhere('form_id=:form_id', array(':form_id'=>$form_id))
->orderByField()
->queryAll();

when i try like this i get an error like this CDbCommand and its behaviors do not have a method or closure named "orderByField".

Alex

@Alex-Bond

->orderBy('id')

try this

$query->orderBy([
'id' => SORT_ASC,
'name' => SORT_DESC,
]);

https://github.com/yiisoft/yii2/blob/master/docs/guide/db-query-builder.md

ajithfort

@ajithfort

cant use asc or desc http://stackoverflow.com/questions/34854708/how-to-order-a-query/34856070#34856070

let me check that github link :-)

Alex

@Alex-Bond

$query->orderBy([
'id' => SORT_ASC,
'name' => SORT_DESC,
]);
i copy it from oficial docs

ajithfort

@ajithfort

i tried like this $first_array = Yii::app()->db->createCommand()
->select('*')
->from('form_fields')
->where(array('not in', 'id', $sorted_array))
->andWhere('form_id=:form_id', array(':form_id'=>$form_id))
->orderBy(['id' => SORT_ASC,'name' => SORT_DESC,])
->queryAll();

and i got this error CDbCommand and its behaviors do not have a method or closure named "orderBy".

:worried:

Alex

@Alex-Bond

try just order

ajithfort

@ajithfort

ok its working partially just some command error

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '4' in 'order clause'. The SQL statement executed was: SELECT *
FROM form_fields
WHERE (id NOT IN ('3', '1', '6')) AND (form_id=:form_id)
ORDER BY 4, 3

i will make it work hopefully :smile:

Alex

@Alex-Bond

dont tell id of column in order

tell hit full name of columns

him*

http://www.yiiframework.com/doc/api/1.1/CDbCommand - check this api doc

ajithfort

@ajithfort

just got my sql query working SELECT * FROM form_fields
WHERE id IN ("3","1","6")
ORDER BY FIELD (id, "3","1","6")

:sparkles:

xicond

@xicond

use ->order() then

$first_array = Yii::app()->db->createCommand()
->select('*')
->from('form_fields')
->where(array('not in', 'id', $sorted_array))
->andWhere('form_id=:form_id', array(':form_id'=>$form_id))
->order(['id' => SORT_ASC,'name' => SORT_DESC,])
->queryAll();

shzaur

@shzaur

This message was deleted

xicond

@xicond

why getPathInfo and createUrl remove ended slash , How to keep it ?

xicond

@xicond

I've got figure it out by urlSuffix

xicond

@xicond

Hello

xicond

@xicond

How to call generator and validator CSRF manually without enable csrf ? I just want to enable for specific action, don't wanna effect the rest of ajax request

Ankit Padia

@InsaneSkull

i want to check row existence in db using CDbCommand. What is the method for that, something like exist() in yii2

Mohamed Cherif Bouchelaghem

@cherifGsoul

@InsaneSkull I dont think something like that already exists, you can make your own method by extending CDbCommand or puting it in your component

Ankit Padia

@InsaneSkull

@cherifGsoul i have already discovered alternative.

Mohamed Cherif Bouchelaghem

@cherifGsoul

@InsaneSkull casting queryScalar to boolean

ok can you share it?

Ankit Padia

@InsaneSkull

i meant not needed to check exist, used queryRow() to solve my problem.

Mohamed Cherif Bouchelaghem

@cherifGsoul

Ankit Padia

@InsaneSkull

I have successfully created cron job, but i want to schedule it using crontab -e but i can't get it working.
Tutorial path:* * * * * php/var/www/html/yii1/ protected/yii makefile/make
My path:* * * * *php /var/www/html/basic/yii make/make
but it's not working, why?

it's yii2 question, but still someone help me with this.

Mohamed Cherif Bouchelaghem

@cherifGsoul

Im not very experienced with this :/

Ankit Padia

@InsaneSkull

@cherifGsoul no problem

:-)

Mohamed Cherif Bouchelaghem

@cherifGsoul

the first make is a command controller?

Ankit Padia

@InsaneSkull

yes

Mohamed Cherif Bouchelaghem

@cherifGsoul

I think pasting the error is more helpful

if you have any

Ankit Padia

@InsaneSkull

no errors, but files are not creating every minute

des1roer

@des1roer

hello

how i can renderpartial from renderpartial ?

1 st

           renderPartial('//../modules/analiz/views/analizCreate/shihta')

and from shihta

Where communities thrive

People

Repo info

Activity