这是以前写的个读取目录下所有图片的例子,你可以参考
include_once('./php/cfg/config.inc.php');//配置文件
include_once("./php/inc/dbmysql.inc.php");//一个php数据库类
include_once("./php/inc/functions.php");
ob_start();
date_default_timezone_set('Asia/Shanghai');
//$stdin = fopen("php://input", "r");
//db connet
$dbInst = new $dbconfig['type']();
$dbInst -> dbConnect($dbconfig['off_man_spec']);//DB CON
//<-- con end
$log_name = "log/readtheme_error.txt";
$log_gif = "log/readtheme_gif.txt";
$to_now=date('Y-m-d H:i:s', time());
$gif_array =array();
function ls($dir, $mask /*.php$|.txt$*/)
{
static $i = 0;
$files = Array();
$d = opendir($dir);
while ($file = readdir($d))
{
if ($file == '.' || $file == '..' || eregi($mask, $file) ) continue;
if (is_dir($dir.'/'.$file))
{
$files += ls($dir.'/'.$file, $mask);
continue;
}
$files[$i++] = $dir.'/'.$file;
//$files[$i++] =$file;
//echo $dir.'
';
insert_sql($dir,$file,$i);
}
return $files;
}
function insert_sql($di,$fi,$k){
global $dbInst,$to_now,$log_name,$gif_array,$log_gif;
//得到唯一标示:gif与对应主题包
$strs_f =explode('-',$fi,4);
$upload_file_attr =$strs_f[0].'-'.$strs_f[1].'-'.$strs_f[2];
$file_z = explode('.',$fi);
if('gif'==$file_z[1]){
$gif_array[$k] =$fi;
log_add($log_gif,$fi."\r\n");
return;
}
$dir_z = explode('/',$di);
$belongtype = $dir_z[2];
$symbian_version =strtolower($dir_z[1]);
$showname =substr ($dir_z[3],3);
$up_filename =$fi;
$sql = "INSERT INTO `pho_upload_theme_test` (`upload_filename` ,`belongtype` ,`symbian_version`,`showname`,`upload_time`,`upload_file_attr` )VALUES ('$up_filename', '$belongtype', '$symbian_version','$showname','$to_now','$upload_file_attr')";
$res = $dbInst -> query ($sql);
if(!$res)log_add($log_name,$sql."\r\n");
//$dir_z = explode('.',$di);
//echo $file_z[1].'
';
}
function gif_insert($arr){
global $dbInst,$to_now,$log_name;
foreach($arr as $val){
$resolution ='';
$strs_v =explode('.',$val);
$strs_f =explode('-',$strs_v[0]);
$key = $strs_f[0].'-'.$strs_f[1].'-'.$strs_f[2];
$resolution =$strs_f[3].'-'.$strs_f[4];
$sql = "INSERT INTO `pho_upload_theme_attr` (`filename` ,`upid` ,`resolution`,`upload_time` )VALUES ('$val', (select IF(ISNULL(upid),1,upid) FROM pho_upload_theme_test where upload_file_attr='$key'), '$resolution','$to_now')";
$res = $dbInst -> query ($sql);
//return $res;
if(!$res)log_add($log_name,$sql."\r\n");
}
}
$f = ls('D:\\theme', ".db$|.php$" /*no spaces*/);
//写入gif
$resl =gif_insert($gif_array);
echo '成功';
$dbInst ->close();
//print_r($f);
?>
//邮箱数据源,假定邮箱的key为"email",数据库中表为tblEmail,相关字段为strEmialAddress
$arrEmails = array();
$intEmailCount = count($arrEmails);
$strInsertSql = "";
for ($i=0; $i < $intEmailCount; $i++ )
{
$strInsertSql .= "INSERT INTO tblEmail(`strEmialAddress`) values('".$arrEmails[$i]["email"]."');"//注意语句结尾有分号
}
然后用你的数据库类或php自身的sql语句执行查询方法,执行$strInsertSql就可以了。