Log message #4055781

# At Username Text
# Jul 22nd 2017, 12:21 itamer I want to add this to my $conds array and pass it into the query 'CONCAT(Individuals.firstname,' ',Individuals.lastname)' => 'Sarah Smith' but when it gets parsed into the query it comes out as CONCAT(Individuals.firstname,' ',individuals.lastname) :c1 and fails because there is no operator between the concat statement and the variable I'm guessing it's the concat that throws it out. Any workarounds?
# Jul 22nd 2017, 12:05 Guest68527 For example two tables are courses, sessions are related by courses_sessions, and courses_sessions belongs to mediums table
# Jul 22nd 2017, 12:03 sonu_nk hmic, is AppController.php -> intilize() is not right place to it ? i dont have any knowledge about middleware...why to use and how to use...
# Jul 22nd 2017, 12:03 Guest68527 How query and all other thing work in this case
# Jul 22nd 2017, 12:03 Guest68527 Is it possible to use A belongs to many B By table AB and AB belongs to many C
# Jul 22nd 2017, 12:01 hmic you could have a middleware too
# Jul 22nd 2017, 12:00 sonu_nk i want to call a common method automatically on each request, AppController.php is the right place ? and should call that method in initialize() ??? right?
# Jul 22nd 2017, 11:59 Guest68527 Hello
# Jul 22nd 2017, 11:51 Guest68527 SomeOne expert here who can help me?
# Jul 22nd 2017, 11:43 ksandeep anyone is online
# Jul 22nd 2017, 11:43 ksandeep plz help how to setup
# Jul 22nd 2017, 11:43 ksandeep all have belong to many relation
# Jul 22nd 2017, 11:43 ksandeep so again relation is with courses_seesions table with mediums table
# Jul 22nd 2017, 11:42 ksandeep Now at same time i have to store data like medium where one course available in multiple lang.
# Jul 22nd 2017, 11:41 ksandeep I have two table course and session. Then have table courses_sessions which take data for course which change session to session
# Jul 22nd 2017, 11:40 ksandeep I need help in table setup. how to give relation plz help
# Jul 22nd 2017, 11:39 ksandeep Hi All
# Jul 22nd 2017, 10:31 crazycoder thanks
# Jul 22nd 2017, 10:31 crazycoder ok i will use a foreach()
# Jul 22nd 2017, 10:30 birdy247 It currently not happening
# Jul 22nd 2017, 10:30 crazycoder can i exit a loop inside collection->each() ?
# Jul 22nd 2017, 10:30 crazycoder hello
# Jul 22nd 2017, 10:27 birdy247 should I expect table object to be called in the through model?
# Jul 22nd 2017, 10:27 birdy247 If I am saving a belongsToMany with the "through" option
# Jul 22nd 2017, 10:04 r3zam slackebot: exactly what i needed (yea , it was address of uploaded image but i didn't know how to make to start from webroot directory)
# Jul 22nd 2017, 09:15 littleylv if $carCompany->logo is something like uploads/files/foo.jpg , try `$this->Html->image($carCompany->logo, ['pathPrefix' => '/']);`
# Jul 22nd 2017, 09:12 littleylv what’s in `$carCompany->logo`
# Jul 22nd 2017, 09:10 widelec-BB r3zam: In 3.x you have UrlHelper.
# Jul 22nd 2017, 09:09 widelec-BB uch, 3.x. sorry, I somehow assumed you are using 2.x...
# Jul 22nd 2017, 09:08 r3zam widelec-BB: i couldn't find assetUrl in cakephp 3.x document
# Jul 22nd 2017, 09:04 r3zam widelec-BB: let me check it
# Jul 22nd 2017, 09:02 widelec-BB r3zam: maybe try using HtmlHelper::assetUrl()
# Jul 22nd 2017, 08:42 r3zam hey guys , i uploaded some images to webroot/uploads/files , but when i try to load them with this syntax i got 404 error (<img src="/<?=$carCompany->logo; ?>" alt="<?=$carCompany->name . '\'s Logo'; ?>) i can't use image helper too , how can i show them with relative path ?
# Jul 22nd 2017, 07:49 birdy247 Morning guys
# Jul 22nd 2017, 07:13 rchavik itamer: find src/Template/ -name "*.ctp" | xargs sed -i 's/Form->input/Form->control/g' :)
# Jul 22nd 2017, 07:01 braeden input() is deprecated? man, that shatters my entire universe
# Jul 22nd 2017, 05:55 admad you can keep using input() until 4.0 if you want :slightly_smiling_face:
# Jul 22nd 2017, 05:43 itamer oh joy, just had a monster site upgraded from 1.2 to 3 and all the input calls have been left.
# Jul 22nd 2017, 05:42 admad form->input() is deprecated btw, so if you are using latest 3.x use form->control()
# Jul 22nd 2017, 05:41 itamer @admad thanks, I'll go look that up
# Jul 22nd 2017, 05:41 admad @italopalanza hidden fields do have id attribute if you use form->control() / form->input() to create them