[Phpmyadmin-devel] foreign key on external database

List overview All Threads
Download

newer

older

[Phpmyadmin-devel] user prefs:...

[Phpmyadmin-devel] phpMyAdmin...

Isart Montane

11 Jun 2009 11 Jun '09

11:40 p.m.

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

Attachments:

attachment.html (text/html — 412 bytes)

Show replies by date

Herman van Rink

12 Jun 12 Jun

10:31 a.m.

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

Marc Delisle

1:04 p.m.

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

Arthur L. Butts

13 Jun 13 Jun

4:50 p.m.

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

Isart Montane

10:11 p.m.

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

Isart Montane

14 Jun 14 Jun

8:45 p.m.

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.comwrote:

...

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

Marc Delisle

15 Jun 15 Jun

12:38 p.m.

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?

Add the table dropdown on an iframe and reload it when the database dropdown changes (javascrpt)

Ajax

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

Isart Montane

9:07 p.m.

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?

...
Add the table dropdown on an iframe and reload it when the database dropdown changes (javascrpt)

Ajax

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

Marc Delisle

9:41 p.m.

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

Marc Delisle

10:20 p.m.

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

Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

-- Marc Delisle http://infomarc.info

5668

Age (days ago)

5672

Last active (days ago)

developers@phpmyadmin.net

9 comments

4 participants

tags (0)

participants (4)

Arthur L. Butts
Herman van Rink
Isart Montane
Marc Delisle