[Phpmyadmin-devel] foreign key on external database

Marc Delisle marc at infomarc.info
Mon Jun 15 22:20:25 CEST 2009


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 at infomarc.info 
>> <mailto:marc at 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 at gmail.com <mailto:isart.montane at gmail.com>
>>      > <mailto: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>
>>      >     <mailto: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>
>>      >         <mailto: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
>>     <mailto:Phpmyadmin-devel at 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 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




More information about the Developers mailing list