Hi,
i have found a strange phpMyAdmin reaction.
if you insert a string like this:
-snip- for ($i=0,$str="";$i<=255;$i++) $str.=chr($i); mysql_query("insert into table (xy) values('".AddSlashes($str)."')"); -snap-
.. into a blob field, you can't edit and save this row if you use phpMyAdmin.
the question is, it is a bug or a feature, because it saves the binary data.
-- Steve Alberty [mailto:alberty@neptunlabs.de] NeptunLabs GbR ----------------------------------------------------Ende der Nachricht--
I just got a patch from a user, about this: "I have attached two changes I made to phpmyadmin 2.1.0 to keep the content of BLOB data fields (images for example) intact after editing a table row with phpmyadmin. See my comments in the code."
I will check this and come back to you.
Steve Alberty a écrit :
Hi,
i have found a strange phpMyAdmin reaction.
if you insert a string like this:
-snip- for ($i=0,$str="";$i<=255;$i++) $str.=chr($i); mysql_query("insert into table (xy) values('".AddSlashes($str)."')"); -snap-
.. into a blob field, you can't edit and save this row if you use phpMyAdmin.
the question is, it is a bug or a feature, because it saves the binary data.
-- Steve Alberty [mailto:alberty@neptunlabs.de] NeptunLabs GbR ----------------------------------------------------Ende der Nachricht--
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Marc,
it's a good idea to leave binary data untouched. maybe, phpmyadmin should mark the blob input field, if the user can't edit it.
-- Steve
-----Original Message----- From: phpmyadmin-devel-admin@lists.sourceforge.net [mailto:phpmyadmin-devel-admin@lists.sourceforge.net]On Behalf Of Marc Delisle Sent: Wednesday, June 27, 2001 4:26 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] bug or feature?
I just got a patch from a user, about this: "I have attached two changes I made to phpmyadmin 2.1.0 to keep the content of BLOB data fields (images for example) intact after editing a table row with phpmyadmin. See my comments in the code."
I will check this and come back to you.
Steve Alberty a écrit :
Hi,
i have found a strange phpMyAdmin reaction.
if you insert a string like this:
-snip- for ($i=0,$str="";$i<=255;$i++) $str.=chr($i); mysql_query("insert into table (xy) values('".AddSlashes($str)."')"); -snap-
.. into a blob field, you can't edit and save this row if you use phpMyAdmin.
the question is, it is a bug or a feature, because it saves the
binary data.
-- Steve Alberty [mailto:alberty@neptunlabs.de] NeptunLabs GbR ----------------------------------------------------Ende der Nachricht--
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle Service de l'informatique Collège de Sherbrooke, Québec
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Marc Delisle -
Steve Alberty