Home  >  Article  >  Backend Development  >  数组处理的有关问题

数组处理的有关问题

WBOY
WBOYOriginal
2016-06-13 12:18:201142browse

数组处理的问题

这样一个一维数组,怎么把他弄成依次按照店铺名、颜色、尺码规格的一个多维数组?
------解决思路----------------------
在封装MySQL类里面写个getAll函数 和query函数
public function getAll($sql)
{
    $rs =$this->query($sql);
   $list =array();
     if(!$rs)
      {
         return false;
       }
     else{
         while($row  = mysql_fetch_assoc($rs))
               {
                 $list[]=$row;
}
     return $list;
}
}

public function query($sql)
{
   return mysql_query($sql,$this->conn) ;       //$this->conn是连接数据库的资源变量
}
在类的外面初始化一个对象,然后写三个sql语句获取三个列,把sql语句通过getAll函数发出去获得结果,最后查询结果自己再写个数组放进去。。。封装类的内容太多就不写了,不知道能不能帮到楼主- -
------解决思路----------------------

<br />$array=array(<br />	array('CKMC'=>'store1','GG1MC'=>'color1','GG2MC'=>'size1'),<br />	array('CKMC'=>'store1','GG1MC'=>'color1','GG2MC'=>'size2'),<br />	array('CKMC'=>'store1','GG1MC'=>'color2','GG2MC'=>'size1'),<br />	array('CKMC'=>'store1','GG1MC'=>'color2','GG2MC'=>'size2'),<br />	array('CKMC'=>'store2','GG1MC'=>'color1','GG2MC'=>'size1'),<br />	array('CKMC'=>'store2','GG1MC'=>'color2','GG2MC'=>'size2'),<br />);<br /><br />$array2=array();<br />foreach($array as $val)<br />{<br />	if(array_key_exists($val['CKMC'],$array2))<br />	{<br />		if(array_key_exists($val['GG1MC'],$array2[$val['CKMC']]))<br />		{<br />			$array2[$val['CKMC']][$val['GG1MC']][]=$val;<br />		}<br />		else $array2[$val['CKMC']][$val['GG1MC']]=array($val);<br />	}<br />	else $array2[$val['CKMC']]=array($val['GG1MC']=>array($val));<br />}<br />echo '<pre class="brush:php;toolbar:false">';<br />print_r($array2);<br />echo '
';

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn