MySQL 存储引擎

来源:互联网 发布:微软编程一小时官网 编辑:程序博客网 时间:2024/06/05 04:51

控制器

public function index(){    $_rows = M('tb')->where(['areaType' => 2])->select();    foreach ($_rows as $k => $v) {        echo "pro_array[" . $v['areaCode'] . "]" . "=" . '"' . $v['areaName'] . '";';        echo '<br>';        echo "city_array[" . $v['areaCode'] . "]" . "=" . "[]";        echo '<br>';        echo "city_array[" . $v['areaCode'] . "]" . "[0]" . "=" . '"' . "请选择" . '";';        echo '<br>';        $_rows2 = M('tb')->where(['areaType' => 3, 'areaParentId' => $v['areaCode']])->select();        foreach ($_rows2 as $k2 => $v2) {            echo "city_array[" . $v['areaCode'] . "]" . "[" . $v2['areaCode'] . "]" . "=" . '"' . $v2['areaName'] . '";';            echo '<br>';            echo "l_arr[" . $v2['areaCode'] . "]" . "=" . '"' . $v2['areaName'] . '";';            echo '<br>';            echo "qu_arr[" . $v2['areaCode'] . "]" . "=" . "[]" . ";";            echo '<br>';            echo "qu_arr[" . $v2['areaCode'] . "]" . "[0]" . "=" . '"' . "请选择" . '";';            echo '<br>';            $_r = M('tb')->where(['areaType' => 4, 'areaParentId' => $v2['areaCode']])->find();            if ($_r) {                $_rows3 = M('tb')->where(['areaType' => 4, 'areaParentId' => $v2['areaCode']])->select();                foreach ($_rows3 as $k3 => $v3) {                    echo "qu_arr[" . $v2['areaCode'] . "]" . "[" . $v3['areaCode'] . "]" . "=" . '"' . $v3['areaName'] . '";';                    echo '<br>';                }            } else {                $_rows3 = M('tb')->where(['areaType' => 5, 'areaParentId' => $v2['areaCode']])->select();                foreach ($_rows3 as $k3 => $v3) {                    echo "qu_arr[" . $v2['areaCode'] . "]" . "[" . $v3['areaCode'] . "]" . "=" . '"' . $v3['areaName'] . '";';                    echo '<br>';                }            }        }    }}
0 0