SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Member
    Join Date
    Jan 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to create a folder and upload a file in mysql and display my webpage..

    how to create a folder and upload a file in mysql and display my webpage..please help...me

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,496
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    create a folder: www.php.net/mkdir‎

    You don't upload a file in mysql, you might store a file in mysql, but depending on what kind of file it is, that might not be the best solution. You should give some more info, and also try to narrow down your problem a bit.

    display webpage: just open it with your browser?

  3. #3
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,014
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Also will you be uploading only one file at a time or many at a time and what will be the approx range of file sizes for the files?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  4. #4
    SitePoint Member
    Join Date
    Jan 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i finish 75% work. But hi have some errors...plz help..
    my codes


    upload a file:


    Code PHP:
    <?php 
     if(isset($_POST['uploaded_file']) )
    {
     
     
    // Check if a file has been uploaded
    if(isset($_FILES['uploaded_file'])) {
        // Make sure the file was sent without errors
        if($_FILES['uploaded_file']['error'] == 0) {
            // Connect to the database
            $dbLink = new mysqli('localhost', 'root', '', 'abc');
            if(mysqli_connect_errno()) {
                die("MySQL connection failed: ". mysqli_connect_error());
            }
     
            // Gather all required data
            $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
            $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
            $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
            $size = intval($_FILES['uploaded_file']['size']);
            $name1=explode(".",$_FILES['uploaded_file']['name']);
            // Create the SQL query
            $query = "
                INSERT INTO `fileupld` (
                    `name`, `mime`, `size`, `data`, `created`
                )
                VALUES (
                    '{$name1[0]}', '{$mime}', {$size}, '{$data}', NOW()
                )";
     
            // Execute the query
            $result = $dbLink->query($query);
     
            // Check if it was successfull
            if($result) {
                echo 'Success! Your file was successfully added!';
            }
            else {
                echo 'Error! Failed to insert the file'
                   . "<pre>{$dbLink->error}</pre>";
            }
        }
        else {
            echo 'An error accured while the file was being uploaded. '
               . 'Error code: '. intval($_FILES['uploaded_file']['error']);
        }
     
     
    }

    create folder


    Code PHP:
    if (!empty($_FILES)){
    $folder1 = $_POST['folder'];
    $dirPath = 'uploads/'.$folder1;
    $result = mkdir($dirPath);
     
    if ($result == '1') {
     
    //file move on        
    $target_path = $dirPath .'/' . basename( $_FILES['uploaded_file']['name']); 
     
      if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $target_path)) {
         echo "The file ".  basename( $_FILES['uploaded_file']['name']). 
    " has been uploaded";
     
      } else{
         echo "There was an error uploading the file, please try again!";
      }
     
     } else {
       echo $dirPath . " has NOT been created";
     }
     }






    display folders and files:
    Code PHP:
    <?php
     
    $includeurl = false;
     
    $startdir = '.';
     
     
    $showthumbnails = true; 
     
     
    $memorylimit = false; // Integer
     
     
    $showdirs = true;
     
     
    $forcedownloads = false;
     
     
    $hide = array(
    				'dlf',
    				'index.php',
    				'Thumbs',
    				'.htaccess',
    				'.htpasswd'
    			);
     
    $displayindex = false;
     
     
    $allowuploads = false;
     
     
    $overwrite = false;
     
    $indexfiles = array (
    				'index.html',
    				'index.htm',
    				'default.htm',
    				'default.html'
    			);
     
     
    $filetypes = array (
    				'png' => 'jpg.gif',
    				'jpeg' => 'jpg.gif',
    				'bmp' => 'jpg.gif',
    				'jpg' => 'jpg.gif', 
    				'gif' => 'gif.gif',
    				'zip' => 'archive.png',
    				'rar' => 'archive.png',
    				'exe' => 'exe.gif',
    				'setup' => 'setup.gif',
    				'txt' => 'text.png',
    				'htm' => 'html.gif',
    				'html' => 'html.gif',
    				'fla' => 'fla.gif',
    				'swf' => 'swf.gif',
    				'xls' => 'xls.gif',
    				'doc' => 'doc.gif',
    				'sig' => 'sig.gif',
    				'fh10' => 'fh10.gif',
    				'pdf' => 'pdf.gif',
    				'psd' => 'psd.gif',
    				'rm' => 'real.gif',
    				'mpg' => 'video.gif',
    				'mpeg' => 'video.gif',
    				'mov' => 'video2.gif',
    				'avi' => 'video.gif',
    				'eps' => 'eps.gif',
    				'gz' => 'archive.png',
    				'asc' => 'sig.gif',
    			);
     
     
     
    if($includeurl)
    {
    	$includeurl = preg_replace("/^\//", "${1}", $includeurl);
    	if(substr($includeurl, strrpos($includeurl, '/')) != '/') $includeurl.='/';
    }
     
    error_reporting(0);
    if(!function_exists('imagecreatetruecolor')) $showthumbnails = false;
    if($startdir) $startdir = preg_replace("/^\//", "${1}", $startdir);
    $leadon = $startdir;
    if($leadon=='.') $leadon = '';
    if((substr($leadon, -1, 1)!='/') && $leadon!='') $leadon = $leadon . '/';
    $startdir = $leadon;
     
    if($_GET['dir']) {
    	//check this is okay.
     
    	if(substr($_GET['dir'], -1, 1)!='/') {
    		$_GET['dir'] = strip_tags($_GET['dir']) . '/';
    	}
     
    	$dirok = true;
    	$dirnames = split('/', strip_tags($_GET['dir']));
    	for($di=0; $di<sizeof($dirnames); $di++) {
     
    		if($di<(sizeof($dirnames)-2)) {
    			$dotdotdir = $dotdotdir . $dirnames[$di] . '/';
    		}
     
    		if($dirnames[$di] == '..') {
    			$dirok = false;
    		}
    	}
     
    	if(substr($_GET['dir'], 0, 1)=='/') {
    		$dirok = false;
    	}
     
    	if($dirok) {
    		 $leadon = $leadon . strip_tags($_GET['dir']);
    	}
    }
     
    if($_GET['download'] && $forcedownloads) {
    	$file = str_replace('/', '', $_GET['download']);
    	$file = str_replace('..', '', $file);
     
    	if(file_exists($includeurl . $leadon . $file)) {
    		header("Content-type: application/x-download");
    		header("Content-Length: ".filesize($includeurl . $leadon . $file)); 
    		header('Content-Disposition: attachment; filename="'.$file.'"');
    		readfile($includeurl . $leadon . $file);
    		die();
    	}
    	die();
    }
     
    if($allowuploads && $_FILES['file']) {
    	$upload = true;
    	if(!$overwrite) {
    		if(file_exists($leadon.$_FILES['file']['name'])) {
    			$upload = false;
    		}
    	}
     
    	if($uploadtypes)
    	{
    		if(!in_array(substr($_FILES['file']['name'], strpos($_FILES['file']['name'], '.')+1, strlen($_FILES['file']['name'])), $uploadtypes))
    		{
    			$upload = false;
    			$uploaderror = "<strong>ERROR: </strong> You may only upload files of type ";
    			$i = 1;
    			foreach($uploadtypes as $k => $v)
    			{
    				if($i == sizeof($uploadtypes) && sizeof($uploadtypes) != 1) $uploaderror.= ' and ';
    				else if($i != 1) $uploaderror.= ', ';
     
    				$uploaderror.= '.'.strtoupper($v);
     
    				$i++;
    			}
    		}
    	}
     
    	if($upload) {
    		move_uploaded_file($_FILES['file']['tmp_name'], $includeurl.$leadon . $_FILES['file']['name']);
    	}
    }
     
    $opendir = $includeurl.$leadon;
    if(!$leadon) $opendir = '.';
    if(!file_exists($opendir)) {
    	$opendir = '.';
    	$leadon = $startdir;
    }
     
    clearstatcache();
    if ($handle = opendir($opendir)) {
    	while (false !== ($file = readdir($handle))) { 
    		//first see if this file is required in the listing
    		if ($file == "." || $file == "..")  continue;
    		$discard = false;
    		for($hi=0;$hi<sizeof($hide);$hi++) {
    			if(strpos($file, $hide[$hi])!==false) {
    				$discard = true;
    			}
    		}
     
    		if($discard) continue;
    		if (@filetype($includeurl.$leadon.$file) == "dir") {
    			if(!$showdirs) continue;
     
    			$n++;
    			if($_GET['sort']=="date") {
    				$key = @filemtime($includeurl.$leadon.$file) . ".$n";
    			}
    			else {
    				$key = $n;
    			}
    			$dirs[$key] = $file . "/";
    		}
    		else {
    			$n++;
    			if($_GET['sort']=="date") {
    				$key = @filemtime($includeurl.$leadon.$file) . ".$n";
    			}
    			elseif($_GET['sort']=="size") {
    				$key = @filesize($includeurl.$leadon.$file) . ".$n";
    			}
    			else {
    				$key = $n;
    			}
     
    			if($showtypes && !in_array(substr($file, strpos($file, '.')+1, strlen($file)), $showtypes)) unset($file);
    			if($file) $files[$key] = $file;
     
    			if($displayindex) {
    				if(in_array(strtolower($file), $indexfiles)) {
    					header("Location: $leadon$file");
    					die();
    				}
    			}
    		}
    	}
    	closedir($handle); 
    }
     
    //sort our files
    if($_GET['sort']=="date") {
    	@ksort($dirs, SORT_NUMERIC);
    	@ksort($files, SORT_NUMERIC);
    }
    elseif($_GET['sort']=="size") {
    	@natcasesort($dirs); 
    	@ksort($files, SORT_NUMERIC);
    }
    else {
    	@natcasesort($dirs); 
    	@natcasesort($files);
    }
     
    //order correctly
    if($_GET['order']=="desc" && $_GET['sort']!="size") {$dirs = @array_reverse($dirs);}
    if($_GET['order']=="desc") {$files = @array_reverse($files);}
    $dirs = @array_values($dirs); $files = @array_values($files);
     
     
    ?>
     
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Directory Listing of <?php echo str_replace('\\', '', dirname(strip_tags($_SERVER['PHP_SELF']))).'/'.$leadon;?></title>
    <link rel="stylesheet" type="text/css" href="<?php echo $includeurl; ?>dlf/styles.css" />
    <?php
    if($showthumbnails) {
    ?>
    <script language="javascript" type="text/javascript">
    <!--
    function o(n, i) {
    	document.images['thumb'+n].src = '<?php echo $includeurl; ?>dlf/i.php?f='+i<?php if($memorylimit!==false) echo "+'&ml=".$memorylimit."'"; ?>;
     
    }
     
    function f(n) {
    	document.images['thumb'+n].src = 'dlf/trans.gif';
    }
    //--><head>
     
     
    </script>
    <?php
    }
    ?>
     
    </head>
    <body>
    <div id="container">
      <h1> folders</h1>
      <div id="breadcrumbs"> <a href="<?php echo strip_tags($_SERVER['PHP_SELF']);?>">home</a> 
      <?php
     	 $breadcrumbs = split('/', str_replace($startdir, '', $leadon));
      	if(($bsize = sizeof($breadcrumbs))>0) {
      		$sofar = '';
      		for($bi=0;$bi<($bsize-1);$bi++) {
    			$sofar = $sofar . $breadcrumbs[$bi] . '/';
    			echo ' &gt; <a href="'.strip_tags($_SERVER['PHP_SELF']).'?dir='.strip_tags($sofar).'">'.$breadcrumbs[$bi].'</a>';
    		}
      	}
     
    	$baseurl = strip_tags($_SERVER['PHP_SELF']) . '?dir='.strip_tags($_GET['dir']) . '&amp;';
    	$fileurl = 'sort=name&amp;order=asc';
    	$sizeurl = 'sort=size&amp;order=asc';
    	$dateurl = 'sort=date&amp;order=asc';
     
    	switch ($_GET['sort']) {
    		case 'name':
    			if($_GET['order']=='asc') $fileurl = 'sort=name&amp;order=desc';
    			break;
    		case 'size':
    			if($_GET['order']=='asc') $sizeurl = 'sort=size&amp;order=desc';
    			break;
     
    		case 'date':
    			if($_GET['order']=='asc') $dateurl = 'sort=date&amp;order=desc';
    			break;  
    		default:
    			$fileurl = 'sort=name&amp;order=desc';
    			break;
    	}
      ?>
      </div>
      <!--div id="listingcontainer">
        <div id="listingheader"> 
    	<div id="headerfile"><a href="<?php echo $baseurl . $fileurl;?>">File</a></div>
    	<div id="headersize"><a href="<?php echo $baseurl . $sizeurl;?>">Size</a></div>
    	<div id="headermodified"><a href="<?php echo $baseurl . $dateurl;?>">Last Modified</a></div>
    	</div-->
        <div id="listing">
    	<?php
    	$class = 'b';
    	if($dirok) {
    	?>
    	<div><a href="<?php echo strip_tags($_SERVER['PHP_SELF']).'?dir='.urlencode($dotdotdir);?>" class="<?php echo $class;?>"><img src="<?php echo $includeurl; ?>dlf/dirup.png" alt="Folder" /><strong>..</strong> <em>&nbsp;</em>&nbsp;</a></div>
    	<?php
    		if($class=='b') $class='w';
    		else $class = 'b';
    	}
    	$arsize = sizeof($dirs);
    	for($i=0;$i<$arsize;$i++) {
    	?>
    	<!--folder link-->
    	<div><a href="<?php echo strip_tags($_SERVER['PHP_SELF']).'?dir='.urlencode(str_replace($startdir,'',$leadon).$dirs[$i]);?>" class="<?php echo $class;?>"><img src="<?php echo $includeurl; ?>dlf/folder.png" alt="<?php echo $dirs[$i];?>" /> <strong><?php echo $dirs[$i];?></strong><?php echo date ("M d Y h:i:s A", filemtime($includeurl.$leadon.$dirs[$i]));?></a></div>
    	<?php
    		if($class=='b') $class='w';
    		else $class = 'b';	
    	}
     
    	$arsize = sizeof($files);
    	for($i=0;$i<$arsize;$i++) {
    		$icon = 'unknown.png';
    		$ext = strtolower(substr($files[$i], strrpos($files[$i], '.')+1));
    		$supportedimages = array('gif', 'png', 'jpeg', 'jpg');
    		$thumb = '';
     
    		if($showthumbnails && in_array($ext, $supportedimages)) {
    			$thumb = '<span><img src="dlf/trans.gif" alt="'.$files[$i].'" name="thumb'.$i.'" /></span>';
    			$thumb2 = ' onmouseover="o('.$i.', \''.urlencode($leadon . $files[$i]).'\');" onmouseout="f('.$i.');"';
     
    		}
     
    		if($filetypes[$ext]) {
    			$icon = $filetypes[$ext];
    		}
     
    		$filename = $files[$i];
    		if(strlen($filename)>43) {
    			$filename = substr($files[$i], 0, 40) . '...';
    		}
     
    		$fileurl = $includeurl . $leadon . $files[$i];
    		if($forcedownloads) {
    			$fileurl = $_SESSION[''] . '?dir=' . urlencode(str_replace($startdir,'',$leadon)) . '&download=' . urlencode($files[$i]);
    		}
     
    	?>
     
     
    	<!--div><input type="text" value="<?php echo $fileurl;?>" onselect="showMsg()"> <strong><em></a></div-->
     
     
    		<!--div>	<a href="<?php echo $fileurl;?>"  class="<?php echo $class;?>"<?php echo $thumb2;?>><img src="<?php echo $includeurl; ?>dlf/<?php echo $icon;?>" alt="<?php echo $files[$i];?>" /><strong><?php echo $filename;?></strong><em></a></div-->
    	<div><a href="<?php echo $fileurl;?>" class="<?php echo $class;?>"<?php echo $thumb2;?>><img src="<?php echo $includeurl; ?>dlf/<?php echo $icon;?>" alt="<?php echo $files[$i];?>" /><strong><?php echo $filename;?></strong> <?php echo date ("M d Y h:i:s A", filemtime($includeurl.$leadon.$files[$i]));?><?php echo $thumb;?></a></div>
    	<?php
    		if($class=='b') $class='w';
    		else $class = 'b';	
    	}	
    	?></div>
     
      </div>
    </div>
     
    </body>
    </html>
    Last edited by Mittineague; Feb 2, 2014 at 10:37. Reason: reformatting bbcode tags

  5. #5
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,014
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    What are the errors that you're getting when attempting to upload a file?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  6. #6
    SitePoint Member
    Join Date
    Jan 2014
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    upload same folder to a file ..i got errors..file to create folder but the file upload in common folder(uploads)..
    then can't create sub folder...
    can't upload file in same folder...
    same time file uploade in db but not show the file in folder..
    thats it

  7. #7
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,014
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    What file permissions are set for the Uploads folder?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •