insert file row in database

[etusha]

hello all

whats up ?!!

 

i need help i have to do a script

that take all file in a specific folder one by one and insert row in mysql

plz any one can help me ??

 

[Fadion]

Try this:

 

<?php
$connect = @mysql_connect('dbhost', 'dbusername', 'dbpass') or die(mysql_error()); //connect to mysql server
mysql_select_db('mydb'); //select the database ure using

$folder = 'myfolder';
$handle = opendir($folder); //open folder
while(($file = readdir($handle)) != false){ //loop through folder files
if($file == '.' or $file == '..'){ continue; }
$resultsInsert = @mysql_query("INSERT INTO mytable (filename) VALUES ('$file')") or die(mysql_error()); //insert the filename in a new row
}

mysql_close($connect); //close connection
?>