Class SaeMysql

Description
Description | Methods (details)

Sae Mysql Class

  1.  $mysql = new SaeMysql();
  2.  
  3.  $sql = "SELECT * FROM `user` LIMIT 10";
  4.  $data = $mysql->getData( $sql );
  5.  $name = strip_tags( $_REQUEST['name'] );
  6.  $age = intval( $_REQUEST['age'] );
  7.  $sql = "INSERT  INTO `user` ( `name` , `age` , `regtime` ) VALUES ( '"  . $mysql->escape( $name ) . "' , '" . intval( $age ) . "' , NOW() ) ";
  8.  $mysql->runSql( $sql );
  9.  if( $mysql->errno() != 0 )
  10.  {
  11.      die( "Error:" . $mysql->errmsg() );
  12.  }
  13.  
  14.  $mysql->closeDb();

  • author: EasyChen

Located in /saemysql.class.php (line 37) 

SaeObject
   |
   --SaeMysql
Method Summary
Description | Methods (details)
void __construct ([bool $do_replication = true])
bool closeDb ()
string errmsg ()
int errno ()
string error ()
string escape (string $str)
array getData (string $sql)
array getLine (string $sql)
mixxed getVar (string $sql)
int lastId ()
void runSql (string $sql)
void setAppname (string $appname)
void setAuth (string $akey, string $skey)
void setCharset (string $charset)
void setPort (string $port)
Methods
Description | Methods (details)
Constructor __construct (line 47)

构造函数

  • author: EasyChen
void __construct ([bool $do_replication = true])
  • bool $do_replication: 是否支持主从分离，true:支持，false:不支持，默认为true
closeDb (line 281)

关闭数据库连接

  • author: EasyChen
  • access: public
bool closeDb ()
errmsg (line 348)

返回错误信息,error的别名

  • author: EasyChen
  • access: public
string errmsg ()
errno (line 326)

返回错误码

  • author: EasyChen
  • access: public
int errno ()
error (line 337)

返回错误信息

  • author: EasyChen
  • access: public
string error ()
escape (line 310)

同mysql_real_escape_string

  • author: EasyChen
  • access: public
string escape (string $str)
  • string $str
getData (line 166)

运行Sql,以多维数组方式返回结果集

  • author: EasyChen
  • access: public
array getData (string $sql)
  • string $sql
getLine (line 205)

运行Sql,以数组方式返回结果集第一条记录

  • author: EasyChen
  • access: public
array getLine (string $sql)
  • string $sql
getVar (line 231)

运行Sql,以数组方式返回结果集第一条记录的第一个字段值

  • author: EasyChen
  • access: public
mixxed getVar (string $sql)
  • string $sql
lastId (line 257)

同mysql_last_id函数 PHP's mysql_last_id()在id为big int时,会出现溢出,用Sql查询替代掉

  • author: EasyChen
  • access: public
int lastId ()
runSql (line 138)

运行Sql语句,不返回结果集

  • access: public
void runSql (string $sql)
  • string $sql
setAppname (line 103)

设置Appname

当需要连接其他APP的数据库时使用

  • author: EasyChen
  • access: public
void setAppname (string $appname)
  • string $appname
setAuth (line 72)

设置keys

当需要连接其他APP的数据库时使用

  • author: EasyChen
  • access: public
void setAuth (string $akey, string $skey)
  • string $akey: AccessKey
  • string $skey: SecretKey
setCharset (line 115)

设置当前连接的字符集 , 必须在发起连接之前进行设置

  • access: public
void setCharset (string $charset)
  • string $charset: 字符集,如GBK,GB2312,UTF8
setPort (line 87)

设置Mysql服务器端口

当需要连接其他APP的数据库时使用

  • author: EasyChen
  • access: public
void setPort (string $port)
  • string $port

Documentation generated on Wed, 11 Aug 2010 17:34:57 +0800 by phpDocumentor 1.4.3