数据库连接

数据库连接

百度BAE

......
    public function responseMsg(){
        //get post data,May be due to the different environments
        $postStr = $GLOBALS["HTTP_RAW_POST_DATA"];

        //extract post data
        if(!empty($postStr)){
            $postObj = simplexml_load_string($postStr,'SimpleXMLElement',LIBXML_NOCDATA);
            $fromUsername = $postObj->FromUserName;
            $toUsername = $postObj->ToUserName;
            $type = $postObj->MsgType;
            $customrevent = $postObj->Event;
            $latitude = $postObj->Location_X;
            $longitude = $postObj->Location_Y;
            $keyword = trim($postObj->Content);
            $time = time();
            $textTpl = "<xml>
                            <ToUserName><![CDATA[%s]]></ToUserName>
                            <FromeUserName><![CDATA[%s]]></FromeUserName>
                            <CreateTime>%s</CreateTime>
                            <MsgType><![CDATA[text]]></MsgType>
                            <Content><![CDATA[%s]]></Content>
                            <FuncFlag>0</FuncFlag>
                        </xml>"
            $dbname = 'SnXAHxsmUPuRqZkaWnjF';
            //从环境变量里取出数据库连接需要的参数
            $host = getenv('HTTP_BAE_ENV_ADDR_SQL_IP');
            $port = getenv('HTTP_BAE_ENV_ADDR_SQL_PORT');
            $user = getenv('HTTP_BAE_ENV_AK');
            $pwd = getenv('HTTP_BAE_ENV_SK');
            //调用mysql_connect()连接服务器
            $link = @mysql_connect("{$host}:{$port}",$user,$pwd,true);
            if(!$link){
                die("Connect Server Failed: ".mysql_error());
            }
            //连接成功后立即调用mysql_select_db()选中需要连接的数据库
            if(!mysql_select_db($dbname,$link)){
                die("Select Database Failed: ".mysql_error($link));
            }

            //至此连接已完全建立，可对当前数据库进行相应操作了
            //!!!!!!!注意，无法再通过本次连接调用mysql_select_db来切换到其他数据库了！！！
            //需要再连接其他数据库，请再使用mysql_connect+mysql_select_db启动另一个连接

            //接下来可以使用其他标准PHP Mysql函数操作进行数据库操作
            $sql = "SELECT * FROM 'weixin' WHERE 'title' = '中国合伙人' LIMIT 0,30 ";
            //或者关键词回复
            $sql = "SELECT * FROM 'weixin' WHERE 'title' = '{$keyword}' LIMIT 0,30 ";
            //模糊查询
            $sql = "SELECT * FROM 'weixin' WHERE 'title' LIKE '%{$keyword}%' LIMIT 0,30 ";
            //执行SQL语句
            $query = mysql_query($sql);
            //获取sql语句结果
            $rs = mysql_fetch_array($query);
            $contentStr = $rs['content'];

            //显示关闭连接，非必需
            mysql_close($link);
            $resultStr = sprintf($textTpl,$fromUsername,$toUsername,$time,$contentStr);
            echo $resultStr;
        }else{
            echo "";
            exit;
        }
    }
......