//MYSQL数据库配置

    define(DB_HOST, '127.0.0.1');

    define(DB_USER, 'user');

    define(DB_PASS, 'pass');

    define(DB_DATABASENAME, 'database');  

    //连接mysql数据库

    $conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("connect failed" . mysql_error());

    mysql_select_db(DB_DATABASENAME, $conn); 

     $conn=mssql_connect('IP:PORT','userid','pass');

       mssql_select_db('database',$conn);

      $sql="select * from dde_top";

     $Result=mssql_query($sql); 

    //SELECT语句

    $sql=sprintf("SELECT username FROM  v9_member where username='%s' ",$userid);

    $result=mysql_query($sql);

    //用途1：获取记录数量

    $num = mysql_num_rows($result);

     if($num==0){

        echo "no_user";  //返回1： 没有此用户

        return;

    }

    //用途2：获取一条数据

     $row = mysql_fetch_array($result)

     $row = mysql_fetch_array($result)

     $row = mysql_fetch_array($result) 

    //用途3：遍历记录集，并转化成数组

    while( $row = mysql_fetch_array($result) ){

         $game = $row['game'];             //游戏名

        $giftname = $row['giftname'];      //礼包名字

     }

     //更新此CDKEY的used,userid,getdate

     $sql=sprintf("UPDATE qyg_gifts SET  userid='%s',getdate=%d WHERE cdkey='%s' ",$userid,time(),$cdkey);

     $result=mysql_query($sql);    

     $sql="delete from qyg_gifts where game='$select_game'";

     mysql_query($sql); 

//A：插入一条数据
$sql=sprintf("INSERT INTO `t_gifts` (`F_UserID`, `F_Gift`, `F_Count`) VALUES ('%s','%s',%d)",$userid,$gift,$count);

         $result=mysql_query($sql);

 //B：生成一次性插入多条的SQL语句

         $sqls="INSERT INTO `t_gifts` (`F_UserID`, `F_Gift`, `F_Count`, `F_Desc`, `F_Used`, `F_BlockNo`, `F_GetDate`) VALUES";

        $i=0;

         foreach($items_arr as $item){

              if($i==0){

                $sqls=$sqls.sprintf("('%s','%s',%d,'%s',0,-1,'%s')",$userid,$item[0],$item[1],$gift_name,date('Y-m-d H:i:s',time()) );

            }else{

                $sqls=$sqls.sprintf(",('%s','%s',%d,'%s',0,-1,'%s')",$userid,$item[0],$item[1],$gift_name,date('Y-m-d H:i:s',time()) );

            }

            $i++;

        }

        $sqls=$sqls.";";

         $result=mysql_query($sql);