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

delete from user_daily where day=date(now() - interval 4 day);
SELECT date( now( ) - INTERVAL 4 DAY ) ;

function httpRequestGET($url){
  $url2 = parse_url($url);
  $url2["path"] = ($url2["path"] == "" ? "/" : $url2["path"]);
  $url2["port"] = ($url2["port"] == "" ? 80 : $url2["port"]);
  $host_ip = @gethostbyname($url2["host"]);
  $fsock_timeout=20;
  if(($fsock = fsockopen($host_ip, 80, $errno, $errstr, $fsock_timeout)) < 0){
    return false;
  }
  
  $request =  $url2["path"] . ($url2["query"] != "" ? "?" . $url2["query"] : "") . ($url2["fragment"] != "" ? "#" . $url2["fragment"] : "");
  $in  = "GET " . $request . " HTTP/1.0\r\n";
  $in .= "Accept: */*\r\n";
  $in .= "User-Agent: Payb-Agent\r\n";
  $in .= "Host: " . $url2["host"] . "\r\n";
  $in .= "Connection: Close\r\n\r\n";
  if(!@fwrite($fsock, $in, strlen($in))){
    fclose($fsock);
    return false;
  }
  unset($in);
  
  $out = "";
  while($buff = @fgets($fsock, 2048)){
    $out .= $buff;
  }
  fclose($fsock);
  $pos = strpos($out, "\r\n\r\n");
  $head = substr($out, 0, $pos);    //http head
  $status = substr($head, 0, strpos($head, "\r\n"));    //http status line
  $body = substr($out, $pos + 4, strlen($out) - ($pos + 4));//page body
  if(preg_match("/^HTTP\/\d\.\d\s([\d]+)\s.*$/", $status, $matches)){
    if(intval($matches[1]) / 100 == 2){
      return $body;  
    }else{
      return false;
    }
  }else{
    return false;
  }
}
function httpRequestPOST($url,$post_data){
  $url2 = parse_url($url);
  $url2["path"] = ($url2["path"] == "" ? "/" : $url2["path"]);
  $url2["port"] = ($url2["port"] == "" ? 80 : $url2["port"]);
  $host_ip = @gethostbyname($url2["host"]);
  $fsock_timeout=20;//秒
  if(($fsock = fsockopen($host_ip, 80, $errno, $errstr, $fsock_timeout)) < 0){
    return false;
  }
  
  $request =  $url2["path"] . ($url2["query"] != "" ? "?" . $url2["query"] : "") . ($url2["fragment"] != "" ? "#" . $url2["fragment"] : "");
  
  $needChar = false;
  
  foreach($post_data as $key => $val)  {
    
    $post_data2 .= ($needChar ? "&" : "") . urlencode($key) . "=" . urlencode($val);
    $needChar = true;
  }
  $in  = "POST " . $request . " HTTP/1.0\r\n";
  $in .= "Accept: */*\r\n";
  $in .= "Host: " . $url2["host"] . "\r\n";
  $in .= "User-Agent: Lowell-Agent\r\n";
  $in .= "Content-type: application/x-www-form-urlencoded\r\n";
  $in .= "Content-Length: " . strlen($post_data2) . "\r\n";
  $in .= "Connection: Close\r\n\r\n";
  $in .= $post_data2 . "\r\n\r\n";
  
  unset($post_data2);
  if(!@fwrite($fsock, $in, strlen($in))){
    fclose($fsock);
    return false;
  }
  unset($in);
  
  $out = "";
  while($buff = fgets($fsock, 2048)){
    $out .= $buff;
  }
  
  fclose($fsock);
  $pos = strpos($out, "\r\n\r\n");
  $head = substr($out, 0, $pos);    //http head
  $status = substr($head, 0, strpos($head, "\r\n"));    //http status line
  $body = substr($out, $pos + 4, strlen($out) - ($pos + 4));//page body
  if(preg_match("/^HTTP\/\d\.\d\s([\d]+)\s.*$/", $status, $matches)){
    if(intval($matches[1]) / 100 == 2){
      return $body;
    }else{
      return false;
    }
  }else{
    return false;
  }
}

$post_data = array("name"=>"xd","sex"=>"man");
httpRequestPOST("http://localhost/post.php",$post_data);

POST /post.php HTTP/1.0
Accept: */*
Host: localhost
User-Agent: Lowell-Agent
Content-type: application/x-www-form-urlencoded
Content-Length: 15
Connection: Close
name=xd&sex=man

POST/?username=111&password=222HTTP/1.1
Host:127.0.0.1:8000
User-Agent:Mozilla/5.0(Windows;U;WindowsNT5.2;zh-CN;rv:1.9.0.1)Gecko/2008070208Firefox/3.0.1
Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language:zh-cn,zh;q=0.5
Accept-Encoding:gzip,deflate
Accept-Charset:gb2312,utf-8;q=0.7,*;q=0.7
Keep-Alive:300
Connection:keep-alive
Referer:http://127.0.0.1:8000/?username=111&password=222
Content-Type:application/x-www-form-urlencoded
Content-Length:25
username=111&password=222

main()
{
  char *src="hello,world";
  char *dest = NULL;
  int len=strlen(src);
  dest = (char*)malloc(len);
  char *d = dest;
  char *s = src[len];//它出题意图是指向最后，然后再减减到开始处，但是C语言是不能这样直接指向的，必须这样：    s = src+len-1;  而且两边的类型也不等，一边是指针，一边是一个数值，写对： char *s = &src[len];
  while(len-- != 0)
  {
    d++ = s--;
    printf("%s",dest);

  }
}

#include <stdio.h>
#include <string.h>

int main()
{
    char *src="hello,world";
    char *dest = NULL;
    int len=strlen(src);

    printf("src =[%s]\n", src);
    dest = (char*)malloc(len+1);
    char *d = dest;
    char *s = NULL;
    int i =0;

    s = src+len-1;
    //s = &src[len]-1; //这个操作就是对内存指针很了解的情况下进行的:取到地址，然后减少一个char类型地址的偏移量。

   //s = &src[len-1];  //直接取到不是\0的前一个字符地址。

    while (len-- != 0)
    {
        *d++ = *s--;
    }

    *d = 0;

    printf("dest=[%s]\n",dest);
    return 0;
}

char str[] = "I love sina china";
char *p;
p=str;
printf("%c",*p);//是把这个地址的内容给取出来，传的是一个地址指向的内容！
printf("%s",p+2);//把这个首地址的内容取出来，然后加二个地址偏移，然后打印出这个地址以及后面的内容,这儿传入的是一个地址！

awk -F"|" '{(total+=$2)};END{print total}' filename.txt

awk -F "|" '{total+=$2}END{print total}' filename.txt

[root@bogon diff]# cat A.txt
111 21
222
333
444
555
666
777
888

[root@bogon diff]# awk '{if(NR==5)print $1}' A.txt  
555

echo is_file('/var/downloads/donkey/incoming/[当地球停止转动].The.Day.The.Earth.Stood.Still.DVDRip.XviD-DMT.avi')?"true":"false";  

echo is_file(iconv('UTF-8','GB2312','/var/downloads/donkey/incoming/[当地球停止转动].The.Day.The.Earth.Stood.Still.DVDRip.XviD-DMT.avi'))?"true":"false";