Questions tagged with db

2 answers

0 votes

Asked by lenzcom, on 31/10/09 in Models

How can i write to sqlite-memory:db?

Hi,

how must my db-config look like to write into sqlite memory:db?

thanks...

0 answers

0 votes

Asked by shapan, on 23/1/10 in Installation / Configuration

Suitable database for CD application

Hello

I need to build a database CD application with proper database security. I am planning to use server2go (www.server2go-web.de) and cakephp with suitable database. Mysql is ok but I can't give proper security to my database. As you know in...

2 answers

0 votes

Asked by st3ph, on 3/2/10 in Shells

Fatal error on dbo_source

Hi,

I am using cakephp 2.5 and I have a problem when I try to use the shell I have the following error :


Fatal error: Call to undefined function:  connect() in /home/USER/DOMAIN/dev/front/cake/libs/model/datasources/dbo_source.php on line 124

Here...

1 answer

0 votes

Asked by jel402, on 25/2/10 in Models

cakephp shell not validating before saving entries

Hello,

Hello,

I have a model called Issue, which when its associated controller and

views are visited on a webpage, (.../issues/add, e.g.) checks for

unique titles and won't submit duplicate entries with the same title

(I have been testing this with...

1 answer

0 votes

Asked by cupidoly, on 25/3/10 in Models

Multiple Table-Model, Multiple DB

I am newbie in CakePHP, using it only for 2 days.

I am using PHP 5.2.10, MySQL 5.0.84, CakePHP 1.2.6.

I have two questions.

Scenario 1. While designing my site in paper, I decided to split my tables into parts ( For example, member table will be...

1 answer

1 vote

Asked by odin88, on 27/3/10 in Models

CakePHP and MongoDB / CouchDB

How can I use CakePHP and MongoDB or CouchDB ?

Is there any tutorial to use this kind of database rather than normal rdbms like mysql ?

0 answers

0 votes

Asked by Tyguy7, on 26/4/10 in Controllers

Single function using alternate database

Very simple question. Is there a native way to run a few save/deletes within a function on a database other than default? It has an identical structure, so it should work fine. The problem is all I can find on the subject is special dynamic...

1 answer

0 votes

Asked by spiliot, on 3/6/10 in Models

How to best implement ACL with multiple groups asigned to users

ACL is based on the tree behavior which implements a ParentNode[/ChildNode]/EndNode tree for the AROs. Each end node can only belong to a single parent.

My plan is to have users.hasAndBelongsToMany.usergroups so the user will be inheriting the...

4 answers

0 votes

Asked by CoreyT, on 4/6/10 in Shells

How to use cake schema create DbAcl correctly

Hi I am new to CakePHP, and going through the tutorial for a "Simple Acl Controlled Application" I am stuck at the part where it says to run "cake schema create DbAcl". Everytime I run that command, I just get the cake schema help, nothing else....

1 answer

0 votes

Asked by pastryking, on 21/7/10 in Models

Do I have to use the InnoDB database Engine to enjoy the relationship model in cake php?

I currently have a database running on the Myisam Engine. I am trying to link various tables and their foreign keys together so when i retrieve an object I have the associated information in the object too. I have executed this code wise (using...

0 answers

0 votes

Asked by wcal, on 5/8/10 in Models

find returns stdClass Object?

Hi Guys,

I just wondering, i'm doing normal findBy<column_name>($value) but somehow the return value is in stdClass Object instead of array.. Did i do something wrong?

What should i do if i want just the normal array? Thanks

0 answers

0 votes

Asked by ofranquesa, on 17/8/10 in Models

ODBC in Cake 1.3 ???

Seems that many data sources drivers has been removed on version 1.3.

In particular, what happened with connections ODBC? Anybody had achieved configure a ODBC connection in cakephp 1.3? How? :D

0 answers

0 votes

Asked by johnnymoped, on 21/8/10 in Shells

Accessing DboSource from Shell - Setting $cacheMethods to false

Is there a way to access the DboSource Instance from a Shell?

I need to disable methodCache because the hashing algorythm is causing false SQL-conditions. I know it could be disabled directly in dbo_source.php but I don't want to disable it...

0 answers

0 votes

Asked by celsowm, on 30/9/10 in Components

Db_acl 1.3 X Multiple Apps

In the 1.2, works (fine) with this tree:

  • app1/
    • controllers/
      • controllerName/
        • actionName/
  • app2/
    • controllers/
      • controllerName2/
        • actionName2/

But in db_acl 1.3 does not works...and cake does not provide the

actionPath..

How works in 1.3?

Thanks,

Celso.

1 answer

0 votes

Asked by Ernesto, on 13/1/11 in Models

model->query() on mssql always returning empty array in 2.0.0-dev

Hi all.

i have a simple app with 2 database configs (MySQL + SQL Server 2005)

both are working and no errors are returned.

var $default = array(

"driver" = "mysql",

"host" = "127.0.0.1",

"login" = "root",

"password" = "*",

"database" = "mydb"

);

var...

0 answers

0 votes

Asked by salines, on 23/1/11 in Models

CakePHP i18n & MongoDB

CakePHP + i18n + MongoDB

I want to hear your experience. Example code?

How to set up? Thanks

1 answer

0 votes

Asked by garagod, on 24/1/11 in Models

how to read() by "title", or findByTitle() but populating the Object at the same time?

Hi!

Q: What is the most reasonable way to read() one record from the db table, but using a different column than "id" (for example "title") and populating the Object at the same time? What I want to do is find one record and keep it in my Object...

0 answers

0 votes

Asked by rogernem, on 16/2/11 in Controllers

Check if exists in db before save($this->data)

I have a form in my view that sends name and email


if(!empty($this->data)) {
 
 if($this->Home->save($this->data)) {
    $this->Session->setFlash("Saved!");
    $this->redirect('/home');
 }
}

I have a unique key in my database so if I try to save...

0 answers

0 votes

Asked by beBibietyeu, on 3/3/11 in Installation / Configuration

Is there anyone connect CakePHP to MS Access File successful? Helps me, plesase.

Is there anyone connect CakePHP to MS Access File successful? Helps me, plesase.

I have a file database ms access, but I don't know how to connect CakePHP to it.

I use :

<?php

$dbq =...

0 answers

1 vote

Asked by beBibietyeu, on 3/3/11 in Installation / Configuration

Is there anyone connect CakePHP to MS Access File successful? Helps me, plesase.

Is there anyone connect CakePHP to MS Access File successful? Helps me, plesase.

I have a file database ms access, but I don't know how to connect CakePHP to it.

I use :


<?php
	
	$dbq =...
<< previous 1   2   3