Odd MySQL Problem...

From: Date: Fri, 14 Oct 2011 02:53:46 +0000
Subject: Odd MySQL Problem...
Groups: php.db 
Request: Send a blank email to php-db+get-48044@lists.php.net to get a copy of this message
Hey everyone, Have a weird issue that I can't seem to figure out... Using PHP to insert phone numbers into the site... I have the Area Code, & Exchange, and then dynamically create the last 4 digits... Once it's inserted it's dropping the leading zero's... Here's some samples: Copied from phpMySQL: Edit Inline Edit Copy Delete 212 200 0 6800001 Edit Inline Edit Copy Delete 212 200 1 6800002 Edit Inline Edit Copy Delete 212 200 2 6800003 Edit Inline Edit Copy Delete 212 200 3 6800004 Edit Inline Edit Copy Delete 212 200 4 echoed output from PHP: SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200, 0001) SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200, 0002) Actual PHP code: <?PHP // ini_set('display_errors', 1); //error_log(-1); set_time_limit(0); //set_time_limit("120"); include "includes.php"; include "databaseabstraction.php"; include "authentication.php"; dbconnect("localhost", "XXXXXX", "XXXXXX", "XXXXXX")or die("Unable to connect: " . mysql_error()); function number_pad($number,$n) { return str_pad((int) $number,$n,"0",STR_PAD_LEFT); } if (($handle = fopen("newyorktest.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { print_r($data); foreach( range(0, 9999) AS $n) { //echo "<BR>DATA: " . $data[2] . "<BR>"; $padded_number = number_pad($n, "4"); $sql = "INSERT INTO phonesite (areacode, exchange, subscriber) "; $sql .= "VALUES({$data[1]}, {$data[2]}, {$padded_number}) "; //mysql_query($sql) or die("Didn't insert you dumb ass.... FIX IT NOW CLOWN!!!! " . mysql_error()); echo "SQL: " . $sql . "<BR>"; } } echo "File Bitches!"; fclose($handle); } ?> Any ideas on what I'm missing? Thanks everyone! Jason Pruim lists@pruimphotography.com

« previous php.db (#48044) next »