change of value of a text input in insert into table

0

The compte field does not know why it has a maximum limit of 4294967295 . As soon as you put a higher number, e.g. 4294967296 o 9876543210 , in that field, the highest accepted number is the one said at the beginning, but accept any other lower number as 1234567890, etc.

The code is this:

<input name="compte" size="10" maxlength="10" type="text" />
$compte = $_POST['compte'];
echo "<tr><td>Banko-konto / Compte bancari</td><td>$idAligxo $banc $oficina $dc $compte</td></tr>";
        $query = "INSERT INTO comptes_prv (id_aligxo, banc, oficina, dc, compte) VALUES ('$idAligxo', '$banc', '$oficina', '$dc', '$compte')";

.....
$query = "SELECT banc, oficina, dc, compte FROM comptes_prv WHERE id_aligxo = '$row[id]'";
...
$fila = mysql_fetch_array($rs);
echo "<br><tr><td><strong>Banko-konto / Compte bancari:</strong> $fila[banc] $fila[oficina] $fila[dc] $fila[compte]</td></tr>";
    
asked by Joan Inglada Roig 04.04.2017 в 00:15
source

1 answer

1

very likely the compte field is a int(11) to solve this modify your database and put it as a bigint , accept a number of more characters.

    
answered by 04.04.2017 / 00:23
source