# |
Mar 14th 2018, 16:40 |
jeremyharris |
yep, cake provides a lot of security out of the box, and sql injection is definitely one of those. the entire orm layer is just really pleasant to work with, not just the query builder |
# |
Mar 14th 2018, 16:40 |
sssd |
then i switched to ORM and i was amazed how readable and easy it was to figure out the purpose and output just by reading |
# |
Mar 14th 2018, 16:39 |
sssd |
true that ORM is a must i used to write SQL queries by hand it was a big mess . 10 lines of sql and only aid to readability was capitalization of keywords. |
# |
Mar 14th 2018, 16:34 |
jeremyharris |
but the framework as a whole makes development fast and clean |
# |
Mar 14th 2018, 16:33 |
jeremyharris |
you can use it outside the framework as well |
# |
Mar 14th 2018, 16:33 |
jeremyharris |
that’s a hard question. many might say the ORM |
# |
Mar 14th 2018, 16:33 |
sssd |
@jeremyharris yea got it, but what is best thing about cakephp ? |
# |
Mar 14th 2018, 16:23 |
jeremyharris |
if you’re deciding between the two, I would run through their respective tutorials, hang out in the communities, explore the plugin space, and decide which one (if either) fits your needs. we’ll be happy to answer any cake specific questions if you’ve got them |
# |
Mar 14th 2018, 16:21 |
jeremyharris |
picking a framework or a toolset depends on the job at hand. heck, even picking a language depends on the job |
# |
Mar 14th 2018, 16:21 |
jeremyharris |
is a hammer better than a screwdriver? depends what you’re doing |
# |
Mar 14th 2018, 16:19 |
sssd |
is cakephp better than laravel? |
# |
Mar 14th 2018, 15:59 |
dereuromark |
would be nice if you can make a PR to fix this. |
# |
Mar 14th 2018, 15:58 |
dereuromark |
https://github.com/dereuromark/cakephp-sandbox/blob/3.0/tests/Fixture/UsersFixture.php#L18 |
# |
Mar 14th 2018, 15:57 |
dereuromark |
looks like it is not complete |
# |
Mar 14th 2018, 15:40 |
alexmax |
there is no boolean type? |
# |
Mar 14th 2018, 15:40 |
alexmax |
https://book.cakephp.org/3.0/en/development/testing.html#creating-fixtures |
# |
Mar 14th 2018, 15:39 |
alexmax |
oh, found it |
# |
Mar 14th 2018, 15:38 |
alexmax |
Where can I find a list of all schema data types? |
# |
Mar 14th 2018, 15:19 |
pierre-baptiste.varle |
thank you @dereuromark |
# |
Mar 14th 2018, 15:17 |
pierre-baptiste.varle |
I will use the standard php function |
# |
Mar 14th 2018, 15:16 |
dereuromark |
you can use some own lib with your own url() method if you want to, this is not framework relevant though |
# |
Mar 14th 2018, 15:16 |
dereuromark |
it is designed for the internal building |
# |
Mar 14th 2018, 15:16 |
dereuromark |
performance issues |
# |
Mar 14th 2018, 15:15 |
pierre-baptiste.varle |
I was thinking that router can be used for external url too |
# |
Mar 14th 2018, 15:15 |
pierre-baptiste.varle |
yes I just found http://php.net/manual/fa/function.http-build-url.php thank |
# |
Mar 14th 2018, 15:13 |
dereuromark |
build_query_strings() etc manually called will do the trick for u |
# |
Mar 14th 2018, 15:13 |
dereuromark |
its mainly meant for internal URLs :slightly_smiling_face: for external you can skip it |
# |
Mar 14th 2018, 15:08 |
pierre-baptiste.varle |
@narendravaghela Router::url('http://www.google.com') return 'http://www.google.com' right? why to use this function if it's do nothing? I would like to have something like thister::url(['http://www.google.com', '?'=>['q'=>'search Query']]) |
# |
Mar 14th 2018, 14:11 |
lorenzo |
what was the generated query? |
# |
Mar 14th 2018, 13:27 |
narendravaghela |
by the way, the query returns too many results - 451 rows |
# |
Mar 14th 2018, 13:23 |
narendravaghela |
I am using ~3.2 |
# |
Mar 14th 2018, 13:22 |
lorenzo |
It is like debug() but specialized to query objects |
# |
Mar 14th 2018, 13:22 |
lorenzo |
There is also sql($query) if you are using the latest debugkit |
# |
Mar 14th 2018, 13:19 |
narendravaghela |
dumpanddie, I did't know that |
# |
Mar 14th 2018, 13:19 |
narendravaghela |
and also thanks @brettl for `dd` |
# |
Mar 14th 2018, 13:19 |
narendravaghela |
thanks :thumbsup: |
# |
Mar 14th 2018, 13:19 |
lorenzo |
Look at the generated query and fix any erros |
# |
Mar 14th 2018, 13:19 |
lorenzo |
Cool I think you can figure it out from here |
# |
Mar 14th 2018, 13:18 |
narendravaghela |
but now `Unknown column TL.id` |
# |
Mar 14th 2018, 13:18 |
lorenzo |
Haha yes @brettl just going slower with him |
# |
Mar 14th 2018, 13:17 |
lorenzo |
Remove it |