遍历echsop的region表形成缓存的程序实例代码_ECSHOP

遍历echsop的region表形成缓存的程序实例代码

2021-03-17 16:38ECSHOP教程网 ECSHOP

下面小编就为大家带来一篇遍历echsop的region表形成缓存的程序实例代码。小编觉得挺不错的，现在就分享给大家，也给大家做个参考。一起跟随小编过来看看吧

如下所示：

									header("Content-type: text/html; charset=utf-8"); 

									$con = mysql_connect("localhost","root","root");

									if (!$con)

									{

									die('Could not connect: ' . mysql_error());

									}

									mysql_select_db("ecshop", $con);

									$result = mysql_query("SELECT * FROM ecs_region where region_type=1");

									$data=array();

									while($row = mysql_fetch_array($result))

									{

									$data1=array();

									$data1["itemName"]=$row["region_name"];

									$data1["itemCode"]=$row["region_id"];

									$data1["list"]=array();

									$data[]=$data1;

									unset($data1);

									}

									foreach ($data as $key => $value) {

									$result1 = mysql_query("SELECT * FROM ecs_region where parent_id=".$value["itemCode"]);

									while($row1 = mysql_fetch_array($result1))

									{

									$data1=array();

									$data1["itemName"]=$row1["region_name"];

									$data1["itemCode"]=$row1["region_id"];

									$data1["list"]=array();

									$result2 = mysql_query("SELECT * FROM ecs_region where parent_id=".$row1["region_id"]);

									while($row2 = mysql_fetch_array($result2))

									{

									$data2=array();

									$data2["itemName"]=$row2["region_name"];

									$data2["itemCode"]=$row2["region_id"];

									$data2["list"]=array();

									$data2["list"]=$data2["list"];

									$data1["list"][]=$data2;

									unset($data2);

									}

									//$data[$key]["list"][]=json_encode($data1);

									$data[$key]["list"][]=$data1;

									unset($data1);

									}

									}

									// foreach ($data as $key => $value) {

									// $data[$key]["list"]=json_encode($data[$key]["list"]);

									// }

									put_content(json_encode($data));

									function put_content($levelconfig) {

									$message="<?php \n";

									$message.="\$address_config = '";

									$message .= $levelconfig;

									$message .="';";

									$message.="\n?> ";

									$fold = "address_config.php";

									$stderr = fopen($fold, 'w+');

									fwrite($stderr, $message);

									fclose($stderr);

									}

									mysql_close($con);

									?>