Hi Olivier! You could just put a primary key on your ID_msg field and the trouble would be gone. I think in the future Nijel wants to implement checkboxes for deleting multiple entries at once, so I guess he'll implement a different logic then anyways - I for one would dislike seeing those huge form buttons on every page instead of hovering links. Maybe someone of the other developers wants to put a word on this... Regards, Garvin. <quote who="Olivier Brouckaert">
my query is
SELECT Sujet,Message FROM forum WHERE ID_msg > 1000
but if you use a button for GET and POST you juste have to do this way
<form method="<?php if($primary_key || $length<2048) echo 'GET'; else echo 'POST'; ?>" action="script.php"> <input type="hidden" name="where_condition" value="<?php if($primary_key) echo $primery_key; else echo $text; ?>"> <input type="submit" name="choice" value="Modify"> <input type="submit" name="choice" value="Delete"> </form>
and no javascript is used
----- Original Message ----- From: "Garvin Hicking" <squirrel@supergarv.de> To: <phpmyadmin-devel@lists.sourceforge.net> Cc: "Olivier Brouckaert" <oli.brouckaert@i-services.be> Sent: Saturday, May 03, 2003 11:27 AM Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et liens dans l'affichage des r ésultats d'une requete
Hi Olivier!
or to take less place, a link with an onclick attribute like this
<a href="#null" onclick="document.myform.submit()">Modify</a>
We can't use a button, because then we would have to use javascript to submit it via GET. And we don't want phpMyAdmin to be dependant on JavaScript.
On the other hand, if a button shows up in your table display, you're doing something wrong with your table layout anyways. Use primary keys where possible, and you won't have to deal with extra length GET methods...
But thanks for your consideration, Garvin.
----- Original Message ----- From: "Olivier Brouckaert" <oli.brouckaert@i-services.be> To: <squirrel@supergarv.de> Sent: Saturday, May 03, 2003 10:36 AM Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et
liens
dans l'affichage des r ésultats d'une requete
ok but why not place a button for GET method as well ? If more than 2048 chars, use POST method, otherwise GET method, and for the user that would be transparent
----- Original Message ----- From: "Garvin Hicking" <squirrel@supergarv.de> To: "Olivier Brouckaert" <oli.brouckaert@i-services.be> Sent: Saturday, May 03, 2003 10:29 AM Subject: Re: [Phpmyadmin-devel] Re: [Phpmyadmin-devel] bug : bouton et liens dans l'affichage des r ésultats d'une requete
Hi Olivier!
Thanks for translating that - the reason is because the Internet Explorer doesn't allow posting a form via a GET method when there are more than 2048 chars. So we use the POST field whenever a request is larger that 2048 chars, and then we have to use buttons.
You could reduce that by placing primary keys on your table, so phpMyAdmin doesn't have to take so many chars into regard when building a unique condition to fetch your data.
Regards, Garvin.
<quote who="Olivier Brouckaert">
Hello
when I show the result of a query "SELECT * FROM WHERE ..." in phpMyAdmin, sometimes the link Modify / Delete is replaced by a button.
Why this and will it be fixed in phpMyAdmin 2.5.0 final release ?
This is a strange bug because if there is sometimes a button, that means there must be a condition which, when it is true, shows a button, otherwise a link. But why that test ?
thanks
Olivier
----- Original Message ----- From: "Garvin Hicking" <squirrel@supergarv.de> To: "Olivier Brouckaert" <oli.brouckaert@i-services.be> Sent: Saturday, May 03, 2003 9:58 AM Subject: Re: [Phpmyadmin-devel] bug : bouton et liens dans l'affichage des résultats d'une requete
> Hi Olivier! > > Are you able to write in english? If yes, please do so. I'm curious what you're > writing about :) > > Regards, > Garvin. > > <quote who="Olivier Brouckaert"> > > Bonjour, > > > > lorsque j'affiche le contenu d'une requete SELECT dans phpmyadmin, parfois je vois > > un lien Modifier / Supprimer parfois ce lien est remplacé par un bouton. > > > > A quoi cela est-il du et est-ce que ce sera corrigé dans la version 2.5.0 ? > > > > En tout cas c'est un étrange bug :) car s'il y a un bouton qui apparait parfois il > > doit y avoir un test sur une condition qui, quand elle est à vrai, affiche un > > bouton, sinon un lien. Mais pourquoi ce test ? > > > > Cordialement, > > > > Olivier Brouckaert > > webmaster@internetservices-fr.net > > > > > -- > Bye, > Garvin. > >
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Bye, Garvin.
-- Bye, Garvin.
-- Bye, Garvin.