参考:http://www.runoob.com/mysql/mysql-connection.html
php中执行mysql有两种方法;一是:直接的mysql相应的函数;二:mysqli_query(mysql链接的结果,SQL语句);
//链接数据库
$link=mysqli_connect("$this->host","$this->username","$this->password","$this->dbname","$this->port")or die("链接数据库失败");
//设置字符编码
mysqli_query(self::$link,"set names utf8");
//选择数据库
方法一: mysqli_query(self::$link,"use lamboone");
方法二:mysqli_select_db( $conn, 'RUNOOB' );
//查询
$retval = mysqli_query( $conn, $sql );
//遍历select的结果:
$rec=mysqli_fetch_assoc($result);函数从结果集中取得一行;
$rec=mysqli_fetch_row($result);
$rec=mysqli_fetch_array($result);
mysqli_free_result($retval);//释放内存
mysqli_close($conn);//断开数据库链接