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

select * from(
SELECT *
FROM news
WHERE screatedate > '2007-06-30'
order BY typeid
)
UNION ALL select * from(
SELECT *
FROM news
WHERE screatedate <= '2007-06-30'
order BY screatedate desc
)

select * from(
SELECT *
FROM news
WHERE screatedate > '2007-06-30'
order BY typeid
) as temp1
UNION ALL select * from(
SELECT *
FROM news
WHERE screatedate <= '2007-06-30'
order BY screatedate desc
)as temp2

<?php
<?php  
function request_post($url = '', $param = '') {  
        if (emptyempty($url) || emptyempty($param)) {  
            return false;  
        }  
          
        $postUrl = $url;  
        $curlPost = $param;  
        $curl = curl_init();//初始化curl  
        curl_setopt($curl, CURLOPT_URL,$postUrl);//抓取指定网页  
        curl_setopt($curl, CURLOPT_HEADER, 0);//设置header  
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);//要求结果为字符串且输出到屏幕上  
        curl_setopt($curl, CURLOPT_POST, 1);//post提交方式  
        curl_setopt($curl, CURLOPT_POSTFIELDS, $curlPost);  
        $data = curl_exec($curl);//运行curl  
        curl_close($curl);  
          
        return $data;  
    }

   1.
      $user=’root’;//数据库连接用户名
   2.
      $pass=”;//对应的密码
   3.
      try{
   4.
          $db = new PDO(’mysql:host=localhost;dbname=test’, $user, $pass,array(PDO::ATTR_PERSISTENT => true));//初始化PDO对象
   5.
          //默认这个不是长连接，如果需要数据库长连接，需要最后加一个参数：array(PDO::ATTR_PERSISTENT => true)
   6.
          $db = new PDO(’数据库类型:host=主机地址;dbname=数据库名’,用户名,密码,array(PDO::ATTR_PERSISTENT => true));
   7.
         $db->query(’SET NAMES \’utf8\”);//设置连接数据库的语言环境
   8.
          echo "连接成功";
   9.
          /*你还可以进行一次搜索操作
  10.
         foreach($dbh->query(’SELECT * from gaga’)as $row){
  11.
              print_r($row);//你可以用 echo($GLOBAL); 来看到这些值
  12.
          }
  13.
         */
  14.
          //$db = null;
  15.
      }catch(PDOException$e){
  16.
          die(’数据库连接错误: ‘.$e->getMessage().’
  17.
      ‘);
  18.
      }

//Curl Get数据
function _curl_get($url) {      
    $ch = curl_init();  
    curl_setopt($ch, CURLOPT_URL,$url);    
    curl_setopt($ch, CURLOPT_HEADER, 0);  
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);    
    $data = curl_exec($ch);        
    curl_close($ch);      
    if ($data)  
        return $data;    
    else
        return false;    
}      

//Curl Post数据
function _curl_post($url, $vars) {      
    $ch = curl_init();  
    curl_setopt($ch,CURLOPT_RETURNTRANSFER, 1);      
    curl_setopt($ch, CURLOPT_URL,$url);    
    curl_setopt($ch, CURLOPT_POST, 1 );    
    curl_setopt($ch, CURLOPT_POSTFIELDS, $vars);    
    $data = curl_exec($ch);        
    curl_close($ch);      
    if ($data)  
        return $data;    
    else
        return false;    
}