Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Programming \ PHP file upload methods exist in the database     - Linux System Getting Started Learning: rename multiple files in Linux (Linux)

- Oracle 11g contraction table space error ORA-03297: file contains used data beyondrequested RESIZE value (Database)

- Computer security perimeter recommendations (Linux)

- The source code compiler installation Nginx 1.8.0 under Ubuntu 14.10 (Server)

- SecureCRT session buffer size settings (Linux)

- On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL (Server)

- ORA-00020: No more process state objects available (Database)

- Linux network security backdoor technology and advanced skill practice (Linux)

- Linux source code to install Apache and solutions to common errors (Server)

- To install the latest version of the EPEL on CentOS 5.x or 6.x (Linux)

- Let you Fun Ubuntu desktop eleven weapon (Linux)

- Ubuntu 14.04 LTS 64-bit installation and activation Sublime Text 3 can not solve the Chinese input method to solve the problem (Linux)

- Let the terminal under Mac OS X as like Linux has displayed a variety of colors (Linux)

- dmidecode command Detailed (Hardware information) (Linux)

- HA-Federation-HDFS + Yarn cluster deployment (Server)

- CentOS 6.x systems installation + NIC driver installation (Realtek PCIe GBE Family Controller for Linux) (Linux)

- Oracle 11g RMAN cross-platform transfer table space (Database)

- MySQL database to open a remote connection method (Database)

- Linux firewall security (Linux)

- Use the DBMS_SCHEDULER package to manage scheduled tasks (Database)

 
         
  PHP file upload methods exist in the database
     
  Add Date : 2018-11-21      
         
         
         
 

This paper describes examples of PHP file upload and save in the database approach. Share to you for your reference. As follows:

show_add.php file as follows:

  if (! Isset ($ _ REQUEST [ '' id '']) or $ _REQUEST [ '' id ''] == "") die ( "error : id none ");
  $ id = $ _REQUEST [ '' id ''];
  // locate a record, read out
  $ conn = mysql_connect (" localhost "," root "," admin ");
  if ($ conn) die (!" error: mysql connect failed ");
  mysql_select_db (" nokiapaymentplat ", $ conn);
  $ sql = "select * from receive where id = $ id";
  $ result = mysql_query ($ sql, $ conn);
  if ($! result) die ( "error: mysql query");
  $ num = mysql_num_rows ($ result);
  if ($ num < 1) die ( "error: no this recorder");
  $ data = mysql_result ($ result, 0, "file_data");
  $ type = mysql_result ($ result, 0, "file_type");
  $ name = mysql_result ($ result, 0, "file_name");
  mysql_close ($ conn);
  // output corresponding to the file header, and restore the original file name
  header ( "Content-type: $ type");
  header ( "Content-Disposition: attachment; filename = $ name");
  echo $ data;
>

 

show_info.php file as follows:

< php
  if (isset ($ _ REQUEST [ '' id '']) or $ _REQUEST [ '' id ''] == "!") Die ( "error:? Id none ");
  $ id = $ _REQUEST [ '' id ''];
  // locate a record, read out
  $ conn = mysql_connect (" localhost ", "root", "admin");
  if ($ conn) die (! "error: mysql connect failed");
  mysql_select_db ( "nokiapaymentplat", $ conn);
  $ sql = "select file_name, file_size from receive where id = $ id";
  $ result = mysql_query ($ sql, $ conn);
  if ($ result! ) die ( "error: mysql query");
  // If no records, the error
  $ num = mysql_num_rows ($ result);
  if ( $ num < 1) die ( "error: no this recorder");
  // The following two procedures can also write
  // $ row = mysql_fetch_object ($ result);
  // $ name = $ row- > name;
  // $ size = $ row- > size;
  $ name = mysql_result ($ result, 0 , "file_name");
  $ size = mysql_result ($ result, 0, "file_size");
  mysql_close ($ conn);
  echo "< hr > files uploaded information: ";
  echo" < br > the file ''s name - $ name ";  
  echo" < br > the file' ' s size - $ size? ";
  echo" < br > < a href = show_add.php id = $ id > attachment < / a > ";
>

submit.php file as follows:

  if (is_uploaded_file ($ _ FILES [ '' myfile ''] [ '' tmp_name ''])) {
  // have uploaded files
  $ myfile = $ _ FILES [ "myfile"];
    // set the timeout limit time, the default time is 30 seconds, set to 0 for the unlimited
    $ time_limit = 60;    
    set_time_limit ($ time_limit); //
    // the contents of the file to read the string
    $ fp = fopen ($ myfile [ '' tmp_name ''], "rb");
    if die ( "file open error") ($ fp!);
    $ file_data = addslashes (fread ($ fp, filesize ($ myfile [ '' tmp_name ''])));
    fclose ($ fp);
    unlink ($ myfile [ '' tmp_name '']);
    // file format, name, size
    $ file_type = $ myfile [ "type"];
    $ file_name = $ myfile [ "name"];
    $ file_size = $ myfile [ "size"];
    die ($ file_type);
    // connect to the database, the file is saved to the database
    $ conn = mysql_connect ( "localhost", "root", "admin");
    if die ($ conn!) ( "error: mysql connect failed");
    mysql_select_db ( "nokiapaymentplat", $ conn);
    $ sql = "insert into receive
    (file_data, file_type, file_name, file_size)
    values ( '' $ file_data '', '' $ file_type '', '' $ file_name '', $ file_size) ";
    $ result = mysql_query ($ sql, $ conn);
    // remove the following phrase just insert statement id
    $ id = mysql_insert_id ();
    mysql_close ($ conn);
    set_time_limit (30); // restore the default timeout settings
    echo "Upload successful ---";
    echo "< a href = ''? show_info.php id = $ id '' > display uploaded file information < / a > ";
 }  
  else { 
    echo" you do not have to upload any file ";  
  }  
>?

upload.php file as follows:

< html >  
< head >  
< title > file upload form < / title >  
< / head >  
< body >  
< table >  
< form enctype = '' multipart / form-data '' name = '' myform '' action = '' submit.php ''
method = '' post '' >  
< INPUT TYPE = "hidden" NAME = "MAX_FILE_SIZE" VALUE = "1000000" >
< tr > < td > Select the upload file < / td > < td >
< input name = '' myfile '' type = '' file '' > < / td > < / tr >
< tr > < td colspan = '' 2 '' > < input name = '' submit '' value = '' Upload ''   type = '' submit '' > < / td > < / tr >  
< / table >  
< / body >  
< / html >

     
         
         
         
  More:      
 
- Fedora network set up simple (Linux)
- Red Hat Linux security settings document (Linux)
- CentOS install expect (Linux)
- 14 useful example Linux Sort command (Linux)
- Oracle restrict certain IP, the malicious user actions on important table (Database)
- Linux check disk parameters trapping lack amendments (Linux)
- Oracle metadata Reconstruction experiments (Database)
- Learning C ++ Standard Template Library and data structures (Programming)
- C ++ inline functions (Programming)
- MySQL full-index scan bug (Database)
- Ambari and Hadoop configuration, management and monitoring of the project Getting (Server)
- Linux startup and logon security settings (Linux)
- xargs Detailed description (Linux)
- Some practical tips Linux (Linux)
- Linux iptables: basic principles and rules (Linux)
- LaTeX Getting Started Tutorial (Linux)
- MySQL In can not be overridden with an internal connection (Database)
- 10 really interesting Linux command (Linux)
- Use scripts easily install the latest Linux kernel in Ubuntu (Linux)
- MyEclipse configuration necessary (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.