将products文件夹的所有图片分离出来
代码
<?php
$server = 'localhost';
$link = mysql_connect($server, 'root', '');
$result = mysql_query('show databases');
echo '<pre>';
$i=0;
$arr=scandir('/vhost');
//print_r($arr);
while($database=mysql_fetch_array($result)){
print_r($database);
@mysql_select_db($database[0]);
$sql_result=mysql_query('select products_image from zen_products');
while ($address=mysql_fetch_array($sql_result)){
print_r($address);
$before=strpos($address[0],'/');
$after=strrpos($address[0],'/');
echo $before;
echo '<br/>';
echo $after;
echo '<br/>';
$filename=substr($address[0],$before+1,$after-9);
if(preg_match("/com/i",$database[0])){
$position=strrpos($database[0],'c');
$b=substr($database[0],0,$position);
if(in_array($b.".com",$arr)){
$d="mkdir -p /vhost/$b.com/images/products/$filename/";
system($d);
$a="cp /vhost/$address[0] /vhost/$b.com/images/products/$filename/";
echo $a;
}
else{
echo "shibaicom";
}
system("mkdir -p /vhost/$b.com/products/$filename/");
$a="cp /vhost/$address[0] /vhost/$b.com/products/$filename/";
echo $a;
}
else{
if(in_array($database[0].".com",$arr)){
$d="mkdir -p /vhost/$database[0].com/images/products/$filename/";
system($d);
$a="cp /vhost/$address[0] /vhost/$database[0].com/images/products/$filename/";
echo $a;
}
else{
echo "shibai";
}
}
echo '<br/>';
system($a);
$i++;
}
}
echo '<br/>';
echo $i;
?>
$server = 'localhost';
$link = mysql_connect($server, 'root', '');
$result = mysql_query('show databases');
echo '<pre>';
$i=0;
$arr=scandir('/vhost');
//print_r($arr);
while($database=mysql_fetch_array($result)){
print_r($database);
@mysql_select_db($database[0]);
$sql_result=mysql_query('select products_image from zen_products');
while ($address=mysql_fetch_array($sql_result)){
print_r($address);
$before=strpos($address[0],'/');
$after=strrpos($address[0],'/');
echo $before;
echo '<br/>';
echo $after;
echo '<br/>';
$filename=substr($address[0],$before+1,$after-9);
if(preg_match("/com/i",$database[0])){
$position=strrpos($database[0],'c');
$b=substr($database[0],0,$position);
if(in_array($b.".com",$arr)){
$d="mkdir -p /vhost/$b.com/images/products/$filename/";
system($d);
$a="cp /vhost/$address[0] /vhost/$b.com/images/products/$filename/";
echo $a;
}
else{
echo "shibaicom";
}
system("mkdir -p /vhost/$b.com/products/$filename/");
$a="cp /vhost/$address[0] /vhost/$b.com/products/$filename/";
echo $a;
}
else{
if(in_array($database[0].".com",$arr)){
$d="mkdir -p /vhost/$database[0].com/images/products/$filename/";
system($d);
$a="cp /vhost/$address[0] /vhost/$database[0].com/images/products/$filename/";
echo $a;
}
else{
echo "shibai";
}
}
echo '<br/>';
system($a);
$i++;
}
}
echo '<br/>';
echo $i;
?>

浙公网安备 33010602011771号