| # |
Feb 9th 2018, 03:19 |
slackebot |
code that works. |
| # |
Feb 9th 2018, 03:19 |
 loginews |
@voycey Thanks I managed to get the data. I have apps already running in MsAccess with mysql / php at the back. MsAccess provides the front-end interface. Now converting tons of code to cakephp. Still getting used to cakephp. But that is a choice I made. It looked the best when I googled for all webdev platforms. My biggest challenge is to be able to do things without coding. I use Bake all the time. I do not want to have to rewrite php |
| # |
Feb 9th 2018, 02:11 |
voycey |
@loginews Cakes ORM uses lazy loading so the queries are only executed once iterated through, if you want to see the data you can use ->toArray |
| # |
Feb 9th 2018, 02:04 |
loginews |
@ricksaccous Thanks I managed to get the data. |
| # |
Feb 9th 2018, 01:51 |
loginews |
I needed to execute a query, not just a find. But I used the select query to see if I got it right. |
| # |
Feb 9th 2018, 01:50 |
loginews |
just not yet used to it, but I will. One thing at a time. |
| # |
Feb 9th 2018, 01:49 |
ricksaccous |
it will make your life easier in the long run |
| # |
Feb 9th 2018, 01:49 |
ricksaccous |
why aren't you using debugkit? |
| # |
Feb 9th 2018, 01:49 |
loginews |
how to I list the results with print_r ? |
| # |
Feb 9th 2018, 01:49 |
loginews |
good |
| # |
Feb 9th 2018, 01:49 |
ricksaccous |
if you want objects just skip out on toArray() |
| # |
Feb 9th 2018, 01:49 |
ricksaccous |
$this->Drugs->find('all')->toArray(); |
| # |
Feb 9th 2018, 01:48 |
loginews |
then |
| # |
Feb 9th 2018, 01:48 |
ricksaccous |
also instead of doing that why not use the find method? |
| # |
Feb 9th 2018, 01:48 |
ricksaccous |
try $this->Drugs->query('select * from drugs')->toArray(); |
| # |
Feb 9th 2018, 01:48 |
loginews |
how |
| # |
Feb 9th 2018, 01:47 |
ricksaccous |
This is a Query object, to get the results execute it or iterate it ;) |
| # |
Feb 9th 2018, 01:46 |
slackebot |
App\Model\Entity\Drug [associations] => Array ( ) [behaviors] => Array ( [0] => Search ) [defaultConnection] => default [connectionName] => default ) ) |
| # |
Feb 9th 2018, 01:46 |
slackebot |
integer [Drugs.used] => integer [used] => integer [Drugs__timestamp] => timestamp [Drugs.timestamp] => timestamp [timestamp] => timestamp ) [decorators] => 0 [executed] => [hydrate] => 1 [buffered] => 1 [formatters] => 0 [mapReducers] => 0 [contain] => Array ( ) [matching] => Array ( ) [extraOptions] => Array ( ) [repository] => App\Model\Table\DrugsTable Object ( [registryAlias] => Drugs [table] => drugs [alias] => Drugs [entityClass] => |
| # |
Feb 9th 2018, 01:46 |
loginews |
Cake\ORM\Query Object ( [(help)] => This is a Query object, to get the results execute or iterate it. [sql] => SELECT Drugs.id AS `Drugs__id`, Drugs.drug AS `Drugs__drug`, Drugs.used AS `Drugs__used`, Drugs.timestamp AS `Drugs__timestamp` FROM drugs Drugs [params] => Array ( ) [defaultTypes] => Array ( [Drugs__id] => integer [Drugs.id] => integer [id] => integer [Drugs__drug] => string [Drugs.drug] => string [drug] => string [Drugs__used] => |
| # |
Feb 9th 2018, 01:43 |
loginews |
hold will paste it |
| # |
Feb 9th 2018, 01:43 |
ricksaccous |
what is it showing instead? |
| # |
Feb 9th 2018, 01:42 |
loginews |
I used that code in a controller. |
| # |
Feb 9th 2018, 01:41 |
loginews |
I am surprised that print_r($data) does not show the data. Any help? |
| # |
Feb 9th 2018, 01:40 |
loginews |
File uploaded https://cakesf.slack.com/files/U435V89H8/F978SAAPQ/-.txt / https://slack-files.com/T053DPNCM-F978SAAPQ-72f855ed2e |
| # |
Feb 8th 2018, 23:23 |
pedroseco |
in bootstrap.php for this example |
| # |
Feb 8th 2018, 23:23 |
pedroseco |
On the Event system, if I need to listen to a created event on a different plugin, for example, do I just need to : EventManager::instance()->on(Model.MyEvent) to make it run a particular callback? |
| # |
Feb 8th 2018, 22:33 |
etipaced |
(I’m referring to reading from the db, not handling request data.) |
| # |
Feb 8th 2018, 22:31 |
etipaced |
When does Cake convert db `datetime` columns into a `FrozenTime` object? I have a need to modify this behavior while the `datetime` value is still a string. |
| # |
Feb 8th 2018, 21:10 |
jameg83 |
Hi can anyone help with CakePdf? I’m getting an error500 ‘permission denied when executing command “usr/bin...”. I’ve checked binary file permissions and all users can execute. |
| # |
Feb 8th 2018, 21:10 |
madrid998 |
Is it possible to have a Table object with a hard-coded array as a record source? |
| # |
Feb 8th 2018, 20:23 |
kevin |
its just this crappy little if/else statement right now. I dont like that a ton. |
| # |
Feb 8th 2018, 20:21 |
kevin |
so right now, I have a default.ctp, and I’m checking to see if the user is logged in. If yes, I display one default.ctp, if no, I display a different one. Is there a better way to do this? like one default.ctp for auth’d vs another for unauth’d? |
| # |
Feb 8th 2018, 20:19 |
kevin |
thats @alysson-azevedo!!! That did the trick for me. I wasnt looking at $rules. I was trying to do it through validation. |
| # |
Feb 8th 2018, 19:39 |
sayed |
File uploaded https://cakesf.slack.com/files/U8SE5F2NN/F964M9EHZ/screen_shot_2018-02-08_at_20.34.31.png / https://slack-files.com/T053DPNCM-F964M9EHZ-f72efd5ed8 |
| # |
Feb 8th 2018, 19:39 |
sayed |
thats why i was getting the error while trying to clear cache |
| # |
Feb 8th 2018, 19:39 |
sayed |
nevermind, found the issue, apcu (for the cli) was running on a different build of the php version |
| # |
Feb 8th 2018, 19:34 |
sayed |
I tried a composer reinstall but still the same error |
| # |
Feb 8th 2018, 19:34 |
sayed |
@bravo-kernel I can see here https://github.com/cakephp/cakephp/issues/8896 that you had the same issue as i have now |
| # |
Feb 8th 2018, 19:33 |
alysson-azevedo |
check cakedc/users https://github.com/CakeDC/users/blob/master/src/Model/Table/UsersTable.php |
| # |
Feb 8th 2018, 19:21 |
kevin |
I cant seem to find anything to specifically assist with that |
