SAE 平台MYSQL数据库连接方式

//-------stl LIB 中给了一个数据库操作类

<?php
class sae_mysql
{
    function __construct( $host , $port , $accesskey , $secretkey , $appname , $do_replication )
    {
        $this->host = ltrim($host, 'ms');
        $this->port = $port;
        $this->accesskey = $accesskey;
        $this->secretkey = $secretkey;
        $this->appname =$appname;  //$this->appname =  'app_' . $appname; 其实是数据库名称
        $this->do_replication = $do_replication;
    }
   
    private function connect( $is_master = true )
    {
        if( $is_master ) $host =$this->host;  //$host ='m' .$this->host;
        else $host =$this->host;         //else $host ='s' .$this->host;
       
        if( !$db = mysql_connect( $host . ':' . $this->port , $this->accesskey , $this->secretkey ) )
        {
            die('can\'t connect to mysql ' . $this->host . ':' . $this->port );
        }
       
        mysql_select_db( $this->appname , $db );
       
        return $db;
    }
   
    private function db_any()
    {
       
    }
   
    private function db_read()
    {
        if( isset( $this->db_read ) )
        {
            mysql_ping( $this->db_read );
            return $this->db_read;
        }
        else
        {
            if( !$this->do_replication ) return $this->db_write();
            else
            {
                $this->db_read = $this->connect( false );
                return $this->db_read;
            }
        }
    }
   
    private function db_write()
    {
        if( isset( $this->db_write ) )
        {
            mysql_ping( $this->db_write );
            return $this->db_write;
        }
        else
        {
            $this->db_write = $this->connect( true );
            return $this->db_write;
        }
    }
   
    public function save_error()
    {
        $GLOBALS['SAE_LAST_ERROR'] = mysql_error();
        $GLOBALS['SAE_LAST_ERRNO'] = mysql_errno();
    }
   
   
    public function run_sql( $sql )
    {
        $ret = mysql_query( $sql , $this->db_write() );
        $this->save_error();
        return $ret;
    }
   
    public function get_data( $sql )
    {
        $GLOBALS['SAE_LAST_SQL'] = $sql;
        $data = Array();
        $i = 0;
        $result = mysql_query( $sql , $this->do_replication ? $this->db_read() : $this->db_write()  );
       
        $this->save_error();

        while( $Array = mysql_fetch_array($result, MYSQL_ASSOC ) )
        {
            $data[$i++] = $Array;
        }

        /*
        if( mysql_errno() != 0 )
            echo mysql_error() .' ' . $sql;
        */
       
        mysql_free_result($result);

        if( count( $data ) > 0 )
            return $data;
        else
            return false;   
    }
   
    public function get_line( $sql )
    {
        $data = $this->get_data( $sql );
        return @reset($data);
    }
   
    public function get_var( $sql )
    {
        $data = $this->get_line( $sql );
        return $data[ @reset(@array_keys( $data )) ];
    }
   
    public function last_id()
    {
        $result = mysql_query( "SELECT LAST_INSERT_ID()" , $this->db_write() );
        return reset( mysql_fetch_array( $result, MYSQL_ASSOC ) );
    }
   
    public function close_db()
    {
        if( isset( $this->db_read ) )
            @mysql_close( $this->db_read );
       
        if( isset( $this->db_write ) )
            @mysql_close( $this->db_write );
           
    }
   
    public function escape( $str )
    {
        if( isset($this->db_read)) $db = $this->db_read ;
        elseif( isset($this->db_write) )    $db = $this->write;
        else $db = $this->db_read();
       
        return mysql_real_escape_string( $str , $db );
    }
   
    public function errno()
    {
        return     $GLOBALS['SAE_LAST_ERRNO'];
    }
   
    public function error()
    {
        return $GLOBALS['SAE_LAST_ERROR'];
    }
}

?>

 

 

//-----------测试连接的

<? 
 $host=SAE_MYSQL_HOST_M;
 $port=SAE_MYSQL_PORT;
 $accesskey=SAE_ACCESSKEY;
 $secretkey=SAE_SECRETKEY;
 $appname=SAE_MYSQL_DB; 
 $do_replication= true;

 $mysql= new sae_mysql($host , $port , $accesskey , $secretkey , $appname ,$do_replication);
    $sql = "SELECT user_name FROM test_user ";
    $data = $mysql->get_data( $sql );
 print_r("my_name：");
 $name=current($data[0]);
    print_r($name);
?>

 

//修改了部分连接类的写发  进行了注释