Jason Pruim
pruimj@xxxxxxxxx
On Aug 11, 2011, at 9:35 AM, Andrew Ballard wrote:
> On Wed, Aug 10, 2011 at 9:22 PM, Jason Pruim <pruimj@xxxxxxxxx> wrote:
>> 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@xxxxxxxxx
>
> You could always push it off to MySQL. I don't have a MySQL instance
> available to test right now, but I ran this on SQL Server and it
> should be generic enough to port without much change. Basically, you
> just load a table with a single tinyint column with the digits between
> 0 and 9, and then allow the database to cross join that table 4 times
> to get 10000 resulting rows numbered 0000 through 9999.
> The cross join on this database server executes in around 44ms.
>
>
> -- Create a temporary table containing the digits 0 through 9
> CREATE TABLE Digits (
> n tinyint NOT NULL PRIMARY KEY
> CHECK (n BETWEEN 0 AND 9)
> )
>
> INSERT INTO Digits
> VALUES
> (0),
> (1),
> (2),
> (3),
> (4),
> (5),
> (6),
> (7),
> (8),
> (9)
>
>
>
> -- Cross join the digits table 4 times to load into a table called numbers.
>
> SELECT CONVERT(char(1), Thousands.n) +
> CONVERT(char(1), Hundreds.n) +
> CONVERT(char(1), Tens.n) +
> CONVERT(char(1), Ones.n) AS Number
> INTO Numbers
> FROM Digits AS Thousands,
> Digits AS Hundreds,
> Digits AS Tens,
> Digits AS Ones
> ORDER BY
> Thousands.n, Hundreds.n, Tens.n, Ones.n
>
>
> SELECT *
> FROM Numbers
>
> -- Drop the temporary digits table
> DROP TABLE Digits
>
>
>
> Andrew
Hey Andrew,
Interesting idea... I'm so used to doing it all from PHP that I forget a database can be more then just a storage engine sometimes :)
I'll definitely give it a try tonight!
Thanks Andrew!
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
