Getting every combination of a String and storing in a db table.

[seany123]

What im looking to do is basically get every combination of a string.

 

example:

 

 

$characters = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!/£$%^&*()+@#?";

 

 

and store each individual result in my database.... so basically i could look in my MYSQL database and look through however million entries there are.

 

note - min length 3. max length 10.

 

anyone help me?

[Pikachu2000]

You might want to take a minute to figure out roughly how many combinations that will generate. Saying "however many million" is a gross understatement.

[seany123]

well i worked it out to be in the billionaires

[fortnox007]

this may sound stupid but why would you need to populate your database with this info if you can verify the same using 1 line of code in a regex? or is it for a special redeem code system of some kind

[Pikachu2000]

It would be roughly 76*76*76*76*76*76*76*76*76*76 or 6.42888893234x10¹⁸. In other words, a whole shitload.

[seany123]

This was just going to be a little project on decrypting Md5 hash's... but first i needed ALOT of different letter combinations (obviously words too...etc), to then transfer into MD5... then obviously to compare with the MD5.

[fortnox007]

This was just going to be a little project on decrypting Md5 hash's... but first i needed ALOT of different letter combinations (obviously words too...etc), to then transfer into MD5... then obviously to compare with the MD5.

 

Nice

[seany123]

in the end i settled with a grabing code with sends the md5 hash to 7 different sites and retreives the result.

 

http://seany.j-site.info/md5.php

[fortnox007]

in the end i settled with a grabing code with sends the md5 hash to 7 different sites and retreives the result.

 

http://seany.j-site.info/md5.php

cool stuff

[seany123]

Just wondering though i wonder how long it would take for php / mysql to run a query through lets say 1 Billion rows... anyone have any idea?