php 多维数组插入mysql_PHP – 重新格式化多维数组以插入MYSQL？

最新推荐文章于 2021-04-06 17:28:58 发布

TraceYang

最新推荐文章于 2021-04-06 17:28:58 发布

阅读量144

点赞数

文章标签： php 多维数组插入mysql

本文链接：https://blog.csdn.net/weixin_30431137/article/details/113345694

版权

我该如何解析php数组：

$cars= array(

"Ford"=>array("C-Max"=>array("length"=>"4333","width"=>"1825","height"=>"1560"),"Escape"=>array("length"=>"4480","width"=>"1845","height"=>"1730")

,"Explorer"=>array("length"=>"4912","width"=>"1872","height"=>"1849"),"Fiesta"=>array("length"=>"3950","width"=>"1973","height"=>"1433")

,"Focus"=>array("length"=>"4488","width"=>"1840","height"=>"1497"),"Fusion"=>array("length"=>"4013","width"=>"1724","height"=>"1543")

,"Galaxy"=>array("length"=>"4820","width"=>"1854","height"=>"1723"),"Kuga"=>array("length"=>"4443","width"=>"1842","height"=>"1677")

,"Mondeo"=>array("length"=>"4844","width"=>"1886","height"=>"1500"),"Ranger"=>array("length"=>"5075","width"=>"1805","height"=>"1745")

,"S-Max"=>array("length"=>"4768","width"=>"1854","height"=>"1658"),

"Hummer"=>array("H2"=>array("length"=>"5170","width"=>"2063","height"=>"2012"),"H3"=>array("length"=>"4782","width"=>"1989","height"=>"1872")));

像这样插入MySQL表：

CREATE TABLE IF NOT EXISTS `cars_dimensions` (

`id` int(10) NOT NULL auto_increment,

`brand` varchar(120) character set utf8 NOT NULL,

`model` varchar(120) character set utf8 NOT NULL,

`length` varchar(5) character set utf8 NOT NULL,

`width` varchar(5) character set utf8 NOT NULL,

`height` varchar(5) character set utf8 NOT NULL,

KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

当我使用foreach并且喜欢$cars [“Hummer”] [“H2”] [“length”];我不知道能不能获得另一个数组维度并同时缓存实际品牌/型号……那么,我的实际阵列在第一维(品牌)中约有3000个项目.

关注