21,887
社区成员
发帖
与我相关
我的任务
分享
// 查询变量
$sql1 = "select remark,name from arp_careset where typegroup ='dissect-position' order by id";
$rs1 = mysql_query($sql1);
while($r1 = mysql_fetch_assoc($rs1))
{ echo $r1['name'];
$sql = "select group_concat(name) as name from arp_careset where typegroup <>'dissect-position' and typegroup like '%".$r1["remark"]."%' order by id";
$rs = mysql_query($sql);
while($r = mysql_fetch_array($rs))
{ $ar = explode(',', $r['name']);
echo join(' ', $ar);
} }
//构建数组
$mem = array(
array
(
lang_show(''),
array
(
// 嵌套开始
array(
lang_show('account_manager'),
//第二层嵌套
array(
'group_list.php,1',
)
//第二层嵌套结束
),
// 嵌套结束
)
),
);
//第二层嵌套 array( '营养状况,6', '分泌物,7', '被毛,8', '皮肤,9', '眼/眼眶,10', '四肢/尾巴,11', '乳腺,12', '外生殖器,13', '肛门,14', ) //第二层嵌套结束
$mem = array(
array
(
lang_show(''),
array
(
// 嵌套开始
array(
'体表',
//第二层嵌套
array(
'营养状况',
'分泌物',
'被毛',
'皮肤',
'眼/眼眶',
'四肢/尾巴',
'乳腺',
'外生殖器',
'肛门',
)
//第二层嵌套结束
),
// 嵌套结束
// 嵌套开始
array(
'淋巴结',
//第二层嵌套
array(
'腋窝淋巴结',
'颈部淋巴结',
'腹股沟淋巴结',
'肺部淋巴结',
'肠系淋巴结',
)
//第二层嵌套结束
),
// 嵌套结束
)
),
);
$rs = mysql_query("select name, SUBSTRING_INDEX(typegroup,'-',-1) as secondary, remark from arp_careset where SUBSTRING_INDEX(typegroup,'-',1)='dissect'");
while($r = mysql_fetch_assoc($rs)) {
echo $r['name']. '<br />';
$rs1 = mysql_query("select name, SUBSTRING_INDEX(typegroup,'-',-1) as secondary, remark from arp_careset where SUBSTRING_INDEX(typegroup,'-',1)='$r[secondary]' and SUBSTRING_INDEX(typegroup,'-',-1) = '$r[remark]'");
while($r = mysql_fetch_assoc($rs1)) {
echo $r['name'] . ' ';
}
echo '<br />';
}
体表
营养状况 分泌物 被毛 皮肤 眼/眼眶 四肢/尾巴 乳腺 外生殖器 肛门
淋巴结
腋窝淋巴结 颈部淋巴结 腹股沟淋巴结 肺部淋巴结 肠系淋巴结
头颈部
眼睑/角膜/瞳孔 牙齿/牙龈 耳 鼻 脑膜/全脑 颅骨 唾液腺 食管 气管 甲状腺
胸部
胸壁 横膈/纵膈 心脏 主动脉弓 肺及支气管
腹部
腹腔 肠系膜 脾脏 胰 肾脏
$res = array(); //这是结果数组
$rs = mysql_query("select name, SUBSTRING_INDEX(typegroup,'-',-1) as secondary, remark from arp_careset where SUBSTRING_INDEX(typegroup,'-',1)='dissect'");
while($r = mysql_fetch_assoc($rs)) {
$tmp = array(); //初始化一个临时数组
$rs1 = mysql_query("select name, SUBSTRING_INDEX(typegroup,'-',-1) as secondary, remark from arp_careset where SUBSTRING_INDEX(typegroup,'-',1)='$r[secondary]' and SUBSTRING_INDEX(typegroup,'-',-1) = '$r[remark]'");
while($r1 = mysql_fetch_assoc($rs1)) {
$tmp[] = $r1['name']; //将数据加入临时数组
}
$res[] = $tmp; //将临时数组归入结果数组
}
每处存放什么内容,自己决定