In the previous chapter, we introduced the tutorial of uploading a file using PHP.

Friends will have questions, how can I upload multiple files to the database?

The key point is to put in several files and click submit to upload. Then all the files will be uploaded together, and each file will be given a new path.

Provide an idea:

First get the information of each uploaded file and put it into a custom array

<?php
    $uploadFiles = array();
?>

Then pass The foreach loop is displayed

<?php
    foreach($upfile as $key =>$value) {
      foreach($value as $k => $v){
        $uploadFiles[$k][$key]=$v;
      }
    }
    print_r($uploadFiles);
?>

The result display is similar

<?php
/* 這里展示同時上傳2個文件信息
Array
(
    [0] => Array
        (
            [name] => 1.png
            [type] => image/png
            [tmp_name] => C:\Windows\php82E9.tmp
            [error] => 0
            [size] => 65646
        )
    [1] => Array
        (
            [name] => 2.png
            [type] => image/png
            [tmp_name] => C:\Windows\php82EA.tmp
            [error] => 0
            [size] => 70463
        )
)
*/
?>

The last step is to put the restrictions on publishing a file demonstrated in the previous chapter into the loop for judgment

Get The random file name uses the current time as the prefix of the new file name, and is recombined with the suffix name into the database.

<?php
    //上傳后的文件名定義(隨機(jī)獲取一個文件名（保持后綴名不變）)
    $fileinfo = pathinfo($v["name"]);//解析上傳文件名字
    do{
      $newfile = date("Y-m-d,H-i-s") . rand(1000, 9999) . "." . $fileinfo["extension"];
    } 
    while (file_exists($path . $newfile));
?>

Of course, linking to the database table and uploading files is also an essential link

<?php
    $link = mysqli_connect('localhost','username','password') or die("數(shù)據(jù)庫連接失敗！");
    mysqli_select_db($link,'test');
    mysqli_set_charset($link,'utf8');
    
    $filepath = $path.$newfile;
    $name = $v['name'];
    $size = $v['size'];
    $sql = "insert into img(id,name,size,pic) value(null,'$name','$size','$filepath')";
    mysqli_query($link,$sql);
    mysqli_close($link);
?>