Problem with inserting numbers...
| From: | Jason Pruim | Date: | Thu, 11 Aug 2011 01:22:41 +0000 |
| Subject: | Problem with inserting numbers... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-314477@lists.php.net to get a copy of this message | ||
So here I am attempting to generate some numbers to be inserted into a database... eventually they
will make up a phone number (Which I've emailed about before and know about the bad ideas with
it.. But it's the customer :))
Here is the code I am working with:
<?PHP
function number_pad($number,$n) {
return str_pad((int) $number,$n,"0",STR_PAD_LEFT);
}
$SQL = "SELECT * FROM Test WHERE
areacode = '907' AND
prefix = '200' LIMIT 5";
$result = mysql_query($SQL);
//$num = "0000";
//foreach ($result as $key => $value) {
// echo $key . "-" . $value . "-" . number_pad($num, "4") .
"<BR>";
// $num++;
//}
while ($num != "10000") {
while($row = mysql_fetch_assoc($result)) {
$padnum = number_pad($num, "4");
echo $row['areacode'] . "-" . $row['prefix'] . "-" .
$padnum . "<BR>";
$num++;
}
}
?>
basically all I'm trying to do is generate the last 4 digits starting at 0000 and going up to
9999. for testing purposes I'm just echoing back but will eventually insert the complete number
back into the database as a 7 digit string.
The error I'm getting is:
Fatal error: Maximum execution time of 30 seconds exceeded in
/home/pruimpho/public_html/jason/dev/clients/flewid/Phone/config/phoneareacodes.php on line25
which is where the second while starts...
Does anyone know a better way to do this?
I'm off to finish searching google while waiting for some good news :)
Thanks Everyone!
Jason Pruim
pruimj@gmail.com