how do make random alphanumeric ?

[GregT]

How do I create a 9 charector alphanumeric (fr92n8a9s) <-- Like that. I need to run it twice once for username and databasename, second time for password. i need to be able to do it like this



$usernamedb = //random function
$password = //random function

//then make the db//
function createdb($usernamedb, $password) {
$sqlserver = "localhost";
$sqluser = "root";
$sqlpass = "";

$link = mysql_connect ($sqlserver, $sqluser, $sqlpass)
or exit ("Couldn't connect to Database Server");

$datab = "$usernamedb";
if (mysql_query("CREATE DATABASE $datab")) {
print ("Username: $usernamedb <br> Password: $password <br> Database: $usernamedb\n");
} else {
printf ("Error: %s\n", mysql_error ());
}
$sql = "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $datab.* TO $usernamedb@localhost IDENTIFIED BY '$password'";
mysql_query($sql);
}

[spork]

*is lazy*

http://www.1phpstreet.com/vb/scripts/ShowCode.asp?txtCodeId=551&lngWId=8

[GregT]

its not working, doesnt echo out anything/doesnt create a db, just a blank page. Is it my code or the random function ?



<?php
function generate_str ($length) {
$characters = array('a','b','c','d','e','f','g','h','i','j','k','l','m','n ','o','p','q','r','s','t','u','v','w','x','y','z','A','B','C ','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R ','S','T','U','V','W','X','Y','Z','0','1','2','3','4','5','6 ','7','8','9');
$random_str = "";
for ($i = 0; $i <= $length; $i++) {
srand((double)microtime()*1000000);
$random_chr = round(rand(0, count($characters)-1));
$random_str .= $characters[$random_chr];
}
return ($random_str);
}

$usernamedb = (generate_str(9));
$password = (generate_str(9));

//then make the db//
function createdb($usernamedb, $password) {
$sqlserver = "localhost";
$sqluser = "root";
$sqlpass = "";

$link = mysql_connect ($sqlserver, $sqluser, $sqlpass)
or exit ("Couldn't connect to Database Server");

$datab = "$usernamedb";
if (mysql_query("CREATE DATABASE $datab")) {
print ("Username: $usernamedb <br> Password: $password <br> Database: $usernamedb\n");
} else {
printf ("Error: %s\n", mysql_error ());
}
$sql = "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON $datab.* TO $usernamedb@localhost IDENTIFIED BY '$password'";
mysql_query($sql);
}
?>