read directory and save file names into sql

[pkhosid]

Hey Guys,

I have searched and tried....for almost 24 hours....

php is in safe mode...phpmyadmin won't except cvs or text files (security risk with load local data infile)...getting rid of local doesn't work....sooooooooo

I want to upload images into a folder via ftp and get php to read the directory and put the file paths into the corresponding table.

The table structure is very simple:
Client_id,Clientphoto

That's it...self incrementing for the first and blob on the second.

Please Please Please help me...

I know that this has got to be easy!

Thanx
P

[drawmack]

there is a way to do put the stuff into the database without using a load data from file command. It's like this:

//open the field directly from it's temporary uploaded location
$upload = fopen($_FILES['Contents']['tmp_name'],'r');
//loop to read the file.
while(!feof($upload) && $msg == "") {
  //read almost a meg at a time into binData and addslashes to it.
  //must cap at under 1meg due to mysql limitation on query size of 1meg.
  $binData = addslashes(fread($upload,906240));
  if(!mysql_query("INSERT INTO tbl_files (Data) VALUES (\"$binData\")") {
    die(mysql_error());
  } //end if
} //end while

you'll need an autonumber field and a foreign key to relate the file data to the record that describes the file. Here is the article I adapted this from.

http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html

[pkhosid]

That is a very cool! Thanks!

I did however come up with a way that I think will be really easy for me to work with.

But for some reason the records are not going into the database?

here is the code

---

<? php $portfolio = mysql_pconnect($hostname_portfolio, $username_portfolio, $password_portfolio) or die(mysql_error()); php ?>
<?php
// Note that !== did not exist until 4.0.0-RC2

if ($handle = opendir('fashion')) {
echo "Directory handle: $handle\n";
echo "Files:\n";

}
/ This is the correct way to loop over the directory. /
while (false !== ($file = readdir($handle))) {
$j++;
echo "$file\n";
//insert array
$sql="INSERT INTO clients_fashion†('client_id','clientname') VALUES ('$j','$file')";
$inyago=mysql_query ($sql,$portfolio);

}

closedir($handle); 

?>

[drawmack]

two things

1) surround php code in php brackets that is [ followed by php followed by ]

2) what output is this giving you to the screen?

[pkhosid]

this is what comes up:

Directory handle: Resource id #2 Files: 1. 2.. 3005.jpg 405_22w_LEGS62.jpg 506_22h_YELLOWPOOL6.jpg 607_22h_REDHOUSE72.jpg 708_22h_CHINATOWN61.jpg 8beach.jpg 9drebin01.jpg 10image3.jpg 11SN0513-Style-3.jpg 12SN0513-style-6.jpg 13SN0826-Lingerie-2.jpg 14SN0826-Lingerie-3.jpg 15SN0826-Lingerie-8.jpg 16SN0826P41.jpg 17SN0826P47.jpg 18vibe-both.jpg 19vibepart-b.jpg

Thans for help!

[drawmack]

$sql="INSERT INTO clients_fashion†('client_id','clientname') VALUES ('$j','$file')";
$inyago=mysql_query ($sql,$portfolio); 

I think the problem in in here I do not know what the point of the little cross is, try doing this

$sql = "INSERT INTO clients_fashion (client_id,clientname) VALUES ($j,\"$file\")";
if(!mysql_query($sql)) {
  echo mysql_errno . ": "  . mysql_error . "<br />\n";
  echo $sql . "<br />\n";
}

This may not fix your problem but at least it will print out the error message with the sql that generated it.

[pkhosid]

Parse error: parse error, unexpected '\"' in /home/virtual/site39/fst/var/www/html/testing/read.php on line 21

now it now spitting out anything?

  /* This is the correct way to loop over the directory. */
    while (false !== ($file = readdir($handle))) { 
	$j++;
	echo "$j";
        echo "$file\n";
		//insert array
		$sql_ =_ "INSERT_INTO_clients_fashion_(client_id,clientname)_VALUES_($j, \" $file \" )" ;
if(! mysql_query ($sql ))_{ 
__echo_ mysql_errno_ ._ ": "__ ._ mysql_error_ ._ "<br />\n" ;
__echo_ $sql_ ._ "<br />\n" ;
}



$inyago=mysql_query ($sql,$portfolio); 

}

closedir($handle);

[drawmack]

  /* This is the correct way to loop over the directory. */
while (false !== ($file = readdir($handle))) { 
  $j++;
  echo "$j";
  echo "$file\n";
  //insert array
  $sql = "INSERT_INTO_clients_fashion_(client_id,clientname) VALUES ($j, \" $file \" )" ;
  if(! mysql_query ($sql )) { 
      echo  mysql_errno  . ": " . mysql_error . "<br />\n" ;
      echo $sql . "<br />\n" ;
  } //END IF
// you don't need this anymore it is already done in the 
// if statement above.
//  $inyago=mysql_query ($sql,$portfolio); 
} //end while
closedir($handle);

just making the code readable

is this the entire script if so which line is line 21?

[pkhosid]

I just entered all the data by hand in a control panel that I designed...on a deadline.

Thanks Anyway!