向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除|赢在IT，Playin' with IT,Focus on Killer Application,Marketing Meets Technology.

CREATE TABLE TEST_MERGE_1(
ID INT(5) NOT NULL,
VALUE VARCHAR(100) NOT NULL,
PRIMARY KEY(ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE TEST_MERGE_2(
ID INT(5) NOT NULL,
VALUE VARCHAR(100) NOT NULL,
PRIMARY KEY(ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE TEST_MERGE(
ID INT(5) NOT NULL,
VALUE VARCHAR(100) NOT NULL,
PRIMARY KEY(ID)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 INSERT_METHOD=LAST UNION=(TEST_MERGE_1,TEST_MERGE_2) ;

<?php
class BolingGame
{
  public  function return_array()
  {  $return_array = array("a"=>"a","b"=>"b");
    return $return_array;
  }
  
  
}
?>

  public function testReturn_array()
  {
    // TODO Auto-generated BolingGameTest->testReturn_array()
    //$this->markTestIncomplete ( "return_array test not implemented" );
    
    $return_array = array("a"=>"a","b"=>"b");
    $this->assertEquals($return_array,$this->BolingGame->return_array());
    
    $return_array = array("a"=>"a","b"=>"c");
    $this->assertEquals($return_array,$this->BolingGame->return_array());
  
  }

mysql> desc record_cache;
+----------+------------+------+-----+---------+----------------+
| Field    | Type       | Null | Key | Default | Extra          |
+----------+------------+------+-----+---------+----------------+
| id       | int(11)    | NO   | PRI | NULL    | auto_increment |
| mc_key   | varchar(2) | NO   | MUL |         |                |
| mc_value | mediumtext | NO   |     |         |                |
+----------+------------+------+-----+---------+----------------+

<?php

class VMc
{
  
  private $db;
  public function __construct()
  {
    $this->db = new MysqlPdo ( );
  
  }
  public function vMcSet($mcKey, $mcValue)
  {
    
    $mcValue ['ctime'] = time ();
    $data ['mc_value'] = serialize ( $mcValue );
    $data ['mc_key'] = $mcKey;
    
    if ($this->db->Insert ( 'record_cache', $data ))
    {
      return true;
    }
    else
    {
      return false;
    }
    
    return false;
  }
  
  public function vMcGet($mcKey)
  {
    
    $sql = "SELECT mc_value FROM record_cache WHERE mc_key = '$mcKey '";
    $bRet = $this->db->Select ( $sql );
    if ($bRet)
    {
      $res = $this->db->Fetch ();
      if ($res)
      {
        $res = unserialize ( $res ['mc_value'] );
      }
      return $res;
    }
    return false;
  
  }
  
  public function flushCache()
  {
    
    $db = $this->db->ConnectM ();
    $sql = 'TRUNCATE TABLE record_cache';
    if ($db->query ( $sql ))
    {
      return true;
    }
    else
    {
      return false;
    }
  }
}

?>

  public function GetRandomRecord(&$current, $page = 1, $offset = 20)
  {
    $total = 200;

    */
    //////////////////////临时缓存//////////////////////////////
    $vMc = new VMc ( );
    $mcValues = $vMc->vMcGet ( $page );
    if (! empty ( $mcValues ))
    {
      if (time () - $mcValues ['ctime'] <= 1800)
      {
        $current ['count'] = $mcValues ['count'];
        unset ( $mcValues ['count'], $mcValues ['ctime'] );
        foreach ( $mcValues as $k => $v )
        {
          if (! empty ( $v ))
          {
            $current ['record'] [$k] = $v;

          }
        }
        return true;
      }
    }
    /////////////////////////////////////////////////////////////
    $current ['count'] = $total;
    $start = $offset * ($page - 1);

    $sql = "select * from record  where status = 0 order by ctime desc limit " . $total;

    $bRet = $this->db->Select ( $sql );

    if ($bRet)
    {
      //fetch the result
      $res = $this->db->FetchAll ();

    }
    //if mc is open put them into memcache


    if (count ( $res ) < 200)
    {
      $current ['count'] = count ( $res );
    }
    $tp = ceil ( count ( $res ) / $offset );
    $tmp = 0;
    for($i = 0; $i < $tp; $i ++)
    {
      $cp = $i + 1;
      $kstart = $i * $offset;
      $pagerec = array_slice ( $res, $kstart, $offset );
      $pagerec ['count'] = $current ['count'];
      //////////////////////临时缓存//////////////////////////////
      if ($cp == 1)
      {
        if ($vMc->flushCache ())
        {
          $tmp = 1;
        }
      }
      if ($tmp == 1)
      {
        $vMc->vMcSet ( $cp, $pagerec );

      }
      //////////////////////////////////////////////////////////
      /*  if($this->mcobj){
      $this->mcobj->set('RANDOM_RECORD_' . $cp , $pagerec ,false ,60*30);
      }
      */
      //set the return data
      if ($cp == $page)
      {
        $current ['record'] = array_slice ( $res, $start, $offset );
      }
    }

    return true;
  }

1> rpm -qa|grep vim
vim-minimal-7.0.109-3.el5.3
vim-common-7.0.109-3.el5.3
vim-enhanced-7.0.109-3.el5.3

[root@localhost  <71.85>]: /home/xiangdong2
0> rpm -e vim-enhanced-7.0.109-3.el5.

<?php
$time = $_SERVER['REQUEST_TIME'];
echo $time = date('Y-m-d H:i:s',$time);
?>

  public function prepare($fromuid, $touid, $sid, $ctime = "Null")
  {
    /*
        $this->fromuid[] = $fromuid;
        $this->touid[] = $touid;
        $this->sid[] = $sid;
    */
    $arr_row ['fromuid'] = $fromuid;
    $arr_row ['touid'] = $touid;
    $arr_row ['sid'] = $sid;
    $arr_row ['ctime'] = $ctime;
    array_push ( $this->arr_data, $arr_row );
  }

for($j=0; $j<count($current['record']);$j++)
{
       $current['record'][$j]['ctime'] = strtotime(str_replace('-','',$    current['record'][$j]['ctime'])) ;
       $current['record'][$j]['ctime'] = TimeFormatter::timeFormat($current['record'][$j]['ctime']);  
       ...
}

$result = abs(strtotime(date("Y-m-d H:i:s")) - strtotime("08-11-2008 19:29:47"))/86400;

if($result>0){
echo "已经过目标时间"; //即今天的日期大
}elseif($result<0){
echo "还未过目标时间"; //即今天的日期小
}else{
echo "今天是目标日期"; //一样大
}

select * from userfollow where uid=1548940117 and followuid in (1584778420,1305619077,1305619077,1582003980,1584778420,1052833673,1052833673,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420)

for($j=0; $j<count($current['record']);$j++)
{
      $uidstr .=  $current['record'][$j]['uid'] . ',';
}

1584778420,1305619077,1305619077,1582003980,1584778420,1052833673,1052833673,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,

$uidstr = trim($uidstr , ',') ;

778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420,1584778420

$arr_follow_list = $obj_userfollow->CheckUserFollowInList($uid, $uidstr);

public function CheckUserFollowInList($uid, $followuids) {
        $sql = "select * from {$this->table_name} where uid={$uid} and followuid in ({$followuids})";
        echo $sql;

        $result = $this->objPdo->Select($sql);
        if ($result)
        {
            $rs_array = $this->objPdo->FetchAll();
            return $rs_array;
        } else
        {
            return FALSE;
        }
    }

        public function CheckParam(&$errstr)
        {
                $errstr = '';
                $this->_par ['page'] = isset($_GET ['page']) ? intval ( $_GET ['page'] ) : 1;
                if(!$this->_par ['page']){

                        $this->_par ['page'] = 1;
                }

                $this->_par ['fuid'] = isset($_GET ['fuid'])  ? intval($_GET ['fuid']) : 0;          
                return true;
        }