php上传图片到服务器&&上传excel到服务器并写入MySQL

controller代码：

在上传excel时要用到用PHPExcel，PHPExcel是相当强大的 MS Office Excel 文档生成类库。

你上它的官网把程序包下载下来放在Apache24\htdocs 【新建一个文件夹（PHPExcel）】里面，然后就可以使用了。
在config配置文件下的mimes.php的文件下xlsx后面（113行）增加一条语句：
‘xlsx’ => array(’ application/octet-stream’，……）

<?phpclass Upload extends CI_Controller{    parent::__construct();    public function __construct()    {        parent::__construct();//继承或者调用父类构造函数        $this->load->helper(array('form', 'url'));//加载辅助函数    }    public function index()    {        $this->load->view('upload_form', array('error' => ' '));    }    public function do_upload()    {        //上传到文件夹的路径        $config['upload_path'] = './uploads/';        $config['allowed_types'] = 'gif|jpg|png|xlsx';        $config['max_size'] = 100;        $config['max_width'] = 1024;        $config['max_height'] = 768;        //加载upload库        $this->load->library('upload', $config);        //上传文件file的name='userfile'        if (!$this->upload->do_upload('userfile')) {            $error = array('error' => $this->upload->display_errors());            //没有选择文件，打印错误            $this->load->view('upload_form', $error);        } else {            //选择文件上传            $data = array('upload_data' => $this->upload->data());            // $this->load->view('upload_success', $data);            // 上传后存储的路径     upload_data/full_path            $excleFullPath = $data["upload_data"]["full_path"];            //获取上传文件的后缀名            $extname = strtolower(substr($excleFullPath, strrpos($excleFullPath, '.') + 1));            //判断是否是excel文件，如果是excel文件就写入数据库            if ($extname == 'xlsx') {                //此处往下为新加的excel上传代码：                //--------输出Excel内容换行                define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');                $this->load->view('upload_success', $data);                echo '$excleFullPath', $excleFullPath, '<br>';                require_once 'PHPExcel/Classes/PHPExcel/IOFactory.php';                $objReader = PHPExcel_IOFactory::createReader('Excel2007'); //创建一个2007的读取对象                $objPHPExcel = $objReader->load($excleFullPath);//读取一个xlsx文件                // 循环sheet                {                    //只取第一个sheet工作簿里面的值                    $worksheet = $objPHPExcel->getSheet(0);                    echo 'Worksheet - ', $worksheet->getTitle(), EOL;                    //循环行                    foreach ($worksheet->getRowIterator() as $row) {                        echo 'Row number - ', $row->getRowIndex(), EOL;                        $cellIterator = $row->getCellIterator(); // 拿到行中的cell迭代器                        $cellIterator->setIterateOnlyExistingCells(false); // 设置cell迭代器，遍历所有cell，哪怕cell没有值                        // 循环列                        $arr = array();                        foreach ($cellIterator as $cell) {                            if (!is_null($cell)) {//如果列不给空就得到它的坐标和计算的值                                $data = $cell->getCalculatedValue();                                $arr[] = $data;                                echo 'Cell - ', $cell->getCoordinate(), '-', $cell->getCalculatedValue(), EOL;                            }                        }                        $this->load->model('Insert');                        $this->Insert->to_sql($arr);                        // print_r($arr);                        //   echo '<br>';                    }                }            } else {                $this->load->view('upload_success', $data);                return;            }        }    }}

models代码：

<?phpclass Insert extends CI_Model{    public function __construct(){        parent::__construct();        $this->load->database();    }    public function to_sql($data){        $colomnArr =array("col1","col2","col3","col4","col5");        if(count($data)<count($colomnArr)){            return;        }        $db_array=array();        //遍历一行的每一列组成一个数组        foreach ($colomnArr as $index=>$item){            $db_array[$colomnArr[$index]] = $data[$index];        }        $this->db->insert("sql",$db_array);        echo  $this->db->last_query();        return $this->db->affected_rows();    }}

views代码：

Upload Form：

<html><head>    <title>Upload Form</title></head><body><?php echo $error; ?><form method="post" enctype="multipart/form-data" action="upload/do_upload" accept-charset="utf-8">    <input type="file" name="userfile" size="20"/>    <br/><br/>    <input type="submit" value="upload"/></form></body></html>

Upload Success：

<html><head>    <title>Upload Success</title></head><body><h3>Your file was successfully uploaded!</h3><ul>    <?php foreach ($upload_data as $item => $value): ?>        <li><?php echo $item; ?>: <?php echo $value; ?></li>    <?php endforeach; ?></ul><p><?php echo anchor('upload', 'Upload Another File!'); ?></p></body></html>