[PHP-DB] Odd MySQL Problem...

Thu, 13 Oct 2011 19:57:43 -0700

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!

Reply via email to