php中操作json格式数据转换实现代码

<?php

       require_once 'sqlTools.class.php';//封装类，可执行dql、dml语句

       $info=$_POST['info'];

       $sql="select name,password,email from user_500 where name like '%$info%' or password like '%$info%' or email like '%$info%'";

       $sqlTools=new  SqlTools();

       $res=$sqlTools->execute_dql($sql);

       while ($row=mysql_fetch_assoc($res)){

              $row['name']=preg_replace("/($info)/i","<b style="color:red">\1</b>",$row['name']);

              $row['password']=preg_replace("/($info)/i","<b style="color:red">\1</b>",$row['password']);

              $row['email']=preg_replace("/($info)/i","<b style="color:red">\1</b>",$row['email']);

              echo $row['name']."-->".$row['password']."-->".$row['email']."<br>";

       }   

?>

sqlTools.class.php的源代码：

<?php

       class SqlTools{

              private $host="localhost";

              private $dbname="test";

              private $dbuser="root";

              private $dbpwd="";

              private $conn;

              public function __construct(){

                     $this->conn=mysql_connect($this->host,$this->dbuser,$this->dbpwd);

                     if(!$this->conn){

                            die("连接数据库失败".mysql_error());

                     }

                     mysql_select_db($this->dbname,$this->conn) or die("找不到该数据库".mysql_error());

                     mysql_query("set names utf8");

              }

              public function execute_dml($sql){

                     $bool=mysql_query($sql);

                     if ($bool){

                            if ($bool>0) {

                                   return 1;

                            }else{

                                   return 2;

                            }

                     }else {

                            return 0;

                     }

              }

              public function execute_dql($sql){

                     $res=mysql_query($sql);

                     return $res;

              }

              public function close_conn(){

                     mysql_close($this->conn);

              }

       }

?>

<?php
ignore_user_abort();//关掉浏览器，PHP脚本也可以继续执行.
set_time_limit(3000);// 通过set_time_limit(0)可以让程序无限制的执行下去
$interval=5;// 每隔5s运行

//方法1--死循环
do{
 echo '测试'.time().'<br/>'; 
 sleep($interval);// 等待5s 
}while(true);

//方法2---sleep 定时执行
 require_once './curlClass.php';//引入文件
 
 $curl = new httpCurl();//实例化
 $stime = $curl->getmicrotime();
 for($i=0;$i<=10;$i++){
  
  echo '测试'.time().'<br/>'; 
  sleep($interval);// 等待5s
  
 }
 ob_flush();
 flush();
 $etime = $curl->getmicrotime();
 echo '<hr>';
 echo round(($etime-stime),4);//程序执行时间

function get_client_ip( )
{
        if ( getenv( "REMOTE_ADDR" ) && strcasecmp( getenv( "REMOTE_ADDR" ), "unknown" ) )
        {
                $onlineip = getenv( "REMOTE_ADDR" );
                return $onlineip;
        }
        if ( isset( $_SERVER['REMOTE_ADDR'] ) && $_SERVER['REMOTE_ADDR'] && strcasecmp( $_SERVER['REMOTE_ADDR'], "unknown" ) )
        {
                $onlineip = $_SERVER['REMOTE_ADDR'];
                return $onlineip;
        }
        if ( getenv( "HTTP_CLIENT_IP" ) && strcasecmp( getenv( "HTTP_CLIENT_IP" ), "unknown" ) )
        {
                $onlineip = getenv( "HTTP_CLIENT_IP" );
                return $onlineip;
        }
        if ( getenv( "HTTP_X_FORWARDED_FOR" ) && strcasecmp( getenv( "HTTP_X_FORWARDED_FOR" ), "unknown" ) )
        {
                $onlineip = getenv( "HTTP_X_FORWARDED_FOR" );
        }
        return $onlineip;
}

function is_ip( $IP )
{
        $IP_ARRAY = explode( ".", $IP );
        $IP_ARRAY_NUM = sizeof( $IP_ARRAY );
        if ( $IP_ARRAY_NUM != 4 )
        {
                return FALSE;
        }
        $I = 0;
        for ( ;    $I < $IP_ARRAY_NUM;    ++$I    )
        {
                if ( !is_numeric( $IP_ARRAY[$I] ) && $IP_ARRAY[$I] < 0 || 255 < $IP_ARRAY[$I] )
                {
                        return FALSE;
                }
                if ( !( $I == 3 ) && !( $IP_ARRAY[$I] == 255 ) )
                {
                        continue;
                }
                return FALSE;
        }
        return TRUE;
}

function compare_date_time( $DATE_TIME1, $DATE_TIME2 )
{
        if ( $DATE_TIME1 == NULL || strlen( $DATE_TIME1 ) == 0 || $DATE_TIME2 == NULL || strlen( $DATE_TIME2 ) == 0 )
        {
                return -1;
        }
        $DATE_TIME1_ARRY = explode( " ", $DATE_TIME1 );
        $DATE_TIME2_ARRY = explode( " ", $DATE_TIME2 );
        if ( compare_date( $DATE_TIME1_ARRY[0], $DATE_TIME2_ARRY[0] ) == 1 )
        {
                return 1;
        }
        if ( compare_date( $DATE_TIME1_ARRY[0], $DATE_TIME2_ARRY[0] ) == 0 )
        {
                if ( compare_time( $DATE_TIME1_ARRY[1], $DATE_TIME2_ARRY[1] ) == 1 )
                {
                        return 1;
                }
                if ( compare_time( $DATE_TIME1_ARRY[1], $DATE_TIME2_ARRY[1] ) == 0 )
                {
                        return 0;
                }
                return -1;
        }
        return -1;
}