Why not consider an alternative hosting? If you like to fiddle and mess
around, I use a service called Linode that allows me to setup my own server
with the software I want and full root access to my machine, etc. Pretty
much they give you a virtualised machine, you install the OS, and all other
software and then transfer domain when you're ready for it.

On Fri, Oct 16, 2009 at 9:18 AM, Davide Borsatto <[email protected]> wrote:

>
> I don't have multiple connections or something like that :)
>
> The point is that my crappy company hosting does not allow me to put
> stuff outside the default root directory (httpdocs in my case), so i
> have to leave the file "public". Writing the connection parameters in
> PHP would be a solution, but now comes in my mind that I could tell
> apache not to allow to enter that directory... :)
>
> On Oct 15, 4:16 pm, Gareth McCumskey <[email protected]> wrote:
> > So for a fuller example:
> >
> > databases.yml:
> >
> > all:
> >   propel:
> >     class: sfPropelDatabase
> >     param:
> >       dsn: 'mysql://pinpoint:[email protected]/pinpoint'
> >
> >   somedomain.org:
> >     class: sfPropelDatabase
> >     param:
> >       dsn: 'mysql://pinpoint:p1np0...@localhost/pinpoint'
> >
> >   somedomain.com:
> >     class: sfPropelDatabase
> >     param:
> >       dsn: 'mysql://pinpoint:[email protected]/pinpoint'
> >
> > In your Model classes overwrite calls to database by putting inside the
> > file:
> >
> > TableNamePeer
> >
> > public static function doSelect(Criteria $criteria, $con = null)
> > {
> >     parent::doSelect($criteria, Propel::getConnection(str_replace("www.",
> > "", sfRequest::getHost())));
> >
> > }
> >
> > On Wed, Oct 14, 2009 at 5:47 PM, Carlos Jorge Andrade <
> >
> >
> >
> > [email protected]> wrote:
> >
> > > On 14, Oct 2009, at 13:48 , Gareth McCumskey wrote:
> >
> > > > First thing that goes through my mind is why you would want to do
> > > > that? databases.yml is where all database connections are defined
> > > > and you can create as many as you like in there.
> >
> > > Imagine the exact same codebase to power two different sites.
> > > Like somesite.com and somesite.org, one document root... depending on
> > > the domain accessed, the db connection would change. How would one do
> > > that ?
> >
> > >http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony.
> ..
> >
> > > > On Wed, Oct 14, 2009 at 1:04 PM, Davide Borsatto <[email protected]>
> > > > wrote:
> >
> > > > Hi everybody,
> >
> > > > Is there a way to specify the connection parameters (those normally
> > > > specified in databases.yml) via PHP? Maybe in the
> ProjectConfiguration
> > > > class, but how?
> >
> > > > --
> > > > Gareth McCumskey
> > > >http://garethmccumskey.blogspot.com
> > > > twitter: @garethmcc
> >
> > --
> > Gareth McCumskeyhttp://garethmccumskey.blogspot.com
> > twitter: @garethmcc
> >
>


-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to