php中使用mysql_fetch_array输出数组至页面中展示

用的是CI框架，很好的MVC结构

在Model层

     public function showProteinCategory(){

         $sql = "SELECT DISTINCT protein_name FROM protein";

         $result = mysql_query($sql);

         $arr = array();

         while ($res = mysql_fetch_array($result)){

             $arr[] = array(

             "protein_name" => $res['protein_name']

             );

         }

         return $arr;

     }

Controllers层

 $this->load->model("selectInfo_model");

             $protein['show'] = $this->selectInfo_model->showProteinCategory();

 //            print_r($protein);

 $this->load->view('information_select',$protein);

view层

 <label>蛋白质种类：</label>

 <select name="bigname" id="bigname" style="width:450px">

 <option value="">-- 请选择蛋白质种类--</option>

  <?php if(is_array($show)) foreach($show as $r):?>

 <option value="<?php echo $r['protein_name'] ?>"><?php echo $r['protein_name'] ?></option>

 <?php endforeach;?>

 </select>

那我们看看这里的$protein吧，到底是什么样的呢，我们到底怎样把握呢？看看输出的

Array

(

    [show] => Array

        (

            [0] => Array

                (

                    [protein_name] => 重组人乳铁蛋白

                )

            [1] => Array

                (

                    [protein_name] => 人乳铁蛋白

                )

        )

)

这里注意的是mysql_fetch_array和mysql_fetch_object的区别

mysql_fetch_array中在页面中是这样显示的foreach($show as $r) {$r['protein_name']}

mysql_fetch_object中在页面中是这样显示的foreach($show as $r) {$r->protein_name}