Odd MySQL Problem...
| From: | Jason Pruim | 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