phpMyAdmin

Isart Montane wrote:
> Hi all,
>
> For a personal project I need to create foreign keys between different
> databases. I've realised that phpmyadmin only allows foreign keys on
> the same db so I'm thinking on develop this feature. 
>
> I know it's not a very good practice to create foreign keys on
> different databases... but I need it anyway...
>
> Any comments or guidelines to do it?
I guess the relation table from the pmadb already has room to store this
info, so it should be mostly a matter of implementing interface details.
I'd be happy to review a patch.

On the subject of guidelines ... please try to follow the coding
guidelines as referred to on http://www.phpmyadmin.net/home_page/improve.php


Regards,

Herman van Rink

Isart Montane a écrit :
> Hi all,
> 
> For a personal project I need to create foreign keys between different 
> databases. I've realised that phpmyadmin only allows foreign keys on the 
> same db so I'm thinking on develop this feature. 
> 
> I know it's not a very good practice to create foreign keys on different 
> databases... but I need it anyway...
> 
> Any comments or guidelines to do it?
> 
> Thanks,
> Isart
> 

Hi Isart,
good initiative! Are you thinking of implementing this in Relation View 
or the Designer page or both?

On Relation View, we could think of a database drop-down, even if this 
can pose a problem with too many databases -- but we already have this 
problem at other places where we have such drop-down.

-- 
Marc Delisle
http://infomarc.info

Hi,
I'm new to php and phpmyadmin. I have a windows 2k Advanced Server running
IIS. I think I loaded MySql OK, & tried to load php & phpmyadmin. I don't
think those loaded properly. Would someone be willing to set it up and check
it out. I would pay for the help.

Art Butts.

-----Original Message-----
From: Marc Delisle [mailto:marc@...] 
Sent: Friday, June 12, 2009 7:05 AM
To: phpmyadmin-devel@...
Subject: Re: [Phpmyadmin-devel] foreign key on external database

Isart Montane a écrit :
> Hi all,
> 
> For a personal project I need to create foreign keys between different 
> databases. I've realised that phpmyadmin only allows foreign keys on 
> the same db so I'm thinking on develop this feature.
> 
> I know it's not a very good practice to create foreign keys on 
> different databases... but I need it anyway...
> 
> Any comments or guidelines to do it?
> 
> Thanks,
> Isart
> 

Hi Isart,
good initiative! Are you thinking of implementing this in Relation View or
the Designer page or both?

On Relation View, we could think of a database drop-down, even if this can
pose a problem with too many databases -- but we already have this problem
at other places where we have such drop-down.

--
Marc Delisle
http://infomarc.info

----------------------------------------------------------------------------
--
Crystal Reports - New Free Runtime and 30 Day Trial Check out the new
simplified licensing option that enables unlimited royalty-free distribution
of the report engine for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

My idea is to add it as a dropdown in the relational view. I will take a
look at the designer page as well and see if I can do both.

On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle <marc@...> wrote:

> Isart Montane a écrit :
> > Hi all,
> >
> > For a personal project I need to create foreign keys between different
> > databases. I've realised that phpmyadmin only allows foreign keys on the
> > same db so I'm thinking on develop this feature.
> >
> > I know it's not a very good practice to create foreign keys on different
> > databases... but I need it anyway...
> >
> > Any comments or guidelines to do it?
> >
> > Thanks,
> > Isart
> >
>
> Hi Isart,
> good initiative! Are you thinking of implementing this in Relation View
> or the Designer page or both?
>
> On Relation View, we could think of a database drop-down, even if this
> can pose a problem with too many databases -- but we already have this
> problem at other places where we have such drop-down.
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>

Hi guys,

If I add a new dropdown with the databases, the table dropdown should be
updated when the database dropdown changes. Any suggestion on how to do it?


   1. Add the table dropdown on an iframe and reload it when the database
   dropdown changes (javascrpt)
   2. Ajax
   3. Others?

Thx!
Isart

On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane <isart.montane@...:

> My idea is to add it as a dropdown in the relational view. I will take a
> look at the designer page as well and see if I can do both.
>
>
> On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle <marc@...> wrote:
>
>> Isart Montane a écrit :
>> > Hi all,
>> >
>> > For a personal project I need to create foreign keys between different
>> > databases. I've realised that phpmyadmin only allows foreign keys on the
>> > same db so I'm thinking on develop this feature.
>> >
>> > I know it's not a very good practice to create foreign keys on different
>> > databases... but I need it anyway...
>> >
>> > Any comments or guidelines to do it?
>> >
>> > Thanks,
>> > Isart
>> >
>>
>> Hi Isart,
>> good initiative! Are you thinking of implementing this in Relation View
>> or the Designer page or both?
>>
>> On Relation View, we could think of a database drop-down, even if this
>> can pose a problem with too many databases -- but we already have this
>> problem at other places where we have such drop-down.
>>
>> --
>> Marc Delisle
>> http://infomarc.info
>>
>>
>> ------------------------------------------------------------------------------
>> Crystal Reports - New Free Runtime and 30 Day Trial
>> Check out the new simplified licensing option that enables unlimited
>> royalty-free distribution of the report engine for externally facing
>> server and web deployment.
>> http://p.sf.net/sfu/businessobjects
>> _______________________________________________
>> Phpmyadmin-devel mailing list
>> Phpmyadmin-devel@...
>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>
>

Hi Isart,
I've done something similar with Ajax. Also you should display a submit 
button to trigger the update of the tables dropdown when javascript is 
disabled in the browser.

Marc

Isart Montane a écrit :
> Hi guys,
> 
> If I add a new dropdown with the databases, the table dropdown should be 
> updated when the database dropdown changes. Any suggestion on how to do it?
> 
>    1. Add the table dropdown on an iframe and reload it when the
>       database dropdown changes (javascrpt)
>    2. Ajax
>    3. Others?
> 
> Thx!
> Isart
> 
> On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane <isart.montane@... 
> <mailto:isart.montane@...>> wrote:
> 
>     My idea is to add it as a dropdown in the relational view. I will
>     take a look at the designer page as well and see if I can do both.
> 
> 
>     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle <marc@...
>     <mailto:marc@...>> wrote:
> 
>         Isart Montane a écrit :
>          > Hi all,
>          >
>          > For a personal project I need to create foreign keys between
>         different
>          > databases. I've realised that phpmyadmin only allows foreign
>         keys on the
>          > same db so I'm thinking on develop this feature.
>          >
>          > I know it's not a very good practice to create foreign keys
>         on different
>          > databases... but I need it anyway...
>          >
>          > Any comments or guidelines to do it?
>          >
>          > Thanks,
>          > Isart
>          >
> 
>         Hi Isart,
>         good initiative! Are you thinking of implementing this in
>         Relation View
>         or the Designer page or both?
> 
>         On Relation View, we could think of a database drop-down, even
>         if this
>         can pose a problem with too many databases -- but we already
>         have this
>         problem at other places where we have such drop-down.
> 
>         --
>         Marc Delisle
>         http://infomarc.info
> 
>         ------------------------------------------------------------------------------
>         Crystal Reports - New Free Runtime and 30 Day Trial
>         Check out the new simplified licensing option that enables unlimited
>         royalty-free distribution of the report engine for externally facing
>         server and web deployment.
>         http://p.sf.net/sfu/businessobjects
>         _______________________________________________
>         Phpmyadmin-devel mailing list
>         Phpmyadmin-devel@...
>         <mailto:Phpmyadmin-devel@...>
>         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing 
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


-- 
Marc Delisle
http://infomarc.info

Thanks marc, where can I get this code? I've run a few grep on the code and
couldn't find it

On Mon, Jun 15, 2009 at 11:38 AM, Marc Delisle <marc@...> wrote:

