| 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:
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 = "" 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! |
Edit
Inline Edit
Copy
Delete