mkdir() help

inulled

$query = mysql_query("SELECT UserID FROM users WHERE UserID='UserID'") or die("Failure");
while($row = mysql_fetch_array($query))
{
mkdir('User-PID{$row[\'UserPID\']}');
}

Whats wrong with the above code and also how do I get the mkdir function to create the folder inside of a different folder?

NogDog

One problem: variables are not interpolated within single-quoted strings, so you would need to use one of these options (by no means exhaustive):

mkdir("User-PID{$row['UserPID']}");
// or
mkdir('User-PID' . $row['UserPID']);

inulled

$result = mysql_query("SELECT * FROM users WHERE UserID='UserID'")or die("Failure");
while($row = mysql_fetch_array($result)) {
mkdir('User-PID' . $row['UserPID']);
}

Thanks I had tried the above method before I posted the question. But it still doesn't seem to work. The mkdir() function works outside of the while loop so it has to do with that.

NogDog

Are you sure any rows were returned by the query? It looks like you're using a literal string "UserID" to search for, where perhaps you wanted a PHP variable? 😕

inulled

for every row in the users table I have a string like this: 217924de89df465bc9. $userid_generator = uniqid(rand(), false); this is the parameter I'm passing to the db. To tackle my problem I simply passed the $userid_generator variable to the mkdir rather than inserting the UserID into the database and then trying to retrieve it with the code im having problems with..... And since the uniqid() function doesn't create a different value everytime its called, it does exactly what i need.

bradgrafelman

Okay, but you didn't answer NogDog's question: are you sure any rows were returned by your query?

The query you showed us above only SELECT's the rows where the UserID column is equal to the string 'UserID'.

inulled

for every row in the users table I have a string like this: 217924de89df465bc9

this answers the question my friend.

NogDog

inulled;10981675 wrote:
this answers the question my friend.

Well, if we take that with your sample code, then the answer is that most likely your query is not returning anything, since as written here, it is only looking for rows where the user ID is "UserID" -- literally U s e r I D :

$result = mysql_query("SELECT * FROM users WHERE UserID=[B][COLOR="Red"]'UserID'[/COLOR][/B]")or die("Failure");

I'm suggesting therefore that maybe you wanted to use a PHP variable there instead of the string literal "UserID"?????

inulled

I actually got my content queried back. But the problem was it queried everything and made all the folders with the queried data. I thought about using DISTINCT, but then the other approach seemed more logical and more faster.

The following does exactly what I need it to do:

$userid_generator = uniqid(rand(), false);
if(is_dir($userid_generator)) {
echo "Something wen't wrong. A bug report has been sent and we are doing what we can to fix it.";
$message = 'Registration problem on account number $userid_generator. The user succesfully registered, but there is already
a directory with the account id of $userid_generator.';
mail($bug_report_email, "Registration Bug!", $message);
} else {
mkdir('../media/User-PID{' . $userid_generator . '}', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/photos', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/backups', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/videos', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/documents', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/developer', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/developer/apps', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/developer/themes', 0777);
mkdir('../media/User-PID{' . $userid_generator . '}/xml', 0777);
}