| # |
May 27th 2016, 16:07 |
max-86666 |
i thought the same, but wanted to be sure :) |
| # |
May 27th 2016, 16:07 |
 nemmons |
sorry =( |
| # |
May 27th 2016, 16:07 |
max-86666 |
well, thx for your advices :) |
| # |
May 27th 2016, 16:07 |
ypnos |
manifesting your bullshit db in fresh code is IMHO the worst you can do |
| # |
May 27th 2016, 16:06 |
ypnos |
but it will become a real performance problem |
| # |
May 27th 2016, 16:06 |
max-86666 |
but i can't :/ |
| # |
May 27th 2016, 16:06 |
ypnos |
and if you can't, maybe you can use SQL functions to build a VIEW that is usable |
| # |
May 27th 2016, 16:06 |
max-86666 |
can't agreee more |
| # |
May 27th 2016, 16:06 |
nemmons |
max-86666 sorry but i think what you're trying to do is probably too weird for Cake's ORM |
| # |
May 27th 2016, 16:06 |
ypnos |
me personally I would suggest you to fix your database |
| # |
May 27th 2016, 16:05 |
max-86666 |
so, you guys suggest me not to use cake's ORM ? |
| # |
May 27th 2016, 16:04 |
ionas |
especially if you think about ajax stuff that would do those pulls anway |
| # |
May 27th 2016, 16:04 |
ionas |
I wonder if a clean implementation of a pull flow instead of push flow and front controller will make things better |
| # |
May 27th 2016, 16:04 |
nemmons |
np. It's good info to have anyway, i'm sure it will come up for me at some point |
| # |
May 27th 2016, 16:04 |
ionas |
VzlaCaker: then |
| # |
May 27th 2016, 16:04 |
ionas |
nemmons true, sorry |
| # |
May 27th 2016, 16:03 |
nemmons |
@ionas thanks for the info but it was VzlaCaker who was asking |
| # |
May 27th 2016, 16:03 |
max-86666 |
if u tell me it's not possible, i'll believe you and make it raw query |
| # |
May 27th 2016, 16:03 |
ionas |
;) |
| # |
May 27th 2016, 16:03 |
ionas |
nemmon better yet, install parsedown and let them use markdown |
| # |
May 27th 2016, 16:03 |
ionas |
and h() |
| # |
May 27th 2016, 16:03 |
ionas |
nemmons: HtmlPurifier (google for HTML5 + HTML Purifier), DomDocument, Tidy |
| # |
May 27th 2016, 16:03 |
max-86666 |
sure, i can do it in raw sql, but i'd like to keep the magic from cake |
| # |
May 27th 2016, 16:02 |
max-86666 |
i guess FIND_IN_SET() |
| # |
May 27th 2016, 16:02 |
nemmons |
if you can't do it in SQL, then the ORM can't do it either |
| # |
May 27th 2016, 16:02 |
ionas |
~awesome |
| # |
May 27th 2016, 16:01 |
nemmons |
what he's asking you is, how would you write a SQL query to do what you want the CakeORM to do |
| # |
May 27th 2016, 16:01 |
max-86666 |
i'm quite stunned markstory is answering me, even if u can't help me :) |
| # |
May 27th 2016, 15:59 |
max-86666 |
i would like to use the Cake ORm to make my queries from controller, actually i use $critere = $this->Criteres->get($id, ['contain' => ['Users'] ]); |
| # |
May 27th 2016, 15:58 |
markstory |
What does a SQL query look like with these comma separated columns? |
| # |
May 27th 2016, 15:57 |
max-86666 |
in the initialize method of my table |
| # |
May 27th 2016, 15:56 |
markstory |
how do you write SQL to do your joins? |
| # |
May 27th 2016, 15:56 |
markstory |
You can't |
| # |
May 27th 2016, 15:55 |
max-86666 |
hellos everybedos, any clue on how i can link tables when foreign keys are store in a comma separated string ? (i can't change the DB design) |
| # |
May 27th 2016, 15:49 |
VzlaCaker |
@nemmons @ypnos thanks for your recommendations |
| # |
May 27th 2016, 15:46 |
ypnos |
you can also use htmlpurifier, see https://github.com/chrisShick/CakePHP3-HtmlPurifier |
| # |
May 27th 2016, 15:42 |
nemmons |
a low-tech solution might be to use http://php.net/manual/en/function.strip-tags.php to strip out all html tags except the ones you specifically want to allow |
| # |
May 27th 2016, 15:41 |
nemmons |
@VzlaCaker sorry, i don't have any experience in letting users format text. |
| # |
May 27th 2016, 15:37 |
markstory |
d0rxy: https://github.com/cakephp/debug_kit/pull/421 |
| # |
May 27th 2016, 15:36 |
markstory |
that requires more sophisticated users though |
| # |
May 27th 2016, 15:36 |
markstory |
markdown |