mkdir confusion

wirthit

I am trying to get a php script going that will read from an SQL database of categories and make directories off of that list.

The list of directories I will need to make is HUGE. About 700,000 so i may have to put in a function that does this in chunks but first I have to get it to make the directory.

I am sure I am missing something obvious but for the life of me i am not figureing it out.

If anyone has an idea please let me know.

<?php
//require the connection data.
require ('./info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT category FROM category order by id ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
$category= stripslashes($recs['category']);
mkdir ('./$category', 0755);
$makeit = "./$category";
$test = "mkdir (\"./$category\", 0755)";
}
?>

Any help woule be appreciated. 😃

drawmack

you know you can use mod-rewrite so that you don't even really need to create all those directories but just one htaccess file.

http://www.phpbuilder.net/columns/tim20000526.php3?aid=20

wirthit

Actually I had no idea about that function. I will do some more reading about it tks. Even if I use it though I would reall like to know what I did wrong with that code before it drives me insane.

Tks again .

Bob

drawmack

well you didn't tell us what errors you were receiving and what was or was not happening so we cannot really help you with your code.

wirthit

Sorry thought I had. Guess I have been looking at that lousy little snippet of code so long that I did not explain as well as I should of.

Ok it does everything ok except it does not make any directories.

It connects to the mysql server.

It gets the data and assigns it fine to $category

When it goes to make the directory it does nothing, no error no anything. Kind of odd.

This is running on an xp box with mysql and apache web server.

Thanks and sorry I did not give enough data.

Thanks again for your quick response.

Bob

tommynanda

Using double qoutes would do the job... assuming you are successfully retrieving values for $category

mkdir("./$category");

NOTE: mode has no importance on Win Box... PHP ignores that 0755 on Windows.. but yeah you're making it compatible with any OS 😉

Good Luck
TommYNandA

drawmack

on windows it would be mkdir(".\$category") not mkdir("./$category). I find it best to create a constant named dirsep so if I ever move between oses theres no issue with this stuff.

wirthit

DOH so far no good.

I tried

<?php
//require the connection data.
require ('./info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT category FROM category order by id ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
$category= stripslashes($recs['category']);
echo "$category ";
mkdir ("./$category", 0755);
echo " ";
}
?>

and got this as an error

Arts

Warning: mkdir(Arts ): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 15

Warning: mkdir(C:\Program Files\Apache Group\Apache2\htdocs\Arts): File exists in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 16

Arts/Movies

Warning: mkdir(Arts/Movies ): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 15

Warning: mkdir(C:\Program Files\Apache Group\Apache2\htdocs\Arts): File exists in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 16

So it is obviously reading the database.

I changed to
<?php
//require the connection data.
require ('./info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT category FROM category order by id ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
$category= stripslashes($recs['category']);
echo "$category ";
mkdir (".\$category", 0755);
echo " ";
}
?>

and then got

Arts

Warning: mkdir(.$category): File exists in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 15

Arts/Movies

Warning: mkdir(.$category): File exists in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 15

and it built a directory called $directory

for what should be such an easy script i am getting owned.

Tks again

drawmack

<?php
if(!is_writable('.'))
    die("I can't create the directories, cause I don't have permission to.");
//require the connection data.
require ('info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT `category` FROM `category` order by `id` ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
    $category= stripslashes($recs['category']);
    $category = str_replace(" ",'_',$category);
    echo "$category<br>";
    mkdir ("$category", 0755);
    echo "<br><br>";
}
?>

I don't have php set up on my windows box so I can't test this but it should work if your permissions are set properly.

wirthit

OK still will not work now after copying and pasting your code into the script I get the following errors.

Just in case it makes a difference i am running apache 2.0.50
PHP Version 4.3.6 working with a mysql 4.0.20

Arts

Warning: mkdir(Arts ): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 19

Arts/Movies

Warning: mkdir(Arts/Movies ): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 19

Arts/Movies/Titles

Warning: mkdir(Arts/Movies/Titles ): No such file or directory in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 19

Boy for what I thought would be an easy problem sure is turning out to be confusing. I appreciate all the help.

Bob

drawmack

ooppss try this

<?php
if(!is_writable('.'))
    die("I can't create the directories, cause I don't have permission to.");
//require the connection data.
require ('info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT `category` FROM `category` order by `id` ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
    $category= stripslashes($recs['category']);
    $category = str_replace(" ",'_',$category);
    $categor = str_replace("/","\\\\",$category);
    echo "$category<br>";
    mkdir ('"' . $category . '"', 0755);
    echo "<br><br>";
}
?>

wirthit

Does anyone know if this is even possible?

Again I am getting

Arts

Warning: mkdir("Arts "): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 19

Arts\Movies

Warning: mkdir("Arts\Movies "): Invalid argument in C:\Program Files\Apache Group\Apache2\htdocs\mkdir.php on line 19
after trying to run

<?php
if(!is_writable('.'))
die("I can't create the directories, cause I don't have permission to.");
//require the connection data.
require ('info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT category FROM category order by id ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
$category= stripslashes($recs['category']);
$category = str_replace(" ",'_',$category);
$category = str_replace("/","\",$category);
echo "$category ";
mkdir ('"' . $category . '"', 0755);
echo " ";
}
?>

I can not even count how much time I have spent looking at this blasted code.

I know that it should work because I can make dirctories all day long if i remplace the $category with a real directory name but this just keeps telling me I have an invalid arguement.

AHHH well tks again for the help.... Seems that my simple little mkdir script is a bit tougher than I thought..

Bob:queasy:

Weedpacket

Throwing a fresh pair of eyes at this problem:

 mkdir ('"' . $category . '"', 0755);

You might have more success if you don't add quotes - you want to create a directory named Arts, not one named "Arts".

drawmack

Originally posted by Weedpacket
Throwing a fresh pair of eyes at this problem:
 mkdir ('"' . $category . '"', 0755); 
You might have more success if you don't add quotes - you want to create a directory named Arts, not one named "Arts". [/B]

I asked him to put the quotes in for a reason. There is a space at the end of arts that I think is cuasing your problem use [man]trim[/man] on it first and see if that helps.

wirthit

Thanks a ton.

It looks like this simple little bit of code seems to be working now.

Umm Thanks again for the help.

Here is what I finally got to do it if anyone wants to see.

<?php
if(!is_writable('.'))
die("I can't create the directories, cause I don't have permission to.");
//require the connection data.
require ('info.rqr');
// The data base is huge so hold open the php for a few extra minutes
set_time_limit(600);
//get the connection stuff set up
$get_list = "SELECT category FROM category order by id ";
$get_list_res = mysql_query($get_list) or die(mysql_error());
//set up a loop to build the directories. Also print to the screen so I know what
//is going on.
while ($recs = mysql_fetch_array($get_list_res))
{
$category= stripslashes($recs['category']);
$category = str_replace(" ",'_',$category);
$category = str_replace("/","\",$category);
$category = trim ($category);
echo "$category ";
mkdir ($category, 0755);
echo " ";
}
?>

I have not tried this on my big database but a little one I just made up here seems to have worked fine.

MMM did I say thanks.

Bob