Хубав файлов мениджър?

Sql:
Код:
CREATE TABLE `filesystem` (
  `id` int(12) NOT NULL auto_increment,
  `file` varchar(255) collate cp1251_bulgarian_ci NOT NULL,
  `direct` varchar(255) collate cp1251_bulgarian_ci NOT NULL,
  `ip` varchar(255) collate cp1251_bulgarian_ci NOT NULL,
  `size` varchar(255) collate cp1251_bulgarian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=2 ;

Index.php :
Код:
<?php
$broinastranica = 20;
 

$pageNum = 1;

if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
if($_GET['id']){
$getid = $_GET['id'];
$mysql = mysql_query("SELECT * FROM filesystem WHERE id = $getid");

while($mysql = mysql_fetch_array($result1)) {

extract($r);
}
}
else {
$query = "SELECT * FROM filesystem ORDER BY id DESC LIMIT $redove, $broinastranica";
$result=mysql_query($query);

while($r = mysql_fetch_array($result)) {

extract($r);

echo "
<tr><td><a href='".$direct."".basename($file)."'>".$file."</a></td><td><font color='green'>".$direct."</font></td><td><a href='del_file.php?id=".$id."'>Изтрий</a></tr>
";
}
echo '</table>';
echo '<table><tr><td>';
$query = "SELECT COUNT(id) AS numrows FROM filesystem";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}



// създаване на ликовете [предишна] [следваща]
// както и линковете [първа] и [последна]


if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\">[««]</a> ";

$parva = " <a href=\"$self?page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\">[»»]</a> ";

$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}

// показваме
echo '<div align="center">';
echo ''.$parva.' '.$predishna.' '.$nomeranastranici.' '.$sledvashta.' '.$posledna.'';
echo '</div>';
echo '</td></tr>';
echo '</table>';
}
echo '<br>';
echo '<div align="center"><a href="upload_file.php">Качи нов файл</a></div>';
?>

Upload_file.php:
Код:
<?php
if(isset($_POST['submit'])){
include "../connect.php";
$id = (int)$_GET['id'];
$ip = $_SERVER['REMOTE_ADDR'];
$direct = $_POST['direct'];
$file=$_FILES['file']['name'];
$tmp_file=$_FILES['file']['tmp_name'];
$size=$_FILES['file']['size'];
$upload_path="".$direct."".basename($file);
if(empty($file)) {
echo "Моля изберете файл";
echo '</td>
<td class="c_right"><img src="../images/blank.gif" width="2" height="2" alt="" border="0"></td>
</tr>
<tr>
<td class="d_left"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_center"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_right"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>';
require("style2.php");
exit;
}

if(file_exists($upload_path)){
echo "Файлът вече съществува";
echo '</td>
<td class="c_right"><img src="../images/blank.gif" width="2" height="2" alt="" border="0"></td>
</tr>
<tr>
<td class="d_left"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_center"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_right"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>';
require("style2.php");
exit;
}

if($size=="0"){
echo "Файлът е повреден";
echo '</td>
<td class="c_right"><img src="../images/blank.gif" width="2" height="2" alt="" border="0"></td>
</tr>
<tr>
<td class="d_left"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_center"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_right"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>';
require("style2.php");
exit;
}

 function random_string($max = 20){
  $chars = explode(" ", 'a b c d e f g h i j k l m n o p q r s t u v w x y z 0 1 2 3 4 5 6 7 8 9');
  for($i = 0; $i < $max; $i++){
   $rand_key = array_rand($chars);
   $screen1  .= $chars[$rand_key];
  }
  return str_shuffle($screen1);
 }

if($size>5242880){
echo "Файлът е твърде голям";
echo '</td>
<td class="c_right"><img src="../images/blank.gif" width="2" height="2" alt="" border="0"></td>
</tr>
<tr>
<td class="d_left"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_center"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_right"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>';
require("style2.php");
exit;
}

$extensions = array("rar","zip","html","jpg","jpeg","gif","png","bmp","js","txt","css");
$extension_file = end(explode(".",$file));
$extension_file = strtolower($extension_file);
if(!in_array($extension_file,$extensions)){
echo "Непозволен тип файл";
echo '</td>
<td class="c_right"><img src="../images/blank.gif" width="2" height="2" alt="" border="0"></td>
</tr>
<tr>
<td class="d_left"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_center"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
<td class="d_right"><img src="../images/blank.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>';
require("style2.php");
exit;
}

$upload=move_uploaded_file($tmp_file,$upload_path);
if($upload){
$q=mysql_query("INSERT INTO `filesystem` (`id`,`file`,`direct`,`ip`,`size`) VALUES ('$id','$file','$direct','$ip','$size')");
if($q = TRUE){
echo "<font color=\"green\">Файлът беше успешно качен</font>";
}else{
echo "<font color=\"red\">Грешка</font></center>";
exit;
}
}
}else{
?>
<form action="" method="post" enctype = "multipart/form-data">
<table width="95%" border="0">
<tr><td>Файл:</td><td><input name="file" type="file">
<br><font color="green">Изберете файл, който да качите.</font></td></tr>
<tr><td></td><td><hr></td></tr>
<tr><td>Директория:</td><td><select name="direct">
<option value="../">начална</option>
<option value="./codes/">codes</option>
<option value="../images/">images</option>
<option value="../functions/">functions</option>
</select>
<br><font color="green">Изберете къде да качите файла.</font></td></tr>
<tr><td></td><td><hr></td></tr>
<tr><td></td><td><input name="submit" type="submit" value="Давай!"></td></tr>
</table>
</form>
<?php
}
?>


connect.php:
Код:
<?php

$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'db';
$conn = @mysql_connect ($dbhost, $dbuser, $dbpass) OR die ('Could not connect to MySQL: ' . mysql_error());

@mysql_select_db ($dbname) OR die('Could not select the database: ' . mysql_error() );

mysql_query('SET names cp1251');

?>
 

Back
Горе