sae mysql 无法连接_为什么我这个类不能连接新浪sae数据库？

<?phpclassmysql {private$host;private$user;private$pwd;private$db;private$port;private$ut;function__construct($ut){$this->host="SAE_MYSQL_HOST_M";$this->user="SAE_MYSQL_US...

class mysql{

private $host;

private $user;

private $pwd;

private $db;

private $port;

private $ut;

function __construct($ut){

$this->host="SAE_MYSQL_HOST_M";

$this->user="SAE_MYSQL_USER";

$this->pwd="SAE_MYSQL_PASS";

$this->db="app_niceworld";

$this->port="SAE_MYSQL_PORT";

$this->ut=$ut;

$this->connect();

}

function connect(){

/*这是第二十行*/ $link=mysql_connect($this->host.':'.$this->port,$this->user,$this->pwd)or die($this->error());

mysql_select_db($this->db,$link)or die("该数据库：".$this->db."不存在！");

mysql_query("SET NAMES '$this->ut'");

}

function query($sql,$link=''){

if (!($query=mysql_query($sql)))$this->show('Say:',$sql);

return $query;

}

function show($message='',$sql=''){

if(!$sql) echo $message;

else echo $message.'
'.$sql.'
';

}

function error(){

return mysql_error();

}

//---------功能封装-----------

function fn_insert($table,$name,$value){

return $this->query("insert into $table ($name) values ($value)");

}

function fn_delete(){

}

}

$db1=new mysql("GBK");

$db1->fn_insert(user,realname,"234");

提示如下：

SAE_Warning: mysql_connect() [function.mysql-connect]: this app is not authorised in mysql.php on line 20

我改写了代码，封装了自己的 操作方式：

class mysql{

private $ut;

private $db="app_niceworld";

function __construct($ut){

$this->ut=$ut;

$this->connect();

}

function connect(){

$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS)or die(mysql_error());

mysql_select_db($this->db,$link)or die("该数据库：".$this->db."不存在！");

mysql_query("SET NAMES '$this->ut'");

}

function query($sql,$link=''){

if (!($query=mysql_query($sql)))$this->show('Say:',$sql);

return $query;

}

function show($message='',$sql=''){

if(!$sql) echo $message;

else echo $message.'
'.$sql.'
';

}

function fn_insert($table,$name,$value){

return $this->query("insert into $table ($name) values ($value)");

}

}

展开