[Phpmyadmin-devel] Improved notification when attempting to insert invalid data.
chirayu.chiripal at gmail.com
Tue Jul 29 14:16:22 CEST 2014
On Tue, Jul 29, 2014 at 1:32 AM, Isaac Bennetch <bennetch at gmail.com> wrote:
> 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
to validate the field when it loses focus or at keyup event.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers