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

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

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

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