PHP程序循环迭代中谨慎操作数据库

/**
 * 递归获取分类
 * @author：xxx
 * @param $tree_id
 */
function get_child_tree($tree_id = 0)
{
    $three_arr = array();
         
    $sql = “SELECT count(*) FROM TABLE WHERE parent_id = “$tree_id” AND is_show = 1 ";
    if ($GLOBALS[db]->getOne($sql) || $tree_id == 0)
    {
        $child_sql = "SELECT ……";
        $res = $GLOBALS[db]->getAll($child_sql);
        foreach ($res AS $row)
        {
            if ($row[is_show])
            {
                $arr[id] = $row[cat_id];
                ……
            }
 
            if ( intval($row[cat_id]) != 0) {
            $three_arr[$row[cat_id]][cat_id] = get_child_tree($row[cat_id]);
            ……
            }
        }
    }
    return $three_arr;
}

<?php
$json = '{"a":1,"b":2,"c":3,"d":4,"e":5}';
var_dump(json_decode($json));
var_dump(json_decode($json, true));
?>

上例将输出：

object(stdClass)#1 (5) {
["a"] => int(1)
["b"] => int(2)
["c"] => int(3)
["d"] => int(4)
["e"] => int(5)
}

array(5) {
["a"] => int(1)
["b"] => int(2)
["c"] => int(3)
["d"] => int(4)
["e"] => int(5)
}

$data='[{"Name":"a1","Number":"123","Contno":"000","QQNo":""},{"Name":"a1","Number":"123","Contno":"000","QQNo":""},{"Name":"a1","Number":"123","Contno":"000","QQNo":""}]';
echo json_decode($data);

结果为：

Array ( [0] => stdClass Object ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) [1] => stdClass Object ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) [2] => stdClass Object ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) )

echo json_decode($data,true);

结果：

Array ( [0] => Array ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) [1] => Array ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) [2] => Array ( [Name] => a1 [Number] => 123 [Contno] => 000 [QQNo] => ) )

{
 "from":"zh",
 "to":"en",
 "trans_result":[
  {
   "src":"u4f60u597d",
   "dst":"Hello"
  }
 ]
}

Array
(
    [from] => zh
    [to] => en
    [trans_result] => Array
        (
            [0] => Array
                (
                    [src] => 你好
                    [dst] => Hello
                )

        )

)

<?php
$data = <<<STR
{
 "from":"zh",
 "to":"en",
 "trans_result":[
  {
   "src":"u4f60u597d",
   "dst":"Hello"
  }
 ]
}
STR;
$jsondata=json_decode($data,true);
header("Content-Type: text/html; charset=UTF-8");
print_r($jsondata);www.111cn.net
echo "<br />".$jsondata['to']; //en
echo "<br />".$jsondata['trans_result'][0]['dst']; //Hello
?>

stdClass Object
(
    [from] => zh
    [to] => en
    [trans_result] => Array
        (
            [0] => stdClass Object
                (
                    [src] => 你好
                    [dst] => Hello
                )

        )

)

<?php
$data = <<<STR
{
 "from":"zh",
 "to":"en",
 "trans_result":[
  {
   "src":"u4f60u597d",
   "dst":"Hello"
  }
 ]
}

STR;
$jsondata=json_decode($data);
header("Content-Type: text/html; charset=UTF-8");
print_r($jsondata);
echo "<br />".$jsondata->from; //zh
echo "<br />".$jsondata->trans_result[0]->src; //你好
?>

<form action=www.111cn.net method="post">

 <p>请输入ip地址：<input type="text" name="ip" /></p>

 <p><input type="submit" value="查询"  /></p>

</form>

<?php

 //获取ip地址

 //$ip = $_SERVER['REMOTE_ADDR'];    //自动获取客户端的IP

 //ip对应的地区

 if(!empty($_POST['ip'])){

  $ip = $_POST['ip'];

  //接口地址,这样返回的是一个xml结果集，

  $str = file_get_contents("http://www.yodao.com/smartresult-xml/search.s?type=ip&q=".$ip);

  //这里要得到里面的地址信息，提取xml方法有很多，我用的是正则。

  preg_match_all( "/<location>(.*?)</location>/",$str,$addr1);

  //最终结果，如图2;

  $addr = $ip."=>".$addr1[1][0];

  echo $addr;

 }

?>

$qqwry=new qqwry('QQWry.Dat');

list($addr1,$addr2)=$qqwry->q('127.0.0.1');
$addr1=iconv('GB2312','UTF-8',$addr1);
$addr2=iconv('GB2312','UTF-8',$addr2);
echo $addr1,'|',$addr2," ";

$arr=$qqwry->q('222.216.47.4');
$arr[0]=iconv('GB2312','UTF-8',$arr[0]);
$arr[1]=iconv('GB2312','UTF-8',$arr[1]);
echo $arr[0],'|',$arr[1]," ";

$arr=$qqwry->q('64.233.187.99');
$arr[0]=iconv('GB2312','UTF-8',$arr[0]);
$arr[1]=iconv('GB2312','UTF-8',$arr[1]);
echo $arr[0],'|',$arr[1]," ";

 <form action="post.php" method="post">
<input type="text" name="user">
<input type="password" name="password">
<input type="submit">
</form>

 <? echo file_get_contents("php://input");?>

<form action="welcome.php" method="post">
Enter your name: <input type="text" name="name" />
Enter your age: <input type="text" name="age" />
<input type="submit" />
</form>

修改
CG(extended_info) = 1;
为
CG(compiler_options) |= ZEND_COMPILE_EXTENDED_INFO;