SoFunction
Updated on 2025-04-04

The program instance code that traverses the region table of echsop to form cache

The program instance code that traverses the region table of echsop to form cache

Updated: November 1, 2016 10:44:23 Submission: jingxian
Below, the editor will bring you a program example code that traverses the region table of echsop to form cache. The editor thinks it is quite good, so I will share it with you now and give you a reference. Let's take a look with the editor

As shown below:

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_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_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);
?>

The above is the entire content of the program instance code that I have brought to you to traverse the region table of echsop to form cache. I hope everyone supports me more~

  • Traversal
  • echsop
  • region

Related Articles

  • Detailed explanation of the introduction to the observer mode and application cases of PHP design mode

    This article mainly introduces the introduction and application of the observer mode of PHP design mode. It analyzes the relevant concepts, principles, usage methods and operation precautions of the PHP observer mode in detail based on specific case forms. Friends who need it can refer to it.
    2019-12-12

  • Implementation of ecshop adaptation to solve errors in PHP7

    Below, the editor will bring you an implementation of ecshop adapted to PHP7 modification method to solve errors. The editor thinks it is quite good, so I will share it with you now and give you a reference. Let's take a look with the editor
    2016-11-11

  • PHP+MYSQL implements user addition, deletion, modification and search

    This article will share with you all the page codes for using PHP+MYSQL to implement the user's addition, deletion, modification and search function. They are very detailed and practical. They are suitable for beginners of PHP and those who need it are for reference.
    2015-03-03

  • Detailed introduction and code examples of Observer mode in PHP design mode

    This article mainly introduces the detailed introduction and code examples of the PHP design pattern and the Observer pattern. Friends who need it can refer to it.
    2014-04-04

  • Analysis of PHP Concurrent Locking Problem and Explanation of Design Code Examples

    This article mainly introduces the analysis of PHP concurrent locking problem and the explanation of the code design examples. Interested students can follow the research and study.
    2021-02-02

  • Example of PHP regular extraction of image addresses that do not contain the specified URL

    Today, when I was doing picture extraction, I encountered this situation. I extracted a picture from an article as the cover of the article, so that the picture and text mode will look more comfortable when typing.
    2014-04-04

  • Example explanation of whether the PHP mailbox is qualified

    In this article, we have shared with you the relevant examples about whether the PHP email is qualified. Friends who are interested can learn it.
    2019-01-01

  • Example analysis of basic usage of Laravel5.1 framework controller

    This article mainly introduces the basic usage of Laravel5.1 framework controller, and analyzes the basic principles, definitions and usage methods of laravel5.1 framework controller in combination with examples. Friends who need it can refer to it.
    2020-01-01

  • A brief discussion on the magic method in object-oriented OOP in PHP

    This article mainly introduces a brief discussion of the magic method in object-oriented OOP in PHP, which has certain reference value. Interested friends can refer to it.
    2017-06-06

  • Website directory scanning index tool implemented by PHP

    This article shares with you the source code of a website directory scanning index tool based on PHP. It is very simple and practical. Friends in need can refer to it.
    2016-09-09

Latest Comments