SQL文の最適化
- WBOYオリジナル
- 2016-06-20 12:26:421030ブラウズ
$searchlist = array( array("id" => 3, "id2" => 16, "flat" => 1), array("id" => 5, "id2" => 6, "flat" => 1), array("id" => 2, "id2" => 3, "flat" => 2), array("id" => 9, "id2" => 1, "flat" => 2), array("id" => 6, "id2" => 4, "flat" => 1),);$searchresult = "";foreach($searchlist as $k=>$v){ if($v['flat'] == 1){ $sql = sprintf("select insurance_entitle1 as title1 from %s_insurance where insurance_id = %d", $this->tablepre, $v['id']); $result = $this->db->get_one($sql); $searchresult[$k]['title1'] = isset($result['title1']) ? $result['title1'] : ""; $sql = sprintf("select insurance_encontent as content from %s_insurance_section where insurancese_section=%d order by insurancese_order", $this->tablepre, $v['id']); $result = $this->db->get_one($sql); $searchresult[$k]['content'] = isset($result['content']) ? $result['content'] : ""; $searchresult[$k]['flat'] = $v['flat']; $searchresult[$k]['id'] = $v['id']; }elseif($v['flat'] == 2){ $sql = sprintf("select insurance_entitle1 as title1 from %s_insurance where insurance_id = %d", $this->tablepre, $v['id2']); $result = $this->db->get_one($sql); $searchresult[$k]['title1'] = isset($result['title1']) ? $result['title1'] : ""; $sql = sprintf("select insurance_encontent as content from %s_insurance_section where insurancese_id=%d order by insurancese_order", $this->tablepre, $v['id']); $result = $this->db->get_one($sql); $searchresult[$k]['content'] = isset($result['content']) ? $result['content'] : ""; $searchresult[$k]['flat'] = $v['flat']; $searchresult[$k]['id'] = $v['id']; $searchresult[$k]['sid'] = $v['id2']; }}
ディスカッションへの返信 (解決策)
SQL なし、php のみ
声明：
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。