> Hi Isart,
> I've done something similar with Ajax. Also you should display a submit
> button to trigger the update of the tables dropdown when javascript is
> disabled in the browser.
>
> Marc
>
> Isart Montane a écrit :
> > Hi guys,
> >
> > If I add a new dropdown with the databases, the table dropdown should be
> > updated when the database dropdown changes. Any suggestion on how to do
> it?
> >
> >    1. Add the table dropdown on an iframe and reload it when the
> >       database dropdown changes (javascrpt)
> >    2. Ajax
> >    3. Others?
> >
> > Thx!
> > Isart
> >
> > On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane <isart.montane@...
> > <mailto:isart.montane@...>> wrote:
> >
> >     My idea is to add it as a dropdown in the relational view. I will
> >     take a look at the designer page as well and see if I can do both.
> >
> >
> >     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle <marc@...
> >     <mailto:marc@...>> wrote:
> >
> >         Isart Montane a écrit :
> >          > Hi all,
> >          >
> >          > For a personal project I need to create foreign keys between
> >         different
> >          > databases. I've realised that phpmyadmin only allows foreign
> >         keys on the
> >          > same db so I'm thinking on develop this feature.
> >          >
> >          > I know it's not a very good practice to create foreign keys
> >         on different
> >          > databases... but I need it anyway...
> >          >
> >          > Any comments or guidelines to do it?
> >          >
> >          > Thanks,
> >          > Isart
> >          >
> >
> >         Hi Isart,
> >         good initiative! Are you thinking of implementing this in
> >         Relation View
> >         or the Designer page or both?
> >
> >         On Relation View, we could think of a database drop-down, even
> >         if this
> >         can pose a problem with too many databases -- but we already
> >         have this
> >         problem at other places where we have such drop-down.
> >
> >         --
> >         Marc Delisle
> >         http://infomarc.info
> >
> >
> ------------------------------------------------------------------------------
> >         Crystal Reports - New Free Runtime and 30 Day Trial
> >         Check out the new simplified licensing option that enables
> unlimited
> >         royalty-free distribution of the report engine for externally
> facing
> >         server and web deployment.
> >         http://p.sf.net/sfu/businessobjects
> >         _______________________________________________
> >         Phpmyadmin-devel mailing list
> >         Phpmyadmin-devel@...
> >         <mailto:Phpmyadmin-devel@...>
> >         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >
> ------------------------------------------------------------------------------
> > Crystal Reports - New Free Runtime and 30 Day Trial
> > Check out the new simplified licensing option that enables unlimited
> > royalty-free distribution of the report engine for externally facing
> > server and web deployment.
> > http://p.sf.net/sfu/businessobjects
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Phpmyadmin-devel mailing list
> > Phpmyadmin-devel@...
> > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>

Hi Isart,

what I've done is not in phpMyAdmin, it's for a project at my job. Let 
me verify how I could help you.

Marc

