Jump to content

insert file row in database


etusha

Recommended Posts

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
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.