Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 数组处理的问题

数组处理的问题

WBOY
Release： 2016-06-20 12:58:10
Original
862 people have browsed it

这样一个一维数组，怎么把他弄成依次按照店铺名、颜色、尺码规格的一个多维数组？


回复讨论(解决方案)

在封装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函数发出去获得结果，最后查询结果自己再写个数组放进去。。。封装类的内容太多就不写了，不知道能不能帮到楼主- - 

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

Related labels：
数组处理的问题
source：php.cn
Previous article：PHP 的 empty()，isset() 还有 is_null() 这三个函数的用法讨论得已经很多了 Next article：php中为什么在trycatch块中定义的变量在块外也可以使用？
Statement of this Website
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
Latest Articles by Author
Latest Issues
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
Compare Imagick, Adobe Photoshop and Windows - Detect resolution (pixels per centimeter or pixels per inch) This is not a question but an attempt to improve my understanding of how DPI is stored in ...
From 2024-04-06 16:01:27
0
1
397
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
React Three Fiber: Why are my scroll events lagging? In ReactThreeFiber, I have a React component that generates a sprite that I want to persis...
From 2024-04-06 13:39:24
0
1
410
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template