Incorrect Integer (2147483647) is inserted into MySQL?

php mysql insert steam-web-api
Archey picture Archey · Apr 21, 2012 · Viewed 58.5k times · Source

Alright, so I've been toying around with the Steam Web API, I have one of the values stored in a variable called $steam64. When I use this code snipper to INSERT it into a mysql database it insert a completley different integer than what is stored in the variable.

$sql_query = "INSERT INTO users_info (steam64) VALUES ('$steam64')";

var_dump($steam64); returns the real int, so does echoing it. Not too sure what is going on here, any help is appreciated.

Answer

George picture George · Jul 22, 2013

2147483647 is the largest int value for mysql. Just change the type from int to bigint.

Related questions

PHP mysql insert date format

Im using jQuery datepicker the format of the datepicker is this 08/25/2012 i have errors when inserting to my database it insert only 0000-00-00 00 00 00 my codes is <?php $id = $_POST['id']; $name = $_POST['name']; $date = $_POST['date']; $sql = mysql_…

Read More
insert multiple rows via a php array into mysql

I'm passing a large dataset into a MySQL table via PHP using insert commands and I'm wondering if its possible to insert approximately 1000 rows at a time via a query other than appending each value on the end of a …

Read More
Escaping single quote in PHP when inserting into MySQL

I have a perplexing issue that I can't seem to comprehend... I have two SQL statements: The first enters information from a form into the database. The second takes data from the database entered above, sends an email, and then …

Read More