MySQL enters another value that the one given by PHP

Answer 1

You are probably using the smallint data type for the port attribute. The maximum value of this data type is 32767.

In fact, I have replicated your problem:

CREATE TABLE a(a smallint);
Query OK, 0 rows affected (0.09 sec)

INSERT INTO a VALUES (37060);
Query OK, 1 row affected, 1 warning (0.02 sec)

SELECT * FROM a;
+-------+
| a     |
+-------+
| 32767 |
+-------+
1 row in set (0.00 sec)

You would simply have to use a larger data type, such as mediumint or int.

Further reading:

• MySQL 5.1 Reference Manual: Numeric Types

Answer 2

I had a similar problem not too long ago, I accidentally had tinyint in a field that received a big value, you should check the type of field you're using. Also I recommend that if the problem still persist try getting the data in a string form.

There's some more way you can try and track down the problem, try checking the logs in MySQL for any possible errors or rewriting the functions that inserts the data into MySQL, sometimes the smallest mistake (often hard to spot) can ruin an otherwise fantastic software.