PHP/MySQL | Вывод файлов в 2 столбца
Ramirez
Помогите решить проблему вывода файлов. Файлы выводятся в одну колонку с таблицы по ID, как сделать чтоб выводились в две колонки
###############Постраничная навигация###############
$all = mysql_fetch_row(mysql_query('SELECT COUNT(`id`) FROM `files` WHERE `infolder` = "'.$d['path'].'"'));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or $page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
###############Получаем список файлов###############
$array_id = array();
$query = mysql_query('SELECT `id` FROM `files` WHERE `infolder` = "'.$d['path'].'" ORDER BY '.$MODE.' LIMIT '.$start.', '.$onpage);
while($list_sw = mysql_fetch_row($query)){
$array_id[] = $list_sw[0];
}
###############Готовим заголовок###################
$ex = explode('/',$d['path']);
foreach($ex as $k=>$v)
{
if($v!='' and $v!='.' and $v!='..' and $v!=$setup['path'])
{
$s = mysql_fetch_array(mysql_query("SELECT `id`,`name` FROM `files` WHERE `path` LIKE '%".clean($v)."/' AND `size` = '0'"));
$s['name'] = str_replace('*','',$s['name']);
if($k >= sizeof($ex)-2) $put .= $s['name'];
else $put .= '<a href="index.php?id='.$s['id'].'">'.$s['name'].'</a>»';
}
}
include 'moduls/head.php';
###############Список фалов и папок###############
if ($all == 0) echo '<div class="a"><strong>[Раздел пуст]</strong></div>';
foreach($array_id as $key => $value)
{
$file_info = mysql_fetch_array(mysql_query('SELECT * FROM `files` WHERE `id` = "'.$value.'";'));
if(is_integer($key / 2))
$row = '';
else
$row = '';
/////////К ДИЗАЙНУ О ВЫВЕДЕНИИ ФАЙЛОВ
//Komments and loads
$all_komments = @mysql_fetch_array(mysql_query('SELECT COUNT(*) FROM `komments` WHERE file_id = "'.$file_info['id'].'"'));
$all_komments = $all_komments[0];
$all_loads = $file_info['loads'];
$file_time = date('d.m.y', $file_info['timeupload']);
if ($sort=='name') $info = '';
if ($sort=='data') $info = "($file_time)";
if ($sort=='eval' and $setup['eval_change']==1) $info = '(<font color="#800000">'.$file_info['yes'].'</font>/<font color="#004080">'.$file_info[no].'</font>)';
//Новизна файла
$new_info='';
$filtime2 = $file_info['timeupload']+(3600*24*$setup['day_new']);
if($filtime2>=$time and $setup['day_new']!=0) $new_info = '<img src="ext/new.png" alt="">';
//Красивый размер
if($file_info['size'] < 1024) $file_info['size'] = '('.$file_info['size'].'b)';
if($file_info['size'] < 1048576 and $file_info['size'] >= 1024) $file_info['size'] = '('.round($file_info['size']/1024, 2).' Kb)';
if($file_info['size'] > 1048576) $file_info['size'] = '('.round($file_info['size']/1024/1024, 2).' Mb)';
$filename = pathinfo($file_info['url_clip']);
$ext = $filename['extension'];
//Иконка к файлу
if(!file_exists('ext/'.$ext.'.png') )
$ico = '<img src="ext/stand.png" alt="">';
else
$ico = '<img src="ext/'.$ext.'.png" alt="">';
//$headers3 = get_headers($file_info['url_clip'], 1);
//$size3 = round($headers3['Content-Length']/1024/1024, 2);
//Собственно вывод
echo $row;
$size1=str_replace(')','',$file_info['size']);
$size2=str_replace('(','',$size1);
$info=str_replace('(','|',$info);
$info=str_replace(')','|',$info);
echo '<div class="blocks-list"><ul>';
echo '<li><h3><a href="view.php?id='.$file_info['id'].'"><strong>'.$file_info['name'].'</strong></h3>
<div class="thumb">
<a href="view.php?id='.$file_info['id'].'">
<img style="margin: 1px;" src="'.$file_info['url_foto'].'" width="157" height="130" alt="'.$file_info['name'].'">
</a>
</div>
<div class="inf">
<div class="leftc"><span class="ico time"></span>'.$size2.'</div>
<div class="rightc"><span class="ico play"></span>'.$file_info['loads'].'</div>
</div>
</li>';
echo '</ul></div>';
________
посл. ред. 30.09.2016 в 00:42; всего 1 раз(а); by Viy
Viy ###############Постраничная навигация###############
$all = mysql_fetch_row(mysql_query('SELECT COUNT(`id`) FROM `files` WHERE `infolder` = "'.$d['path'].'"'));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or $page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
###############Получаем список файлов###############
$array_id = array();
$query = mysql_query('SELECT `id` FROM `files` WHERE `infolder` = "'.$d['path'].'" ORDER BY '.$MODE.' LIMIT '.$start.', '.$onpage);
while($list_sw = mysql_fetch_row($query)){
$array_id[] = $list_sw[0];
}
###############Готовим заголовок###################
$ex = explode('/',$d['path']);
foreach($ex as $k=>$v)
{
if($v!='' and $v!='.' and $v!='..' and $v!=$setup['path'])
{
$s = mysql_fetch_array(mysql_query("SELECT `id`,`name` FROM `files` WHERE `path` LIKE '%".clean($v)."/' AND `size` = '0'"));
$s['name'] = str_replace('*','',$s['name']);
if($k >= sizeof($ex)-2) $put .= $s['name'];
else $put .= '<a href="index.php?id='.$s['id'].'">'.$s['name'].'</a>»';
}
}
include 'moduls/head.php';
###############Список фалов и папок###############
if ($all == 0) echo '<div class="a"><strong>[Раздел пуст]</strong></div>';
foreach($array_id as $key => $value)
{
$file_info = mysql_fetch_array(mysql_query('SELECT * FROM `files` WHERE `id` = "'.$value.'";'));
if(is_integer($key / 2))
$row = '';
else
$row = '';
/////////К ДИЗАЙНУ О ВЫВЕДЕНИИ ФАЙЛОВ
//Komments and loads
$all_komments = @mysql_fetch_array(mysql_query('SELECT COUNT(*) FROM `komments` WHERE file_id = "'.$file_info['id'].'"'));
$all_komments = $all_komments[0];
$all_loads = $file_info['loads'];
$file_time = date('d.m.y', $file_info['timeupload']);
if ($sort=='name') $info = '';
if ($sort=='data') $info = "($file_time)";
if ($sort=='eval' and $setup['eval_change']==1) $info = '(<font color="#800000">'.$file_info['yes'].'</font>/<font color="#004080">'.$file_info[no].'</font>)';
//Новизна файла
$new_info='';
$filtime2 = $file_info['timeupload']+(3600*24*$setup['day_new']);
if($filtime2>=$time and $setup['day_new']!=0) $new_info = '<img src="ext/new.png" alt="">';
//Красивый размер
if($file_info['size'] < 1024) $file_info['size'] = '('.$file_info['size'].'b)';
if($file_info['size'] < 1048576 and $file_info['size'] >= 1024) $file_info['size'] = '('.round($file_info['size']/1024, 2).' Kb)';
if($file_info['size'] > 1048576) $file_info['size'] = '('.round($file_info['size']/1024/1024, 2).' Mb)';
$filename = pathinfo($file_info['url_clip']);
$ext = $filename['extension'];
//Иконка к файлу
if(!file_exists('ext/'.$ext.'.png') )
$ico = '<img src="ext/stand.png" alt="">';
else
$ico = '<img src="ext/'.$ext.'.png" alt="">';
//$headers3 = get_headers($file_info['url_clip'], 1);
//$size3 = round($headers3['Content-Length']/1024/1024, 2);
//Собственно вывод
echo $row;
$size1=str_replace(')','',$file_info['size']);
$size2=str_replace('(','',$size1);
$info=str_replace('(','|',$info);
$info=str_replace(')','|',$info);
echo '<div class="blocks-list"><ul>';
echo '<li><h3><a href="view.php?id='.$file_info['id'].'"><strong>'.$file_info['name'].'</strong></h3>
<div class="thumb">
<a href="view.php?id='.$file_info['id'].'">
<img style="margin: 1px;" src="'.$file_info['url_foto'].'" width="157" height="130" alt="'.$file_info['name'].'">
</a>
</div>
<div class="inf">
<div class="leftc"><span class="ico time"></span>'.$size2.'</div>
<div class="rightc"><span class="ico play"></span>'.$file_info['loads'].'</div>
</div>
</li>';
echo '</ul></div>';
________
посл. ред. 30.09.2016 в 00:42; всего 1 раз(а); by Viy
ти б ещо больше кода кинул
Коляда