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

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.11397 seconds
  • Memory Usage 2,990KB
  • Queries Executed 13 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_code
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (11)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (11)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (70):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates