继续、驕傲 发表于 2012-10-15 16:47:43

CI 如何遍历列表

我想在前台显示成:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAT4AAACSCAIAAABT8zFGAAAIMklEQVR4nO2dPZIUORBGKzgADjchghtgcR2Cu3ACPG6AzzWwcDCxMIheY2Nne0pS6svUz1TOvGc1VVJmlipfq7Z3ovu4AUBCjqcuAAAioC5ASlAXICWoC5AS1IWXxfEfexItjL8uNMAFOe44HXRNnzgyBurCy6Jq1BFCSbTwQtaFnsKeZxt4OdjqTk/kHeDY1V11nN5y1nnlenuLxfS+ie7havVsY9sdeSp1yxSDDRl8vt/TYetSXFaPl6mu4dL0dVinblfFqkTVIFI6sSCjUCVNDNTVpyytaimbG+wUtuWVq1Rl8G517UtC3SuQ+kLs4lfcpvuYR0H1YHWYmMi4loXqKoUu7RvUVUh9IXvUVSQ0RAoU0IqPuteNvJnsF2LXv+LqWjGfobqegieTVN3ByI6bd0c4nZ5lf3DUtVLoub0cBd7xykRvltOs8LWUGfWDSvBwMYHprpL0RONMz2JUbhz0FlCdVR6M3b7/p7vSe0uv3m8x3cgUvcLASHuhW2fFjN5l993s0Irdj2m9XsGK+Ma9q+aq3sRY5coRPcVtqbp6TO/x2JTAsJt2R6unYrV5l917IYGqjseES/WyIvhRw0h3P8a4s90U1YlGRulauhUoUcSJ3u7phjIKCBc5pTDvKW9hgfHhFWt13lIWpTtdS/m6HOa9/HLkogWcrG53Vjkg0Ot2FqVy8eoCBcROeQvzjh9ZsUWdZ7Ao1/GYW1vdcoorhXFw4mKirkWggNgpb2He8SMrNqvVRNblOh6j5NWvfcqNcJFbXZuROk8j9emxU4HCXONHVsxb0gjrEnUv1nujB8sYHHPLrq6rtlgEV8H22Ym3zTt+ZMWmt6+daHVwu6mqB8WqjgVY6ZRSumP0KeUAY0rrlGtBxTK6I8U1DVxOrDDX+JEVG19tPYt+PBD8mKHu+DIqXSQFVJJ1x+hTWmvh6vXxK1/X8YHLGcm47kKmzHWl8J6KxbebqnqwnOst6WgTuqDbbVBd5WqVU97x3dq6iyIuXGB9wzXHMlbHe+9La0qsJC+BHhuJ323C4zG3AWPLjK3XkbB6VvHUrCn2enVPha+rNbLEG1lJ6r2dxtJ5C5tVkov9qe0mnJioms7+py+yN7eScnzKUaM15f6UuBb6klUrUaqKJdULa01RFtm1YoGSdLrLOz2vfeNW5wqsfzO4twg9k3dKOTgwyxgfaBEjYDnRiGmnCxRmX5prsHHhIyWJdBNNzHXKWD2uR4glsg+6rnfhZw/Z6S7lot6CpQyqK950O4txXNeYtmuCus8SZd8T0eN7zypNRds1Qd1nSeuujd9KpR/0Mf107gJfEq13Qde7I1yKFTfOsVXOy07n9ak/LSEtPCn0H0BKUBcgJagLkBLUBUgJ6gKkBHUBUoK6AClBXYCUoC5ASlAXICWoC5AS1AVICeoCpAR1AVKCugApQV2AlKAuQEpQFyAlqAuQEtQFSAnqAqQEdQFSgroAKUFdgJSgLkBKUBcgJVdUt/pTTiuy6D9Hws+UwNW4YkeWLum/96MLqR98CNtKEblIgDEu13YPrp6O3Bq7cSl5OXiKuq0xqAtPwrXarjRE8aTreWuWd3/WSwJYTYK267pxslQUMlAA6sJ1uFzbtdwzbAzsumLk08jW3LkrAKCwqe3+/v377du3L1++/Pr1q1OQ9tPgDy9OCunqeguoRhYLBpjOjrb78+fP+/fv/7XrzZs3379/75cl7If3g70TDbGrWbzjAVazo+0+f/58b9G7d+/6ZQ1//Kvvul0V7QGoC0/Cjrb7+PHjvbqvX7/ulxXdde2D1bNdM08FiFUBLGVH2339+vW+0T98+NAvy+PDhgdmYwDqwpOwqe0+ffr06tWr4zjevn3748eP7viWga0Ntjwl7roPG6k4sRyAuvAk7Gu7379///z5UxwsPht7n6KNYYqxped6IoC5XLTtBoUURypvBKct3fU4ALCOizZcwBBjSsvJVpDJFwOwgIu26fiuawdfGh9gA3QqQEpQFyAl11VX/6/TLeX4MvLgDau5dIfdC2B/QPXwQvxky/uZVnW6OMAbHEDhcm3UlarsfmN/Fj+O6gbsRjDOBoIDdLl0G4m7bmuuMcWrbuyt5OBPOGAZV2yj6p7Z3Uhvzgdm/Z92UmM66sI6LtpGZdNXNajOOr1uqavvot68pyDKWwmAl01tJH5LRteokwBdSVqqHCt33dPBbnCAADvaKPAtGS6qkrTMqR5U1O2+j7QioC6sYEcbxb4lI7CFLlW3W3M4OECAHW0U+5YM/fi9pbrt4V20W/kpjlIPgJcdbTTxWzJS7LquXAAxNrXR6m/JOL14iHBDXXim7GujFd+ScTpY7rqKt+WRKbK13jtQF6Zw0TbS1TUU1YNPVPf0dOB6fADQuWgDiR1fPiF3Jyr7drl7A1yNi/al64F5bli8hRTQmgApQV2AlKAuQEpQFyAlqAuQEtQFSAnqAqQEdQFSgroAKUFdgJSgLkBKUBcgJagLkBLUBUgJ6gKkBHUBUoK6AClBXYCUzFS3++1QfKkawCw6v4I1aCCWAiyir27srDIAAMIs2XV5TgZYzZJtszoRdQEm4lPXteueIqAuwETcD8xSUNQFWIxj10VdgOvgVpcHZoArwAMzQEpGd92qjagLsJodu26pMQAMMvQxlW0j0gKsw/F3jrq65Rbt2rQBoIvvT5TtR+juczUCA8yi83935udDXYAZYBFASlAXICWoC5AS1AVICeoCpAR1AVKCugApQV2AlKAuQEpQFyAlqAuQEtQFSAnqAqQEdQFSgroAKUFdgJSgLkBK/gH75l0y7PFowQAAAABJRU5ErkJggg==
在管理员组下面需要再遍历出管理员组拥有的权限名称。

数据库表如下:
这是用户组表
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAW8AAABaCAIAAAD4nkDpAAAOWElEQVR4nO2dT2gc1x3HH8EYWkMDOfjkgw8tRDmUQK8+5lACPqQUCi649BS3pSU1PpXWbqGFFlpkaCCYoJNRcgiOIzmRLLt2/aceS1blP1mvY9eybEteRfaupdWu/u6MPD1sMhm9P7/3m5k3s/t+el8eYvbNm99832/f7zOzK9nDljeLgQKGqTqj/vYGdy6xM75L1SM9JK4jfSMhKMZY9NMphU6Pr4zdDa7d3bh2d2Pvz//SbhdLfrQ9dN0fnghGJvwz/10Kw/BI30j8DXo2V2F7Di0t1ZeW6s3mAtcYY9x2/CcwGO5sNhcajfn551/OVR6yPYdWV1fhVeSUVJqyhOs2zgvxpWo8wCDgvNrgcTma5K3ha8ujd/x2i0MkQslXbcIfGW+GSposLC0tNJvzXGOMAdvxHvEl0Nlszjcaz+efz85VphxN8pABmnA/VbczYrTU9yZawTSJIOJoklqfjq5cKQfxFqHkXMk/V/qKJp9NtD4bS08TKTgcTbpWWWkivWWA7024l0hwFEATBxe8RJq0gdJGCZImUYVHjTHG/eRae8mJh0gjiG1xsfa8VvnyyQNHkzyUjCaql/EbEyBOOpoAtzAqATSJI8PRJLUGrq5cKgVX7nzTLpc3LpWDM7eDwRt+1AbGW6dGl0MFTRqN+UZjfnHxebwxxqKf0sbtEkcCx9brtVq1MjvjaJKLoC9WVeJDCMUvHaw6EAYW0AnsUtEExoejCV4nLq+cvxlcKgWXSsGl8jftzO1guBQMl4JTt4KTE/7J8dbgqPJb2Oh+obBWr1dr1SezM5OOJnkowQXfIok0aaNNrAqOfUUUIgkZoUlU4YW1hYWn1Wczlen7jiZ5aKvQxMmsTlxeOTMRnL8ZXPzcP38zaLdzJX+4FAzd8odu+YM3/JMT/omx9QFP+b1JvV6t158V2Rbm557NPX4yfc/RJA85mjil0UcXl4bH10eu+/+63orayA1/aMIfnPAHJ/yB8daJsfWPR1c/udIIFTSpVWer1Uq1WqlVK7XqbN6tWq08nXv8ZPp/jx7cdjTJQ44mTml0f2Zt2Fs8PdYYGWtG7fRY49TocrsNji4NeM1PrjTuzayEAk2qT2d37j3876vXph/eeTR1+/FUefrhnbzb46nyw8nP738xMXTu3M69h9fW1jq1PqnK0cSpCHE0ma89e/uvx9/87T+Pf/zpnZtXimnlm/8p37g8MDz0w98c/dXf+1utVqfWJ1WRpYlr3dbib9DiYr2xWDvy/snv/eTPbM+hItvOvYd//Y8PVlcbvu93an1SFU2aOHW/VldX19fXW62Wn0obCRUdGARBEAS+77vvTYzL0cTJycmMHE2cnJzMiKdJaXLGNa5ZlBmLrBJotLPtaJJjWjtug5hVAo12th1Nckxrx20Qs0qg0c62lTRJ+pcLnUprx99dYlYJNNrZto8mYRj+9MAHiVrxQOngomEsZIyfr7Szg1YBP9GAjmQv7+Zo4miSMq0df3ej1m00Se3W9taF2TY+O5toUlJ80onA0eWfdKJS4TbiJaTqgSNgRiayml8DpsDNHZMci1r2bKveU2DNiPkEjso+uy6iSbrij9OksJNq06pdCsAbLB2PCQLUZyKruTbkFJDJkcU/JvZwreApm8q2KmOY3OLznGV23UKTNhRS1HYWmqQ+qTatqqUgfdfxY5CdyLXSDTTBdALJEYIfK20GirhtO02A5GjTuCVokp0IxR8LpxW5FBxNMJ1AcjZHPhbxQtyO9xQ8ZVPZxjMCOZJjUPbZdZ4m8e9WU/y6V0sEOKbx72sdTeCWE03ipOB4IcKl4CmbynbG5aEaYHB2HaZJol/TSAsepkn2+KYWjXhZEN9UDCOAIPAheKu5tvzuTUrgZxmq9ybZaeLuTSSHd/m9ifS9lF1jJTefGHBg1g3ean4ti3NpcjYPkN+bxDuJ0YRLCzK3mGSmmF3naVLaMt+bSJdFumbwemJq4h1vWkx08GMOvWxLZ9cVNCltgd/plIxeDRxNrGu0s91dNClR/3uTLmwWWSXQaGe762iSruXxaSV7Wjtug5hVAo12th1Nckxrx20Qs0qg0c62o0mOae24DWJWCTTa2SZCk9LXvwPuuI14Wjtug5hVAo12tunQpKuaRZmxyCqBRjvbjiY5prXjNohZJdBoZ9sATZycnJzSydHEycnJjHiaVHJWfmexMbJxWWSVgGhn29HEssjGBVtljLV/ilINBuIgRwLnwjsRz5jRM+BTNKY6CpNtpLeMWUqaDYwcTSyLbFxImsRfVkDKiCtYW3iqo7iNimy5ixUorSuxB/bMGdDag01GArJdZJaA2QHmtSJOk7Hv77qw++UUkXv37fMY6923Dwjupb0EdZVUVvFrV9UjPUQbQVvh8OqHX+I9AwZU88IUJJBtLprKocEscecCEoIUZZpcfX33xrE/zf/49VO7tiWN7DEW9vaEjPXK8usp+rN7zkPwEoGtYtaudACwCxhZUZcrfrLxyMCx8IxUBhii7IGTItmda5ZUU0gURCqyNBl5n032vVL9xVsP3th99rXt/a+8lDSy9/V/HMCBQ4uS1J7zkLRO4tLSJB5BVTxMgIt0Wxq/ItSS9lzaYoMjaz3DBrj4iaYM0ER1CDyXFFlSvRRzklS502TXW3/ENK3FRLM6ePDDj/rY2oVtF/a+fPHVb519ddtRWZowkb3NQMGgJJ3nPMSteKkAq9HyAtau9BTSytSuWmnNiBRQHQgbE8fAnqVFC58IU5NIduedJdE/cCBeRdBkcvKLdpuauvfo0f3p6alKZXpurlKrPV1YqC0uLpilycGDH3pe+LejL4UeWzrLrv+OSVGCjxwBBYmSFJ5zVTqaxOtHtXbjKxIuA7h0U4xR1QDgUNwAPHMRuGhiQNXpOGlpgs8AZgyQJdEzYBup4miiQkmzuWiQJm2UeF7Y2+sdf4/VT7Pxd1NeKOLyZB95ABGgSfxYoCYxLyu6a6kYHChy8RRJt7WexTKTvhSxJT0wLm22C8gSdwh8ukQqiCYASpaXl0zRJEJJf/9Ub6/X2+vt39+bPXKEEjxQtiBNkDUA98D1XxFKQhyZiCYqzyIUVD1SY6LtSJhsa3uyZyneo42GVxE0gVGyurpihCZJUYKMzN2VIIFCiSaq6xtwiqQ0QQIokY2kloAB+AyI9ckpC01MZYkLZRlNYJSsr68ZpAkeJZjI0g84GKAQoIn0LiOqFriMMTcCqouqaqTqQGlhmMIZUMCADenp2sKwu8gsIc+IVBE0gVHi+63sNDl6YHt//1QilGgjez094T4m/RO1cAvQxCkP0c52ETSBUbKxERihyR9+vy0RSuDIXk8P8NdrFR1QLFo0FlklINrZLoImMEpevHiRkSZHD2x/95fb+97ZcXD/d9780beTTl66y+uBUJIlcrfJIqsERDvbRdAERkkYhhlpwhj7wXe3/eyNHX3v7EgxedVeLUqA2xOLFo1FVgmIdraLoAmMktQ0iX9vlJQjcOTssmjRWGSVgGhnuwiawCjJfm+SWjZGNi6LrBIQ7WwXQZPi/50OUjZGNi6LrBIQ7WznThNTFl3knGSRVQKinW1HE8siG5dFVgmIdrYdTSyLbFwWWSUg2tk2QBMnJyendHI0cXJyMiOeJuWcld9ZbIxsXBZZJSDa2XY0sSyyccFWGWPAy3g/JziUKqz0n7Ti46giqCylCAKHkkaLS7swsmfJSAaAfiCOo4llkY1LZVW6FuM/ucHwS+36FrcxSxl2Alcmvt6A/qR1CywMU1kymAGm5hcwO7I0aT9PJ0Xk6Hk6QHAv1aLpNiWyCqxg5KIUX4pjpKHETtUwMaboWVoP+E5A8HiYJvGNdFlSjReNaScbtwHEEWdHkybx5+kkjRx/no50r7QfE7lgwReTMvpqWVZUbzQSeFmWLU2VJVUtqRa6OEwl2KEYUBsnBX3ghZE9S0jnWvPchnbW8dkRpIn4PJ2kkePP0+H6YZSk9mxcmEUA00S1IY4ESg5WNAYOJcaErcLT14JAVU6YqUlT1JYq26ayZCoDYvIxE8ydJsh/pwNESFGZ0ufppIvsbQYKBiXpPOct1SIwQpPs0lavWBhA8cPbZQQItH7EmBhlXBhJXWXJACY+pyJognmeDhAh6RsgfZ5Olsjc83QwHsjQRHqNkg7QFid+4UqHqTq1h8On06aLFUiT7FlSBUmdAW768IHF0QR+ng4QIVFlSp+nkz2yJ/vIA6jbaKJdAcBR4kpVBQfOAhwlDQLwAt6rWvcF00S1S0sTuCepq9QZ4AAEUCmugmiifZ4OEAFfmdKHYGSPzD1PB+OEGE3Ey5QUMfCVEHmp5M6CLOMsdQXMXZxv3jTJmCXAYdIMiCfSHlsETTDP0wEiICszKUqQkbm7EiRQuoom8NJRWRXrR0oT7vKF9yAuUNgnfHmURrCRJkAPMkvw4bA97tiksy6CJpjn6QAREtEEjxJMZOkHHAxQuocm2nWjXd9iOYmd3C6x5uGrrhhcHAmPl042OhAYA0wcyAbslhsWFybbprKUJQOYc6lmly9NMM/TASJgziI+Twcej4kcPU9H3BVaQpPs69vJrGhnuwiaYJ6no7UIn4V7nk6iyUt3xZ+nIx0AA8WiRWORVQKine0iaIJ5no7WIjCAe55O0slLd0XP08FHQ0buNllklYBoZ7sImmCep6O1CAxgsefppJi8aq8WJcDtiUWLxiKrBEQ720XQBPM8Ha1FsT/+jUBSjsCRs8uiRWORVQKine0iaIJ5no7WosE5Wx3ZuCyySkC0s10ETYr/dzpI2RjZuCyySkC0s507TUxZdJFzkkVWCYh2th1NLItsXBZZJSDa2XY0sSyycVlklYBoZ9sATZycnJzSydHEycnJjBxNnJyczMjRxMnJyYwcTZycnMzo/11XRxBpNIRwAAAAAElFTkSuQmCC

这是用户组权限关系表
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATwAAABNCAIAAAC0bk+BAAAIC0lEQVR4nO2cTYgcRRTHi7AsaMBADp5yyEEh60ECXj3mIIEcIoKwQjwaFSUunkRdBQ8KyiwYkBD2FDY5CIoo6pJLRG0RQQPDKuK6hMhC1CXJ5sPJzsymPQxpOt3Vr15Xva56VXl/HrLp6f5XvVfvNz1flrqZuuYXl3MRJ80vLpcX6PLGP8+9e+rgKx+e+uSLX89/7ydWzn+38su3n3315RMvL7z4/tJwOAzVnxZSoSfQueYXlyW4RXmBNjevXtvcmD/56cNPv6Mef9VnPHjozZc+OD0YXBuNRqH600LpQyvir8FgsLW1NRwOR1babqniwvF4PB6PR6PRYDAIXYMWEmhFosgk0IpEkQmCtr/6l0Ql0q4MVXZpVylICLSutQs+DebZpV2lICHQutYu+DSYZ5d2lYIEX2jbfuMXqnbBl5B5dmlXKUgwhTbP82eOnm4V/rkN2I5K5UpV89UeJM+u7dD+q2RRB6pLaJcAXhqB1r52ngcFwg+0bYfmVqWIlqApmELbb3h5XPDJ/OVxsXiVP8qL2nQEdsCc2Wl2bYc2+mBqAgyKKU5lepjKG9P0sATw0viG1o6xMrTeBjXWrn7c2FV9xJLDJsCTQm0yJyb/LaJ8vP532+yAoTE+wBMTviDG4uAPdrcE9X+WF8ViabxCO2HPAiEXaK0HBcLlXmTRT3DH1IcolrxoiHo3VNqlVXbw0J6rBBSnVpPGgx0tgRFO7XHj0viD1h08/9c2RRTQatuleKjSPa2y4w9t8bfW1s8SFOUFnjcrq4BcGk/Qlj9esvj+xgge7En+kRV/aOGOuRegLT8EHOx6CYDnTe0dmAu0rT4Q1nIFQ+vu3zaQbW3RjvULmxpFe1q5LSr9UekYY2cYs2saGukDAGCsErKMmMtJLmlagqY6lxfFYmnkTksJrbEbKl2rbVP8MzowRLHqXbynNQ6N9IHvVPUqtaoDUGTYx2IUqiWQ97QE1zYF0I6V/nAZhcJB3zR22RFWyTGvWELLpPa0ViX1B23/Hvj0uN/wBG8XoZpboGUbAaDtp/49bRrRNbQSjiX1Da1ddPES1712wafBPLu0qxQkBFrX2gWfBvPs0q5SkBBoXWsXfBrMs0u7SkEiJmj7d77UCT6Ncu2CT4N5dmlXKUhEBi2rSLsyAi3bEGhdaxd8GsyzS7tKQQILrUgkYiiBViSKTBC06x2ru1FidOYgquzSrlIQCbQcnTlIoGUrgZajMwcJtGyVArQ/Prrn3N5dFs692dlMqd7sLGCeKWXhnIAEWraKHtof9u/dPvH25af2f75nqq1zplTem8mV6unIzBqOu8+ZiRRRdlQ+okKYksYK7fJJtbq4+9/nD/95YO/ZR6aXdu9o65zd+T/oKnwaibWeMxMppUhgo/IRFUKW1BXaPYffwoRxHq1ym5s78/GiunVu6tyhXd/su+/svqkFXaoY5+xubjHE2s2ZiSY94Q4blY+oEL6kBNCurv42ibW13y9c+OPixbX19YuXLq1vbPx95crG5uYVWmjn5s5kWf7ewo48UzfOqp9fU1pi8c4Ft0hiLebMTfLymK28QttE7PXrm4TQTojNsrzXy059pK5+rX46TvBxUaZ7nQwo9nYUaNnKH7QAsTdv3qCCtiB2aWmt18t6vezIkZ67c0EsntvY21GgZStP0MLEDgb/kUDbllikc+Uei+Q29nYUaNnKE7QwsVtbtwihxROLcda+KsZwG3s7CrRs5QlamNjRaOgO7cLR6aWltVbEGp2zmZl8Vml/QZELtAJtIHmCFiZ2e3tMAu0br0+1IhZ2zmZmgB9XrJu4TbsdqbJLu0pBRAYtTOzt27cdoV04On38henFYzvnjjxw8Mn722aofSibgYh1cU5AAi1bkUELE5vnuSO0SqnHHpp69sDOxWM7LTJsetRILHCzTbsdBVq2IoMWJtYaWlVSW1xhZ3el3Y4CLVuRQQsT636ntVaMzhwk0LIVGbT+f3uMVIzOHCTQshUNtFTzEGc+EmjZSqDl6MxBAi1bCbQcnTlIoGUrLLQikYihBFqRKDJB0K50rO5GidGZg6iyS7tKQSTQcnTmIIGWrQRajs4cJNCyVQrQTvY9tnAu9j0GzDOlLJwTkEDLVtFDW973uK1zed9j7aPa4xjnKKQosit+Ge7oIyqELGms0Nb3PW7rXN73uHIcJtZ6zkwEt8UKLruyQ5Nb1FXyL3xJXaFF/vYYcLBYWu2+x3bO2d3cYoi1mzMTTbqB5E5b8XT3ERXqHFrMvseAQ9ul1e577OJc2fcYM4fY21GgZS5P0ML7HgMOrZZWu++xu3Ome50MKPZ2JIRW3tOSq/P3tMh9jwEH/NJqd1F1d67se4yZSeztKNBylg9oMfseAw7IpW1LLNK5co9Fcht7O1JBS/syW7SCKykBtJh9j43zMCZT3/fYeInRWfuqGMNt7O1I9ZUPfELsVfIvZEkJoMXse2ycBzxKfd9j+HyMc7Hvcf2hPPV2JPnKpyxrH1EhfEkJoMXseww4IKEt73sMn4xxLu97rD0B5jbtdqTKLu0qBREZtJh9j43zAE6o7HvcNkPtQ8W+x3g3pHMCEmjZigxazL7HxnkAJ5T3PbbIsOlRI7HAzTbtdhRo2YoMWsy+x8Z51I9X9j22ztDiwoDOHCTQshUZtJh9j43zIEwsamcOEmjZigxa/789RipGZw4SaNmKBlqqeYgzHwm0bCXQcnTmIIGWrQRajs4cJNCyFRZakUjEUAKtSBSZ/gcYwNgwZ6aCKAAAAABJRU5ErkJggg==

这是权限表
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcwAAABHCAIAAAAFueB+AAALa0lEQVR4nO2dz4scRRTHizAs6EICOe9hDx4yHiTgv5CT4GHF0wjxunoKewwK8ehp9hCQIHuSNQePXpS9rJcWEbwsQcR1kciAYjAGMyYx7raHMWPbXfXq1Y+e/lbV+1KESXfP6/d99fozPbW7M2o+n8/n86Pjn2S0hlRGSpqQBdjEijU4fyaVXOorrtHgaeQ0MigprAXYxIo1KJDl1mjwNHIaGZQU1gJsYsUaHB6ytaOGqtHgU5XTyKCksBZgEyvW4MCQrev6je2PncbqObv6yihVK+VmM9ZTPOIkUdJVWlhBAWFrO2DzRGndPvpfIOs/qVkOgWyghdUUELO2wzaPQNY4tGsCS54iLxcs56M5MYvHnC3NXdogpqfTMTlnND3lCOY64fs11dBUul4tcGa/72rHqq1rRzG9r8Bg99R0/U0XRdyE+4KsHxObkF3ZSb0nVdtq3enUTq01CB+UnL3Ws5guCaVuaf+r1K3W6B7feq5fSbv15NewOyl0bloXrhaWj02Zc6rdLGlzb6vaPdXW5Mij5tb6mxrGo3m0p9Y6sl5c2pq3+pyYiFbCvUB2wUoP5IVA1vuk1hoRk0pMEp+S2gO01yGx0emMTB51O6x7bWi3Ey3oVNKWa9caak11rTU3tix4d4VT5q0ETMP6GhC3tn4dZepSwmbE5mF2OxOyBFKdWiU+ZMNBufrnmsaAkD1qNCtxVViDh0D2qNNM2u1HnXZsbfQuqVPOrQO01Wsl373alxsJ3jEh61dt4iUtOmTpDE2V5Dc/gVrTnWxg89AJMw8z9YOWs9pGaiUcGbLNH2d5/D6WFZR0zOg/IhsWss1dxMa+IWu66SPeRrW6MEpJQ2qoHdr3410XgRb41SYQb73F66O25pbg1pzgrMlmFMha91p9aSvf7RDtpdFNOCZknX5hQMtBGrLh8V1HT2uynANiEZP5FAPKjU1vIgIaZIlXjq6LiMsFnLKbqm26pE0lDW/X8B62etdlpV90DmkeOg1+27RywFouKO1Olu6n5dRa+48IqO17azN5YMjEo9a/re2m5jN1nh+htJhgPks7s6b3fdoDmBasmTOrbTp7+HIB0Utm0Dj3ML/+/TWPySnTVzMlOlXOjMiaLDWYq28ZD9M6VPewwJIOZY2febiF7kXulK13YlDt2q05fvO0YNpl66ohe1TYbxfIiFLShEaIBestXh+JZdOuyTVPj5A9yv33ZGWUXFJYC7CJFWuwX8j6jT7e8ofXaPA0choZlBTWAmxixRoUyHJrNHgaOY0MSgprATaxYg0KZLk1GjyNnEYGJYW1AJtYsQYRIXv07Je0Bk+jWaPB08hpZFBSWAuwiRVrEBSyUEMqIyVNyAJsYsUaFMhyazR4GjmNDEoKawE2sWINtiErEolEoj4kkBWJRKIe9S9kZz2rv7OkGLlYZVBSWAuwicVScgYFskNGLlZESZVS3cfNjc292u3aw5qynpcj2K6ATSyWkjMokB0ycrGiS9plK0FAehcTna6EnQF3BWxisZScwZQg+9VLG4ebFzwiTyeTSqnpZEIEr8yXWXKTii9rSbu3nyZi+vHXdBiftrBdAZtYLCVnMBnIfnl58/TWe7+9fvnTjZFr5EqpejqulZrqLqHKsD0855JF04pZ0ih3sjSsu09ncha2K2ATY4pe1ZnhGWQmjA7Zzz9Ux3sXf31r64crmwcvru1fPOcauXr20XItnloJ651zybK+TzeV1ERAeiHVe5mVQ2FXC4MLNjGOOO8qoAzyE+ZCdmPrBmcQETwKtLNz+5M99fhwdPjqhS8uPXdwabSrM8OJXP2fsxzC+uVcsmjwLUSUdPl0DvsCIRsi2K6ATYyj5CDbVDTIHh9/uxgnJ9/9+OP3d++ezGZ3f/55du/eL/fv33vw4H5cyO7s3K6q+v3dc3WlHh6ob64rLWH5kZecZRLWI2fRLBiyrcfW1VjiAJrUfrextIVhBZsYRwLZ/yBrIuwffzyICNkFYauqnk6rjz5Qv3+mvr4ZYaWm0q0bEIKdVGRBQZZIzHR3bBVsV8AmxlG6kCXaxgeyBGHn84exILsk7P7+yXRaTafV1avT8MhLwvI5izmp4AqHLH29WbeYAC2QRZZAdraxdYMm7KNHf0aBrCthmZFb97BMzmJOKrj8INt8g09E4yzCNiFLLxc4ZW61MLhgE+MoUchyut0BsjRhnzx5HBGyfMJyImtXCTicBZxUfIVAdkb+4IuO3D3GymtZk8VRipC1NowzZGnCPn36Vzhkd7fX9vdPnAhrjVyNx/VEaf/ioBbI9iDv5YJUBGsBNjGmrC91UAY5L8/OkKUJe3r6dxTIvvvOyImwdORqPCb+GGFm4yzUpOahDEoKawE2sVhKzqAzZGnCnp2dBUJ2d3vt5ttre9fWd66ef+W1512daHdVY4qwIZFFfsqgpLAWYBOLpeQMOkOWJmxd14GQVUq9/MLozSvre9fWPZyY9loJS9zMJjep+MqgpLAWYBOLpeQMOkOWJqw3ZJvrGq54pSOHK7lJxVcGJYW1AJtYLCVn0BmyNGHD72S9lWLkYpVBSWEtwCYWS8kZdIbs6j+7gKkUIxerDEoKawE2sVhKzqAbZGOdTyIXrgxKCmsBNrFYSs6gQHbIyMUqg5LCWoBNLJaSMyiQHTJyscqgpLAWYBOLpeQMtiErEolEoj4kkBWJRKIe9S9k7/Ss/s6SYuRilUFJYS3AJhZLyRkUyA4ZuVhZS6qU0j6mj/Q7pvspXNaAd4C7AjaxWErOoEB2yMjFKgSypk9BbCKScwwRP4qFoQSbWCwlZzAlyH710sbh5gWPyNPJpFJqOpkQwSvzpZXcpOKLLmkXc0zw0dFMQQSyaSk5g8lA9svLm6e33vvt9cufboxcI1dKLT/qULtXu50TWaSV9X13OGQ596ec21jtkRyPsF0BmxhTgc2zejETRofs5x+q472Lv7619cOVzYMX1/YvnnONvPhahC5nrYT1zrlYKcZyKlFS7/tN0wGtB/wn0oLtCtjEOApsntWLnzAXsszPLiAieBRoZ+f2J3vq8eHo8NULX1x67uDSaFdnhhO5+j9nOYT1y1m0kOt1suSg9u6yiUvrXaoWqfwbVatguwI2MY6Sg2xT0SC7+Epw4jtr40J28WVf7++eqyv18EB9c11pCcuPvOQsk7AeOYuWCrlOONcbcUATzVpSa3fxFw1guwI2MY4Esv9BlvjO2oiQXX5n7XRaffSB+v0z9fXNCCs1lW7dgBDspIIrcFmNCVkTEDnLBZxdJsF2BWxiHKULWWu3u0GW/lbwWJDVfit4eOQlYfmcxZxUfIVAllgnJdYKmsAVyKYogeydja0bNGEfPfozCmRdCcuM3LqHZXIWc1LBRUOKLqn2vb/riZoAleWCVJQoZDnd7gBZmrBPnjyOCFk+YTmRtasEHM4CTiq4vAnVohvNO+teTvzmA7mTHVwpQpbZKg6QpQn79Olf4ZDd3V7b3z9xIqw1cjUe1xOl/YuDOtnLCVOc+8EMSgprATYxpqzvJKAM8rvdAbI0YU9P/44C2XffGTkRlo5cjcfEHyPcsXEWalLzUAYlhbUAm1gsJWfQGbI0Yc/OzgIhu7u9dvPttb1r6ztXz7/y2vOuTrS7qjFF2JDIIj9lUFJYC7CJxVJyBp0hSxN28W211vMRByilXn5h9OaV9b1r6x5OTHuthCVuZpObVHxlUFJYC7CJxVJyBp0hSxPWG7LNdQ1XvNKRw5XcpOIrg5LCWoBNLJaSM+gMWZqw4Xey3koxcrHKoKSwFmATi6XkDDpDdvWfXcBUipGLVQYlhbUAm1gsJWfQDbKxzieRC1cGJYW1AJtYLCVnUCA7ZORilUFJYS3AJhZLyRkUyA4ZuVhlUFJYC7CJxVJyBtuQFYlEIlEf+gdcqQpvmUhPUwAAAABJRU5ErkJggg==

根据表的信息,在前台遍历出来的结果应该是:

管理员组
   进入后台
   分享商品
普通用户组

在控制器中和视图中都该如何遍历才能显示出来?



liya22315 发表于 2012-10-15 18:42:18

在控制器中写aql语句到数据库查询,对结果集进行排列,生成需要的数组,在分配到视图中显示。。。

大道达人 发表于 2012-10-16 09:42:51


//遍历groups
       $data = array();
       $groups = $this->db->get('用户组')->result_array();
       foreach ($groups as $group) {
         //获取组权限
         $groupPre = $this->db->select('permissionid')->where(array('groupid' => $value['groupid']))->get('用户组权限关系')->result_array();
$data[$value['name']] = array();
          foreach($groupPreas $pre)
         $data[$value['name']][] = $this->db->select('name')->get_where('权限',array('permissionid' => $pre->permissionid))->first_row->name;
       }   

继续、驕傲 发表于 2012-10-16 10:03:09

大道达人 发表于 2012-10-16 09:42 static/image/common/back.gif


你好, 我没太理解了代码意思,代码里面的$value['groupid']应该是$group['groupid']吧, $data[$value['name']]这个没有太理解。
下面一行的$pre->permissionid这个对象的访问方式,
没想出来啊,求指教。

大道达人 发表于 2012-10-16 11:20:54

继续、驕傲 发表于 2012-10-16 10:03 static/image/common/back.gif
你好, 我没太理解了代码意思,代码里面的$value['groupid']应该是$group['groupid']吧, $data[$value[' ...


$value改成$group
直接放在你的controller
然后
print_r($data);你就知道返回结果了
页: [1]
查看完整版本: CI 如何遍历列表