数据库连接

百度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;        }    }......