Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 14:07
    sss6672 commented #4470
  • 14:05
    sss6672 commented on a786560
  • 14:04
    sss6672 commented on a786560
  • 11:36
    marcovtwout closed #4458
  • 11:36
    marcovtwout commented #4458
  • 11:08
    kenguest commented #4458
  • 07:00
    bizley commented #4473
  • 07:00
    bizley closed #4473
  • 06:59
    bizley commented #4474
  • 06:59
    bizley closed #4474
  • Aug 18 19:07
    marcovtwout closed #4475
  • Aug 18 19:07
    marcovtwout commented #4475
  • Aug 18 18:52
    sss6672 opened #4475
  • Aug 18 08:17
    marcovtwout commented #4385
  • Aug 18 06:34
    papppeter commented #4385
  • Aug 18 02:43
    wfrsilva edited #4474
  • Aug 18 02:42
    wfrsilva opened #4474
  • Aug 18 02:09
    wfrsilva opened #4473
  • Aug 18 02:08
    wfrsilva closed #4471
  • Aug 18 02:04
    wfrsilva closed #4472
xicond
@xicond

if I have

'urlManager' => array(
  'rules' => array(
‘form/<gender:(male|female)>' => ’site/form’,
‘contact’ => ‘site/form’,
…
)),

I wanna $_GET[‘gender’] auto transform tobe man|woman, How is it?
I wanna $this->createUrl(‘site/form’,[‘gender’=>’other']); to result "contact?gender=other" since other not in regex (male|female), How is it ?

Rohit Suthar
@rohitsuthar
hello..
xicond
@xicond
How to know weather the urlRule exist ?
ajithfort
@ajithfort
hi how can i use order by field in yii1?
$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,
]);
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*
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
ok
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