[Phpmyadmin-devel] foreign key on external database

[Marc Delisle]

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 at gmail.com 
> <mailto:isart.montane at 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 at infomarc.info
>     <mailto:marc at 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 at lists.sourceforge.net
>         <mailto:Phpmyadmin-devel at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


-- 
Marc Delisle
http://infomarc.info