php - 如何使用 Codeigniter 上传文本文件并将其数据导入到 sql 中？

Question

我有一个核心 PHP 脚本，它允许我上传文本文件并将其数据导入 sql 数据库。

我想使用 Codeigniter 做同样的事情。当我将代码放入 CI 应用程序时，我尝试通过屏幕显示空白屏幕。

以下是我用于上传文件和导入文件的核心 PHP 脚本:

<?php
include_once 'dbconfig.php';
if(isset($_POST['btn-upload']))
{    

    $file = rand(1000,100000)."-".$_FILES['file']['name'];
    $file_loc = $_FILES['file']['tmp_name'];
    $file_size = $_FILES['file']['size'];
    $file_type = $_FILES['file']['type'];
    $folder="uploads/";
    $location =$_FILES['file'];

    // new file size in KB
    $new_size = $file_size/1024;  
    // new file size in KB

    // make file name in lower case
    $new_file_name = strtolower($file);
    // make file name in lower case

    $final_file=str_replace(' ','-',$new_file_name);

        if(move_uploaded_file($file_loc,$folder.$final_file))
    {
        $sql="INSERT INTO tbl_uploads(file,type,size) VALUES('$final_file','$file_type','$new_size')";
        mysqli_query($connection,$sql);


        $handle = fopen("c:/wamp/www/codeigniter/uploads/$file", "r");

         if ($handle) {
                while (($line = fgets($handle)) !== false) {

                     $lineArr = explode("\t", "$line");
                     //var_dump($lineArr); // to make sure array is ok

                     // instead assigning one by onb use php list -> http://php.net/manual/en/function.list.php            
                     list($emp_id, $date_data, $abc, $def, $entry, $ghi) = $lineArr;

                     // and then insert data
                     mysqli_query($connection,"INSERT INTO `daily_data2` (emp_id, date_data, abc, def, entry, ghi) 
            VALUES ('$emp_id', '$date_data', '$abc', '$def', '$entry', '$ghi')");
                }

                fclose($handle);
            }


        ?>
        <script>
        alert('successfully uploaded');
        window.location.href='index.php?success';
        </script>
        <?php


    }
    else
    {
        ?>
        <script>
        alert('error while uploading file');
        window.location.href='index.php?fail';
        </script>
        <?php
    }

}

?>

我不知道如何在 Codeigniter 中执行此操作。请在这里指导我

词形:

     <h2>Upload CSV To Import Users</h2>
        <form method="post" action="<?php echo site_url('admin/attendance/upload');?>" enctype="multipart/form-data">
            <input type="file" name="userfile"  ><br><br>
            <input type="submit" name="submit" value="UPLOAD" class="btn btn-primary">
        </form>

Answer 1

说真的，伙计们，有带有 CodeIgniter 的文件上传类，它是免费的，功能强大，错误捕获而且非常简单!

请看:

https://ellislab.com/codeigniter/user-guide/libraries/file_uploading.html

我真诚地希望你能使用它:)