Isart Montane a écrit :
> Thanks marc, where can I get this code? I've run a few grep on the code 
> and couldn't find it
> 
> On Mon, Jun 15, 2009 at 11:38 AM, Marc Delisle <marc@... 
> <mailto:marc@...>> wrote:
> 
>     Hi Isart,
>     I've done something similar with Ajax. Also you should display a submit
>     button to trigger the update of the tables dropdown when javascript is
>     disabled in the browser.
> 
>     Marc
> 
>     Isart Montane a écrit :
>      > Hi guys,
>      >
>      > If I add a new dropdown with the databases, the table dropdown
>     should be
>      > updated when the database dropdown changes. Any suggestion on how
>     to do it?
>      >
>      >    1. Add the table dropdown on an iframe and reload it when the
>      >       database dropdown changes (javascrpt)
>      >    2. Ajax
>      >    3. Others?
>      >
>      > Thx!
>      > Isart
>      >
>      > On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane
>     <isart.montane@... <mailto:isart.montane@...>
>      > <mailto:isart.montane@...
>     <mailto:isart.montane@...>>> wrote:
>      >
>      >     My idea is to add it as a dropdown in the relational view. I will
>      >     take a look at the designer page as well and see if I can do
>     both.
>      >
>      >
>      >     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle
>     <marc@... <mailto:marc@...>
>      >     <mailto:marc@... <mailto:marc@...>>> wrote:
>      >
>      >         Isart Montane a écrit :
>      >          > Hi all,
>      >          >
>      >          > For a personal project I need to create foreign keys
>     between
>      >         different
>      >          > databases. I've realised that phpmyadmin only allows
>     foreign
>      >         keys on the
>      >          > same db so I'm thinking on develop this feature.
>      >          >
>      >          > I know it's not a very good practice to create foreign
>     keys
>      >         on different
>      >          > databases... but I need it anyway...
>      >          >
>      >          > Any comments or guidelines to do it?
>      >          >
>      >          > Thanks,
>      >          > Isart
>      >          >
>      >
>      >         Hi Isart,
>      >         good initiative! Are you thinking of implementing this in
>      >         Relation View
>      >         or the Designer page or both?
>      >
>      >         On Relation View, we could think of a database drop-down,
>     even
>      >         if this
>      >         can pose a problem with too many databases -- but we already
>      >         have this
>      >         problem at other places where we have such drop-down.
>      >
>      >         --
>      >         Marc Delisle
>      >         http://infomarc.info
>      >
>      >        
>     ------------------------------------------------------------------------------
>      >         Crystal Reports - New Free Runtime and 30 Day Trial
>      >         Check out the new simplified licensing option that
>     enables unlimited
>      >         royalty-free distribution of the report engine for
>     externally facing
>      >         server and web deployment.
>      >         http://p.sf.net/sfu/businessobjects
>      >         _______________________________________________
>      >         Phpmyadmin-devel mailing list
>      >         Phpmyadmin-devel@...
>     <mailto:Phpmyadmin-devel@...>
>      >         <mailto:Phpmyadmin-devel@...
>     <mailto:Phpmyadmin-devel@...>>
>      >         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>      >
>      >
>      >
>      >
>      >
>     ------------------------------------------------------------------------
>      >
>      >
>     ------------------------------------------------------------------------------
>      > Crystal Reports - New Free Runtime and 30 Day Trial
>      > Check out the new simplified licensing option that enables unlimited
>      > royalty-free distribution of the report engine for externally facing
>      > server and web deployment.
>      > http://p.sf.net/sfu/businessobjects
>      >
>      >
>      >
>     ------------------------------------------------------------------------
>      >
>      > _______________________________________________
>      > Phpmyadmin-devel mailing list
>      > Phpmyadmin-devel@...
>     <mailto:Phpmyadmin-devel@...>
>      > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 
>     --
>     Marc Delisle
>     http://infomarc.info
> 
>     ------------------------------------------------------------------------------
>     Crystal Reports - New Free Runtime and 30 Day Trial
>     Check out the new simplified licensing option that enables unlimited
>     royalty-free distribution of the report engine for externally facing
>     server and web deployment.
>     http://p.sf.net/sfu/businessobjects
>     _______________________________________________
>     Phpmyadmin-devel mailing list
>     Phpmyadmin-devel@...
>     <mailto:Phpmyadmin-devel@...>
>     https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing 
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


-- 
Marc Delisle
http://infomarc.info

Hello again,
this should help you:
http://www.plus2net.com/php_tutorial/ajax_drop_down_list.php

Marc

