[Phpmyadmin-devel] foreign key on external database

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

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@infomarc.info] Sent: Friday, June 12, 2009 7:05 AM To: phpmyadmin-devel@lists.sourceforge.net 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@lists.sourceforge.net 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@infomarc.info> 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@lists.sourceforge.net 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@gmail.com>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@infomarc.info> 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@lists.sourceforge.net 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@gmail.com <mailto:isart.montane@gmail.com>> 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@infomarc.info <mailto:marc@infomarc.info>> 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> 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@lists.sourceforge.net 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@infomarc.info> 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@gmail.com <mailto:isart.montane@gmail.com>> 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@infomarc.info <mailto:marc@infomarc.info>> 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> 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@lists.sourceforge.net 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@lists.sourceforge.net 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@infomarc.info <mailto:marc@infomarc.info>> 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@gmail.com <mailto:isart.montane@gmail.com> > <mailto:isart.montane@gmail.com <mailto:isart.montane@gmail.com>>> 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@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> > <mailto:Phpmyadmin-devel@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net>> > 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> > 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> 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@lists.sourceforge.net 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@infomarc.info <mailto:marc@infomarc.info>> 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@gmail.com <mailto:isart.montane@gmail.com> > <mailto:isart.montane@gmail.com <mailto:isart.montane@gmail.com>>> 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@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> > <mailto:Phpmyadmin-devel@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net>> > 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> > 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@lists.sourceforge.net <mailto:Phpmyadmin-devel@lists.sourceforge.net> 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
participants (4)
-
Arthur L. Butts
-
Herman van Rink
-
Isart Montane
-
Marc Delisle