自己写的时候采用了两种方式,都可以连接到新浪云sea mysql数据库数据取数
Hello, SAE!
';
//echo "用户名:" .SAE_MYSQL_USER."
";
//echo "密码:".SAE_MYSQL_PASS."
";
//echo "主库域名:".SAE_MYSQL_HOST_M."
";
//echo "从库域名:".SAE_MYSQL_HOST_S."
";
//echo "端口号:".SAE_MYSQL_PORT."
";
//echo "数据库名:".SAE_MYSQL_DB."
";
//获取数据的连接用户名密码等等
$hostname=SAE_MYSQL_HOST_M.":" .SAE_MYSQL_PORT;
$user=SAE_MYSQL_USER;
$poss=SAE_MYSQL_PASS;
$dbname=SAE_MYSQL_DB;
//mysql_connect连接数据库
$link=mysql_connect($hostname,$user,$poss);
//var_dump($link);
if(!$link){
die('connot connect:'.mysql_error());
}
//echo 'connect connection OK!!
';
//设置编码格式为utf8
$sql="set names utf8";
mysql_query($sql,$link);
mysql_set_charset("utf8");
//查询数据
$sql="select * from app_swdr.swry";
$result=mysql_query($sql,$link);
//判断结果是否为空
if(!$result){
if(empty($result)){
echo "empty";
}
echo "failed";
exit;
}
//创建数据
$arry=array();
//转换为对象,处理数据
class Title{
public $id;
public $label;
public $name;
public $value;
}
while($row=mysql_fetch_object($result)){
$title = new Title();
$title -> id=$row ->id;
$title -> label=$row ->label;
$title -> name=$row ->name;
$title -> value=$row ->value;
$arry[]=$title;
}
//对变量进行json解码
$arry=json_encode((array("state"=>"success","data"=>$arry)));
echo (urldecode($arry));
//释放结果
mysql_free_result($result);
/*一下是直接输出数据库查询出来的数据 sucessful成功状态**/
//$mysql = new SaeMysql();
//$sql = "select * from app_swdr.swry";
//$data = $mysql -> getData($sql);
//var_dump($data);
//for($i = 0;$i < count($data);$i++){
// echo "id:".$data[$i][id]. "label:".$data[$i]['label']. "name:".$data[$i]['name']. "value:".$data[$i]['value']."
\n";
//}
//if($mysql -> errno() != 0){
// die("error:".$mysql -> errmsg());
//}else{
// echo "succeful";
//}
//关闭连接
//$mysql -> closeDb()
mysql_close();
?>
第一种方式是新浪云sea提供的SeaMysql()直接连接数据库,上诉屏蔽的均为第一种方式
第二种方式通过mysql_connect(host,name,pass);再来查询输出数据
下面为输出的数据库数据
{"state":"success","data":[{"id":"1","label":"\u51cf\u514d\u7a0e\u662f\u7a0e\u6536\u4f18\u60e0\uff0c\u4e0b\u5217\u6709\u5173\u51cf\u514d\u7a0e\u7684\u8868\u8ff0\u6b63\u786e\u7684\u662f\uff08\u3000\uff09\u3002","name":"\u201c\u201d","value":"0"},
label里面的数据为加密之后的形式,未encode转换 转换方式下一篇文章讲解