Marc Delisle a écrit :
> Hi Isart,
> 
> what I've done is not in phpMyAdmin, it's for a project at my job. Let 
> me verify how I could help you.
> 
> Marc
> 
> Isart Montane a écrit :
>> Thanks marc, where can I get this code? I've run a few grep on the code 
>> and couldn't find it
>>
>> On Mon, Jun 15, 2009 at 11:38 AM, Marc Delisle <marc@... 
>> <mailto:marc@...>> wrote:
>>
>>     Hi Isart,
>>     I've done something similar with Ajax. Also you should display a submit
>>     button to trigger the update of the tables dropdown when javascript is
>>     disabled in the browser.
>>
>>     Marc
>>
>>     Isart Montane a écrit :
>>      > Hi guys,
>>      >
>>      > If I add a new dropdown with the databases, the table dropdown
>>     should be
>>      > updated when the database dropdown changes. Any suggestion on how
>>     to do it?
>>      >
>>      >    1. Add the table dropdown on an iframe and reload it when the
>>      >       database dropdown changes (javascrpt)
>>      >    2. Ajax
>>      >    3. Others?
>>      >
>>      > Thx!
>>      > Isart
>>      >
>>      > On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane
>>     <isart.montane@... <mailto:isart.montane@...>
>>      > <mailto:isart.montane@...
>>     <mailto:isart.montane@...>>> wrote:
>>      >
>>      >     My idea is to add it as a dropdown in the relational view. I will
>>      >     take a look at the designer page as well and see if I can do
>>     both.
>>      >
>>      >
>>      >     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle
>>     <marc@... <mailto:marc@...>
>>      >     <mailto:marc@... <mailto:marc@...>>> wrote:
>>      >
>>      >         Isart Montane a écrit :
>>      >          > Hi all,
>>      >          >
>>      >          > For a personal project I need to create foreign keys
>>     between
>>      >         different
>>      >          > databases. I've realised that phpmyadmin only allows
>>     foreign
>>      >         keys on the
>>      >          > same db so I'm thinking on develop this feature.
>>      >          >
>>      >          > I know it's not a very good practice to create foreign
>>     keys
>>      >         on different
>>      >          > databases... but I need it anyway...
>>      >          >
>>      >          > Any comments or guidelines to do it?
>>      >          >
>>      >          > Thanks,
>>      >          > Isart
>>      >          >
>>      >
>>      >         Hi Isart,
>>      >         good initiative! Are you thinking of implementing this in
>>      >         Relation View
>>      >         or the Designer page or both?
>>      >
>>      >         On Relation View, we could think of a database drop-down,
>>     even
>>      >         if this
>>      >         can pose a problem with too many databases -- but we already
>>      >         have this
>>      >         problem at other places where we have such drop-down.
>>      >
>>      >         --
>>      >         Marc Delisle
>>      >         http://infomarc.info
>>      >
>>      >        
>>     ------------------------------------------------------------------------------
>>      >         Crystal Reports - New Free Runtime and 30 Day Trial
>>      >         Check out the new simplified licensing option that
>>     enables unlimited
>>      >         royalty-free distribution of the report engine for
>>     externally facing
>>      >         server and web deployment.
>>      >         http://p.sf.net/sfu/businessobjects
>>      >         _______________________________________________
>>      >         Phpmyadmin-devel mailing list
>>      >         Phpmyadmin-devel@...
>>     <mailto:Phpmyadmin-devel@...>
>>      >         <mailto:Phpmyadmin-devel@...
>>     <mailto:Phpmyadmin-devel@...>>
>>      >         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>      >
>>      >
>>      >
>>      >
>>      >
>>     ------------------------------------------------------------------------
>>      >
>>      >
>>     ------------------------------------------------------------------------------
>>      > Crystal Reports - New Free Runtime and 30 Day Trial
>>      > Check out the new simplified licensing option that enables unlimited
>>      > royalty-free distribution of the report engine for externally facing
>>      > server and web deployment.
>>      > http://p.sf.net/sfu/businessobjects
>>      >
>>      >
>>      >
>>     ------------------------------------------------------------------------
>>      >
>>      > _______________________________________________
>>      > Phpmyadmin-devel mailing list
>>      > Phpmyadmin-devel@...
>>     <mailto:Phpmyadmin-devel@...>
>>      > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>>
>>     --
>>     Marc Delisle
>>     http://infomarc.info
>>
>>     ------------------------------------------------------------------------------
>>     Crystal Reports - New Free Runtime and 30 Day Trial
>>     Check out the new simplified licensing option that enables unlimited
>>     royalty-free distribution of the report engine for externally facing
>>     server and web deployment.
>>     http://p.sf.net/sfu/businessobjects
>>     _______________________________________________
>>     Phpmyadmin-devel mailing list
>>     Phpmyadmin-devel@...
>>     <mailto:Phpmyadmin-devel@...>
>>     https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ------------------------------------------------------------------------------
>> Crystal Reports - New Free Runtime and 30 Day Trial
>> Check out the new simplified licensing option that enables unlimited
>> royalty-free distribution of the report engine for externally facing 
>> server and web deployment.
>> http://p.sf.net/sfu/businessobjects
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Phpmyadmin-devel mailing list
>> Phpmyadmin-devel@...
>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
> 


-- 
Marc Delisle
http://infomarc.info