[Phpmyadmin-devel] Improved notification when attempting to insert invalid data.

[Chirayu Chiripal]

On Tue, Jul 29, 2014 at 1:32 AM, Isaac Bennetch <bennetch at gmail.com> wrote:

> Hi,
>
> On 7/28/14, 1:30 PM, Chirayu Chiripal wrote:
> > Hi,
> >
> > My GSoC task for this week is "Improved notification when attempting to
> > insert invalid data". I would like to know at which places validation is
> > required to be done?
>
> The idea here is basically that if a user attempts to insert data that
> will be truncated that we'll warn them. Some of this has already been
> implemented (for instance, try to insert the text "foo" to a column of
> type INT(10); the field turns red indicating a problem).
>
> This can be enhanced, though, for instance the following scenarios do
> not warn correctly:
> * Insert 999 to a TINYINT
> * Insert 99999999999 to an INT
>

For integer types we can change our current input type="text" to input
type="number" and specify a min and max value using attributes. Or, we
still have to add a min and max value attribute and use Javascript/Jquery
to validate the field when it loses focus or at keyup event.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140729/34d0e048/attachment.html>