# |
Feb 12th 2018, 08:26 |
neon1024 |
Morning |
# |
Feb 12th 2018, 08:16 |
saeideng |
`$this->deleteAll()` is returns `DELETE FROM table_name` |
# |
Feb 12th 2018, 08:12 |
saeideng |
there is not function to generate `TRUNCATE TABLE tableName` directly to use like `$this->truncate()` .... |
# |
Feb 12th 2018, 08:10 |
javier_rodri1989 |
I said $this->deleteAll() |
# |
Feb 12th 2018, 08:09 |
javier_rodri1989 |
but I want insert in the controller |
# |
Feb 12th 2018, 08:08 |
saeideng |
there is not direct function |
# |
Feb 12th 2018, 08:07 |
saeideng |
``` public function truncate(ConnectionInterface $db) { $sql = $this->_schema->truncateSql($db); foreach ($sql as $stmt) { $db->execute($stmt)->closeCursor(); } return true; } ``` |
# |
Feb 12th 2018, 07:54 |
javier_rodri1989 |
Good morning, how to do a truncate of a table in cakephp3? |
# |
Feb 12th 2018, 07:42 |
savant |
night all. |
# |
Feb 12th 2018, 07:41 |
savant |
AWS is a little futzy if you’re not super familiar with it |
# |
Feb 12th 2018, 07:41 |
savant |
no problem |
# |
Feb 12th 2018, 07:24 |
chris802 |
@savant Nope. But I just did and that worked. Thanks a million! This is my first time using Amazon. |
# |
Feb 12th 2018, 07:14 |
savant |
@chris802 did you open the security groups on your RDS instance to allow access from wherever you are connecting? |
# |
Feb 12th 2018, 06:20 |
Junior |
yello ;) |
# |
Feb 12th 2018, 04:28 |
chris802 |
Could someone give me any tips on connecting to an Amazon RDS MySQL database in CakePHP 3? I've added all of my Amazon credentials and nothing happens, it just times out when I reload the page. Any help / tips would be appreciated! |
# |
Feb 12th 2018, 03:11 |
ricksaccous |
@yogimishra96 yeah you would have to deal with a third party library |
# |
Feb 12th 2018, 02:48 |
john |
From a quick search, Mongo doesn't appear to be officially supported. There's an library at https://github.com/tiaguinho/mongodb-cakephp3 that looks to be actively maintained. |
# |
Feb 12th 2018, 02:40 |
yogimishra96 |
The official or standard way to integrate the mongo with cakephp |
# |
Feb 12th 2018, 02:40 |
yogimishra96 |
How to use mongo php library in cakephp 3. |
# |
Feb 12th 2018, 02:38 |
loginews |
File uploaded https://cakesf.slack.com/files/U435V89H8/F97B5SECT/-.txt / https://slack-files.com/T053DPNCM-F97B5SECT-5f71d5507f - It seems to work |
# |
Feb 12th 2018, 02:35 |
loginews |
thanks |
# |
Feb 12th 2018, 02:35 |
loginews |
I found it |
# |
Feb 12th 2018, 02:35 |
john |
https://stackoverflow.com/questions/30876688/cakephp-3-change-order-in-datewidget#30877084 |
# |
Feb 12th 2018, 02:18 |
loginews |
I feel like I will have to write the docs myself! |
# |
Feb 12th 2018, 02:16 |
loginews |
what should I type? |
# |
Feb 12th 2018, 02:16 |
loginews |
so instead of typing $this->Form->input('thisdate',['type'=>'date','dateFormat'=>'DMY']) |
# |
Feb 12th 2018, 02:15 |
john |
``` * To control the order of inputs, and any elements/content between the inputs you * can override the `dateWidget` template. By default the `dateWidget` template is: * `{{month}}{{day}}{{year}}{{hour}}{{minute}}{{second}}{{meridian}}` ``` |
# |
Feb 12th 2018, 02:15 |
loginews |
thanks |
# |
Feb 12th 2018, 02:13 |
john |
Oh, nevermind, Timeformat isn't what you're looking for. |
# |
Feb 12th 2018, 02:12 |
john |
or format? |
# |
Feb 12th 2018, 02:12 |
john |
Looking at the source ( https://github.com/cakephp/cakephp/blob/master/src/View/Helper/FormHelper.php ), have you tried using timeFormat instead of dateFormat? |
# |
Feb 12th 2018, 02:09 |
john |
Admittedly, I've used primary CakePHP 2.x |
# |
Feb 12th 2018, 02:03 |
loginews |
@john Have you used date input in cakephp3 |
# |
Feb 12th 2018, 01:31 |
loginews |
thanks. Still searching for the replacement syntax. |
# |
Feb 12th 2018, 01:06 |
dereuromark |
loginews: https://book.cakephp.org/3.0/en/appendices/3-0-migration-guide.html#formhelper |
# |
Feb 12th 2018, 01:05 |
loginews |
$this->Form->input('thisdate',['type'=>'date','dateFormat'=>'DMY']) The above input still displays the field in YMD format. What did I miss ? |
# |
Feb 11th 2018, 21:58 |
K4T |
:P |
# |
Feb 11th 2018, 21:58 |
K4T |
https://cakebuild.net/ |
# |
Feb 11th 2018, 20:57 |
dereuromark |
the variable is never declared, it misses the crucial part of reading from db |
# |
Feb 11th 2018, 20:57 |
dereuromark |
its pretty obvious from your code (and the message) tba |
# |
Feb 11th 2018, 20:49 |
rafael.junqueira.sant |
I read the code over and over again and didn't understand what I am doing wrong. |