www.webdeveloper.com
Results 1 to 11 of 11

Thread: Help with file upload/download

  1. #1
    Join Date
    Apr 2012
    Posts
    8

    Help with file upload/download

    Hello Friends,

    I have a question. I made an uploading page which uploads the files to database and download page where the files can be viewed.
    In my upload page there is a dropdownlist containing 4 options. I uploaded files based on the dropdownlist. My options in the dropdown are A,AA,AACC,AAME,AAN which are listed under company. My question is;
    If I select A option in my dropdownlist and upload files , in the download page i shud be able to view all the A files that are uploaded.
    If I select AA option in my dropdownlist and upload files , in the download page i shud be able to view all the AA files that are uploaded.

    How can i do this. If i am not wrong it is like input of uploading page shud be the query of download page if m not wrong??..

    I have created ID,TITLE,CODE,DESCRIPTION,FILE ,DATE and COMPANY fields in my database.
    My codes for upload page and download page are below.

    Regards,

    Rohan


    PHP Code:
        <?php
        
    //second page.php
        
    $form "<form action='secondpage.php' method='POST' enctype='multipart/form-data'>
        <table align='center'>
        <tr>
        <td>Title:</td>
        <td><input type='text' name='title' /></td>
        </tr>
        <tr>
        <td>Description:</td>
        <td><textarea name='description' cols='35' rows='5'></textarea></td>
        </tr>
        <tr>
        <td>company:</td>
        <td><select name=company id=company>
        <option value='A'>A</option>
        <option value='AA'>AA</option>
        <option value='AACC'>AACC</option>
        <option value='AAME'>AAME</option>
        <option value='AAN'>AAN</option>
        </select></td>
        </tr>
        <tr>
        <td></td>
        <td><input type='file' name='myfile' /></td>
        </tr>
        <tr>
        <td></td>
        <td><input type='submit' name='submitbutton' value='Submit' /></td>
        </tr>
        </table>
        </form>"
    ;
        if(isset(
    $_POST["submitbutton"]))
        {
        
    $title $_POST['title'];
        
    $description $_POST['description'];
            
    $company $_POST['company'];
        
    $name $_FILES['myfile']['name'];
        
    $type $_FILES['myfile']['type'];
        
    $size $_FILES['myfile']['size'];
        
    $tmpname $_FILES['myfile']['tmp_name'];
        
    $ext substr($namestrrpos($name'.'));
        if(
    $name)
        {
        if(
    $title && $description)
        {
        require(
    "connect.php");
        
    $date date("M-d-Y");
        
    $charset "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
        
    $length 15;
        
    $code "";
        for (
    $i 0$i <= $length$i++)
        {
        
    $rand rand() % strlen($charset);
        
    $tmp substr($charset$rand1);
        
    $code.= $tmp;
        }
        
    $query mysql_query("SELECT code FROM files WHERE code= '$code'");
        
    $numrows mysql_num_rows($query);
        while(
    $numrows != 0)
        {
        for (
    $i 0$i <= $length$i++)
        {
        
    $rand rand() % strlen($charset);
        
    $tmp substr($charset$rand1);
        
    $code.= $tmp;
        }
        
    $query mysql_query("SELECT code FROM files WHERE code= '$code'");
        
    $numrows mysql_num_rows($query);
        }
        
    mkdir("files/$code");
        
    move_uploaded_file($tmpname"files/$code/"."$name");
        
    $file "$name";
        
    $query mysql_query("INSERT INTO files VALUES ('', '$title', '$code','$description', '$name','$date', '$company')");
        echo 
    "Your file has been uploaded.<br><br><a href='download.php?code=$code'>Download File</a>";
        }
        else
        echo 
    "You did not fill in the form completely.$form ";
        }
        else
        echo 
    "You did not select a file.$form ";
        }
        else
        echo 
    "$form";
        
    ?>


    PHP Code:

        //download.php
        <?php
        
    //echo "<title></title>";
        
    $code $_GET['code'];
        if (
    $code)
        {
        require(
    "connect.php");
        
    $query mysql_query("SELECT * FROM files WHERE code='$code'");
        
    $numrows mysql_num_rows($query);
        if(
    $numrows == 1)
        {
        
    $row mysql_fetch_assoc($query);
        
    $id $row['id'];
        
    $title $row['title'];
        
    $file $row['file'];
        
    $description $row['description'];
        
    $date $row['date'];
            
    $company $row['company'];
        echo 
    "<title>$title - File Upload</title>";
        echo 
    "<center><h1>Company Reports</h1></center><br>";
        echo 
    "<div style ='background-color: #efefef; width: 500px; margin-left: auto; margin-right: auto; padding: 8px;'><a href='files/$code/$file'>$title</a>
        <br><br>
        <left>
    $description</left>
        </div>"
    ;
        }
        else
        echo 
    "No file was found.";
        }
        else
        {
        echo 
    "please upload a file.<br><br>";
        require (
    "secondpage.php");
        }
        
    ?>

  2. #2
    Join Date
    Feb 2011
    Posts
    231
    Hi,
    In the file for upload you should get the selected ottion in dropdown list, and to add it in the link to Download:
    download.php?code=$code&company=...
    Then, in "download.php" make the selection like this:
    Code:
    $query = mysql_query("SELECT * FROM files WHERE code='$code' AND company='". $_GET['company']."'");
    - is indicated to filter $_GET['company'] .

  3. #3
    Join Date
    Apr 2012
    Posts
    8
    Thank you my friend. Will try n let u knw!

  4. #4
    Join Date
    Apr 2012
    Posts
    8
    I have made he changes which u told. Files are getting uploded. But as i click the download page link..its showing no file found. M unable to view the download page.

  5. #5
    Join Date
    Feb 2011
    Posts
    231
    Maybe the url is not created correctly, the ideea is to pass in url the "code" and the "company".
    For example: href="download.php?code=$code&company=AAN" .

  6. #6
    Join Date
    Apr 2012
    Posts
    8
    So for each company shud i do it individually..if it is for another company then i shd put another company's name

  7. #7
    Join Date
    Apr 2012
    Posts
    8
    Sorry for asking you many questions. I am new to php ..that's y..the thing is in the download page m only able to view the current file which i uploaded....rest all files which are there in the database i want them to be listed in the download page as per the dropdownlist in the upload page..Please help me

  8. #8
    Join Date
    Feb 2011
    Posts
    231
    Having 'company' in url, try this select in download.php:
    Code:
    $query = mysql_query("SELECT * FROM files WHERE company='". $_GET['company']."'");

  9. #9
    Join Date
    Apr 2012
    Posts
    8
    company in the url means..

  10. #10
    Join Date
    Apr 2012
    Posts
    8
    shud i put single company or company?

  11. #11
    Join Date
    Apr 2012
    Posts
    8
    I tried..But its showing no file found..eventhough it has uploaded

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles