Password Generator in For Loop

[Anon]

Sorry for the dulicate posting - I posted in the wrong forum

I'm trying to write a script that will loop through my database and replace old passwords with newly generated ones.

I thought the below would work but it doesn't - it just retiurns the same password for each loop. Can anyone tell me how I can get nice prounceable(ish) passwords in this way - or I am I totally on the wrong track.

TIA Tony

Code:

// Update the passwords
$result = $db_query("SELECT * FROM $table");
$numb = $db_num_rows($result);

$pass = substr($pass, 0, $length);
for ($i=0; $i < $numb; $i++){
$row = $db_fetch_array($result);
$id = $row[id];
$password = $row[password];
$newpass = $row[newpass];

/ generate the new password /
// This is the bit that doesn't work 🙁

$length = 7;
srand((double)microtime()*1000000);
$vowels = array("a", "e", "i", "o", "u");
$cons = array("b", "c", "d", "g", "h", "j", "k", "l", "m", "n", "p", "r", "s", "t", "u", "v", "w", "tr", "cr", "br", "fr", "th", "dr", "ch", "ph", "wr", "st", "sp", "sw", "pr", "sl", "cl");
$num_vowels = count($vowels);
$num_cons = count($cons);
for($j = 0; $j < $length; $j++){
$pass .= $cons[rand(0, $num_cons - 1)] . $vowels[rand(0, $num_vowels - 1)];
}

Print"$password - $pass - $id<br>";
}

[Anon]

It works fine with me.. Maybe there is something wrong elsewhere in the code... I get diffrent passwords every time..

Andreas Bernhardsen

[Anon]

This works fine for me:

<?php
function CreatePasswords($length=8) {

$sets = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$sets .= "abcdefghijklmnopqrstuvwxyz";
$sets .= "1234567890";

for($index = 0; $index < $length; $index++)
{
$sid .= substr($sets,(rand()%(strlen($sets))), 1);
}

return($sid);
}

?>

<?php
srand(time());
for ($i=1000;$i<=1500;$i++) {
echo CreatePasswords()."<br>\n";
}

?>

[Anon]

This works great, but could you show me how to just print one result, I get dozens at a time.

I want to generate a password, then post that into the mysql database and send an email to the customer with the password to login.

Thanks

Stuart

[Anon]

Simply call the function once.
CreatePasswords()
or
CreatePasswords(n) # if you want only a n-digit long password.

[Anon]

Hi,

I ended up using this one:

<?

/ Generate password. (i.e. jachudru, cupheki) /

function genpassword($length){
srand(time());

$vowels = array("a", "e", "i", "o", "u"); 
$cons = array("b", "c", "d", "g", "h", "j", "k", "l", "m", "n", "p", "r", "s", "t", "u", "v", "w", "tr", 
"cr", "br", "fr", "th", "dr", "ch", "ph", "wr", "st", "sp", "sw", "pr", "sl", "cl", "an", "ba", "bak", "bo", "bom", "bru", "can","con",

"cro", "da", "di", "dom", "er", "em", "et");

$num_vowels = count($vowels); 
$num_cons = count($cons); 

for($i = 0; $i < $length; $i++){ 
    $suggestpass .= $cons[rand(0, $num_cons - 1)] . $vowels[rand(0, $num_vowels - 1)]; 
} 

return substr($suggestpass, 0, $length); 

}

$suggestpass = genpassword(6) ;

Print"$suggestpass"

?>

[Anon]

Oops sorry - add a semi-colon and avoid a parse error

Print"$suggestpass";

[erick_e]

Try this one to open your db table and insert a generated password in each record:

$servername="servername";
$dbusername="dbusername";
$dbpassword="dbpassword";
$dbname="dbname";
$table="table name";
$lenghtchar="8";

mysql_connect ("$servername", "$dbusername", "$dbpassword");
mysql_select_db ("$dbname");

$result_update = mysql_query("SELECT * FROM $table order by ID");

if ($row_update = mysql_fetch_array($result_update)) {
echo "open db <BR>";

function Generate_Pass ($pass_len) {
$nps = "";
mt_srand ((double) microtime() * 1000000);
while (strlen($nps)<$pass_len) {
$c = chr(mt_rand (0,255));
if (eregi("^[a-z0-9]$", $c)) $nps = $nps.$c;
};
return ($nps);
};

do{
$id = $row_update[ID];
$oldpassword = $row_update[password];

$newpass = Generate_Pass ($lenghtchar);

echo "(id: $id) (oldpassword: $oldpassword) (new_password: ";
echo $newpass;
echo ")<br>";

// $insert = mysql_query("UPDATE $table SET new_password='$newpass' WHERE ID='$id'");
}
while($row_update = mysql_fetch_array($result_update));
}
echo "close db <BR>";

[erick_e]

remove the dubble slashes when you wish to do the update!!

old:
// $insert = mysql_query("UPDATE $table SET new_password='$newpass' WHERE ID='$id'");

new:
$insert = mysql_query("UPDATE $table SET new_password='$newpass' WHERE ID='$id'");