11 Jun
2009
11 Jun
'09
6: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
12 Jun
12 Jun
5: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
8:04 a.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
13 Jun
13 Jun
11:50 a.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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
5: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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
14 Jun
14 Jun
3: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(a)gmail.com>wrote;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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
15 Jun
15 Jun
7:38 a.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?
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(a)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(a)infomarc.info
<mailto:marc@infomarc.info>> wrote:
Isart Montane a écrit :
--
Marc Delisle
http://infomarc.info
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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
4: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(a)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(a)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(a)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(a)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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
4: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(a)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 :
------------------------------------------------------------------------------
> 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
>
------------------------------------------------------------------------
--
Marc Delisle
http://infomarc.info
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(a)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(a)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
even
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, 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(a)lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
<mailto:Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>>
------------------------------------------------------------------------
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
--
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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
5: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 :
--
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(a)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 :
------------------------------------------------------------------------------
> 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
>
------------------------------------------------------------------------
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(a)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(a)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
even
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, 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(a)lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
<mailto:Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>>
------------------------------------------------------------------------
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
--
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(a)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(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
5563
days inactive
5567
days old
9 comments
4 participants
participants (4)
-
Arthur L. Butts -
Herman van Rink -
Isart Montane -
Marc Delisle